Project

General

Profile

« Previous | Next » 

Revision 1625

Added by Jing Tao almost 21 years ago

Add a foreign key in xml_accesssbutree table.

View differences:

src/xmltables.sql
305 305
  controllevel VARCHAR2(50), -- the level it control -- document or subtree
306 306
  subtreeid VARCHAR2(250), -- the subtree id 
307 307
	startnodeid	NUMBER(20),	-- the start node id of access subtree
308
  endnodeid NUMBER(20) -- the end node if of access subtree
308
  endnodeid NUMBER(20), -- the end node if of access subtree
309
  CONSTRAINT xml_accesssubtree_docid_fk 
310
		FOREIGN KEY (docid) REFERENCES xml_documents
309 311
);
310 312

  

Also available in: Unified diff