diff options
author | Boris Kolpackov <boris@codesynthesis.com> | 2015-09-24 17:11:06 +0200 |
---|---|---|
committer | Boris Kolpackov <boris@codesynthesis.com> | 2015-09-24 17:11:06 +0200 |
commit | 7ac7872103a868f4232f4284aeefc1762bd75a89 (patch) | |
tree | 1d32f19b9c1fc11d38ca379ecc774b1a4cc62853 /doc/manual.xhtml | |
parent | e1c9e5a496b319f9ec7869dab1287b0c57ab17c1 (diff) |
Add missing generated FKs in documentation
Diffstat (limited to 'doc/manual.xhtml')
-rw-r--r-- | doc/manual.xhtml | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/doc/manual.xhtml b/doc/manual.xhtml index cf9d8e5..825e5fe 100644 --- a/doc/manual.xhtml +++ b/doc/manual.xhtml @@ -7116,7 +7116,7 @@ CREATE TABLE employer ( name VARCHAR (255) NOT NULL PRIMARY KEY); CREATE TABLE employer_employees ( - object_id VARCHAR (255) NOT NULL, + object_id VARCHAR (255) NOT NULL REFERENCES employer (name), value BIGINT UNSIGNED NOT NULL REFERENCES employee (id)); CREATE TABLE employee ( @@ -7168,7 +7168,7 @@ CREATE TABLE employee ( id BIGINT UNSIGNED NOT NULL PRIMARY KEY); CREATE TABLE employee_projects ( - object_id BIGINT UNSIGNED NOT NULL, + object_id BIGINT UNSIGNED NOT NULL REFERENCES employee (id), value VARCHAR (255) NOT NULL REFERENCES project (name)); </pre> @@ -7180,7 +7180,7 @@ CREATE TABLE project ( name VARCHAR (255) NOT NULL PRIMARY KEY); CREATE TABLE project_employees ( - object_id VARCHAR (255) NOT NULL, + object_id VARCHAR (255) NOT NULL REFERENCES project (name), value BIGINT UNSIGNED NOT NULL REFERENCES employee (id)); CREATE TABLE employee ( |