| id |
int(10)
|
|
|
|
| no_rawat |
varchar(80)
|
utf8_general_ci
|
|
|
| no_rm |
varchar(40)
|
utf8_general_ci
|
|
|
| nama_pasien |
varchar(160)
|
utf8_general_ci
|
|
|
| tanggal_kunjungan |
date
|
|
|
|
| tanggal_kejadian |
date
|
|
|
|
| lokasi_kejadian |
varchar(255)
|
utf8_general_ci
|
|
|
| jenis_kecelakaan |
varchar(120)
|
utf8_general_ci
|
|
|
| no_laporan |
varchar(120)
|
utf8_general_ci
|
|
|
| no_surat_jaminan |
varchar(120)
|
utf8_general_ci
|
|
|
| no_berkas_klaim |
varchar(120)
|
utf8_general_ci
|
|
|
| tanggal_pengajuan |
date
|
|
|
|
| tanggal_dibayar |
date
|
|
|
|
| diagnosa |
text
|
utf8_general_ci
|
|
|
| tindakan |
text
|
utf8_general_ci
|
|
|
| total_biaya |
decimal(18,2)
|
|
|
|
| nilai_dijamin |
decimal(18,2)
|
|
|
|
| nominal_dibayar |
decimal(18,2)
|
|
|
|
| selisih |
decimal(18,2)
|
|
|
|
| status_klaim |
varchar(30)
|
utf8_general_ci
|
|
|
| status_pembayaran |
varchar(30)
|
utf8_general_ci
|
|
|
| berkas_laporan_polisi |
tinyint(1)
|
|
|
|
| berkas_surat_jaminan |
tinyint(1)
|
|
|
|
| berkas_identitas |
tinyint(1)
|
|
|
|
| berkas_resume_medis |
tinyint(1)
|
|
|
|
| berkas_rincian_biaya |
tinyint(1)
|
|
|
|
| catatan |
text
|
utf8_general_ci
|
|
|
| created_by |
varchar(80)
|
utf8_general_ci
|
|
|
| created_at |
datetime
|
|
|
|
| updated_by |
varchar(80)
|
utf8_general_ci
|
|
|
| updated_at |
datetime
|
|
|
|
