generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

model User {
  id        String      @id @default(uuid())
  name      String
  email     String   @unique
  pwdHash   String?
  role      UserRole @default(Standard)
}

model Image {
  id         String   @id @default(uuid())
  filename   String
  s3Key      String   @unique
  s3Url      String
  s3ThumbKey String   @unique
  s3ThumbUrl String
  status     String
  mime       String
  type       String   // e.g., "image"
  metaUrl    String
  createdBy  String
  updatedBy  String
  secure     Boolean  @default(false)
  createdAt  DateTime @default(now())
  updatedAt  DateTime @updatedAt
  hash       String?
  userId     String?
  // Add more fields as needed (e.g., thumbnail, metadata)

  @@index([filename])
  @@index([status])
}


enum UserRole {
  Standard
  Admin
}