RxNorm.archive_data
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| RXAUI | int(11) | NO | MUL | |||
| AUI | int(11) | YES | MUL | |||
| STR | varchar(4000) | NO | ||||
| ARCHIVE_TIMESTAMP | varchar(280) | NO | ||||
| CREATED_TIMESTAMP | varchar(280) | NO | ||||
| UPDATED_TIMESTAMP | varchar(280) | NO | ||||
| CODE | varchar(50) | YES | ||||
| IS_BRAND | varchar(1) | YES | ||||
| LAT | varchar(3) | YES | ||||
| LAST_RELEASED | varchar(30) | YES | ||||
| SAUI | int(11) | YES | MUL | |||
| VSAB | varchar(40) | YES | ||||
| RXCUI | int(11) | YES | MUL | |||
| SAB | varchar(20) | YES | ||||
| TTY | varchar(20) | YES | ||||
| MERGED_TO_RXCUI | varchar(8) | YES |
References
| Local Column | References | ||||||
|---|---|---|---|---|---|---|---|
| RXCUI |
|