drug_bank
Tables (20)
Untitled (link)
- Key (ref-id) — Primary key — NOT NULL
- Key (title) — Primary key — NOT NULL
- Field3 (url)
Untitled (state)
- Key (state) — Primary key — NOT NULL
Untitled (links)
- Key (drug_bank_id) — Foreign key → Untitled.Key — NOT NULL
Untitled (articles)
- Key (drug_bank_id) — Foreign key → Untitled.Key — NOT NULL
Untitled (patents_patent)
- Key (drug_bank_id) — Foreign key → Untitled.Key — NOT NULL
- Key (number) — Foreign key → Untitled.Key — NOT NULL
Untitled (patent)
- Key (number) — Primary key — NOT NULL
- Field2 (country)
- Field3 (approved)
- Field4 (expires)
- Field5 (pediatric_extension)
Untitled (patents)
- Key (drug_bank_id) — Foreign key → Untitled.Key — NOT NULL
Untitled (reference_link)
- Key (ref-id) — Foreign key → Untitled.Key — NOT NULL
- Key (title) — Foreign key → Untitled.Key — NOT NULL
- Key (drug_bank_id) — Foreign key → Untitled.Key — NOT NULL
Untitled (reference_article)
- Key (ref-id) — Foreign key → Untitled.Key — NOT NULL
- Key (member_id) — Foreign key → Untitled.Key — NOT NULL
- Key (drug_bank_id) — Foreign key → Untitled.Key — NOT NULL
Untitled (member)
- Key (member_id) — Primary key — NOT NULL
Untitled (drug)
- Key (drug_bank_id) — Primary key — NOT NULL
- Field (name)
- Field (description)
- Field2 (cas-number)
- Field4 (average-mass)
- Field5 (monoisotopic-mass)
- Key (state) — Foreign key → Untitled.Key — NOT NULL
Untitled (article)
- Key (ref-id) — Primary key — NOT NULL
- Key (member_id) — Foreign key → Untitled.Key — NOT NULL
- Field3 (citation)
Untitled (general_references)
- Key (drug_bank_id) — Foreign key → Untitled.Key — NOT NULL
Untitled (reaction_element)
- Key (reaction_element) — Primary key — NOT NULL
- Key (drug_bank_id) — Foreign key → Untitled.Key — NOT NULL
- Key (name) — NOT NULL
Untitled (kind)
- Key (kind) — Primary key — NOT NULL
Untitled (source)
- Key (source) — Primary key — NOT NULL
Untitled (reaction)
- Key (reaction_id) — Primary key — NOT NULL
- Key (drug_bank_id) — Foreign key → Untitled.Key — NOT NULL
- Field (sequence)
- Key (left_element) — Foreign key → Untitled.Key — NOT NULL
- Key (right_element) — Foreign key → Untitled.Key — NOT NULL
Untitled (property)
- Key (property_id) — Primary key — NOT NULL
- Key (drug_bank_id) — Foreign key → Untitled.Key — NOT NULL
- Key (source) — Foreign key → Untitled.Key — NOT NULL
- Field (value)
- Key (kind) — Foreign key → Untitled.Key — NOT NULL
Untitled (reactions)
- Key (drug_bank_id) — Foreign key → Untitled.Key — NOT NULL
Untitled (caculated_properties)
- Key (drug_bank_id) — Foreign key → Untitled.Key — NOT NULL