RxNorm.sources

Field Type Null Default Key Extra Comment
src_id int(11) NO PRI auto_increment
VCUI int(11) YES MUL
RCUI int(11) YES MUL
VSAB varchar(40) YES
RSAB varchar(20) NO UNI
SON varchar(3000) YES
SF varchar(20) YES
SVER varchar(20) YES
VSTART varchar(10) YES
VEND varchar(10) YES
IMETA varchar(10) YES
RMETA varchar(10) YES
SLC varchar(1000) YES
SCC varchar(1000) YES
SRL int(11) YES MUL
TFR int(11) YES MUL
CFR int(11) YES MUL
CXTY varchar(50) YES
TTYL varchar(300) YES
ATNL varchar(1000) YES
LAT varchar(3) YES
CENC varchar(20) YES
CURVER varchar(1) YES
SABIN varchar(1) YES
SSN varchar(3000) YES
SCIT varchar(4000) YES

References

Local Column References