CREATE TABLE Salaries (<\n> person_id INT4 NOT NULL REFERENCES People, monthly_gross NUMERIC(8,0) NOT NULL CHECK (monthly_gross > 0), as_of DATE NOT NULL, approved_by INT4 NOT NULL REFERENCES People, notes VARCHAR(255) NULL, UNIQUE(person_id, as_of) );