{"list": {"columns": [[0, "LastName", "TEXT", 0, null, 1], [1, "FirstName", "TEXT", 0, null, 2], [2, "Grade", "INTEGER", 0, null, 0], [3, "Classroom", "INTEGER", 0, null, 0]], "primary_keys": ["LastName", "FirstName"], "foreign_keys": [], "unique_constraints": [[[0, 0, "LastName"], [1, 1, "FirstName"]]], "check_constraints": []}, "teachers": {"columns": [[0, "LastName", "TEXT", 0, null, 1], [1, "FirstName", "TEXT", 0, null, 2], [2, "Classroom", "INTEGER", 0, null, 0]], "primary_keys": ["LastName", "FirstName"], "foreign_keys": [], "unique_constraints": [[[0, 0, "LastName"], [1, 1, "FirstName"]]], "check_constraints": []}}
CREATE TABLE list (
    LastName TEXT   PRIMARY KEY,
    FirstName TEXT   PRIMARY KEY,
    Grade INTEGER,
    Classroom INTEGER,
    PRIMARY KEY (LastName, FirstName),
    UNIQUE (LastName, FirstName)
);

CREATE TABLE teachers (
    LastName TEXT   PRIMARY KEY,
    FirstName TEXT   PRIMARY KEY,
    Classroom INTEGER,
    PRIMARY KEY (LastName, FirstName),
    UNIQUE (LastName, FirstName)
);