CREATE TABLE states ( state varchar UNIQUE NOT NULL, active bool NOT NULL DEFAULT TRUE, -- Whether request can be considered "active" PRIMARY KEY(state) ); INSERT INTO states (state,active) VALUES ('Requested',TRUE), ('Rejected',FALSE), ('Accepted',TRUE), ('Learned',FALSE);