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