{"school": {"columns": [[0, "School_ID", "INT", 0, null, 1], [1, "School", "TEXT", 0, null, 0], [2, "Location", "TEXT", 0, null, 0], [3, "Enrollment", "REAL", 0, null, 0], [4, "Founded", "REAL", 0, null, 0], [5, "Denomination", "TEXT", 0, null, 0], [6, "Boys_or_Girls", "TEXT", 0, null, 0], [7, "Day_or_Boarding", "TEXT", 0, null, 0], [8, "Year_Entered_Competition", "REAL", 0, null, 0], [9, "School_Colors", "TEXT", 0, null, 0]], "primary_keys": ["School_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "School_ID"]]], "check_constraints": []}, "school_details": {"columns": [[0, "School_ID", "INT", 0, null, 1], [1, "Nickname", "TEXT", 0, null, 0], [2, "Colors", "TEXT", 0, null, 0], [3, "League", "TEXT", 0, null, 0], [4, "Class", "TEXT", 0, null, 0], [5, "Division", "TEXT", 0, null, 0]], "primary_keys": ["School_ID"], "foreign_keys": [[0, 0, "school", "School_ID", "School_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "School_ID"]]], "check_constraints": []}, "school_performance": {"columns": [[0, "School_Id", "INT", 0, null, 1], [1, "School_Year", "TEXT", 0, null, 2], [2, "Class_A", "TEXT", 0, null, 0], [3, "Class_AA", "TEXT", 0, null, 0]], "primary_keys": ["School_Id", "School_Year"], "foreign_keys": [[0, 0, "school", "School_Id", "School_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "School_Id"], [1, 1, "School_Year"]]], "check_constraints": []}, "player": {"columns": [[0, "Player_ID", "INT", 0, null, 1], [1, "Player", "TEXT", 0, null, 0], [2, "Team", "TEXT", 0, null, 0], [3, "Age", "INT", 0, null, 0], [4, "Position", "TEXT", 0, null, 0], [5, "School_ID", "INT", 0, null, 0]], "primary_keys": ["Player_ID"], "foreign_keys": [[0, 0, "school", "School_ID", "School_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Player_ID"]]], "check_constraints": []}}
CREATE TABLE school (
    School_ID INT   PRIMARY KEY,
    School TEXT,
    Location TEXT,
    Enrollment REAL,
    Founded REAL,
    Denomination TEXT,
    Boys_or_Girls TEXT,
    Day_or_Boarding TEXT,
    Year_Entered_Competition REAL,
    School_Colors TEXT,
    UNIQUE (School_ID)
);

CREATE TABLE school_details (
    School_ID INT   PRIMARY KEY,
    Nickname TEXT,
    Colors TEXT,
    League TEXT,
    Class TEXT,
    Division TEXT,
    UNIQUE (School_ID),
    FOREIGN KEY (School_ID) REFERENCES school(School_ID)
);

CREATE TABLE school_performance (
    School_Id INT   PRIMARY KEY,
    School_Year TEXT   PRIMARY KEY,
    Class_A TEXT,
    Class_AA TEXT,
    PRIMARY KEY (School_Id, School_Year),
    UNIQUE (School_Id, School_Year),
    FOREIGN KEY (School_Id) REFERENCES school(School_ID)
);

CREATE TABLE player (
    Player_ID INT   PRIMARY KEY,
    Player TEXT,
    Team TEXT,
    Age INT,
    Position TEXT,
    School_ID INT,
    UNIQUE (Player_ID),
    FOREIGN KEY (School_ID) REFERENCES school(School_ID)
);