Metacat

				-- ELEMENT, ATTRIBUTE, TEXT)

	nodename VARCHAR(250),	-- the name of an element or attribute

        nodeprefix VARCHAR(50), -- the namespace prefix of the node

				-- for TEXT it is the content)

	parentnodeid INT8,	-- index of the parent of this node

	rootnodeid INT8,	-- index of the root node of this tree

                                -- ELEMENT, ATTRIBUTE, TEXT)

        nodename VARCHAR(250),  -- the name of an element or attribute

        nodeprefix VARCHAR(50), -- the namespace prefix of the node

                                -- for TEXT it is the content)

        parentnodeid INT8,      -- index of the parent of this node

        rootnodeid INT8,        -- index of the root node of this tree

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

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

  docid                VARCHAR(250),  -- docid of the document

  				       -- returnfield

  CONSTRAINT xml_queryresult_pk PRIMARY KEY (queryresult_id),

  CONSTRAINT xml_queryresult_searchid_fk

    nodeid INT8  default nextval('xml_path_index_id_seq'),

        docid VARCHAR(250),     -- the document id

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

                                -- for TEXT it is the content)

        nodedatanumerical FLOAT8, -- the data for this node if

                                  -- if it is a number