aurora_standard.newicd10
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| cd_type | varchar(1) | YES | ||||
| code10 | varchar(10) | YES | UNI | |||
| eff_dt | varchar(8) | YES | ||||
| termination_dt | varchar(8) | YES | ||||
| short_title | varchar(60) | YES | ||||
| 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 | ||||
| p1 | varchar(1) | YES | ||||
| p2 | varchar(1) | YES | ||||
| p3 | varchar(1) | YES | ||||
| p4 | varchar(1) | YES | ||||
| p5 | varchar(1) | YES | ||||
| p6 | varchar(1) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |
References
| Local Column | References | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| code10 |
| ||||||||||||||||
| p1 |
| ||||||||||||||||
| p2 |
| ||||||||||||||||
| eff_dt |
|