summaryrefslogtreecommitdiffstats
path: root/db_demo/sql/tables/cr_tbl_person.sql
diff options
context:
space:
mode:
Diffstat (limited to 'db_demo/sql/tables/cr_tbl_person.sql')
-rw-r--r--db_demo/sql/tables/cr_tbl_person.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/db_demo/sql/tables/cr_tbl_person.sql b/db_demo/sql/tables/cr_tbl_person.sql
new file mode 100644
index 0000000..95e01b7
--- /dev/null
+++ b/db_demo/sql/tables/cr_tbl_person.sql
@@ -0,0 +1,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
+); \ No newline at end of file