aurora_standard.bhbadd
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| full_name | char(50) | YES | ||||
| mrno | char(20) | NO | PRI | |||
| gu_no | varchar(20) | YES | ||||
| adm_dt | varchar(10) | NO | PRI | |||
| dis_dt | char(10) | YES | ||||
| fc_desc | varchar(20) | YES | ||||
| ts_cd | char(10) | YES | ||||
| trn_dt | varchar(10) | YES | ||||
| coll_ag | varchar(10) | YES | ||||
| last_dt_amt | varchar(30) | YES | ||||
| bdbal | decimal(16,2) | NO | 0.00 | PRI | ||
| fac | varchar(3) | YES | ||||
| dischg_dt | date | YES | MUL | |||
| vis_no | int(11) | YES | MUL | |||
| new_guar | int(11) | YES | ||||
| birth_dt | date | YES | ||||
| new_mrno | varchar(20) | YES | MUL | |||
| mr_number | int(11) | YES | ||||
| p_ssn | varchar(20) | YES |