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)