Metacat

/* 

 * accessSubtree -- table to store access subtree info 

 */

CREATE TABLE xml_accesssubtree (

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

  rev 		INT8 default 1, --the revision number of the docume

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

  subtreeid VARCHAR(250), -- the subtree id 

	startnodeid	INT8,	-- the start node id of access subtree

  endnodeid INT8 -- the end node if of access subtree

);