model User {
id String @id @default(dbgenerated("gen_random_uuid()")) @db.Uuid
createdAt DateTime @default(now())
updatedAt DateTime @default(now())
email String @unique
emailVerified Boolean @default(false)
googleId String @unique
displayName String
firstName String
lastName String
profilePicture String
receiveMarketingEmails Boolean @default(false)
QRCodes QRCode[]
quota Int @default(10)
}
model QRCode {
id String @id @default(dbgenerated("gen_random_uuid()")) @db.Uuid
user User? @relation(fields: [userId], references: [id])
userId String @db.Uuid
createdAt DateTime @default(now())
updatedAt DateTime @default(now())
key String @unique
redirectURL String?
isActive Boolean @default(false)
description String?
Scans Scan[]
scansCount Int @default(0)
}
model Scan {
id String @id @default(dbgenerated("gen_random_uuid()")) @db.Uuid
qrCode QRCode? @relation(fields: [qrCodeId], references: [id])
qrCodeId String @db.Uuid
createdAt DateTime @default(now())
geoLocationData Json?
}
model User {
id String @id @default(dbgenerated("gen_random_uuid()")) @db.Uuid
createdAt DateTime @default(now())
updatedAt DateTime @default(now())
email String @unique
emailVerified Boolean @default(false)
googleId String @unique
displayName String
firstName String
lastName String
profilePicture String
receiveMarketingEmails Boolean @default(false)
QRCodes QRCode[]
quota Int @default(10)
}
model QRCode {
id String @id @default(dbgenerated("gen_random_uuid()")) @db.Uuid
user User? @relation(fields: [userId], references: [id])
userId String @db.Uuid
createdAt DateTime @default(now())
updatedAt DateTime @default(now())
key String @unique
redirectURL String?
isActive Boolean @default(false)
description String?
Scans Scan[]
scansCount Int @default(0)
}
model Scan {
id String @id @default(dbgenerated("gen_random_uuid()")) @db.Uuid
qrCode QRCode? @relation(fields: [qrCodeId], references: [id])
qrCodeId String @db.Uuid
createdAt DateTime @default(now())
geoLocationData Json?
}