db_demo/sql/tables/cr_tbl_person.sql


1
2
3
4
5
6
7
8

CREATE SEQUENCE seq_person START 1;

CREATE TABLE tbl_person (
  key            integer PRIMARY KEY,                                 -- primary key
  agegroupid     integer NOT NULL REFERENCES const_agegroup(key),     -- age group foreign key
  c_experience   boolean NOT NULL,                                    -- computer experience
  w_experience   boolean NOT NULL                                     -- wiimote experience
);