| id |
bigint(20)
|
|
|
|
| no_surat |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| no_rawat |
varchar(17)
|
utf8mb4_unicode_ci
|
|
|
| tanggal |
date
|
|
|
|
| pengobatan_kepada |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| nilai_kepercayaan |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| nama_pj |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| umur_pj |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| no_ktppj |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| jkpj |
enum('L', 'P')
|
utf8mb4_unicode_ci
|
|
|
| bertindak_atas |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| no_telp |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| nama_pj2 |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| umur_pj2 |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| no_ktppj2 |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| jkpj2 |
enum('L', 'P')
|
utf8mb4_unicode_ci
|
|
|
| bertindak_atas2 |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| no_telp2 |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| nip |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| nip2 |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| surat_jaminan |
enum('Ya', 'Tidak', '')
|
utf8mb4_unicode_ci
|
|
|
| status |
enum('draft', 'input', 'foto_ttd', 'selesai')
|
utf8mb4_unicode_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|