schema.prisma

datasource db {
  provider = "postgresql"
}

generator client {
  provider = "prisma-client"
  output = "./generated/client"
  moduleFormat = "cjs"
}

// User
enum Role {
  USER
  SUPER_ADMIN
}
enum Plan {
  FREE
  DOCTOR
  ORGANIZATION
}
model User {
  id       String   @id @default(uuid())
  username String   @unique
  email    String   @unique
  password  String?
  googleId  String?  @unique
  profile_image_url String?
  plan    Plan   @default(FREE)
  role    Role   @default(USER)
  is_active Boolean  @default(true)

  total_scans Int @default(0)
  total_reports Int @default(0)

  twoFactorSecret String?
  twoFactorEnabled Boolean @default(false)
  
  reset_password_token String?
  reset_token_expires DateTime?
  
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  // Relations
  patients Patient[]
  scans    Scan[]
  notifications Notifications[]
  emailNotification EmailNotification?
  inAppNotification InAppNotification?
  sessions Session[]

  ownedOrg    Organization?  @relation("OrgOwner")
  orgMember   OrgMember? @relation("OrgMember")

  subscription Subscription?
  payments Payment[]

  auditLogs AuditLog[]

  submittedTickets Ticket[] @relation("TicketSubmittedBy")
  assignedTickets  Ticket[] @relation("TicketAssignedTo")
}

// HOSPITAL
model Organization {
  id        String   @id @default(uuid())
  name      String
  ownerId   String   @unique
  owner     User     @relation("OrgOwner", fields: [ownerId], references: [id], onDelete: Cascade)
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  // Relations
  members   OrgMember[]
  apiKeys   ApiKey[]
  patients   Patient[]
  scans      Scan[]
  auditLogs AuditLog[]
}
model OrgMember {
  id        String   @id @default(uuid())
  
  orgId     String
  org       Organization @relation(fields: [orgId], references: [id], onDelete: Cascade)

  userId    String   @unique
  user      User     @relation("OrgMember", fields: [userId], references: [id], onDelete: Cascade)

  isActive  Boolean      @default(true)
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}

// Patient
enum Gender {
  Male
  Female
}
model Patient {
  id              String   @id @default(uuid())
  cin            String
  full_name       String
  date_of_birth   String
  gender          Gender
  email           String
  phone_number    String

  createdById     String?
  created_by      User?     @relation(fields: [createdById], references: [id], onDelete: Cascade)

  orgId          String?
  organization    Organization? @relation(fields: [orgId], references: [id], onDelete: Cascade)

  createdAt       DateTime @default(now())
  updatedAt       DateTime @updatedAt

  // Relations
  scans Scan[]
}

// Scan
enum Class {
  meningioma
  glioma
  pituitary
  notumor
}
enum Status {
  PROCESSING
  DONE
  FAILED
}
model Scan {
  id              String   @id @default(uuid())
  scan_code       String   @unique
  name           String?
  notes          String?
  class           Class
  confidence_score Float
  all_scores      Json
  status          Status   @default(PROCESSING)
  processing   Float

  uploadedById    String
  uploaded_by     User     @relation(fields: [uploadedById], references: [id], onDelete: Cascade)

  patientId       String?
  patient         Patient? @relation(fields: [patientId], references: [id], onDelete: Cascade)

  orgId          String?
  organization    Organization? @relation(fields: [orgId], references: [id], onDelete: Cascade)

  createdAt       DateTime @default(now())
  updatedAt       DateTime @updatedAt

  // Relations
  scanImage ScanImage?
  report    Report?

  ticketsForScan       Ticket[] @relation("TicketScan")
  ticketsAsReanalysis  Ticket[] @relation("TicketReanalysisScan")
}

model ScanImage {
  id       String   @id @default(uuid())
  scanId   String   @unique
  scan     Scan     @relation(fields: [scanId], references: [id], onDelete: Cascade)
  url String
  size    Int
  resolution String
  format  String
  name   String
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}

// Report
model Report {
  id       String   @id @default(uuid())
  content  Json

  scanId   String   @unique
  scan     Scan     @relation(fields: [scanId], references: [id], onDelete: Cascade)
  
  code    String   @unique
  is_shared Boolean  @default(false)
  downloads Int @default(0)
  share_token  String?  @unique
  processing Float

  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  ticketsForReport       Ticket[] @relation("TicketReport")
  ticketsAsReanalysis    Ticket[] @relation("TicketReanalysisReport")
}

// Notification
enum NotificationType {
  scan
  report
  team
  alert
  info
}
model Notifications {
  id       String   @id @default(uuid())
  userId   String
  title    String
  message  String
  path     String?
  type     NotificationType
  read     Boolean  @default(false)

  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  user User @relation(fields: [userId], references: [id], onDelete: Cascade)
}
model EmailNotification {
  id       String   @id @default(uuid())

  userId   String   @unique
  user     User     @relation(fields: [userId], references: [id], onDelete: Cascade)

  scanReady Boolean @default(true)
  reportReady   Boolean @default(true)
  productUpdates Boolean @default(true)

  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}
model InAppNotification {
  id       String   @id @default(uuid())

  userId   String   @unique
  user     User     @relation(fields: [userId], references: [id], onDelete: Cascade)

  scanReady Boolean @default(true)
  reportReady   Boolean @default(true)
  productUpdates Boolean @default(true)

  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}

// Integration
model ApiKey {
  id         String    @id @default(uuid())

  organizationId String
  organization   Organization @relation(fields: [organizationId], references: [id], onDelete: Cascade)

  name       String
  key        String    @unique
  lastUsedAt DateTime?
  createdAt  DateTime  @default(now())
  updatedAt  DateTime  @updatedAt
}

// Session
model Session {
  id           String   @id @default(uuid())

  userId       String
  user User @relation(fields: [userId], references: [id], onDelete: Cascade)

  refreshToken String   @unique
  deviceInfo   String? 
  ipAddress    String?
  lastUsedAt   DateTime @default(now())
  expiresAt    DateTime
  isRevoked    Boolean  @default(false)

  createdAt    DateTime @default(now())
  updatedAt    DateTime @updatedAt
}

// Stripe
enum SubscriptionStatus {
  active
  past_due
  canceled
  unpaid
}
model Subscription {
  id                   String   @id @default(uuid())
  userId               String   @unique
  stripeCustomerId     String
  stripeSubscriptionId String
  status               SubscriptionStatus
  currentPeriodEnd     DateTime
  cancelAtPeriodEnd    Boolean  @default(false)
  createdAt            DateTime @default(now())
  updatedAt            DateTime @updatedAt

  user User @relation(fields: [userId], references: [id], onDelete: Cascade)
}

enum PaymentStatus {
  succeeded
  failed
}
enum PaymentMode {
  subscription
  renewal
}
model Payment {
  id              String   @id @default(uuid())
  userId          String
  amount          Int
  status          PaymentStatus
  stripePaymentId String
  plan            Plan
  mode           PaymentMode
  createdAt       DateTime @default(now())

  user User @relation(fields: [userId], references: [id], onDelete: Cascade)
}

// Tickets
enum TicketType {
  RE_ANALYSIS
  RE_REPORT
}
enum TicketStatus {
  OPEN
  IN_PROGRESS
  RESOLVED
  DISMISSED
}
enum TicketPriority {
  LOW
  MEDIUM
  HIGH
}
model Ticket {
  id       String       @id @default(uuid())
  code     String       @unique
  type     TicketType
  status   TicketStatus   @default(OPEN)
  priority TicketPriority @default(MEDIUM)
  reason   String

  scanId   String?
  scan     Scan?    @relation("TicketScan", fields: [scanId], references: [id], onDelete: SetNull)

  reportId String?
  report   Report?  @relation("TicketReport", fields: [reportId], references: [id], onDelete: SetNull)

  submittedById String
  submittedBy   User   @relation("TicketSubmittedBy", fields: [submittedById], references: [id], onDelete: Cascade)

  assignedToId String?
  assignedTo   User?    @relation("TicketAssignedTo", fields: [assignedToId], references: [id], onDelete: SetNull)

  resolutionNote     String?
  reanalysisScanId   String?
  reanalysisScan     Scan?   @relation("TicketReanalysisScan", fields: [reanalysisScanId], references: [id], onDelete: SetNull)
  reanalysisReportId String?
  reanalysisReport   Report? @relation("TicketReanalysisReport", fields: [reanalysisReportId], references: [id], onDelete: SetNull)

  createdAt  DateTime  @default(now())
  updatedAt  DateTime  @updatedAt
  resolvedAt DateTime?

  @@index([status])
  @@index([type])
  @@index([submittedById])
  @@index([createdAt])
}

// Audit Logs
enum AuditCategory {
  scans
  patients
  members
  api
  reports
}
enum AuditSeverity {
  info
  success
  warning
  danger
}
enum AuditStatus {
  success
  failed
}
model AuditLog {
  id          String        @id @default(uuid())

  orgId       String?
  organization Organization? @relation(fields: [orgId], references: [id], onDelete: Cascade)

  actorId     String?
  actor       User?         @relation(fields: [actorId], references: [id], onDelete: SetNull)
  actorName   String
  actorEmail  String

  action      String
  category    AuditCategory
  status      AuditStatus   @default(success)
  severity    AuditSeverity @default(info)

  target      String
  targetId    String?

  ip          String?
  userAgent   String?

  createdAt   DateTime      @default(now())

  @@index([orgId, createdAt])
  @@index([orgId, category])
  @@index([orgId, status])
  @@index([orgId, actorEmail])
}