A Smart Lab Result Portal That Turns Reports Into Clear Answers

// prisma.schema configuration
model User {
  id        String   @id @default(uuid())
  name      String
  email     String   @unique
  role      Role     @default(PATIENT)
  patient   Patient?
  doctor    Doctor?
  logs      AuditLog[]
}

model Patient {
  id        String   @id @default(uuid())
  userId    String   @unique
  user      User     @relation(fields: [userId], references: [id])
  reports   Report[]
}

model Report {
  id         String       @id @default(uuid())
  patientId  String
  patient    Patient      @relation(fields: [patientId], references: [id])
  labId      String
  lab        Lab          @relation(fields: [labId], references: [id])
  title      String
  status     ReportStatus @default(PROCESSING)
  fileUrl    String
  results    LabResult[]
  notes      DoctorNote[]
}

model LabResult {
  id        String   @id @default(uuid())
  reportId  String
  report    Report   @relation(fields: [reportId], references: [id])
  testName  String
  value     String
  unit      String
}

model DoctorNote {
  id        String   @id @default(uuid())
  reportId  String
  report    Report   @relation(fields: [reportId], references: [id])
  doctorId  String
  note      String
}

enum Role {
  PATIENT
  DOCTOR
  LAB_STAFF
  ADMIN
}

enum ReportStatus {
  PROCESSING
  COMPLETED
  REVIEWED
  DELIVERED
}