{"Services": {"columns": [[0, "Service_ID", "INTEGER", 1, null, 1], [1, "Service_Type_Code", "CHAR(15)", 1, null, 0]], "primary_keys": ["Service_ID"], "foreign_keys": [], "unique_constraints": [], "check_constraints": []}, "Participants": {"columns": [[0, "Participant_ID", "INTEGER", 1, null, 1], [1, "Participant_Type_Code", "CHAR(15)", 1, null, 0], [2, "Participant_Details", "VARCHAR(255)", 0, null, 0]], "primary_keys": ["Participant_ID"], "foreign_keys": [], "unique_constraints": [], "check_constraints": []}, "Events": {"columns": [[0, "Event_ID", "INTEGER", 1, null, 1], [1, "Service_ID", "INTEGER", 1, null, 0], [2, "Event_Details", "VARCHAR(255)", 0, null, 0]], "primary_keys": ["Event_ID"], "foreign_keys": [[0, 0, "Services", "Service_ID", "Service_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [], "check_constraints": []}, "Participants_in_Events": {"columns": [[0, "Event_ID", "INTEGER", 1, null, 1], [1, "Participant_ID", "INTEGER", 1, null, 2]], "primary_keys": ["Event_ID", "Participant_ID"], "foreign_keys": [[0, 0, "Events", "Event_ID", "Event_ID", "NO ACTION", "NO ACTION", "NONE"], [1, 0, "Participants", "Participant_ID", "Participant_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Event_ID"], [1, 1, "Participant_ID"]]], "check_constraints": []}}
CREATE TABLE Services (
    Service_ID INTEGER NOT NULL  PRIMARY KEY,
    Service_Type_Code CHAR(15) NOT NULL
);

CREATE TABLE Participants (
    Participant_ID INTEGER NOT NULL  PRIMARY KEY,
    Participant_Type_Code CHAR(15) NOT NULL,
    Participant_Details VARCHAR(255)
);

CREATE TABLE Events (
    Event_ID INTEGER NOT NULL  PRIMARY KEY,
    Service_ID INTEGER NOT NULL,
    Event_Details VARCHAR(255),
    FOREIGN KEY (Service_ID) REFERENCES Services(Service_ID)
);

CREATE TABLE Participants_in_Events (
    Event_ID INTEGER NOT NULL  PRIMARY KEY,
    Participant_ID INTEGER NOT NULL  PRIMARY KEY,
    PRIMARY KEY (Event_ID, Participant_ID),
    UNIQUE (Event_ID, Participant_ID),
    FOREIGN KEY (Event_ID) REFERENCES Events(Event_ID),
    FOREIGN KEY (Participant_ID) REFERENCES Participants(Participant_ID)
);