Drugbank ERD
Tables (11)
Articles (Untitled7)
- ref-id (Key2) — int — Primary key — NOT NULL
- pubmed_id (Field) — int
- citation (Field2)
Calculated-properties (Untitled2)
- cp_id (Key2) — int — Primary key — NOT NULL
- source (Field3) — varchar(1000)
- kind (Field) — varchar(1000)
- value (Field2) — float
- drugbank_id (Key) — int — Foreign key → Drug.drugbank_id — NOT NULL
Drug (Untitled)
- drugbank_id (Key) — int — Primary key — NOT NULL
- drug_name (Field) — varchar(255)
- decription (Field2) — varchar(1000)
- cas-number (Field3) — int
- reactions (Field4) — varchar(1000)
- average-mass (Field5) — varchar(255)
- monoisotopic-mass (Field6) — varchar(255)
- state (Field7) — varchar(255)
Drug_Patents (Untitled12)
- drug_patens_id (Key3) — int — Primary key — NOT NULL
- drugbank_id (Key) — int — Foreign key → Drug.drugbank_id — NOT NULL
- patent_number (Key2) — int — Foreign key → Patents.patent_number — NOT NULL
Drug_Reaction (Untitled4)
- reaction_element_id (Key2) — int — Primary key — NOT NULL
- drugbank_id (Key3) — int — Foreign key → Drug.drugbank_id — NOT NULL
- reaction_id (Key4) — int — Foreign key → Reaction.reaction_id — NOT NULL
- position (Field) — varchar(5)
General-references (Untitled6)
- drugbank_id (Key) — int — Foreign key → Drug.drugbank_id — NOT NULL
Links (Untitled8)
- ref-id (Key) — int — Primary key — NOT NULL
- title (Field) — varchar(255)
- url (Field2) — varchar(1000)
Patents (Untitled11)
- patent_number (Key2) — int — Primary key — NOT NULL
- country (Field) — varchar(255)
- approved (Field2) — varchar(255)
- expires (Field3) — varchar(255)
- pediatric_extension (Field4) — boolean
Reaction (Untitled3)
- reaction_id (Key) — int — Primary key — NOT NULL
- sequence (Field) — varchar(255)
References_Articles (Untitled9)
- references_articles_id (Key3) — int — Primary key — NOT NULL
- drugbank_id (Key) — int — Foreign key → General-references.drugbank_id — NOT NULL
- ref-id (Key2) — int — Foreign key → Articles.ref-id — NOT NULL
References_Links (Untitled10)
- references_links_id (Key3) — int — Primary key — NOT NULL
- drugbank_id (Key) — int — Foreign key → General-references.drugbank_id — NOT NULL
- ref-id (Key2) — int — Foreign key → Links.ref-id — NOT NULL