metacat/src/createaccesssubtreetable.sql @ 1581
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 |
);
|