Metacat

	docid VARCHAR(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 VARCHAR(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 VARCHAR(1000),     -- precomputed path through tree

        nodedata TEXT, -- the data for this node (e.g.,

                                -- for TEXT it is the content)

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

                                -- by this row

   CONSTRAINT xml_path_index_pk PRIMARY KEY (nodeid),

CREATE INDEX xml_path_index_idx2 ON xml_path_index (nodedata);

CREATE INDEX xml_path_index_idx3 ON xml_path_index (nodedatanumerical);

CREATE INDEX xml_path_index_idx4 ON xml_path_index (upper(nodedata));

/*

 * harvest_site_schedule -- table to store harvest sites and schedule info