aurora_standard.chsmodsr
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| incident_no | bigint(20) unsigned | NO | PRI | auto_increment | ||
| hospital_code | varchar(6) | YES | MUL | |||
| req_type | varchar(2) | YES | ||||
| req_name | varchar(20) | YES | ||||
| req_date | date | YES | ||||
| fix_date | date | YES | ||||
| input_by | varchar(4) | YES | ||||
| module_code | varchar(5) | YES | ||||
| prob_desc1 | varchar(70) | YES | ||||
| owner | varchar(3) | YES | MUL | |||
| priority | smallint(6) | YES | ||||
| prob_desc2 | varchar(70) | YES | ||||
| prob_desc3 | varchar(70) | YES | ||||
| prob_desc4 | varchar(70) | YES | ||||
| last_act_date | date | YES | ||||
| req_time | time | YES | ||||
| menu_opt | varchar(55) | YES | ||||
| ring_menu | varchar(55) | YES | ||||
| visit | varchar(55) | YES | ||||
| select | varchar(70) | YES | ||||
| fac_no | varchar(3) | YES | ||||
| var_text | varchar(255) | YES |