Revision 1620
Added by Jing Tao over 21 years ago
src/xmltables_postgres.sql | ||
---|---|---|
251 | 251 |
controllevel VARCHAR(50), -- the level it control -- document or subtree |
252 | 252 |
subtreeid VARCHAR(250), -- the subtree id |
253 | 253 |
startnodeid INT8, -- the start node id of access subtree |
254 |
endnodeid INT8 -- the end node if of access subtree |
|
254 |
endnodeid INT8, -- the end node if of access subtree |
|
255 |
CONSTRAINT xml_accesssubtree_docid_fk |
|
256 |
FOREIGN KEY (docid) REFERENCES xml_documents |
|
255 | 257 |
); |
256 | 258 |
|
Also available in: Unified diff
Add a foreign key constrain in xml_accesssubtree table.