CREATE SEQUENCE seq_person START 1; CREATE TABLE tbl_person ( key integer DEFAULT nextval('seq_person') PRIMARY KEY, -- primary key agegroupid integer NOT NULL REFERENCES const_agegroup(key), -- age group foreign key cexperience boolean NOT NULL, -- computer experience wexperience boolean NOT NULL, -- wiimote experience inserttime timestamp DEFAULT current_timestamp -- time of insertion );