Project

General

Profile

Revision 426

Added by bojilova almost 21 years ago

get rid of the FK in xml_acess table that points to xm_documents.docid
since xml_access.docid(s) point to current and revised documents
(ie xml_documents.docid and xml_revisions.docid)

View differences:

xmltables.sql
88 88
	begin_time	DATE,		-- the time that access permission begins
89 89
	end_time	DATE,		-- the time that access permission ends
90 90
   CONSTRAINT xml_access_pk UNIQUE (docid, principal_name, principal_type, access_type, begin_time),
91
   CONSTRAINT xml_access_docid_fk 
92
		FOREIGN KEY (docid) REFERENCES xml_documents,
93 91
   CONSTRAINT xml_access_ck CHECK (begin_time < end_time)
94 92
);
95 93

  

Also available in: Unified diff