detail_hasil_lab
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| noorder (Primary) | varchar(15) | No | ||||
| kd_jenis_prw (Primary) | varchar(15) | No | ||||
| id_template (Primary) | int | No | ||||
| nilai | varchar(60) | No | ||||
| nilai_rujukan | varchar(30) | No | ||||
| keterangan | varchar(60) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | noorder | A | No | ||
| kd_jenis_prw | A | No | ||||||
| id_template | 0 | A | No |
detail_permintaan_lab
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| noorder (Primary) | varchar(15) | No | ||||
| kd_jenis_prw (Primary) | varchar(15) | No | ||||
| id_template (Primary) | int | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | noorder | A | No | ||
| kd_jenis_prw | A | No | ||||||
| id_template | 13 | A | No |
lis_order
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| ID (Primary) | bigint | No | ||||
| MESSAGE_DT | datetime | Yes | NULL | |||
| ORDER_CONTROL | enum('NW', 'RP', 'CA') | Yes | NULL | |||
| PID | varchar(15) | Yes | NULL | |||
| PNAME | varchar(40) | Yes | NULL | |||
| ADDRESS1 | varchar(100) | Yes | NULL | |||
| ADDRESS2 | varchar(100) | Yes | NULL | |||
| ADDRESS3 | varchar(100) | Yes | NULL | |||
| ADDRESS4 | varchar(100) | Yes | NULL | |||
| PTYPE | enum('IN', 'OP') | Yes | NULL | |||
| BIRTH_DT | date | Yes | NULL | |||
| SEX | enum('1', '2') | Yes | NULL | |||
| ONO | varchar(17) | Yes | NULL | |||
| REQUEST_DT | datetime | Yes | NULL | |||
| SOURCE | varchar(80) | Yes | NULL | |||
| CLINICIAN | varchar(80) | Yes | NULL | |||
| ROOM_NO | varchar(15) | Yes | NULL | |||
| PRIORITY | enum('R', 'U') | Yes | NULL | |||
| COMMENT | varchar(80) | Yes | NULL | |||
| VISITNO | varchar(17) | Yes | NULL | |||
| ORDER_TESTID | varchar(2000) | Yes | NULL | |||
| FLAG | enum('0', '1') | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | ID | 6 | A | No | |
| ONO | BTREE | Yes | No | ONO | A | Yes |
lis_order_detail
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| ID (Primary) | bigint | No | ||||
| MESSAGE_DT | datetime | Yes | NULL | |||
| ORDER_CONTROL | enum('NW', 'RP', 'CA') | Yes | NULL | |||
| PID | varchar(15) | Yes | NULL | |||
| PNAME | varchar(40) | Yes | NULL | |||
| ADDRESS1 | varchar(100) | Yes | NULL | |||
| ADDRESS2 | varchar(100) | Yes | NULL | |||
| ADDRESS3 | varchar(100) | Yes | NULL | |||
| ADDRESS4 | varchar(100) | Yes | NULL | |||
| PTYPE | enum('IN', 'OP') | Yes | NULL | |||
| BIRTH_DT | date | Yes | NULL | |||
| SEX | enum('1', '2') | Yes | NULL | |||
| ONO | varchar(17) | Yes | NULL | |||
| REQUEST_DT | datetime | Yes | NULL | |||
| SOURCE | varchar(80) | Yes | NULL | |||
| CLINICIAN | varchar(80) | Yes | NULL | |||
| ROOM_NO | varchar(15) | Yes | NULL | |||
| PRIORITY | enum('R', 'U') | Yes | NULL | |||
| COMMENT | varchar(80) | Yes | NULL | |||
| VISITNO | varchar(17) | Yes | NULL | |||
| ORDER_TESTID | varchar(2000) | Yes | NULL | |||
| FLAG | enum('0', '1') | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | ID | 0 | A | No | |
| ONO | BTREE | Yes | No | ONO | A | Yes |
permintaan_lab
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| noorder (Primary) | varchar(15) | No | ||||
| no_rawat | varchar(17) | No | ||||
| no_rkm_medis | varchar(15) | No | ||||
| nm_pasien | varchar(40) | No | ||||
| varchar(50) | No | |||||
| jk | enum('L', 'P') | Yes | NULL | |||
| tmp_lahir | varchar(15) | Yes | NULL | |||
| tgl_lahir | date | Yes | NULL | |||
| alamat | varchar(200) | Yes | NULL | |||
| tgl_permintaan | date | No | ||||
| jam_permintaan | time | No | ||||
| kode_dokter_perujuk | varchar(20) | No | ||||
| dokter_perujuk | varchar(50) | No | ||||
| status | enum('ralan', 'ranap') | No | ||||
| kode_ruang | varchar(20) | No | ||||
| nama_ruang | varchar(50) | No | ||||
| kode_carabayar | varchar(20) | No | ||||
| nama_carabayar | varchar(50) | No | ||||
| informasi_tambahan | varchar(60) | No | ||||
| diagnosa_klinis | varchar(80) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | noorder | 2 | A | No |
resdt
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| ID (Primary) | bigint | No | ||||
| ONO (Primary) | varchar(17) | No | ||||
| TEST_CD (Primary) | char(20) | No | ||||
| TEST_NM | varchar(50) | Yes | NULL | |||
| DATA_TYP | enum('NM', 'ST', 'FT') | Yes | NULL | |||
| RESULT_VALUE | varchar(40) | Yes | NULL | |||
| RESULT_FT | varchar(8192) | Yes | NULL | |||
| UNIT | varchar(15) | Yes | NULL | |||
| FLAG | enum('L', 'H', 'LL', 'HH') | Yes | NULL | |||
| REF_RANGE | varchar(50) | Yes | NULL | |||
| STATUS | enum('D', 'F') | Yes | NULL | |||
| TEST_COMMENT | varchar(300) | Yes | NULL | |||
| VALIDATE_BY | varchar(60) | Yes | NULL | |||
| VALIDATE_ON | datetime | Yes | NULL | |||
| DISP_SEQ | varchar(15) | Yes | NULL | |||
| ORDER_TESTID | varchar(6) | Yes | NULL | |||
| ORDER_TESTNM | varchar(30) | Yes | NULL | |||
| TEST_GROUP | varchar(20) | Yes | NULL | |||
| ITEM_PARENT | varchar(6) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | ID | A | No | ||
| ONO | A | No | ||||||
| TEST_CD | 0 | A | No | |||||
| ONO | BTREE | Yes | No | ONO | A | No | ||
| TEST_CD | 0 | A | No |
reshd
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| ID (Primary) | bigint | No | ||||
| PID | varchar(15) | Yes | NULL | |||
| APID | varchar(16) | Yes | NULL | |||
| PNAME | varchar(40) | Yes | NULL | |||
| ONO (Primary) | varchar(17) | No | ||||
| LNO | varchar(20) | Yes | NULL | |||
| REQUEST_DT | datetime | Yes | NULL | |||
| SOURCE_CD | varchar(6) | Yes | NULL | |||
| SOURCE_NM | varchar(50) | Yes | NULL | |||
| CLINICIAN_CD | varchar(20) | Yes | NULL | |||
| CLINICIAN_NM | varchar(50) | Yes | NULL | |||
| PRIORITY | enum('R', 'U') | Yes | NULL | |||
| COMMENT | varchar(80) | Yes | NULL | |||
| VISITNO | varchar(17) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | ID | A | No | ||
| ONO | 0 | A | No | |||||
| ONO | BTREE | Yes | No | ONO | 0 | A | No |