aurora_standard.bhldgr
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| mrno | char(20) | YES | MUL | |||
| p_ssn | char(20) | YES | MUL | |||
| adm_dt | char(10) | YES | ||||
| adm_hr | char(2) | YES | ||||
| dis_dt | char(10) | YES | ||||
| dis_hr | char(2) | YES | ||||
| guar_no | bigint(20) | YES | MUL | |||
| guar_ssn | varchar(20) | YES | ||||
| fac | varchar(3) | YES | ||||
| admit_dt | date | YES | ||||
| dischg_dt | date | YES | ||||
| vis_no | int(20) unsigned | YES | UNI | |||
| new_guar | int(20) | YES | ||||
| birth_dt | date | YES | ||||
| new_mrno | varchar(20) | YES | ||||
| mr_number | int(11) | YES |