Skip Navigation Bar
NLM logo

Unified Medical Language System® (UMLS®)

DRUGBANK Source Information

Click on a topic below the Source Synopsis section to display details.

Source Synopsis

Web site:
http://www.drugbank.ca/

Authority
The DrugBank database is supported by the Canadian Institutes of Research, Alberta Innovates - Health Solutions, and The Metabolomics Innovation Centre (TMIC).

Purpose
DrugBank combines information on drugs and drug targets.

Description
Drug entries include FDA-approved small molecule and biotech drugs, nutraceuticals and experimental drugs as well as non-redundant protein sequences linked to the drugs.

Update Frequency
DrugBank is updated daily.

RxNorm Update Frequency
DrugBank is updated in each RxNorm monthly release.

Sites Consulted

DrugBank [Internet]. [place unknown: publisher unknown]; [cited 2017 June 20]. Available from http://www.drugbank.ca/; Frequently Asked Questions (FAQ): https://www.drugbank.ca/faqs

Metadata

Field Value
Short NameDrugBank
FamilyDRUGBANK
Source Restriction Level0
LanguageENG
License ContactOMx Personal Health Analytics Inc.
301 - 10359 104 St.
Edmonton
Alberta
Canada
T5J 1B9
312-440-7742
support@omx.io
http://www.drugbank.ca
Content ContactOMx Personal Health Analytics Inc.
Edmonton
Alberta
Canada
T5J 1B9
312-440-7742
support@omx.io
http://www.drugbank.ca

Source Representation

This section lists specific source data elements and provides information on their representation in RxNorm.

Summary of Changes

There are no changes to the original data format or to RxNorm source processing.

Source Provided Files:

The file is available at https://portal.drugbankplus.com/

The following file is used for RxNorm source processing.

File Name Description
Drugs.json Json File

Source-Provided Files: Details

The following is a list of fields in the DrugBank source file used in RxNorm:

File name: Drugs.json
Field Name Description
Primary_accession_number Unique DrugBank accession number consisting of a 2-letter prefix (DB) and a 5-number suffix. This ID is used to access the drug entry via the URL. If an entry is deleted, it's DrugBank ID will not be reused.
Secondary_accession_number It consists of the 4-letter prefix and a 5-number suffix. Each accession number is unique to the drug's generic name. The 4-letter suffix (APRD, EXPT, BIOD, NUTR) indicates the type of drug (APRD=approved small molecule drug, EXPT=experimental drug, BIOD=biotech drug, NUTR=nutraceutical or natural product).
Name Standard name of drug as provided by drug manufacturer.
Synonym Alternate names of the drug
UNII FDA UNII code
Language Language of Synonym

DrugBank Field Representation in RxNorm Files:

Field RxNorm Representation
Primary_accession_number RXNCONSO.CODE
Secondary_accession_number RXNSAT.ATN = SID
Name RXNCONSO.STR
CODE = Primary_accession_number
TTY = "IN"
SUPPRESS = "N"
Synonym RXNCONSO.STR
CODE = Primary_accession_number
TTY = "SY" or "FSY" (TTY = SY when Language field is "English"; TTY = FSY when Language field is not "English")
SUPPRESS = "N"
UNII RXNSAT.ATN = FDA_UNII_CODE
Language Not represented in RxNorm but used to process TTY = "SY" or "FSY"

RxNorm Representation

This section lists RxNorm data elements and traces them back to the specific DrugBank data that populates them.

Summary of Changes

There are no changes to the original data format or to RxNorm source processing.

Source Provided Files:

The file is available at https://portal.drugbankplus.com/

The following file is used for RxNorm source processing.

File Name Description
Drugs.json Json File

RxNorm Identifiers:

Identifiers are assigned as follows:

Identifier Origin
CODE Primary_accession_number
SAUI Not applicable
SCUI Not applicable
SDUI Not applicable

Atoms (RXNCONSO):

Term Type Origin
IN Name
SY Synonym
(Language = "English")
FSY Synonym
(Language = foreign language such as Latin)

Relationships (RXNREL):

No relationships are provided for this source.

Attributes (RXNSAT):

ATN Origin
SID Secondary_accession_number
FDA_UNII_CODE UNII

Data Examples with Sample Database Queries

This section lists source terminology specific data examples and sample database queries using Structured Query Language (SQL) to obtain the data. For more information about RxNorm data and files, see the RxNorm Technical Documentation.

Names and Codes in RXNCONSO.RRF

Here are sample source terminology code, source string, RxNorm Concept Unique Identifier (RXCUI), RxNorm string, RxNorm term type (TTY), and suppress values.

SOURCE_CODE SOURCE_STR RXCUI RXNORM_STR RXNORM_TTY SUPPRESS
DB01050 (RS)-ibuprofen 5640 Ibuprofen IN N
DB01050 (4-isobutylphenyl)-α-methylacetic acid 5640 Ibuprofen IN N
DB01050 Ibuprofeno 5640 Ibuprofen IN N

Here is a sample database query to retrieve the data above:

SELECT distinct rc1.code as source_code, rc1.str as source_str, rc1.rxcui, rc2.str as rxnorm_str, rc2.tty as rxnorm_tty, rc2.suppress
FROM rxnconso rc1, rxnconso rc2
WHERE rc1.code = 'DB01050'
     AND rc1.sab = 'DRUGBANK'
     AND rc1.rxcui = rc2.rxcui
     AND rc2.sab = 'RXNORM';

Names and Relationships in RXNCONSO.RRF and RXNREL.RRF

Here are sample source terminology code, source string, RXCUI, relationship name, RxNorm term type (TTY), brand name, and suppress values.

SOURCE_CODE SOURCE_STR RXCUI RELA RXNORM_TTY BN SUPPRESS
DB01050 α-(4-isobutylphenyl)propionic acid 5640 has_tradename BN Motrin PM N
DB01050 (±)-ibuprofen 5640 has_tradename BN Motrin PM N
DB01050 (±)-α-methyl-4-(2-methylpropyl)benzeneacetic acid 5640 has_tradename BN Addaprin N
DB01050 (±)-p-isobutylhydratropic acid 5640 has_tradename BN Addaprin N

Here is a sample database query to retrieve the data above:

SELECT distinct rc1.code as source_code, rc1.str as source_str, rc1.rxcui, rr.rela, rc2.tty as rxnorm_tty, rc2.str as bn, rc2.suppress
FROM rxnconso rc1, rxnrel rr, rxnconso rc2
WHERE rc1.code = 'DB01050'
     AND rc1.sab = 'DRUGBANK'
     AND rc1.rxcui = rr.rxcui2
     AND rr.rela = 'has_tradename'
     AND rr.rxcui1 = rc2.rxcui
     AND rc2.sab = 'RXNORM'
     AND rc2.tty = 'BN'
     ORDER BY suppress;

Last Reviewed: March 31, 2020