RxNorm.simple_concept_and_atom_attributes

Field Type Null Default Key Extra Comment
RXCUI int(11) YES MUL
LUI int(11) YES MUL
SUI int(11) YES MUL
RXAUI int(11) YES MUL
STYPE varchar(50) YES
CODE varchar(50) YES
ATUI int(11) YES MUL
SATUI int(11) YES MUL
ATN varchar(1000) NO MUL
SAB varchar(20) NO
ATV varchar(4000) YES MUL
SUPPRESS varchar(1) YES
CVF varchar(50) YES

References

Local Column References
RXCUI
TableColumn
RxNorm.archive_dataMERGED_TO_RXCUI
RxNorm.concept_changesOLD_RXCUI
RxNorm.concept_changesNEW_RXCUI