Drugbank ERD - 2024-04-23 09:49:41

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 — 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 — NOT NULL
  • patent_number (Key2) — int — Foreign key — NOT NULL

Drug_Reaction (Untitled4)

  • reaction_element_id (Key2) — int — Primary key — NOT NULL
  • drugbank_id (Key3) — int — Foreign key — NOT NULL
  • reaction_id (Key4) — int — Foreign key — NOT NULL
  • position (Field) — varchar(5)

General-references (Untitled6)

  • drugbank_id (Key) — int — Foreign key — 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 — NOT NULL
  • ref-id (Key2) — int — Foreign key — NOT NULL

References_Links (Untitled10)

  • references_links_id (Key3) — int — Primary key — NOT NULL
  • drugbank_id (Key) — int — Foreign key — NOT NULL
  • ref-id (Key2) — int — Foreign key — NOT NULL