{"driver": {"columns": [[0, "Driver_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Party", "TEXT", 0, null, 0], [3, "Home_city", "TEXT", 0, null, 0], [4, "Age", "INT", 0, null, 0]], "primary_keys": ["Driver_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Driver_ID"]]], "check_constraints": []}, "school": {"columns": [[0, "School_ID", "INT", 0, null, 1], [1, "Grade", "TEXT", 0, null, 0], [2, "School", "TEXT", 0, null, 0], [3, "Location", "TEXT", 0, null, 0], [4, "Type", "TEXT", 0, null, 0]], "primary_keys": ["School_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "School_ID"]]], "check_constraints": []}, "school_bus": {"columns": [[0, "School_ID", "INT", 0, null, 1], [1, "Driver_ID", "INT", 0, null, 2], [2, "Years_Working", "INT", 0, null, 0], [3, "If_full_time", "bool", 0, null, 0]], "primary_keys": ["School_ID", "Driver_ID"], "foreign_keys": [[0, 0, "driver", "Driver_ID", "Driver_ID", "NO ACTION", "NO ACTION", "NONE"], [1, 0, "school", "School_ID", "School_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "School_ID"], [1, 1, "Driver_ID"]]], "check_constraints": []}}
CREATE TABLE driver (
    Driver_ID INT   PRIMARY KEY,
    Name TEXT,
    Party TEXT,
    Home_city TEXT,
    Age INT,
    UNIQUE (Driver_ID)
);

CREATE TABLE school (
    School_ID INT   PRIMARY KEY,
    Grade TEXT,
    School TEXT,
    Location TEXT,
    Type TEXT,
    UNIQUE (School_ID)
);

CREATE TABLE school_bus (
    School_ID INT   PRIMARY KEY,
    Driver_ID INT   PRIMARY KEY,
    Years_Working INT,
    If_full_time bool,
    PRIMARY KEY (School_ID, Driver_ID),
    UNIQUE (School_ID, Driver_ID),
    FOREIGN KEY (Driver_ID) REFERENCES driver(Driver_ID),
    FOREIGN KEY (School_ID) REFERENCES school(School_ID)
);