Drugbank

Tables (11)

Drug (Untitled)

  • Drugbank_id (Key) — int — Primary key — NOT NULL
  • name (Field)
  • description (Field2)
  • cas-number (Field3)
  • averge-mass (Field5)
  • monoisotopic-mass (Field4)
  • state (Field6)

articles (Untitled9)

  • article (Key) — Primary key — NOT NULL
  • ref-id (Field)
  • pubmed-id (Field2)
  • caotion (Field3)

calculated-properties (Untitled3)

  • kind (Key) — Primary key — NOT NULL
  • value (Field)
  • source (Field2)

gemeral_references (Untitled8)

  • Drugbank_id (Key) — int — Foreign key → Drug.Drugbank_id — NOT NULL
  • article (Key2) — Foreign key → articles.article — NOT NULL
  • links (Key3) — Foreign key → links.links — NOT NULL

id_calculated-properties (Untitled2)

  • kind (Key2) — Foreign key → calculated-properties.kind — NOT NULL
  • Drugbank_id (Key) — int — Foreign key → Drug.Drugbank_id — NOT NULL

id_reaction (Untitled5)

  • Drugbank_id (Key) — int — Foreign key → Drug.Drugbank_id — NOT NULL
  • sequence (Key2) — Foreign key → reaction.sequence — NOT NULL

left_element (Untitled6)

  • left_element (Key) — Primary key — NOT NULL
  • Drugbank_id (Key2) — int — Foreign key → Drug.Drugbank_id — NOT NULL

links (Untitled10)

  • links (Key) — Primary key — NOT NULL
  • ref-id (Field)
  • title (Field2)
  • url (Field3)

patents (Untitled11)

  • patent_number (Key) — Primary key — NOT NULL
  • Drugbank_id (Key2) — int — Foreign key → Drug.Drugbank_id — NOT NULL
  • country (Field)
  • approved (Field2)
  • expires (Field3)
  • pediatric_extension (Field4)

reaction (Untitled4)

  • sequence (Key) — Primary key — NOT NULL
  • left_element (Key2) — Foreign key → left_element.left_element — NOT NULL
  • right_element (Key3) — Foreign key → right_element.right_element — NOT NULL

right_element (Untitled7)

  • right_element (Key) — Primary key — NOT NULL
  • Drugbank_id (Key2) — int — Foreign key → Drug.Drugbank_id — NOT NULL