torqvoice/prisma/schema/condition-marks.prisma

/// A mark on the vehicle's condition map: a dent, a scratch, a chip, drawn
/// on a line drawing of the car by tapping where it is.
///
/// Marks belong to the vehicle, not to the sheet they were drawn on. An
/// inspection or a work order records new ones; the next visit starts with
/// the ones still there, greyed, and either confirms them or clears them as
/// repaired. That is what makes "new since last time" a fact rather than an
/// argument. The sheet a mark was drawn on is kept for the print, and lets
/// go of the mark rather than taking it with it when the sheet is deleted.
model ConditionMark {
  id             String       @id @default(cuid())
  organizationId String
  organization   Organization @relation(fields: [organizationId], references: [id], onDelete: Cascade)

  vehicleId String
  vehicle   Vehicle @relation(fields: [vehicleId], references: [id], onDelete: Cascade)

  /// Where it was recorded: the inspection check or the work order's drop-off.
  inspectionId     String?
  inspection       Inspection?     @relation(fields: [inspectionId], references: [id], onDelete: SetNull)
  inspectionItemId String?
  inspectionItem   InspectionItem? @relation(fields: [inspectionItemId], references: [id], onDelete: SetNull)
  serviceRecordId  String?
  serviceRecord    ServiceRecord?  @relation(fields: [serviceRecordId], references: [id], onDelete: SetNull)

  /// Which drawing it sits on, so a body type changed later cannot move it.
  bodyType  String
  /// top | left | right | front | rear
  view      String
  /// The named panel the tap landed on; see condition-map/Lib/drawingTypes.ts.
  panel     String
  /// Position as a fraction of the view's box, 0..1 from the top-left.
  x         Float
  y         Float
  /// dent | scratch | chip | crack | rust | paint | previous_repair | missing
  kind      String
  /// minor | major
  severity  String   @default("minor")
  note      String?
  imageUrls String[] @default([])

  recordedAt   DateTime @default(now())
  recordedById String?
  recordedBy   User?    @relation("ConditionMarkRecordedBy", fields: [recordedById], references: [id], onDelete: SetNull)

  /// Set when a later visit found the damage gone. The mark stays as history
  /// and stops printing as current.
  resolvedAt   DateTime?
  resolvedById String?
  resolvedBy   User?     @relation("ConditionMarkResolvedBy", fields: [resolvedById], references: [id], onDelete: SetNull)
  /// Set with resolvedAt when a later visit confirmed the damage still there
  /// and recorded it again: the id of that newer mark. Closed because it was
  /// superseded, not repaired, so the sheet it was drawn on still prints it
  /// as its own record while the vehicle shows the dent once.
  carriedToId  String?

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

  @@index([vehicleId])
  @@index([inspectionId])
  @@index([inspectionItemId])
  @@index([serviceRecordId])
  @@index([organizationId])
  @@map("condition_marks")
}

/// A workshop's own kind of mark on the condition map: one of the eight
/// built-in kinds renamed or recoloured (the row carries the built-in key),
/// or a kind of the workshop's own. A mark refers to a kind by its key, so a
/// renamed kind changes on every open document at once; an issued invoice and
/// a completed inspection keep the kinds as they were in their own snapshots.
model ConditionMarkType {
  id             String       @id @default(cuid())
  organizationId String
  organization   Organization @relation(fields: [organizationId], references: [id], onDelete: Cascade)

  /// dent, scratch, chip, crack, rust, paint, previous_repair, missing for a
  /// built-in kind; a key made from the id for a workshop's own.
  key       String
  name      String
  /// circle | diamond | triangle | square | cross | hex
  shape     String
  /// A hex colour, printed as it is.
  color     String
  sortOrder Int     @default(0)
  /// Kept out of the picker; marks that carry it still show and print.
  hidden    Boolean @default(false)

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

  @@unique([organizationId, key])
  @@index([organizationId])
  @@map("condition_mark_types")
}