{"stadium": {"columns": [[0, "id", "INT", 0, null, 1], [1, "name", "TEXT", 0, null, 0], [2, "Home_Games", "INT", 0, null, 0], [3, "Average_Attendance", "REAL", 0, null, 0], [4, "Total_Attendance", "REAL", 0, null, 0], [5, "Capacity_Percentage", "REAL", 0, null, 0]], "primary_keys": ["id"], "foreign_keys": [], "unique_constraints": [[[0, 0, "id"]]], "check_constraints": []}, "game": {"columns": [[0, "stadium_id", "INT", 0, null, 0], [1, "id", "INT", 0, null, 1], [2, "Season", "INT", 0, null, 0], [3, "Date", "TEXT", 0, null, 0], [4, "Home_team", "TEXT", 0, null, 0], [5, "Away_team", "TEXT", 0, null, 0], [6, "Score", "TEXT", 0, null, 0], [7, "Competition", "TEXT", 0, null, 0]], "primary_keys": ["id"], "foreign_keys": [[0, 0, "stadium", "stadium_id", "id", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 1, "id"]]], "check_constraints": []}, "injury_accident": {"columns": [[0, "game_id", "INT", 0, null, 0], [1, "id", "INT", 0, null, 1], [2, "Player", "TEXT", 0, null, 0], [3, "Injury", "TEXT", 0, null, 0], [4, "Number_of_matches", "TEXT", 0, null, 0], [5, "Source", "TEXT", 0, null, 0]], "primary_keys": ["id"], "foreign_keys": [[0, 0, "game", "game_id", "id", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 1, "id"]]], "check_constraints": []}}
CREATE TABLE stadium (
    id INT   PRIMARY KEY,
    name TEXT,
    Home_Games INT,
    Average_Attendance REAL,
    Total_Attendance REAL,
    Capacity_Percentage REAL,
    UNIQUE (id)
);

CREATE TABLE game (
    stadium_id INT,
    id INT   PRIMARY KEY,
    Season INT,
    Date TEXT,
    Home_team TEXT,
    Away_team TEXT,
    Score TEXT,
    Competition TEXT,
    UNIQUE (id),
    FOREIGN KEY (stadium_id) REFERENCES stadium(id)
);

CREATE TABLE injury_accident (
    game_id INT,
    id INT   PRIMARY KEY,
    Player TEXT,
    Injury TEXT,
    Number_of_matches TEXT,
    Source TEXT,
    UNIQUE (id),
    FOREIGN KEY (game_id) REFERENCES game(id)
);