47 lines
911 B
Plaintext
47 lines
911 B
Plaintext
|
|
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
|
|
} |