Project

General

Profile

« Previous | Next » 

Revision 1624

Added by Jing Tao over 21 years ago

Add a foreign key in xml_accesssubtree table.

View differences:

src/reviseformetacat13.sql
22 22 
 * accesssubtree -- table to store access subtree info
23 23 
 */
24 24 
CREATE TABLE xml_accesssubtree (
25 
        docid           VARCHAR2(250),  -- the document id #
26 
  rev           NUMBER(10) DEFAULT 1, --the revision number of the docume
25 
	docid		VARCHAR2(250),	-- the document id #
26 
  rev 		NUMBER(10) DEFAULT 1, --the revision number of the docume
27 27 
  controllevel VARCHAR2(50), -- the level it control -- document or subtree
28 
  subtreeid VARCHAR2(250), -- the subtree id
29 
        startnodeid     NUMBER(20),     -- the start node id of access subtree
30 
  endnodeid NUMBER(20) -- the end node if of access subtree
28 
  subtreeid VARCHAR2(250), -- the subtree id
29 
	startnodeid	NUMBER(20),	-- the start node id of access subtree
30 
  endnodeid NUMBER(20), -- the end node if of access subtree
31 
  CONSTRAINT xml_accesssubtree_docid_fk
32 
		FOREIGN KEY (docid) REFERENCES xml_documents
31 33 
);
32 34 

  		




  33
  35
  
    
/*


  		












Also available in:  Unified diff