aurora_standard.chmpr10c
| 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 | ||||
| p1 | varchar(1) | YES | ||||
| p2 | varchar(1) | YES | ||||
| p3 | varchar(1) | YES | ||||
| p4 | varchar(1) | YES | ||||
| p5 | varchar(1) | YES | ||||
| p6 | varchar(1) | YES | ||||
| rpt_group | varchar(10) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |