diff options
Diffstat (limited to 'db_demo/sql/tables/cr_tbl_test.sql')
| -rw-r--r-- | db_demo/sql/tables/cr_tbl_test.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/db_demo/sql/tables/cr_tbl_test.sql b/db_demo/sql/tables/cr_tbl_test.sql new file mode 100644 index 0000000..15e94d0 --- /dev/null +++ b/db_demo/sql/tables/cr_tbl_test.sql @@ -0,0 +1,7 @@ +CREATE SEQUENCE seq_test START 1;
+
+CREATE TABLE tbl_test (
+ key integer 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
+);
\ No newline at end of file |