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