db_demo/sql/tables/cr_tbl_test.sql


1
2
3
4
5
6
7
8

CREATE SEQUENCE seq_test START 1;

CREATE TABLE tbl_test (
  key            integer DEFAULT nextval('seq_test') PRIMARY KEY, -- primary key
  personid       integer NOT NULL REFERENCES tbl_person(key),     -- person foreign key
  gametypeid     integer NOT NULL REFERENCES const_gametype(key), -- gametype foreign key
  inserttime     timestamp DEFAULT current_timestamp              -- time of insertion
);