| id | bigint(20) unsigned |
|
|
|
| episode_key | varchar(60) |
|
|
|
| patient_name | varchar(180) |
|
|
|
| idrm | varchar(80) |
|
|
|
| no_visum | varchar(120) |
|
|
|
| request_number | varchar(180) |
|
|
|
| request_agency | varchar(180) |
|
|
|
| request_signer | varchar(180) |
|
|
|
| request_date | date |
|
|
|
| request_received_at | datetime |
|
|
2026-10-04 20:51:36.000000
|
| examined_at | datetime |
|
|
2026-10-04 20:51:36.000000
|
| doctor_name | varchar(160) |
|
|
|
| doctor_sip | varchar(160) |
|
|
|
| nationality | varchar(80) |
|
|
|
| occupation | varchar(120) |
|
|
|
| religion | varchar(80) |
|
|
|
| chronology | longtext |
|
|
|
| general_condition | text |
|
|
|
| findings_json | longtext |
|
|
|
| conclusion | longtext |
|
|
|
| status_document | varchar(20) |
|
|
draft
|
| cash_amount | decimal(18,2) |
|
|
|
| cash_payment | varchar(20) |
|
|
|
| income_cash_code | varchar(20) |
|
|
|
| income_cash_row_id | bigint(20) |
|
|
|
| hospital_percentage | decimal(5,2) |
|
|
|
| hospital_amount | decimal(18,2) |
|
|
|
| operator_percentage | decimal(5,2) |
|
|
|
| operator_amount | decimal(18,2) |
|
|
|
| operator_payment | varchar(20) |
|
|
|
| operator_cash_code | varchar(20) |
|
|
|
| operator_cash_row_id | bigint(20) |
|
|
|
| cash_table | varchar(80) |
|
|
|
| cash_row_id | bigint(20) |
|
|
|
| cash_approved_at | datetime |
|
|
2026-10-04 20:51:36.000000
|
| cash_approved_by | varchar(120) |
|
|
|
| created_by | varchar(120) |
|
|
|
| updated_by | varchar(120) |
|
|
|
| created_at | datetime |
|
|
2026-10-04 20:51:36.000000
|
| updated_at | datetime |
|
|
2026-10-04 20:51:36.000000
|
| deleted_at | datetime |
|
|
2026-10-04 20:51:36.000000
|