model WorkOrderStatusHistory {
  id          String           @id @default(cuid()) @db.VarChar(30)
  workOrderId String           @db.VarChar(30)
  changedById String?          @db.VarChar(30)
  fromStatus  WorkOrderStatus?
  toStatus    WorkOrderStatus
  note        String?          @db.Text
  changedAt   DateTime         @default(now()) @db.DateTime(3)
  workOrder   WorkOrder        @relation(fields: [workOrderId], references: [id], onDelete: Restrict)
  changedBy   User?            @relation(fields: [changedById], references: [id], onDelete: Restrict)

  @@index([workOrderId, changedAt])
  @@index([changedById])
}
