Revision 450
Added by berkley over 23 years ago
| xmltables.sql | ||
|---|---|---|
| 168 | 168 |
path VARCHAR2(200), -- precomputed path through tree |
| 169 | 169 |
docid VARCHAR2(250), -- index to the document id |
| 170 | 170 |
doctype VARCHAR2(100), -- public id indicating document type |
| 171 |
parentnodeid NUMBER(20), -- id of the parent of the node represented by this row |
|
| 171 | 172 |
CONSTRAINT xml_index_pk PRIMARY KEY (nodeid,path), |
| 172 | 173 |
CONSTRAINT xml_index_nodeid_fk FOREIGN KEY (nodeid) REFERENCES xml_nodes, |
| 173 | 174 |
CONSTRAINT xml_index_docid_fk |
Also available in: Unified diff
added parentnodeid to xml_index table