AppStateESS/homestead

CREATE TABLE hms_special_assignment (
    id INTEGER NOT NULL,
    term INTEGER NOT NULL,
    username VARCHAR(16) NOT NULL,
    hall VARCHAR(6) NOT NULL,
    floor INTEGER,
    room INTEGER
);