diff options
Diffstat (limited to 'db_demo/sql/tables/cr_tbl_person.sql')
| -rw-r--r-- | db_demo/sql/tables/cr_tbl_person.sql | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/db_demo/sql/tables/cr_tbl_person.sql b/db_demo/sql/tables/cr_tbl_person.sql index 95e01b7..87fc5bd 100644 --- a/db_demo/sql/tables/cr_tbl_person.sql +++ b/db_demo/sql/tables/cr_tbl_person.sql @@ -1,8 +1,9 @@ CREATE SEQUENCE seq_person START 1;
CREATE TABLE tbl_person (
- key integer PRIMARY KEY, -- primary key
+ key integer DEFAULT nextval('seq_person') 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
+ cexperience boolean NOT NULL, -- computer experience
+ wexperience boolean NOT NULL, -- wiimote experience
+ inserttime timestamp DEFAULT current_timestamp -- time of insertion
);
\ No newline at end of file |