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

	path VARCHAR(1000),	-- precomputed path through tree

	docid VARCHAR(250),	-- index to the document id

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

   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 (

	relationid INT8 default nextval('xml_relation_id_seq') PRIMARY KEY,