drug
Tables (3)
calculated_properties
- drugbank_id — VARCHAR(50) — Primary key
- id — INT
- kind — VARCHAR(255)
- value — VARCHAR(255)
- source — VARCHAR(255)
drugs
- drugbank_id (drugbank_id2) — VARCHAR(50) — Foreign key → calculated_properties.drugbank_id
- name — VARCHAR(255)
- description — TEXT
- cas_number — VARCHAR(50)
- average_mass — FLOAT
- monoisotopic_mass — FLOAT
- state — VARCHAR(50)
reactions
- drugbank_id — VARCHAR(50) — Foreign key → drugs.drugbank_id
- reaction_id — INT
- sequence — INT
- left_element — TEXT
- right_element — TEXT