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)