Drugbank ERD
Tables (13)
article (Untitled9)
- ref_id (Key) — Primary key — NOT NULL
- ]pubmed_id (Field2)
- cituation (Field3)
calculated-properties (Untitled6)
- kind (Key3) — Foreign key → kind.kind — NOT NULL
- value (Field)
- source (Key2) — Foreign key → source.source — NOT NULL
drug (Untitled)
- drugbank_id (Key) — Primary key — NOT NULL
- name (Field)
- description (Field2)
- cas-number (Field3)
- average-mass (Field4)
- monoisotopic-mass (Field5)
- state (Field6)
drug-calculated (Untitled2)
- kind (Key3) — Foreign key → calculated-properties.kind — NOT NULL
- drugbank_id (Key2) — Foreign key → drug.drugbank_id — NOT NULL
drug-reaction (Untitled5)
- sequence (Key2) — Primary key — NOT NULL
- drugbank_id (Key) — Foreign key → drug.drugbank_id — NOT NULL
- left_element (Key23) — Foreign key → reaction-element.drugbank_id — NOT NULL
- right_element (Key24) — Foreign key → reaction-element.drugbank_id — NOT NULL
general-references (Untitled3)
- drugbank_id (Key4) — Foreign key → drug.drugbank_id — NOT NULL
- ref_id (Key) — Foreign key → reference-list.ref_id — NOT NULL
- ref_id (Key2) — Foreign key → reference-list.ref_id — NOT NULL
kind (Untitled12)
- kind (Key) — Primary key — NOT NULL
links (Untitled10)
- ref_id (Key) — Primary key — NOT NULL
- url (Field2)
- title (Field3)
patents (Untitled4)
- patent_number (Key2) — Primary key — NOT NULL
- contry (Field)
- approved (Field2)
- expires (Field3)
- pediatric_extension (Field4)
patents (Untitled13)
- drugbank_id (Key) — Foreign key → drug.drugbank_id — NOT NULL
- patent_number (Key2) — Foreign key → patents.patent_number — NOT NULL
reaction-element (Untitled7)
- drugbank_id (Key2) — Foreign key → drug.drugbank_id — NOT NULL
- name (Field)
reference-list (Untitled8)
- ref_id (Key) — Foreign key → article.ref_id — NOT NULL
- ref_id (Key2) — Foreign key → links.ref_id — NOT NULL
source (Untitled11)
- source (Key) — Primary key — NOT NULL