Project

General

Profile

« Previous | Next » 

Revision 426

Added by bojilova almost 24 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