{"basketball_match": {"columns": [[0, "Team_ID", "INT", 0, null, 1], [1, "School_ID", "INT", 0, null, 0], [2, "Team_Name", "TEXT", 0, null, 0], [3, "ACC_Regular_Season", "TEXT", 0, null, 0], [4, "ACC_Percent", "TEXT", 0, null, 0], [5, "ACC_Home", "TEXT", 0, null, 0], [6, "ACC_Road", "TEXT", 0, null, 0], [7, "All_Games", "TEXT", 0, null, 0], [8, "All_Games_Percent", "INT", 0, null, 0], [9, "All_Home", "TEXT", 0, null, 0], [10, "All_Road", "TEXT", 0, null, 0], [11, "All_Neutral", "TEXT", 0, null, 0]], "primary_keys": ["Team_ID"], "foreign_keys": [[0, 0, "university", "School_ID", "School_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Team_ID"]]], "check_constraints": []}, "university": {"columns": [[0, "School_ID", "INT", 0, null, 1], [1, "School", "TEXT", 0, null, 0], [2, "Location", "TEXT", 0, null, 0], [3, "Founded", "REAL", 0, null, 0], [4, "Affiliation", "TEXT", 0, null, 0], [5, "Enrollment", "REAL", 0, null, 0], [6, "Nickname", "TEXT", 0, null, 0], [7, "Primary_conference", "TEXT", 0, null, 0]], "primary_keys": ["School_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "School_ID"]]], "check_constraints": []}}
CREATE TABLE basketball_match (
    Team_ID INT   PRIMARY KEY,
    School_ID INT,
    Team_Name TEXT,
    ACC_Regular_Season TEXT,
    ACC_Percent TEXT,
    ACC_Home TEXT,
    ACC_Road TEXT,
    All_Games TEXT,
    All_Games_Percent INT,
    All_Home TEXT,
    All_Road TEXT,
    All_Neutral TEXT,
    UNIQUE (Team_ID),
    FOREIGN KEY (School_ID) REFERENCES university(School_ID)
);

CREATE TABLE university (
    School_ID INT   PRIMARY KEY,
    School TEXT,
    Location TEXT,
    Founded REAL,
    Affiliation TEXT,
    Enrollment REAL,
    Nickname TEXT,
    Primary_conference TEXT,
    UNIQUE (School_ID)
);