| PRODUCT |
varchar(15)
|
utf8mb4_general_ci
|
|
|
| VERSION |
varchar(15)
|
utf8mb4_general_ci
|
|
|
| PMRN |
varchar(15)
|
utf8mb4_general_ci
|
|
|
| PNAME |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| SEX |
varchar(1)
|
utf8mb4_general_ci
|
|
|
| BIRTH_DT |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| ADDRESS |
varchar(250)
|
utf8mb4_general_ci
|
|
|
| NO_TLP |
varchar(25)
|
utf8mb4_general_ci
|
|
|
| NO_HP |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| EMAIL |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| NIK |
varchar(60)
|
utf8mb4_general_ci
|
|
|
| ORDER_CONTROL |
varchar(2)
|
utf8mb4_general_ci
|
|
|
| PTYPE |
varchar(2)
|
utf8mb4_general_ci
|
|
|
| REG_NO |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| PROVIDER_ID |
varchar(15)
|
utf8mb4_general_ci
|
|
|
| PROVIDER_NAME |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| ORDER_DATE |
datetime
|
|
|
|
| CLINICIAN_ID |
varchar(15)
|
utf8mb4_general_ci
|
|
|
| CLINICIAN_NAME |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| BANGSAL_ID |
varchar(15)
|
utf8mb4_general_ci
|
|
|
| BANGSAL_NAME |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| BED_ID |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| BED_NAME |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| CLASS_ID |
varchar(15)
|
utf8mb4_general_ci
|
|
|
| CLASS_NAME |
varchar(15)
|
utf8mb4_general_ci
|
|
|
| CITO |
varchar(1)
|
utf8mb4_general_ci
|
|
|
| MED_LEGAL |
varchar(1)
|
utf8mb4_general_ci
|
|
|
| USER_ID |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| RESERVE |
text
|
utf8mb4_general_ci
|
|
|
| ORDER_RAD |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| KODE_TEST_HIS |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| NAMA_TEST_HIS |
varchar(250)
|
utf8mb4_general_ci
|
|
|
| CLINICIANRAD_ID |
varchar(15)
|
utf8mb4_general_ci
|
|
|
| CLINICIANRAD_NAME |
varchar(100)
|
utf8mb4_general_ci
|
|
|