aurora_standard.chmmbc37
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| visit_no | int(11) | YES | ||||
| policy_holder_name | varchar(19) | YES | ||||
| plan_carrier_name | varchar(12) | YES | ||||
| plan_carrier_addr | varchar(19) | YES | ||||
| plan_carrier_city | varchar(15) | YES | ||||
| plan_carrier_state | varchar(2) | YES | ||||
| plan_carrier_zip | varchar(9) | YES | ||||
| policy_number | varchar(12) | YES | ||||
| ocna_number | int(11) | YES | ||||
| oth_carrier_group | varchar(10) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |
References
| Local Column | References | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| visit_no |
|