db_demo/sql/tables/cr_tbl_person.sql


1
2
3
4
5
6
7
8
9

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
);