Project

General

Profile

1 1528 tao
/*
2
 * accessSubtree -- table to store access subtree info
3
 */
4
CREATE TABLE xml_accesssubtree (
5
	docid		VARCHAR2(250),	-- the document id #
6
  rev 		NUMBER(10) DEFAULT 1, --the revision number of the docume
7
  controllevel VARCHAR2(50), -- the level it control -- document or subtree
8
  subtreeid VARCHAR2(250), -- the subtree id
9
	startnodeid	NUMBER(20),	-- the start node id of access subtree
10
  endnodeid NUMBER(20) -- the end node if of access subtree
11
);