Revision 1625
Added by Jing Tao over 21 years ago
| src/xmltables.sql | ||
|---|---|---|
| 305 | 305 |
controllevel VARCHAR2(50), -- the level it control -- document or subtree |
| 306 | 306 |
subtreeid VARCHAR2(250), -- the subtree id |
| 307 | 307 |
startnodeid NUMBER(20), -- the start node id of access subtree |
| 308 |
endnodeid NUMBER(20) -- the end node if of access subtree |
|
| 308 |
endnodeid NUMBER(20), -- the end node if of access subtree |
|
| 309 |
CONSTRAINT xml_accesssubtree_docid_fk |
|
| 310 |
FOREIGN KEY (docid) REFERENCES xml_documents |
|
| 309 | 311 |
); |
| 310 | 312 |
|
Also available in: Unified diff
Add a foreign key in xml_accesssbutree table.