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