DrugBank

테이블 (10)

Drug_Categories

  • drugbank_id — VARCHAR(20)
  • mesh_id — VARCHAR(20)

Drug_Targets

  • drugbank_id — VARCHAR(20)
  • target_id — VARCHAR(20)

Experimental_Properties

  • drugbank_id — VARCHAR(20)
  • kind — VARCHAR(255)
  • value — TEXT
  • source — VARCHAR(255)

Products

  • drugbank_id — VARCHAR(20)
  • name — VARCHAR(255)
  • labeller — VARCHAR(255)
  • strength — VARCHAR(255)
  • route — VARCHAR(255)
  • approved — BOOLEAN
  • ndc_product_code — VARCHAR(20)
  • ema_ma_number — VARCHAR(255)

References

  • ref_id — INTEGER
  • pubmed_id — INTEGER
  • citation — TEXT

Target_References

  • target_id — VARCHAR(20)
  • ref_id — INTEGER

Targets

  • id — VARCHAR(20)
  • name — VARCHAR(255)
  • organism — VARCHAR(255)

약물 (Drugs)

  • drugbank_id (Key) — VARCHAR(20) — 기본 키 — NOT NULL
  • name — VARCHAR(255)
  • description — TEXT
  • cas_number — VARCHAR(20)
  • state — VARCHAR(50)
  • unii — VARCHAR(20)

외부 식별자 (External_Identifiers)

  • drugbank_id — VARCHAR(20)
  • resource — VARCHAR(255)
  • identifier — VARCHAR(255)

카테고리 (Categories)

  • mesh_id — VARCHAR(20) — 기본 키
  • category — VARCHAR(255)