NOTE: None of these tables should be altered using SQL.
Field name |
Field type |
Description |
COLUMN_ID |
NUMBER |
The XML column's identifier and the table's primary key.
This value is assigned by ArcSDE at the time the XML column is created.
NOT NULL. |
REGISTRATION_ID |
NUMBER |
The identifier of the business table containing the XML column and foreign key to the TABLE_REGISTRY system table.
NOT NULL. |
COLUMN_NAME |
NVARCHAR2(32) |
The name of the column in the business table that is the XML column.
NOT NULL. |
INDEX_ID |
NUMBER |
The identifier of the XPath index associated with the XML column (if one exists) and foreign key to the SDE_XML_INDEXES table. |
MINIMUM_ID |
NUMBER |
The value of the initial number used in the business table's XML column to identify individual XML documents. |
CONFIG_KEYWORD |
NVARCHAR2(32) |
The DBTUNE configuration keyword whose parameters determine how the XML document, the XML XPath index tables, and the text indexes created on those tables are defined in the database.
For more information on DBTUNE keywords and their parameters, see DBTUNE configuration keywords and DBTUNE configuration parameter name-configuration string pairs. |
XFLAGS |
NUMBER |
A value indicating if the original documents in the XML document table are stored compressed or uncompressed.
By default, documents are compressed; compressed documents provide better performance. |
Field name |
Field type |
Description |
INDEX_ID |
NUMBER |
The identifier of the XPath index and the table's primary key.
NOT NULL. |
INDEX_NAME |
NVARCHAR2(32) |
The name of the XPath index.
For XPath indexes associated with an ArcIMS Metadata Service, the name will be "ims_xml#", where # is the identifier of the XML column in the metadata service's business table.
NOT NULL. |
OWNER |
NVARCHAR2(32) |
The database user who owns the XML column
For ArcIMS Metadata Services, this is the user specified in the service's ArcXML configuration file.
NOT NULL. |
INDEX_TYPE |
NUMBER |
A value indicating the type of XPath index.
With ArcSDE 9.1 and later, the value will be 2 for the index type SE_XML_INDEX_DEFINITION and 1 for the index type SE_XML_INDEX_TEMPLATE. For XPath indexes associated with an ArcIMS Metadata Service, only the index type SE_XML_INDEX_DEFINITION is supported.
NOT NULL. |
DESCRIPTION |
NVARCHAR2(64) |
Text identifying the XPath index.
If an index definition file was used to create the index, the index description may be specified at the top of the file. |
Field name |
Field type |
Description |
INDEX_ID |
NUMBER |
The identifier of the XPath index associated with an XML column (if one exists) and foreign key to the SDE_XML_INDEXES table.
NOT NULL. |
TAG_ID |
NUMBER |
The identifier of an XPath or tag.
NOT NULL. |
TAG_NAME |
NVARCHAR2(1024) |
An absolute XPath identifying an XML element or attribute that may occur in an XML document.
For example, /metadata/mdDateSt identifies an XML element and /metadata/dataIdInfo/tpCat/TopicCatCd/@value identifies an XML attribute. These XPaths must not contain asterisks (*) to refer to a group of XML elements or attributes—each element or attribute is matched exactly using the XPaths specified in this table. Elements can't be named "*" in a valid XML document.
NOT NULL. |
DATA_TYPE |
NUMBER |
A value indicating if the XML element or attribute will be indexed as a number, a varchar, or text. A 1 indicates the content of the tag will be indexed as text; a 2 indicates the content of the tag will be indexed as a number; a 3 indicates the content of the tag will be indexed as a varchar.
NOT NULL. |
TAG_ALIAS |
NUMBER |
A number that may be used to identify an XPath.
For example, the Z39.50 communication protocol uses numeric codes to refer to content that may be searched. This column is not used by the ArcIMS Z39.50 Connector. |
DESCRIPTION |
NVARCHAR2(64) |
Text identifying the content that should be contained in the XML element or attribute. |
IS_EXCLUDED |
NUMBER |
A value indicating whether the XML element is included in or excluded from the XPath index.
0 = The XPath is included.
1 = The XPath is excluded.
NOT NULL. |
Field name |
Field type |
Description |
XML_KEY_COLUMN |
NUMBER |
The identifier for the indexed value and primary key for the table
NOT NULL |
SDE_XML_ID |
NUMBER |
The identifier for the XML document that contains the indexed value
NOT NULL |
TAG_ID |
NUMBER |
The identifier for the tag associated with the XML column's XPath index, which identifies where in the document the value is stored
NOT NULL |
DOUBLE_TAG |
FLOAT(126) |
The indexed value, when the tag is defined as DOUBLE in the XPath index definition |
STRING_TAG |
NVARCHAR2(256) |
The indexed value, when the tag is defined as VARCHAR in the XPath index definition |
TEXT_TAG |
CLOB |
The indexed value, when the tag is defined as STRING in the XPath index definition |