{"swimmer": {"columns": [[0, "ID", "INT", 0, null, 1], [1, "name", "TEXT", 0, null, 0], [2, "Nationality", "TEXT", 0, null, 0], [3, "meter_100", "REAL", 0, null, 0], [4, "meter_200", "TEXT", 0, null, 0], [5, "meter_300", "TEXT", 0, null, 0], [6, "meter_400", "TEXT", 0, null, 0], [7, "meter_500", "TEXT", 0, null, 0], [8, "meter_600", "TEXT", 0, null, 0], [9, "meter_700", "TEXT", 0, null, 0], [10, "Time", "TEXT", 0, null, 0]], "primary_keys": ["ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "ID"]]], "check_constraints": []}, "stadium": {"columns": [[0, "ID", "INT", 0, null, 1], [1, "name", "TEXT", 0, null, 0], [2, "Capacity", "INT", 0, null, 0], [3, "City", "TEXT", 0, null, 0], [4, "Country", "TEXT", 0, null, 0], [5, "Opening_year", "INT", 0, null, 0]], "primary_keys": ["ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "ID"]]], "check_constraints": []}, "event": {"columns": [[0, "ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Stadium_ID", "INT", 0, null, 0], [3, "Year", "TEXT", 0, null, 0]], "primary_keys": ["ID"], "foreign_keys": [[0, 0, "stadium", "Stadium_ID", "ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "ID"]]], "check_constraints": []}, "record": {"columns": [[0, "ID", "INT", 0, null, 0], [1, "Result", "TEXT", 0, null, 0], [2, "Swimmer_ID", "INT", 0, null, 1], [3, "Event_ID", "INT", 0, null, 2]], "primary_keys": ["Swimmer_ID", "Event_ID"], "foreign_keys": [[0, 0, "swimmer", "Swimmer_ID", "ID", "NO ACTION", "NO ACTION", "NONE"], [1, 0, "event", "Event_ID", "ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 2, "Swimmer_ID"], [1, 3, "Event_ID"]]], "check_constraints": []}}
CREATE TABLE swimmer (
    ID INT   PRIMARY KEY,
    name TEXT,
    Nationality TEXT,
    meter_100 REAL,
    meter_200 TEXT,
    meter_300 TEXT,
    meter_400 TEXT,
    meter_500 TEXT,
    meter_600 TEXT,
    meter_700 TEXT,
    Time TEXT,
    UNIQUE (ID)
);

CREATE TABLE stadium (
    ID INT   PRIMARY KEY,
    name TEXT,
    Capacity INT,
    City TEXT,
    Country TEXT,
    Opening_year INT,
    UNIQUE (ID)
);

CREATE TABLE event (
    ID INT   PRIMARY KEY,
    Name TEXT,
    Stadium_ID INT,
    Year TEXT,
    UNIQUE (ID),
    FOREIGN KEY (Stadium_ID) REFERENCES stadium(ID)
);

CREATE TABLE record (
    ID INT,
    Result TEXT,
    Swimmer_ID INT   PRIMARY KEY,
    Event_ID INT   PRIMARY KEY,
    PRIMARY KEY (Swimmer_ID, Event_ID),
    UNIQUE (Swimmer_ID, Event_ID),
    FOREIGN KEY (Swimmer_ID) REFERENCES swimmer(ID),
    FOREIGN KEY (Event_ID) REFERENCES event(ID)
);