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