{{#var defaultId = @default(cuid())}}
model User {
    id                 String     @id {{defaultId}}
    name               String
    email              String
    emailVerified      Boolean    @default(false)
    role               Role       @default(USER)
    status             UserStatus @default(ACTIVE)
    needPasswordChange Boolean    @default(false)
    isDeleted          Boolean    @default(false)
    deletedAt          DateTime?
    image              String?
    createdAt          DateTime   @default(now())
    updatedAt          DateTime   @updatedAt
    sessions           Session[]
    accounts           Account[]

    @@unique([email])
    @@map("user")
}

model Session {
    id        String   @id {{defaultId}}
    expiresAt DateTime
    token     String   @unique
    createdAt DateTime @default(now())
    updatedAt DateTime @updatedAt
    ipAddress String?
    userAgent String?
    userId    String
    user      User     @relation(fields: [userId], references: [id], onDelete: Cascade)

    @@index([userId])
    @@map("session")
}

model Account {
    id                    String    @id {{defaultId}}
    accountId             String
    providerId            String
    userId                String
    user                  User      @relation(fields: [userId], references: [id], onDelete: Cascade)
    accessToken           String?
    refreshToken          String?
    idToken               String?
    accessTokenExpiresAt  DateTime?
    refreshTokenExpiresAt DateTime?
    scope                 String?
    password              String?
    createdAt             DateTime  @default(now())
    updatedAt             DateTime  @updatedAt

    @@index([userId])
    @@map("account")
}

model Verification {
    id         String   @id {{defaultId}}
    identifier String
    value      String
    expiresAt  DateTime
    createdAt  DateTime @default(now())
    updatedAt  DateTime @updatedAt

    @@index([identifier])
    @@map("verification")
}