schema.prisma

generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

// ============================================================================
// Enums
// ============================================================================

enum RequestPriority {
  LOW
  MEDIUM
  HIGH
}

enum UserType {
  STAFF
  PARTNER
}

enum DonorOfferState {
  UNFINALIZED
  FINALIZED
  ARCHIVED
}

enum ShipmentStatus {
  WAITING_ARRIVAL_FROM_DONOR
  LOAD_ON_SHIP_AIR
  ARRIVED_IN_HAITI
  CLEARED_CUSTOMS
  ARRIVED_AT_DEPO
  INVENTORIES
  READY_FOR_DISTRIBUTION
}

enum ItemType {
  MEDICATION
  MEDICATION_SUPPLEMENT
  NON_MEDICATION
}

enum ItemCategory {
  NEEDLES_SYRINGES
  ALZHEIMERS
  ANTIBIOTIC
  ANTIFUNGAL
  ANTIVIRAL
  BOOKS
  CANCER
  CARDIOVASCULAR
  CLOTHING_ACCESSORIES
  DENTAL
  DERMATOLOGY
  DEWORMER
  DIABETES
  EMERGENCY_RELIEF
  ENT
  FACILITY
  FLUID_REPLENISHMENT
  GASTROENTEROLOGY
  GENERAL
  HIV
  HORMONES
  HYGIENE
  LAB
  NEUROLOGICAL
  NUTRITION_SUPPLEMENTS
  OB_GYN
  OFFICE_SUPPLIES
  OPHTHALMOLOGY
  ORTHO
  PAIN_RELIEVERS
  PEDIATRIC
  PPE
  PSYCHIATRIC
  RECREATION
  RESPIRATORY
  STEROID
  SURGICAL
  THYROID
  URINARY_BOWEL
  VACCINES
  WASH
  WOUND_CARE
  X_RAY
}

// ============================================================================
// User Management
// ============================================================================

model User {
  id           Int      @id @default(autoincrement())
  email        String   @unique
  name         String
  passwordHash String
  type         UserType
  tag          String?
  enabled      Boolean  @default(true)
  pending      Boolean  @default(true)
  
  isSuper            Boolean @default(false)
  userRead           Boolean @default(false)
  userWrite          Boolean @default(false)
  itemNotify         Boolean @default(false)
  offerWrite         Boolean @default(false)
  requestRead        Boolean @default(false)
  requestWrite       Boolean @default(false)
  allocationRead     Boolean @default(false)
  allocationWrite    Boolean @default(false)
  archivedRead       Boolean @default(false)
  distributionRead   Boolean @default(false)
  distributionWrite  Boolean @default(false)
  shipmentRead       Boolean @default(false)
  shipmentWrite      Boolean @default(false)
  signoffWrite       Boolean @default(false)
  wishlistRead       Boolean @default(false)
  supportRead        Boolean @default(false)
  supportWrite       Boolean @default(false)
  supportNotify      Boolean @default(false)

  donorOfferVisibilities DonorOffer[]
  partnerDetails         Json?
  generalItemRequests    GeneralItemRequest[]
  allocations            Allocation[]
  distributions          Distribution[]
  wishlists              Wishlist[]
  invite                 UserInvite?
  notifications          Notification[]

  streamUserId    String? @unique
  streamUserToken String? @unique

  dashboardTutorial Boolean @default(false)
  itemsTutorial Boolean @default(false)
  requestsTutorial Boolean @default(false)
  wishlistsTutorial Boolean @default(false)
}

model UserInvite {
  id         Int      @id @default(autoincrement())
  token      String   @unique
  expiration DateTime
  user       User     @relation(fields: [userId], references: [id], onDelete: Cascade)
  userId     Int      @unique
}

// ============================================================================
// Donor Offers
// ============================================================================

model DonorOffer {
  id Int @id @default(autoincrement())

  state                   DonorOfferState
  offerName               String
  donorName               String
  partnerResponseDeadline DateTime
  donorResponseDeadline   DateTime
  archivedAt              DateTime?

  partnerVisibilities User[]
  items               GeneralItem[]
  embeddings          ItemEmbedding[]
}

// ============================================================================
// Items
// ============================================================================

model GeneralItem {
  id Int @id @default(autoincrement())

  donorOfferId Int
  donorOffer   DonorOffer @relation(fields: [donorOfferId], references: [id], onDelete: Cascade)

  title          String
  expirationDate DateTime? @db.Date
  unitType       String

  initialQuantity Int
  requestQuantity Int?

  description String?
  type        ItemType?
  category    ItemCategory?

  weight Decimal @db.Decimal(10, 2)

  requests  GeneralItemRequest[]
  items     LineItem[]
  wishlists Wishlist[]
  embedding ItemEmbedding? @relation("GeneralItemEmbedding")

  @@unique([donorOfferId, title, expirationDate, unitType])
}

// A specific item inside a general item. Ex: a specific box inside a donation of many boxes
model LineItem {
  id Int @id @default(autoincrement())

  // Columns that define a unique line item
  donorName           String
  quantity            Int
  lotNumber           String
  palletNumber        String
  boxNumber           String
  unitPrice           Decimal   @db.Money
  maxRequestLimit     String?
  donorShippingNumber String?
  hfhShippingNumber   String?
  datePosted          DateTime  @default(now())
  ndc                 String?
  notes               String?

  allowAllocations Boolean
  visible          Boolean
  gik              Boolean

  generalItemId Int?
  generalItem   GeneralItem? @relation(fields: [generalItemId], references: [id], onDelete: Cascade)

  allocation Allocation? @relation
}

model ItemEmbedding {
  id            Int      @id @default(autoincrement())
  generalItemId Int?     @unique
  wishlistId    Int?     @unique
  donorOfferId  Int?
  embedding     Unsupported("vector")
  createdAt     DateTime @default(now())
  updatedAt     DateTime @updatedAt

  generalItem GeneralItem? @relation("GeneralItemEmbedding", fields: [generalItemId], references: [id], onDelete: Cascade)
  wishlist    Wishlist?    @relation("WishlistEmbedding", fields: [wishlistId], references: [id], onDelete: Cascade)
  donorOffer  DonorOffer?  @relation(fields: [donorOfferId], references: [id], onDelete: Cascade)

  @@index([donorOfferId])
  @@index([generalItemId])
  @@index([wishlistId])
  @@map("ItemEmbeddings")
}

// ============================================================================
// Requests
// ============================================================================

model GeneralItemRequest {
  id Int @id @default(autoincrement())

  generalItemId Int
  generalItem   GeneralItem @relation(fields: [generalItemId], references: [id], onDelete: Cascade)

  partnerId Int
  partner   User @relation(fields: [partnerId], references: [id], onDelete: Cascade)

  quantity      Int
  finalQuantity Int              @default(0)
  comments      String?
  priority      RequestPriority?

  createdAt DateTime @default(now())

  @@unique([generalItemId, partnerId])
}

// ============================================================================
// Allocations & Distributions
// ============================================================================

model Allocation {
  id Int @id @default(autoincrement())

  partnerId Int?
  partner   User? @relation(fields: [partnerId], references: [id], onDelete: Cascade)

  lineItemId Int      @unique
  lineItem   LineItem @relation(fields: [lineItemId], references: [id], onDelete: Cascade)

  distributionId Int
  distribution   Distribution @relation(fields: [distributionId], references: [id], onDelete: Cascade)

  signOffId Int?
  signOff   SignOff? @relation(fields: [signOffId], references: [id], onDelete: Cascade)
}

model Distribution {
  id Int @id @default(autoincrement())

  partnerId Int
  partner   User @relation(fields: [partnerId], references: [id])

  pending Boolean @default(false)

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

  allocations Allocation[]
}

model SignOff {
  id Int @id @default(autoincrement())

  staffMemberName String
  partnerId       Int
  partnerName     String
  partnerSignerName String?
  date            DateTime
  signatureUrl    String?
  partnerSignatureUrl String?

  createdAt DateTime @default(now())

  allocations Allocation[]
}

// ============================================================================
// Shipping
// ============================================================================

model ShippingStatus {
  id Int @id @default(autoincrement())

  donorShippingNumber String?
  hfhShippingNumber   String?

  value ShipmentStatus

  @@unique([donorShippingNumber, hfhShippingNumber])
}

// ============================================================================
// Wishlists
// ============================================================================

model Wishlist {
  id Int @id @default(autoincrement())

  name     String
  quantity Int?
  priority RequestPriority

  lastUpdated DateTime @updatedAt

  comments  String
  partnerId Int
  partner   User   @relation(fields: [partnerId], references: [id], onDelete: Cascade)

  generalItemId Int?
  generalItem   GeneralItem? @relation(fields: [generalItemId], references: [id])
  embedding     ItemEmbedding? @relation("WishlistEmbedding")
}

// ============================================================================
// Miscellaneous
// ============================================================================

model PasswordResetToken {
  id        Int      @id @default(autoincrement())
  userId    Int
  token     String   @unique
  expiresAt DateTime
  used      Boolean  @default(false)
}

model Notification {
  id           Int       @id @default(autoincrement())
  title        String
  action       String?
  actionText   String?
  dateCreated  DateTime  @default(now())
  dateViewed   DateTime?
  isDelivered  Boolean   @default(false)
  template     String?
  payload      Json?
  userId       Int
  user         User      @relation(fields: [userId], references: [id], onDelete: Cascade)

  @@index([userId, dateViewed])
}