{"School": {"columns": [[0, "School_id", "TEXT", 0, null, 1], [1, "School_name", "TEXT", 0, null, 0], [2, "Location", "TEXT", 0, null, 0], [3, "Mascot", "TEXT", 0, null, 0], [4, "Enrollment", "INT", 0, null, 0], [5, "IHSAA_Class", "TEXT", 0, null, 0], [6, "IHSAA_Football_Class", "TEXT", 0, null, 0], [7, "County", "TEXT", 0, null, 0]], "primary_keys": ["School_id"], "foreign_keys": [], "unique_constraints": [[[0, 0, "School_id"]]], "check_constraints": []}, "budget": {"columns": [[0, "School_id", "INT", 0, null, 1], [1, "Year", "INT", 0, null, 2], [2, "Budgeted", "INT", 0, null, 0], [3, "total_budget_percent_budgeted", "REAL", 0, null, 0], [4, "Invested", "INT", 0, null, 0], [5, "total_budget_percent_invested", "REAL", 0, null, 0], [6, "Budget_invested_percent", "TEXT", 0, null, 0]], "primary_keys": ["School_id", "Year"], "foreign_keys": [[0, 0, "School", "School_id", "School_id", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "School_id"], [1, 1, "Year"]]], "check_constraints": []}, "endowment": {"columns": [[0, "endowment_id", "INT", 0, null, 1], [1, "School_id", "INT", 0, null, 0], [2, "donator_name", "TEXT", 0, null, 0], [3, "amount", "REAL", 0, null, 0]], "primary_keys": ["endowment_id"], "foreign_keys": [[0, 0, "School", "School_id", "School_id", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "endowment_id"]]], "check_constraints": []}}
CREATE TABLE School (
    School_id TEXT   PRIMARY KEY,
    School_name TEXT,
    Location TEXT,
    Mascot TEXT,
    Enrollment INT,
    IHSAA_Class TEXT,
    IHSAA_Football_Class TEXT,
    County TEXT,
    UNIQUE (School_id)
);

CREATE TABLE budget (
    School_id INT   PRIMARY KEY,
    Year INT   PRIMARY KEY,
    Budgeted INT,
    total_budget_percent_budgeted REAL,
    Invested INT,
    total_budget_percent_invested REAL,
    Budget_invested_percent TEXT,
    PRIMARY KEY (School_id, Year),
    UNIQUE (School_id, Year),
    FOREIGN KEY (School_id) REFERENCES School(School_id)
);

CREATE TABLE endowment (
    endowment_id INT   PRIMARY KEY,
    School_id INT,
    donator_name TEXT,
    amount REAL,
    UNIQUE (endowment_id),
    FOREIGN KEY (School_id) REFERENCES School(School_id)
);