From 7ac7872103a868f4232f4284aeefc1762bd75a89 Mon Sep 17 00:00:00 2001 From: Boris Kolpackov Date: Thu, 24 Sep 2015 17:11:06 +0200 Subject: Add missing generated FKs in documentation --- doc/manual.xhtml | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'doc/manual.xhtml') 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)); @@ -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 ( -- cgit v1.1