Support & Disputes

model Dispute {
  id            Int      @id @default(autoincrement())
  transactionId Int
  transaction   Transaction @relation(fields: [transactionId], references: [id])
  openedBy      String   // userId
  opener        User     @relation("disputeOpener", fields: [openedBy], references: [id])
  reason        DisputeReason
  description   String
  evidence      Json?    // array of image URLs
  status        DisputeStatus @default(OPEN)
  resolution    String?  // admin's resolution note
  resolvedBy    String?  // admin userId
  resolvedAt    DateTime?
  refundAmount  Decimal? // if partial refund
  createdAt     DateTime @default(now())
  updatedAt     DateTime @updatedAt
}

enum DisputeReason {
  NOT_AS_DESCRIBED
  DAMAGED
  NOT_RECEIVED
  COUNTERFEIT
  OTHER
}

enum DisputeStatus {
  OPEN
  UNDER_REVIEW     // admin is investigating
  RESOLVED_BUYER   // resolved in buyer's favor
  RESOLVED_SELLER  // resolved in seller's favor
  RESOLVED_PARTIAL // compromise
  CLOSED
}

model SupportThread {
  id        Int      @id @default(autoincrement())
  disputeId Int?     // optional: linked to dispute
  dispute   Dispute? @relation(fields: [disputeId], references: [id])
  userId    String   // user who opened support
  user      User     @relation(fields: [userId], references: [id])
  subject   String
  status    SupportStatus @default(OPEN)
  messages  SupportMessage[]
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}

model SupportMessage {
  id          Int      @id @default(autoincrement())
  threadId    Int
  thread      SupportThread @relation(fields: [threadId], references: [id])
  senderId    String   // userId (user or admin)
  sender      User     @relation(fields: [senderId], references: [id])
  content     String
  attachments Json?    // image URLs
  createdAt   DateTime @default(now())
}

enum SupportStatus {
  OPEN
  AWAITING_USER
  AWAITING_ADMIN
  RESOLVED
  CLOSED
}