pillsgood
Tables (4)
disease (DISEASE)
- Key (disease_id) — BIGINT — Primary key — NOT NULL
- Field (disease_name) — VARCHAR(255)
pill (DRUG)
- 약 인덱스 (pill_id) — BIGINT — Primary key — NOT NULL
- Field (edi_code) — INT
- Field (item_name) — VARCHAR(255)
- Field (ingredient_code) — VARCHAR(255)
- Field (ingredient_name) — VARCHAR(255)
- Field (entp_name) — VARCHAR(255)
- Field (reimbursement) — VARCHAR(255)
- Field (chart) — VARCHAR(255)
- Field (storage_method) — VARCHAR(255)
- Field (valid_term) — VARCHAR(255)
- Field (effect) — TEXT
- Field (usage) — TEXT
- Field (underlying_disease) — TEXT
toboo (INTERACTION)
- 병용금기 (interaction_id) — BIGINT — Primary key — NOT NULL
- 약 인덱스 (drug_code1) — BIGINT — Foreign key → pill.약 인덱스
- 약 인덱스 (drug_code2) — BIGINT — Foreign key → pill.약 인덱스
- Field (taboo_cause) — TEXT