Metacat

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

	date_created	DATE,

	date_updated	DATE,

   CONSTRAINT xml_nodes_pk PRIMARY KEY (nodeid),

   CONSTRAINT xml_nodes_root_fk

		FOREIGN KEY (rootnodeid) REFERENCES xml_nodes,

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

        date_created    DATE,

        date_updated    DATE,

   CONSTRAINT xml_nodes_revisions_pk PRIMARY KEY (nodeid),

   CONSTRAINT xml_nodes_revisions_root_fk

                FOREIGN KEY (rootnodeid) REFERENCES xml_nodes_revisions,

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

	    nodedata        VARCHAR2(4000), -- the data for this node e.g.,

        nodedatanumerical NUMBER(20),   -- the data for this node if

        CONSTRAINT xml_path_index_pk PRIMARY KEY (nodeid),

        CONSTRAINT xml_path_index_docid_fk FOREIGN KEY (docid) REFERENCES xml_documents

 );                                                                                        

CREATE INDEX xml_path_index_idx1 ON xml_path_index (path);

CREATE INDEX xml_path_index_idx2 ON xml_path_index (nodedata);

CREATE INDEX xml_path_index_idx3 ON xml_path_index (nodedatanumerical);

CREATE TABLE xml_relation (

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

	docid         VARCHAR2(250),          -- the docid of the package file