drugbank

Tables (7)

articles (article-tlb)

  • ref_id (Key2) — Primary key — NOT NULL
  • drugbank_id (Key) — Foreign key → drug.drugbank_id — NOT NULL
  • pubmed_id (Field)
  • citation (Field2)

calculated-properties (calcul-protlb)

  • source (Key4) — Primary key — NOT NULL
  • kind (Key3) — Primary key — NOT NULL
  • drugbank_id (Key2) — Foreign key → drug.drugbank_id — NOT NULL
  • value (Key) — NOT NULL

drug (drug-tbl)

  • drugbank_id (Key) — Primary key — NOT NULL
  • name (Field)
  • description (Field2)
  • cas-number (Field3)
  • average (Field4)
  • monoisotopic (Field5)
  • state (Field6)

drug-patent (drug-patent-tlb)

  • drugbank_id (Key) — Foreign key → drug.drugbank_id — NOT NULL
  • number (Key2) — Foreign key → patents.number — NOT NULL

links (links-tbl)

  • ref_id (Key) — Primary key — NOT NULL
  • drugbank_id (Key2) — Foreign key → drug.drugbank_id — NOT NULL
  • title (Field)
  • url (Field2)

patents (patent-tlb)

  • number (Key) — Primary key — NOT NULL
  • country (Field)
  • approved (Field2)
  • expires (Field3)
  • Field4

reactions (reaction-tbl)

  • left_id (Key) — Primary key — NOT NULL
  • right_id (Key2) — Primary key — NOT NULL
  • sequence (Key4) — Primary key — NOT NULL
  • drugbank_id (Key3) — Foreign key → drug.drugbank_id — NOT NULL
  • left_element_name (Field)
  • right_element_name (Field2)