Skip to content

review_cases

Source: src/db/review-cases/schema.ts

Columns

TypeScript key	SQL column	Notes
`caseId`	`case_id`
`userId`	`user_id`
`rtId`	`rt_id`
`dcId`	`dc_id`
`patientAge`	`patient_age`
`patientGender`	`patient_gender`
`status`	`status`
`medicalHistory`	`medical_history`
`medicalDocuments`	`medical_documents`
`createdDate`	`created_date`
`updatedDate`	`updated_date`
`rejectReason`	`reject_reason`
`cancelReason`	`cancel_reason`
`otherReasonEn`	`other_reason_en`
`otherReasonAr`	`other_reason_ar`
`caseCoordinatorId`	`case_coordinator_id`
`totalAmount`	`total_amount`
`paymentUrl`	`payment_url`
`reqObj`	`req_obj`
`otherDocuments`	`other_documents`
`caseCancelled`	`case_cancelled`
`documentUploadStatus`	`document_upload_status`
`report`	`report`
`reportDate`	`report_date`
`draftNotifSent`	`draft_notif_sent`
`delayReportSent`	`delay_report_sent`

Status values (`status` column)

Value	Description
`draft`	Patient editing; documents can be updated
`payment_pending`	Awaiting payment
`payment_success`	Payment completed
`payment_failed`	Payment did not complete
`review`	Under coordinator/doctor review
`doctor_assigned`	Specialists assigned
`completed`	Final report available
`cancelled`	Cancelled by patient or admin
`rejected`	Rejected by admin

Notes

draft_notif_sent: 0 until UCP98 draft reminder sent, then 1
delay_report_sent: 0 until UCP105 delay reminder sent, then 1
medical_documents: JSON array, max 50 items
user_id comes from JWT — never sent in request body