{"region": {"columns": [[0, "Region_ID", "INT", 0, null, 1], [1, "Region_name", "TEXT", 0, null, 0], [2, "Date", "TEXT", 0, null, 0], [3, "Label", "TEXT", 0, null, 0], [4, "Format", "TEXT", 0, null, 0], [5, "Catalogue", "TEXT", 0, null, 0]], "primary_keys": ["Region_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Region_ID"]]], "check_constraints": []}, "party": {"columns": [[0, "Party_ID", "INT", 0, null, 1], [1, "Minister", "TEXT", 0, null, 0], [2, "Took_office", "TEXT", 0, null, 0], [3, "Left_office", "TEXT", 0, null, 0], [4, "Region_ID", "INT", 0, null, 0], [5, "Party_name", "TEXT", 0, null, 0]], "primary_keys": ["Party_ID"], "foreign_keys": [[0, 0, "region", "Region_ID", "Region_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Party_ID"]]], "check_constraints": []}, "member": {"columns": [[0, "Member_ID", "INT", 0, null, 1], [1, "Member_Name", "TEXT", 0, null, 0], [2, "Party_ID", "TEXT", 0, null, 0], [3, "In_office", "TEXT", 0, null, 0]], "primary_keys": ["Member_ID"], "foreign_keys": [[0, 0, "party", "Party_ID", "Party_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Member_ID"]]], "check_constraints": []}, "party_events": {"columns": [[0, "Event_ID", "INT", 0, null, 1], [1, "Event_Name", "TEXT", 0, null, 0], [2, "Party_ID", "INT", 0, null, 0], [3, "Member_in_charge_ID", "INT", 0, null, 0]], "primary_keys": ["Event_ID"], "foreign_keys": [[0, 0, "member", "Member_in_charge_ID", "Member_ID", "NO ACTION", "NO ACTION", "NONE"], [1, 0, "party", "Party_ID", "Party_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Event_ID"]]], "check_constraints": []}}
CREATE TABLE region (
    Region_ID INT   PRIMARY KEY,
    Region_name TEXT,
    Date TEXT,
    Label TEXT,
    Format TEXT,
    Catalogue TEXT,
    UNIQUE (Region_ID)
);

CREATE TABLE party (
    Party_ID INT   PRIMARY KEY,
    Minister TEXT,
    Took_office TEXT,
    Left_office TEXT,
    Region_ID INT,
    Party_name TEXT,
    UNIQUE (Party_ID),
    FOREIGN KEY (Region_ID) REFERENCES region(Region_ID)
);

CREATE TABLE member (
    Member_ID INT   PRIMARY KEY,
    Member_Name TEXT,
    Party_ID TEXT,
    In_office TEXT,
    UNIQUE (Member_ID),
    FOREIGN KEY (Party_ID) REFERENCES party(Party_ID)
);

CREATE TABLE party_events (
    Event_ID INT   PRIMARY KEY,
    Event_Name TEXT,
    Party_ID INT,
    Member_in_charge_ID INT,
    UNIQUE (Event_ID),
    FOREIGN KEY (Member_in_charge_ID) REFERENCES member(Member_ID),
    FOREIGN KEY (Party_ID) REFERENCES party(Party_ID)
);