Metacat

 * Returnfields -- table to store combinations of returnfields requested

 *		    and the number of times this table is accessed

 */

CREATE TABLE xml_returnfield (

        returnfield_id     INT8 default nextval('xml_returnfield_id_seq'),   -- the id for this returnfield entry

        returnfield_string VARCHAR(2000),                                    -- the returnfield string

);

CREATE INDEX xml_returnfield_idx1 ON xml_returnfield(returnfield_string);

/*

 * Queryresults -- table to store queryresults for a given docid

 * and returnfield_id

 */

CREATE TABLE xml_queryresult(

  queryresult_id INT8 default nextval('xml_queryresult_id_seq'), -- id for this entry

  returnfield_id       INT8,          -- id for the returnfield corresponding to this entry

CREATE INDEX xml_queryresult_idx1 ON xml_queryresult (returnfield_id, docid);

/*

 * Logging -- table to store metadata and data access log

 */