{"stadium": {"columns": [[0, "Stadium_ID", "INT", 0, null, 1], [1, "Location", "TEXT", 0, null, 0], [2, "Name", "TEXT", 0, null, 0], [3, "Capacity", "INT", 0, null, 0], [4, "Highest", "INT", 0, null, 0], [5, "Lowest", "INT", 0, null, 0], [6, "Average", "INT", 0, null, 0]], "primary_keys": ["Stadium_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Stadium_ID"]]], "check_constraints": []}, "singer": {"columns": [[0, "Singer_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Country", "TEXT", 0, null, 0], [3, "Song_Name", "TEXT", 0, null, 0], [4, "Song_release_year", "TEXT", 0, null, 0], [5, "Age", "INT", 0, null, 0], [6, "Is_male", "bool", 0, null, 0]], "primary_keys": ["Singer_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Singer_ID"]]], "check_constraints": []}, "concert": {"columns": [[0, "concert_ID", "INT", 0, null, 1], [1, "concert_Name", "TEXT", 0, null, 0], [2, "Theme", "TEXT", 0, null, 0], [3, "Stadium_ID", "TEXT", 0, null, 0], [4, "Year", "TEXT", 0, null, 0]], "primary_keys": ["concert_ID"], "foreign_keys": [[0, 0, "stadium", "Stadium_ID", "Stadium_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "concert_ID"]]], "check_constraints": []}, "singer_in_concert": {"columns": [[0, "concert_ID", "INT", 0, null, 1], [1, "Singer_ID", "TEXT", 0, null, 2]], "primary_keys": ["concert_ID", "Singer_ID"], "foreign_keys": [[0, 0, "singer", "Singer_ID", "Singer_ID", "NO ACTION", "NO ACTION", "NONE"], [1, 0, "concert", "concert_ID", "concert_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "concert_ID"], [1, 1, "Singer_ID"]]], "check_constraints": []}}
CREATE TABLE stadium (
    Stadium_ID INT   PRIMARY KEY,
    Location TEXT,
    Name TEXT,
    Capacity INT,
    Highest INT,
    Lowest INT,
    Average INT,
    UNIQUE (Stadium_ID)
);

CREATE TABLE singer (
    Singer_ID INT   PRIMARY KEY,
    Name TEXT,
    Country TEXT,
    Song_Name TEXT,
    Song_release_year TEXT,
    Age INT,
    Is_male bool,
    UNIQUE (Singer_ID)
);

CREATE TABLE concert (
    concert_ID INT   PRIMARY KEY,
    concert_Name TEXT,
    Theme TEXT,
    Stadium_ID TEXT,
    Year TEXT,
    UNIQUE (concert_ID),
    FOREIGN KEY (Stadium_ID) REFERENCES stadium(Stadium_ID)
);

CREATE TABLE singer_in_concert (
    concert_ID INT   PRIMARY KEY,
    Singer_ID TEXT   PRIMARY KEY,
    PRIMARY KEY (concert_ID, Singer_ID),
    UNIQUE (concert_ID, Singer_ID),
    FOREIGN KEY (Singer_ID) REFERENCES singer(Singer_ID),
    FOREIGN KEY (concert_ID) REFERENCES concert(concert_ID)
);