aurora_standard.chmdi10c
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| code10 | varchar(10) | YES | UNI | |||
| eff_date | date | YES | ||||
| del_date | date | YES | ||||
| descrip | varchar(60) | YES | MUL | |||
| long_title | varchar(280) | YES | ||||
| cm1 | varchar(1) | YES | ||||
| cm2 | varchar(1) | YES | ||||
| cm3 | varchar(1) | YES | ||||
| cm4 | varchar(1) | YES | ||||
| cm5 | varchar(1) | YES | ||||
| cm6 | varchar(1) | YES | ||||
| cm7 | varchar(1) | YES | ||||
| rpt_group | varchar(10) | YES | ||||
| code_dec | varchar(10) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |