{"city": {"columns": [[0, "City_ID", "INT", 0, null, 1], [1, "City", "TEXT", 0, null, 0], [2, "Hanzi", "TEXT", 0, null, 0], [3, "Hanyu_Pinyin", "TEXT", 0, null, 0], [4, "Regional_Population", "INT", 0, null, 0], [5, "GDP", "REAL", 0, null, 0]], "primary_keys": ["City_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "City_ID"]]], "check_constraints": []}, "match": {"columns": [[0, "Match_ID", "INT", 0, null, 1], [1, "Date", "TEXT", 0, null, 0], [2, "Venue", "TEXT", 0, null, 0], [3, "Score", "TEXT", 0, null, 0], [4, "Result", "TEXT", 0, null, 0], [5, "Competition", "TEXT", 0, null, 0]], "primary_keys": ["Match_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Match_ID"]]], "check_constraints": []}, "temperature": {"columns": [[0, "City_ID", "INT", 0, null, 1], [1, "Jan", "REAL", 0, null, 0], [2, "Feb", "REAL", 0, null, 0], [3, "Mar", "REAL", 0, null, 0], [4, "Apr", "REAL", 0, null, 0], [5, "Jun", "REAL", 0, null, 0], [6, "Jul", "REAL", 0, null, 0], [7, "Aug", "REAL", 0, null, 0], [8, "Sep", "REAL", 0, null, 0], [9, "Oct", "REAL", 0, null, 0], [10, "Nov", "REAL", 0, null, 0], [11, "Dec", "REAL", 0, null, 0]], "primary_keys": ["City_ID"], "foreign_keys": [[0, 0, "city", "City_ID", "City_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "City_ID"]]], "check_constraints": []}, "hosting_city": {"columns": [[0, "Year", "INT", 0, null, 1], [1, "Match_ID", "INT", 0, null, 0], [2, "Host_City", "TEXT", 0, null, 0]], "primary_keys": ["Year"], "foreign_keys": [[0, 0, "match", "Match_ID", "Match_ID", "NO ACTION", "NO ACTION", "NONE"], [1, 0, "city", "Host_City", "City_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Year"]]], "check_constraints": []}}
CREATE TABLE city (
    City_ID INT   PRIMARY KEY,
    City TEXT,
    Hanzi TEXT,
    Hanyu_Pinyin TEXT,
    Regional_Population INT,
    GDP REAL,
    UNIQUE (City_ID)
);

CREATE TABLE match (
    Match_ID INT   PRIMARY KEY,
    Date TEXT,
    Venue TEXT,
    Score TEXT,
    Result TEXT,
    Competition TEXT,
    UNIQUE (Match_ID)
);

CREATE TABLE temperature (
    City_ID INT   PRIMARY KEY,
    Jan REAL,
    Feb REAL,
    Mar REAL,
    Apr REAL,
    Jun REAL,
    Jul REAL,
    Aug REAL,
    Sep REAL,
    Oct REAL,
    Nov REAL,
    Dec REAL,
    UNIQUE (City_ID),
    FOREIGN KEY (City_ID) REFERENCES city(City_ID)
);

CREATE TABLE hosting_city (
    Year INT   PRIMARY KEY,
    Match_ID INT,
    Host_City TEXT,
    UNIQUE (Year),
    FOREIGN KEY (Match_ID) REFERENCES match(Match_ID),
    FOREIGN KEY (Host_City) REFERENCES city(City_ID)
);