aurora_standard.chxexamr
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| id_no | varchar(20) | YES | ||||
| visit_no | int(11) | YES | MUL | |||
| req_seq | smallint(6) | YES | ||||
| req_date | date | YES | ||||
| routine_stat | varchar(1) | YES | ||||
| portable | varchar(1) | YES | ||||
| on_iv | varchar(1) | YES | ||||
| on_o2 | varchar(1) | YES | ||||
| stret_amb_wchr | varchar(1) | YES | ||||
| input_by | smallint(6) | YES | ||||
| shield | varchar(1) | YES | ||||
| pdp | varchar(1) | YES | ||||
| lmp | date | YES | ||||
| order_phys | int(11) | YES | ||||
| xray_diag | varchar(40) | YES | ||||
| pat_status | varchar(3) | YES | ||||
| room | varchar(3) | YES | ||||
| myelogram | varchar(1) | YES | ||||
| fluro_min | decimal(2,0) | YES | ||||
| fluro_sec | decimal(2,0) | YES | ||||
| contrast_lot_no | varchar(20) | YES | ||||
| contrast_expire | date | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |