Drugbank2

Tables (13)

Drug (Drugbank)

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

General-references (Untitled)

  • drugbank_id (PK) — Foreign key → Drug.drugbank_id — NOT NULL
  • article_ref-id (Key) — Foreign key → reference-list-type.article_ref-id — NOT NULL
  • link_ref-id (Key2) — Foreign key → reference-list-type.link_ref-id — NOT NULL

article-type (Untitled4)

  • ref-id (Key) — Primary key — NOT NULL
  • citation (Field2)
  • pubmed_id, (Field)

calculated-propery-list-type (Untitled14)

  • drugbank_id (PK) — Foreign key → Drug.drugbank_id — NOT NULL
  • kind (Key) — Foreign key → property.kind — NOT NULL

kind (Untitled12)

  • kind (Key) — Primary key — NOT NULL

links-type (Untitled5)

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

patent (Untitled6)

  • patent_number (PK) — Primary key — NOT NULL
  • country (Field)
  • approved (Field2)
  • expires (Field3)
  • pediatric_extension (Field4)

patent_patents (Untitled8)

  • drugbank_id (PK) — Foreign key → Drug.drugbank_id — NOT NULL
  • patent_number (PK2) — Foreign key → patent.patent_number — NOT NULL

property (Untitled2)

  • kind (Key) — Foreign key → kind.kind — NOT NULL
  • value (Field)
  • source (Key2) — Foreign key → source.source — NOT NULL

reaction_element_type (Untitled7)

  • drugbank_id (PK) — Foreign key → Drug.drugbank_id — NOT NULL
  • name (Field)

reactions (Untitled3)

  • sequence (PK) — Primary key — NOT NULL
  • drugbank_id (FK) — Foreign key → Drug.drugbank_id — NOT NULL
  • left-element (PK2) — Foreign key → reaction_element_type.drugbank_id — NOT NULL
  • right-element (PK3) — Foreign key → reaction_element_type.drugbank_id — NOT NULL

reference-list-type (Untitled9)

  • article_ref-id (Key) — Foreign key → article-type.ref-id — NOT NULL
  • link_ref-id (Key2) — Foreign key → links-type.ref-id — NOT NULL

source (Untitled13)

  • source (Key) — Primary key — NOT NULL