pillsgood

Tables (4)

Untitled

    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