Project

General

Profile

metacat / src / createaccesssubtreetable.sql @ 1575

1
/* 
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
);