| id | bigint(20) unsigned |
|
|
|
| episode_type | varchar(20) |
|
|
|
| episode_id | bigint(20) unsigned |
|
|
0
|
| episode_key | varchar(80) |
|
|
|
| no_kartu | varchar(120) |
|
|
|
| idrm | varchar(80) |
|
|
|
| nama_pasien | varchar(180) |
|
|
|
| jenis_kelamin | varchar(40) |
|
|
|
| tanggal_lahir | date |
|
|
|
| alamat | text |
|
|
|
| tanggal_masuk | date |
|
|
|
| tanggal_keluar | date |
|
|
|
| ruang_poli | varchar(160) |
|
|
|
| dokter_dpjp | varchar(160) |
|
|
|
| diagnosa_masuk | text |
|
|
|
| diagnosa_utama | text |
|
|
|
| diagnosa_sekunder | text |
|
|
|
| tindakan_prosedur | text |
|
|
|
| anamnesis | text |
|
|
|
| pemeriksaan_fisik | text |
|
|
|
| pemeriksaan_penunjang | text |
|
|
|
| terapi_diberikan | text |
|
|
|
| obat_pulang | text |
|
|
|
| kondisi_pulang | varchar(120) |
|
|
|
| cara_pulang | varchar(120) |
|
|
|
| rencana_kontrol | text |
|
|
|
| instruksi_pulang | text |
|
|
|
| diet | text |
|
|
|
| aktivitas | text |
|
|
|
| alergi | text |
|
|
|
| catatan | text |
|
|
|
| status_lokalis_label | varchar(120) |
|
|
|
| status_lokalis_gambar | varchar(255) |
|
|
|
| status_dokumen | varchar(20) |
|
|
draft
|
| dibuat_oleh | varchar(120) |
|
|
|
| updated_by | varchar(120) |
|
|
|
| created_at | datetime |
|
|
2026-08-05 23:52:20.000000
|
| updated_at | datetime |
|
|
2026-08-05 23:52:20.000000
|
| deleted_at | datetime |
|
|
2026-08-05 23:52:20.000000
|