aurora_standard.chpdeped
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| empl_code | varchar(6) | YES | ||||
| dependent_name | varchar(40) | YES | ||||
| depend_ssn | varchar(11) | YES | ||||
| birthdate | date | YES | ||||
| relationship | char(2) | NO | ||||
| covered_1095b | varchar(1) | YES | ||||
| depend_addr1 | varchar(30) | YES | ||||
| depend_addr2 | varchar(30) | YES | ||||
| depend_city | varchar(20) | YES | ||||
| depend_state | varchar(2) | YES | ||||
| depend_zip | varchar(10) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |
References
| Local Column | References | ||||||
|---|---|---|---|---|---|---|---|
| birthdate |
| ||||||
| empl_code |
| ||||||
| relationship |
|