aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBoris Kolpackov <boris@codesynthesis.com>2015-09-24 17:11:06 +0200
committerBoris Kolpackov <boris@codesynthesis.com>2015-09-24 17:11:06 +0200
commit7ac7872103a868f4232f4284aeefc1762bd75a89 (patch)
tree1d32f19b9c1fc11d38ca379ecc774b1a4cc62853
parente1c9e5a496b319f9ec7869dab1287b0c57ab17c1 (diff)
Add missing generated FKs in documentation
-rw-r--r--doc/manual.xhtml6
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 (