Metacat

	doctype		VARCHAR2(100),	-- public id indicating document type

        parentnodeid    NUMBER(20),     -- id of the parent of the node

					-- represented by this row

   CONSTRAINT xml_index_pk PRIMARY KEY (nodeid,path),

   CONSTRAINT xml_index_nodeid_fk FOREIGN KEY (nodeid) REFERENCES xml_nodes,

   CONSTRAINT xml_index_docid_fk

 * Index of the paths in xml_index

 */

CREATE INDEX xml_index_idx1 ON xml_index (path);

CREATE TABLE xml_relation (

	relationid    NUMBER(20) PRIMARY KEY, -- unique id

	doctype VARCHAR(100),	-- public id indicating document type

        parentnodeid INT8,      -- id of the parent of the node represented

				-- by this row

   CONSTRAINT xml_index_pk PRIMARY KEY (nodeid,path),

   CONSTRAINT xml_index_nodeid_fk FOREIGN KEY (nodeid) REFERENCES xml_nodes,

   CONSTRAINT xml_index_docid_fk

 * Index of the paths in xml_index

 */

CREATE INDEX xml_index_idx1 ON xml_index (path);

CREATE SEQUENCE xml_relation_id_seq;

CREATE TABLE xml_relation (