Metacat

/* 

 * accessSubtree -- table to store access subtree info 

 */

CREATE TABLE xml_accesssubtree (

	docid		VARCHAR2(250),	-- the document id #

  rev 		NUMBER(10) DEFAULT 1, --the revision number of the docume

  controllevel VARCHAR2(50), -- the level it control -- document or subtree

  subtreeid VARCHAR2(250), -- the subtree id 

	startnodeid	NUMBER(20),	-- the start node id of access subtree

  endnodeid NUMBER(20) -- the end node if of access subtree

);