erd1

Tables (3)

calculated-properties (Untitled2)

  • drugbank_id (Key) — Primary key — NOT NULL
  • kind (Key2) — Primary key — NOT NULL
  • drugbank_id (Key3) — Foreign key → drug.drugbank_id — NOT NULL
  • value (Field)
  • source (Field2)

drug (Untitled)

  • drugbank_id (Key) — Primary key — NOT NULL
  • name (Field)
  • description (Field2)
  • cas-number (Field3)
  • average-mass (Field4)
  • monoisotopic-mass (Field5)
  • state (Field6)

general-reference (Untitled3)

  • ref_id (Key) — Primary key — NOT NULL
  • drugbank_id (Field)