db_demo/sql/tables/cr_tbl_turn.sql


1
2
3
4
5
6
7
8
9

CREATE SEQUENCE seq_turn START 1;

CREATE TABLE tbl_turn (
  key            integer PRIMARY KEY,                             -- primary key
  testid         integer NOT NULL REFERENCES tbl_test(key),       -- test foreign key
  blockid        integer NOT NULL REFERENCES const_block(key),    -- block foreign key
  elapsedtime    time NOT NULL,                                   -- time in ms.
  holeposition   integer NOT NULL                                 -- position of the hole
);