aurora_standard.c9mpi
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| p_ssn | varchar(20) | YES | MUL | |||
| mrno | int(11) | YES | UNI | |||
| pname | char(50) | YES | ||||
| p_dob | varchar(10) | YES | ||||
| p_sex | varchar(1) | YES | ||||
| pri_phy_nm | varchar(40) | YES | ||||
| gu_no | int(20) | YES | ||||
| spouse_nm | varchar(40) | YES | ||||
| p_addr1 | char(30) | YES | ||||
| p_addr2 | char(30) | YES | ||||
| p_county | char(20) | YES | ||||
| p_cityst | char(30) | YES | ||||
| p_zip | char(20) | YES | ||||
| p_ph_area | char(3) | YES | ||||
| p_ph_no | char(20) | YES | ||||
| marital | char(20) | YES | ||||
| race | char(10) | YES | ||||
| relig_desc | char(20) | YES | ||||
| nk_nm | varchar(50) | YES | ||||
| nk_addr | varchar(50) | YES | ||||
| nk_cityst | varchar(50) | YES | ||||
| nk_zip | varchar(20) | YES | ||||
| nk_ph_area | varchar(3) | YES | ||||
| nk_ph_no | varchar(10) | YES | ||||
| nk_ph_2 | varchar(20) | YES | ||||
| nk_rel | varchar(10) | YES | ||||
| prim_lang | varchar(20) | YES |