{"medicine": {"columns": [[0, "id", "INT", 0, null, 1], [1, "name", "TEXT", 0, null, 0], [2, "Trade_Name", "TEXT", 0, null, 0], [3, "FDA_approved", "TEXT", 0, null, 0]], "primary_keys": ["id"], "foreign_keys": [], "unique_constraints": [[[0, 0, "id"]]], "check_constraints": []}, "enzyme": {"columns": [[0, "id", "INT", 0, null, 1], [1, "name", "TEXT", 0, null, 0], [2, "Location", "TEXT", 0, null, 0], [3, "Product", "TEXT", 0, null, 0], [4, "Chromosome", "TEXT", 0, null, 0], [5, "OMIM", "INT", 0, null, 0], [6, "Porphyria", "TEXT", 0, null, 0]], "primary_keys": ["id"], "foreign_keys": [], "unique_constraints": [[[0, 0, "id"]]], "check_constraints": []}, "medicine_enzyme_interaction": {"columns": [[0, "enzyme_id", "INT", 0, null, 1], [1, "medicine_id", "INT", 0, null, 2], [2, "interaction_type", "TEXT", 0, null, 0]], "primary_keys": ["enzyme_id", "medicine_id"], "foreign_keys": [[0, 0, "medicine", "medicine_id", "id", "NO ACTION", "NO ACTION", "NONE"], [1, 0, "enzyme", "enzyme_id", "id", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "enzyme_id"], [1, 1, "medicine_id"]]], "check_constraints": []}}
CREATE TABLE medicine (
    id INT   PRIMARY KEY,
    name TEXT,
    Trade_Name TEXT,
    FDA_approved TEXT,
    UNIQUE (id)
);

CREATE TABLE enzyme (
    id INT   PRIMARY KEY,
    name TEXT,
    Location TEXT,
    Product TEXT,
    Chromosome TEXT,
    OMIM INT,
    Porphyria TEXT,
    UNIQUE (id)
);

CREATE TABLE medicine_enzyme_interaction (
    enzyme_id INT   PRIMARY KEY,
    medicine_id INT   PRIMARY KEY,
    interaction_type TEXT,
    PRIMARY KEY (enzyme_id, medicine_id),
    UNIQUE (enzyme_id, medicine_id),
    FOREIGN KEY (medicine_id) REFERENCES medicine(id),
    FOREIGN KEY (enzyme_id) REFERENCES enzyme(id)
);