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