System tables of a geodatabase in Informix

The system tables for a geodatabase enforce geodatabase behavior, store information about the geodatabase, and keep track of the data stored in the geodatabase.

View a diagram of the ArcSDE geodatabase system tables.

You need Adobe Acrobat Reader to open the file.

The system tables and their contents should not be altered using anything other than ArcGIS software. However, you can use SQL to view the contents of the system tables.

column_registry

The column_registry table manages all registered columns.

Caution:

If you alter column definitions using a SQL interface, the records in the column_registry table are not updated. This may cause any subsequent exports of the data to fail.

Field name	Field type	Description	Null?
database_name	varchar(32)	Name of the database in which the table containing the column is stored	NOT NULL
table_name	varchar(128)	Name of the table that contains the registered column	NOT NULL
owner	varchar(32)	Owner of the table in which the column resides (the user who created the table)	NOT NULL
column_name	varchar(32)	Name of the registered column	NOT NULL
sde_type	integer	Code for the column's data type; possible values and their definitions include the following: 1 = SE_INT16_TYPE—2-byte integer 2 = SE_INT32_TYPE—4-byte integer 3 = SE_FLOAT32_TYPE—4-byte float 4 = SE_FLOAT64_TYPE—8-byte float 5 = SE_STRING_TYPE—Null terminal character array 6 = SE_BLOB_TYPE—Variable length data 7 = SE_DATE_TYPE—Structured time date 8 = SE_SHAPE_TYPE—Shape geometry (SE_SHAPE) 9 = SE_RASTER_TYPE—Raster 10 = SE_XML_TYPE—XML document 11 = SE_INT64_TYPE—8-byte integer 12 = SE_UUID_TYPE—A universal unique ID 13 = SE_CLOB_TYPE—Character variable length data 14 = SE_NSTRING_TYPE—Unicode null terminal character array 15 = SE_NCLOB_TYPE—Unicode character large object 20 = SE_POINT_TYPE—Point user-defined type 21 = SE_CURVE_TYPE—Linestring user-defined type 22 = SE_LINESTRING_TYPE—Linestring user-defined type 23 = SE_SURFACE_TYPE—Polygon user-defined type 24 = SE_POLYGON_TYPE— Polygon user-defined type 25 = SE_GEOMETRYCOLLECTION_TYPE—Multipoint user-defined type 26 = SE_MULTISURFACE_TYPE—Linestring user-defined type 27 = SE_MULTICURVE_TYPE—Linestring user-defined type 28 = SE_MULTIPOINT_TYPE—Multipoint user-defined type 29 = SE_MULTILINESTRING_TYPE—Multilinestring user-defined type 30 = SE_MULTIPOLYGON_TYPE—Multipolygon user-defined type 31 = SE_GEOMETRY_TYPE—Geometry user-defined type	NOT NULL
column_size	integer	The length of the registered column value
decimal_digits	integer	Number of integers to the right of the decimal in the column value
description	varchar(65)	A description of the type of column
object_flags	integer	Stores the column properties, which include the following: Has a row ID Row ID column controlled by ArcSDE Allows NULLs Stores Oracle LONG RAW data Stores BLOB data Stores CLOB data Stores ST_Geometry geometry data Stores binary geometry data Stores user-defined type geometry data Stores Oracle LOB geometry data Stores binary raster data Stores user-defined type raster data Stores XML data Stores dates Stores time Stores a timestamp Stores a Unicode string	NOT NULL
object_id	integer	This value is set to the rastercolumn_id of the sde.raster_columns table if the column is a raster column or the layer_id of the sde.layers table if this column is a geometry column.

compress_log

The compress_log table tracks all compress operations performed on the geodatabase.

Note:

This table is created the first time you compress the geodatabase.

Field name	Field type	Description	Null?
compress_id	serial	Unique identifier of a compress operation	NOT NULL
sde_id	integer	Process identification number of the compress operation; references sde_id column in the process_information table	NOT NULL
server_id	integer	System process_id of the ArcSDE server process that performed or is performing the compress operation	NOT NULL
direct_connect	varchar(1)	Y (yes) or N (no) if the client is making a direct connection to the geodatabase	NOT NULL
compress_start	datetime	The date and time the compress operation started	NOT NULL
start_state_count	integer	The number of states present when compress started	NOT NULL
compress_end	datetime	The date and time the compress operation completed
end_state_count	integer	The number of remaining states after the compress operation
compress_status	varchar(20)	Indicates whether or not the compress operation completed successfully

dbtune

The dbtune table stores the configuration keywords forArcSDE data objects, such as feature classes.

Field name	Field type	Description	Null?
keyword	varchar(32)	The configuration keyword	NOT NULL
parameter	varchar(32)	The configuration parameter	NOT NULL
config_string	character(2048)	The value of the configuration parameter

gdb_itemrelationships

The gdb_itemrelationships table stores information about how objects in the gdb_items table are related. For example, feature datasets and replicas are tracked in this table.

Field name	Field type	Description	Null?
objectid	integer	Unique identifier for the row	NOT NULL
uuid	character(38)	Unique identifier of the item	NOT NULL
type	character(38)	Corresponds to uuid in the gdb_itemrelationshiptypes table	NOT NULL
originid	character(38)	Corresponds to uuid in the gdb_items table	NOT NULL
destid	character(38)	Corresponds to uuid in the gdb_items table	NOT NULL
attributes	integer	Property set representing the attribute pairs
properties	integer	Bitmask of item properties

gdb_itemrelationshiptypes

The gdb_itemrelationshiptypes table maintains data on the types of relationships that exist between the objects in the gdb_items table.

Field name	Field type	Description	Null?
objectid	integer	Unique identifier for the row	NOT NULL
uuid	character(38)	Unique identifier of the item	NOT NULL
name	varchar(226)	Name of the relationship type; values include the following: DatasetInFeatureDataset DatasetInFolder DatasetOfReplicaDataset DatasetsRelatedThrough DomainInDataset FeatureClassInGeometricNetwork FeatureClassInNetworkDataset FeatureClassInParcelFabric FeatureClassInTerrain FeatureClassInTopology FolderInFolder ItemInFolder ReplicaDatasetInReplica RepresentationOfFeatureClass TableInParcelFabric	NOT NULL
forwardlabel	varchar(226)	Label that describes the relationship from the context of the origin item
backwardlabel	varchar(226)	Label that describes the relationship from the context of the destination item
originitemtypeid	character(38)	Corresponds to uuid in the gdb_itemtypes table	NOT NULL
destitemtypeid	character(38)	Corresponds to uuid in the gdb_itemtypes table	NOT NULL
iscontainment	smallint	Indicates whether the origin item's existence controls the existence of the destination object

gdb_items

Items are any object used in the ArcGIS system that can be indexed and searched, including tables, domains, topologies, and networks. The gdb_items table maintains information about all the items stored in the geodatabase.

Field name	Field type	Description	Null?
objectid	integer	Unique identifier for the row	NOT NULL
uuid	character(38)	Unique identifier of the item	NOT NULL
type	character(38)	Corresponds to uuid in the gdb_itemtypes table	NOT NULL
name	varchar(226)	Name of the item (logical)
physicalname	varchar(226)	Fully qualified name of the item
path	character(512)	The unique relative path to the item
url	varchar(255)	The associated URL for the item; used with catalog services
properties	integer	Bitmask of item properties
defaults	BLOB	Information about the item that is independent of the underlying dataset, such as a serialized renderer; a symbol for a feature class; or column widths, colors, or fonts for tables
datasetsubtype1	integer	Indicates the feature type of the table Possible values are as follows for feature classes and raster catalogs: Null 1 = simple feature 7 = simple junction feature 8 = simple edge 10 = complex edge 11 = annotation feature 13 = dimension feature 14 = raster catalog item For relationship classes, the cardinality of the relationship class is stored. Possible values are: 1 = 1:1 2 = 1:M 3 = M:N For topologies, this column stores the Topology ID.
datasetsubtype2	integer	Indicates the geometry type of the table Possible values are as follows for feature classes and raster catalogs: Null 1 = single, zero dimensional geometry 2 = ordered collection of points 3 = ordered collection of paths 4 = collection of rings ordered by their containment relationship 9 = collection of surface patches For relationship classes, the value in this column indicates whether the relationship class is attributed. Possible values are 0 = nonattributed, or 1 = attributed.
datasetinfo1	varchar(255)	Stores the shape field name for feature classes
datasetinfo2	varchar(255)	Stores information for feature classes that participate in topologies
definition	integer	Stores information about the item
documentation	integer	Data definition of the item (metadata)
iteminfo	integer	Storage information for the item, such as symbology, that is independent of the underlying dataset
shape	st_multipolygon	The spatial extent of the item

gdb_itemtypes

The gdb_itemtypes table stores information on what type of object each item in the gdb_items table is.

Field name	Field type	Description	Null?
objectid	integer	Unique identifier for the row	NOT NULL
uuid	character(38)	Unique identifier of the item	NOT NULL
parenttypeid	character(38)	Corresponds to uuid in this (the gdb_itemtypes) table	NOT NULL
name	varchar(226)	Name of the item type; values include the following: AbstractTable Catalog Dataset Coded Value Domain Dataset Domain Extension Dataset Feature Class Feature Dataset Folder Geometric Network Historical Marker Item Mosaic Dataset Network Dataset Parcel Fabric Range Domain Raster Catalog Raster Dataset Relationship Class Replica Replica Dataset Representation Class Resource Schematic Dataset Survey Datraset Table Terrain Tin Toolbox Topology Workspace Workspace Extension	NOT NULL

gdb_replicalog

Each time a replica exports or imports changes, information about the operation is stored in the gdb_replicalog table.

Field name	Field type	Description	Null?
id	integer	Unique identifier for the row	NOT NULL
replicaid	integer	Corresponds to the objectid field in the gdb_items table	NOT NULL
event	integer	Indicates whether an import (1) or an export (2) has been logged	NOT NULL
errorcode	integer	The error code associated with the event; you can search the developer help to get the description associated with the error. If the event was successful, a success error code is returned.	NOT NULL
logdate	datetime	The date on which the event occurred	NOT NULL
sourcebegingen	integer	Several generations of data changes may be imported or exported in one event. This value indicates the generation number of the first generation of changes involved. For example, if generations 1 to 3 were imported, this field would have the value 1.	NOT NULL
sourceendgen	integer	Several generations of data changes may be imported or exported in one event. This value indicates the generation number of the last generation of changes involved. For example, if generations 1 to 3 were imported, this field would have the value 3.	NOT NULL
targetgen	integer	The generation to which changes are to be applied; this value is used to apply changes to the appropriate version in the target replica.	NOT NULL

gdb_tables_last_modified

The gdb_tables_last_modified table is used to validate geodatabase system tables when cached by the client application.

Field name	Field type	Description	Null?
table_name	varchar(160)	Name of the geodatabase system table that was modified	NOT NULL
last_modified_count	integer	Keeps a count of the number of times a system table is modified; incrementally increases for each modification	NOT NULL

geometry_columns

The geometry_columns table stores a row for each column of type Geometry in the database that complies with the OpenGIS SQL specification. ArcSDE treats this table as write only—the only time it is accessed by ArcSDE is when a layer is added or deleted that uses an OpenGIS SQL data format. This table is defined by the OpenGIS SQL specification and may be updated by other applications with geometry columns not managed by ArcSDE. When a new Geometry column is created in an OpenGIS compliant format, the fully qualified table, column name, and spatial reference ID (srid) are added to the geometry_columns table.

Each geometry column is associated with a spatial reference system. ArcSDE stores information on each spatial reference system in the spatial_references table.

Field name	Field type	Description	Null?
f_table_catalog	varchar(32)	The database in which the geometry column's table is stored	NOT NULL
f_table_schema	varchar(32)	The owner of the geometry column's table	NOT NULL
f_table_name	varchar(128)	The geometry column's table name	NOT NULL
f_geometry_column	varchar(128)	The name of the geometry column	NOT NULL
storage_type	integer	This is an OGC required field that is not used by ArcSDE
geometry_type	integer	The geometry type code; ArcSDE inserts one of the following values into this field: 0 = ST_Geometry 1 = ST_Point 3 = ST_LineString 5 = ST_Polygon 7 = ST_MultiPoint 9 = ST_MultiLineString 11 = ST_MultiPolygon	NOT NULL
coord_dimension	integer	Code for the coordinate dimension: 0 = point 1 = linear 2 = area
srid	integer	The geometry column's spatial reference system; this is a foreign key to the srid column of the spatial_references table	NOT NULL

layer_locks

The layer_locks table maintains the locks on feature classes.

Field name	Field type	Description	Null?
sde_id	integer	Process identification number of the process that has locked the layer; foreign key to the sde_id column in process_information table	NOT NULL
layer_id	integer	Corresponds to layer_id field in layers table	NOT NULL
autolock	character(1)	Set to 1 if the layer lock was set internally; otherwise, set to 0 if the layer lock was set by the application.	NOT NULL
lock_type	character(1)	The type of layer lock can be one of the following: 0 = A read lock on the entire layer 1 = A write lock on the entire layer 2 = A read lock on an area within the layer 3 = A write lock on an area within the layer 4 = A layer autolock	NOT NULL
minx	integer	The minimum x-coordinate of the bounding box used to define the features within an area locked during an area lock
miny	integer	The minimum y-coordinate of the bounding box used to define the features within an area locked during an area lock
maxx	integer	The maximum x-coordinate of the bounding box used to define the features within an area locked during an area lock
maxy	integer	The maximum y-coordinate of the bounding box used to define the features within an area locked during an area lock

layers

The layers table maintains data about each feature class in the database. The information helps build and maintain spatial indexes, ensure proper shape types, maintain data integrity, and store the spatial reference for the coordinate data.

This table stores a row for each spatial column in the database. Applications use the layer properties to discover available spatial data sources. The layer properties are used by ArcSDE to constrain and validate the contents of the spatial column, index geometry values, and properly create and manage the associated DBMS tables.

Fied name	Field type	Description	Null?
layer_id	integer	The unique identifier for the layer	NOT NULL
description	varchar(65)	User-defined description of the layer
databasename	varchar(32)	Name of the database in which the layer is stored
owner	varchar(32)	The user who created the layer	NOT NULL
table_name	varchar(128)	Name of the business table of the layer	NOT NULL
spatial_column	varchar(128)	Name of the spatial column in the layer	NOT NULL
eflags	integer	Stores the following layer properties: Stores single-precision or double-precision coordinates Stores 3D coordinates Stores measures Has autolocking enabled or disabled Is in load-only I/O mode or normal I/O mode Stores annotation Stores CAD data Is a view of another layer Does not have a spatial index The DBMS data type in which the layer data is stored The sde types that the layer can accept, which can be such types as points, linestrings, and polygons	NOT NULL
layer_mask	integer	Stores additional internal properties about the layer	NOT NULL
minx	float	Minimum x-coordinate value of the layer	NOT NULL
miny	float	Minimum y-coordinate value of the layer	NOT NULL
maxx	float	Maximum x-coordinate value of the layer	NOT NULL
maxy	float	Maximum y-coordinate value of the layer	NOT NULL
minz	float	Minimum z-coordinate value of the layer
maxz	float	Maximum z-coordinate value of the layer
minm	float	Minimum m-coordinate value of the layer
maxm	float	Maximum m-coordinate value of the layer
cdate	integer	The date the layer was created	NOT NULL
layer_config	varchar(32)	The configuration keyword that was specified when the layer was created
optimal_array_size	integer	Geometry array buffer size
stats_date	integer	The date statistics were last calculated for a layer
minimum_id	integer	The minimum feature ID value of a binary layer
srid	integer	Spatial reference identification number; corresponds to srid value in the spatial_references table	NOT NULL
secondary_srid	integer	Not in use at this time
base_layer_id	integer	Stores the base layer's layer_id value for a layer that is actually a view	NOT NULL

lineages_modified

The lineages_modified table contains a state lineage ID and its most recent modification time stamp.

Field name	Field type	Description	Null?
lineage_name	int8	Corresponds to the lineage_name field in the states_lineages table	NOT NULL
time_last_modified	datetime	The date and time the lineage was last modified	NOT NULL

locators

The locators table stores information about locator objects.

Field name	Field type	Description	Null?
locator_id	integer	Unique identifier of the locator	NOT NULL
name	varchar(32)	The name of the locator	NOT NULL
owner	varchar(32)	The name of the user who owns the locator	NOT NULL
category	varchar(32)	The category of the locator; address locators have a category value of Address	NOT NULL
type	integer	The type of locator; values represented as follows: 0—Defines locator styles 1—Defines locators 2—Defines attached locators; in other words, locators that are attached to a geocoded feature class and are a copy of the locator and the geocoding options that were used to create the geocoded feature class	NOT NULL
description	varchar(64)	The description of the locator	NOT NULL

metadata

When you add a locator to a geodatabase in a DBMS, a row is added to the metadata table for each property of the locator. Each row in the sde_layer_stats table defines a single property for a locator.

Field name	Field type	Description	Null?
record_id	integer	Unique identifier for the record	NOT NULL
object_name	varchar(160)	The name of the locator to which the property belongs and foreign key to the name column in the locators table	NOT NULL
object_database	varchar(32)	The name of the database in which the locator is stored
object_owner	varchar(32)	The name of the user who owns the record	NOT NULL
object_type	integer	Always a value of 2 for locator properties	NOT NULL
class_name	varchar(32)	Always a value of SDE_internal for locator properties
property	varchar(32)	The name of the locator property
prop_value	varchar(255)	The value of the locator property
description	varchar(65)	Not used for locator properties
creation_date	datetime	Date and time the locator property was created	NOT NULL

mvtables_modified

The mvtables_modified table maintains the list of all tables that are modified in each state of the database. This information aids in quickly determining if conflicts exist between versions or states of the database.

The mvtables_modified table maintains a record of all tables modified by state. This information allows applications to determine which tables need to be checked for changes when reconciling potential conflicts between versions and states in the database.

Any time a feature class or table is modified in a state, a new entry is created in the mvtables_modified table. When two versions are reconciled, the first step in the process is to identify the states these two versions reference—the current edit version’s state and the target version’s state. From these states, a common ancestor state is identified by tracing back through the state lineage of these two versions.

Field name	Field type	Description	Null?
state_id	int8	The identifier of the state in which this table was modified; foreign key to the states table	NOT NULL
registration_id	integer	The registration id of the table that was modified in the state; corresponds to the table_registry table	NOT NULL

object_locks

The object_locks table maintains locks on geodatabase objects.

Field name	Field type	Description	Null?
sde_id	integer	Process identification number of the process that locked the geodatabase object; references sde_id column in process_information table	NOT NULL
object_id	integer	Identifier of the affected dataset	NOT NULL
object_type	integer	Object lock type, for example, version,state_tree lock used by internal applications	NOT NULL
application_id	integer	Application unique identifier	NOT NULL
autolock	character(1)	Set to 1 if the layer lock was set internally; otherwise, set to 0, which means the layer lock was set by the application	NOT NULL
lock_type	character(1)	The type of object lock: S = shared or E = exclusive	NOT NULL

process_information

The process_information table collects ArcSDE session statistics such as the number of records read and the number of records written while the session was active.

Field name	Field type	Description	Null?
sde_id	integer	Process identification number	NOT NULL
spid	integer	The gsrvr process ID	NOT NULL
server_id	integer	The operating system process ID of the server process	NOT NULL
start_time	datetime	Date and time process was started	NOT NULL
rcount	integer	The number of reads that have been processed	NOT NULL
wcount	integer	The number of writes that have been processed	NOT NULL
opcount	integer	Total number of operations a process has executed	NOT NULL
numlocks	integer	The number of locks that the process currently has open	NOT NULL
fb_partial	integer	Total number of partial features shipped by the process	NOT NULL
fb_count	integer	Total number of buffers loaded by the process	NOT NULL
fb_fcount	integer	Total number of features buffered by the process	NOT NULL
fb_kbytes	integer	Total number of kilobytes buffered by the process	NOT NULL
owner	varchar(30)	The name of the connected user	NOT NULL
direct_connect	varchar(1)	Indicates whether process was made with a direct connection: T (true) or F (false)	NOT NULL
sysname	varchar(32)	The operating system that the client machine is running	NOT NULL
nodename	varchar(255)	The connected client machine name	NOT NULL
xdr_needed	varchar(1)	Records whether client is using XDR to communicate with the gsrvr: T (true) or F (false)	NOT NULL

raster_columns

The raster_columns table contains a list of raster columns stored in the database.

This table references the raster data in the band, block, and auxiliary tables.

Field name	Field type	Description	Null?
rastercolumn_id	integer	The primary key of the raster column table	NOT NULL
description	varchar(65)	The user-defined description of the raster table
database_name	varchar(32)	Name of the database in which the raster is stored	NOT NULL
owner	varchar(32)	The owner of the raster column's business table	NOT NULL
table_name	varchar(128)	The business table name	NOT NULL
raster_column	varchar(128)	The raster column name	NOT NULL
cdate	integer	The date the raster column was added to the business table	NOT NULL
config_keyword	varchar(32)	The DBTUNE configuration keyword specified when the raster was created; determines how the tables and indexes of the raster are stored in the database
minimum_id	integer	Defined during the creation of the raster, establishes value of the raster table's raster_id column
base_rastercolumn_id	integer	When the raster column is part of a view and not a table, is the rastercolumn_id of the base table of the view	NOT NULL
rastercolumn_mask	integer	Set to 256 for a geodatabase raster	NOT NULL
srid	integer	Spatial reference identifier number, foreign key to srid in the spatial_references table

sde_archives

The sde_archives table stores the metadata for the archives in a geodatabase.

Field name	Field type	Description	Null?
archiving_regid	integer	The registration ID of the business table	NOT NULL
history_regid	integer	The registration ID of the archive table	NOT NULL
from_date	varchar(32)	The name of the from date field	NOT NULL
to_date	varchar(32)	The name of the to date field	NOT NULL
archive_date	datetime	The date the archive was created	NOT NULL
archive_flags	int8	Not currently used	NOT NULL

sde_layer_stats

The sde_layer_stats table manages statistics for both versioned and nonversioned feature classes. These statistics are generated when you update geodatabase statistics. The statistics are used by certain geoprocessing tools to estimate whether to use tiled processing.

The sde_layer_stats table is related to the layers table by way of the layer ID.

Field name	Field type	Description	Null?
layer_id	integer	The unique identifier for the layer	NOT NULL
minx	float	Minimum x-coordinate value of the area for which statistics have been updated	NOT NULL
miny	float	Minimum y-coordinate value of the layer	NOT NULL
maxx	float	Maximum x-coordinate value of the layer	NOT NULL
maxy	float	Maximum y-coordinate value of the layer	NOT NULL
minz	float	Minimum z-coordinate value of the layer
minm	float	Minimum z-coordinate value of the layer
maxz	float	Maximum z-coordinate value of the layer
maxm	float	Maximum m-coordinate value of the layer
total_features	integer	The total number of features in the feature class	NOT NULL
total_points	integer	The total number of points (vertices) in the feature class	NOT NULL
version_id	integer	Unique identifier for the geodatabase version
last_analyzed	datetime year to second	The date and time the feature class was last analyzed and statistics updated	NOT NULL

sde_sde_logfile_pool

The sde_sde_logfile_pool table will be present in the geodatabase when it is first created, regardless of what type of log files you use. For a description of this and other log file tables, see Log file tables in a geodatabase in Informix.

sde_xml_columns

When you add an ArcSDE XML column to a business table, a row is added to the XML columns table. This table occurs once in each ArcSDE geodatabase.

Field name	Field type	Description	Null?
column_id	serial	The XML column's identifier; assigned by ArcSDE at the time the XML column is created	NOT NULL
registration_id	integer	The identifier of the business table containing the XML column; corresponds to the id column in the table_registry table	NOT NULL
column_name	varchar(32)	Name of the XML column in the business table	NOT NULL
index_id	integer	The identifier of the XPath index associated with the XML column, if one exists; a foreign key to the XML indexes table
minimum_id	integer	The value of the initial number used in the business table's XML column to identify individual XML documents
config_keyword	varchar(32)	The DBTUNE configuration keyword containing parameters that determine how the XML document and the XML XPath index tables and the text indexes created on those tables are defined in the database
xflags	integer	A value indicating whether the original documents in the XML document table are stored compressed or decompressed; compressed by default (Compressed documents provide better performance.)

sde_xml_index_tags

An ArcSDE XML column can optionally have an XPath index, which lets people search the content of a specific XML element or attribute in each document. The definition of which elements and attributes are included in or excluded from each XPath index is recorded in this table.

This table occurs once in each ArcSDE database. It contains one row for each XPath associated with the XPath index of an ArcSDE XML column.

Field name	Field type	Description	Null?
index_id	serial	The identifier of the XPath index associated with an ArcSDE XML column, if one exists; foreign key to the XML indexes table	NOT NULL
tag_id	integer	The identifier of an XPath or tag	NOT NULL
tag_name	varchar(896)	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.)	NOT NULL
data_type	integer	A value indicating whether the XML element or attribute will be indexed as a string or a number 1 = The content of the tag will be indexed as text. 2 = The content will be indexed as a number.	NOT NULL
tag_alias	integer	A number that can 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	varchar(64)	Text identifying the content that should be contained in the XML element or attribute
is_excluded	integer	A value indicating whether the XML element is included in or excluded from the XPath index 0 = included 1 = excluded	NOT NULL

sde_xml_indexes

This table occurs once in each ArcSDE database. It contains one row for each ArcSDE XML column that has an XPath index.

Field name	Field type	Description	Null?
index_id	integer	The identifier of the XPath index	NOT NULL
index_name	varchar(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	varchar(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	integer	A value indicating the type of XPath index 1 = index type SE_XML_INDEX_TEMPLATE 2 = index type SE_XML_INDEX_DEFINITION	NOT NULL
description	varchar(64)	Text identifying the XPath index If an index definition file was used to create the index, the index's description might be specified at the top of the file.

server_config

The server_config table stores ArcSDE server configuration parameters. These parameters define how the ArcSDE software uses memory.

Field name	Field type	Description	Null?
prop_name	varchar(32)	The initialization parameter name	NOT NULL
char_prop_value	char(512)	The character value of the initialization parameter
num_prop_value	integer	The integer value of the initialization parameter

spatial_references

The spatial_references table contains the coordinate system and floating point-to-integer transformation values. Internal functions use the parameters of a spatial reference system to translate and scale each floating point coordinate of the geometry into 64-bit positive integers prior to storage. Upon retrieval, the coordinates are restored to their original external floating point format.

Each geometry column of the geometry_columns table is associated with a spatial reference system, the information for which is stored in the spatial_references table. The columns of this table are those defined by the OpenGIS SQL Specification (srid, srtext, auth_name, and auth_srid) and those required by ArcSDE for internal coordinate transformation. The spatial reference system identifies the coordinate system for a geometry and gives meaning to the numeric coordinate values for the geometry.

Field name	Field type	Description	Null?
srid	integer	Spatial reference identifier	NOT NULL
description	varchar(64)	The text description of the spatial reference system
auth_name	varchar(256)	The name of the standard or standards body that is being cited for this reference system; for example, POSC would be a valid auth_name
auth_srid	integer	The ID of the Spatial Reference System as defined by the Authority cited in auth_name
falsex	float	The x offset used when transforming ground coordinates to internal system coordinates	NOT NULL
falsey	float	The y offset used when transforming ground coordinates to internal system coordinates	NOT NULL
xyunits	float	The scale factor to apply when transforming ground coordinates to internal system coordinates	NOT NULL
falsez	float	The z offset to use when transforming z values to internal system coordinates	NOT NULL
zunits	float	The scale factor to use when transforming z values to internal system coordinates	NOT NULL
falsem	float	The measure offset to use when transforming measure values to internal system coordinates	NOT NULL
munits	float	The scale factor to use when transforming measure values to internal system coordinates	NOT NULL
srtext	character(2048)	Name and descriptor for the spaital reference as seen in the ArcGIS interface	NOT NULL
object_flags	integer	Stores object attributes, including precision	NOT NULL
xycluster_tol	float	Xy-coordinate cluster tolerance for topological processing
zcluster_tol	float	Z-coordinate cluster tolerance for topological processing
mcluster_tol	float	Measure cluster tolerance for topological processing

state_lineages

The state_lineages table stores the lineage of each state. A new lineage name is created for each version. Each time a state is added, the lineage name and the state ID are added. When a state is added that is a new version, the ancestry state lineage of the parent state is added with the lineage name.

To return the correct view of a version, its states lineage is queried to identify all the states that recorded each change made to that version. From this list of states, the table rows that correctly represent the version can be determined.

Field name	Field type	Description	Null?
lineage_name	int8	Name that describes a state	NOT NULL
lineage_id	int8	Unique identifier of individual states	NOT NULL

state_locks

The state_locks table maintains the version state locks.

Field name	Field type	Description	Null?
sde_id	integer	Process identification number of the process that locked the state; references sde_id column in process_information table	NOT NULL
state_id	int8	Identifier of the state that is locked	NOT NULL
autolock	character(1)	Set to 1 if the layer lock was set internally; otherwise, set to 0 if the layer lock was set by the application	NOT NULL
lock_type	character(1)	The type of state lock; the following are possible types: 0 = A shared lock on the entire state tree 1 = An exclusive lock on the entire state tree 2 = A shared lock on a state 3 = An exclusive lock on a state 4 = A shared autolock 5 = An exclusive autolock	NOT NULL

states

The states table contains the state metadata. It accounts for the states that have been created over time, and the creation time, closing time, parent, and owner of each state.

When a state is created, a state ID is assigned and a record is added to this table.

Field name	Field type	Discussion	Null?
state_id	int8	A unique identifier for this state, assigned by ArcSDE	NOT NULL
owner	varchar(32)	The user who created this state	NOT NULL
creation_time	datetime	The date and time this state was created	NOT NULL
closing_time	datetime	The date and time this state was closed
parent_state_id	int8	This state_id of the parent state	NOT NULL
lineage_name	int8	References the state's lineage stored in the state_lineages table	NOT NULL

table_locks

The table_locks table maintains the locks on ArcSDE registered tables.

Field name	Field type	Description	Null?
sde_id	integer	Process identification number of the process that locked the table; references sde_id column in process_information table	NOT NULL
registration_id	integer	Corresponds to registration_id field in the table_registry table	NOT NULL
lock_type	character(1)	The type of table lock S = Shared E = Exclusive	NOT NULL

table_registry

The table_registry table manages all registered tables. The values include an ID, table name, owner, and description.

Field name	Field type	Description	Null?
registration_id	integer	Unique identifier for the registration of the table	NOT NULL
database_name	varchar(32)	Name of the database in which the table is stored	NOT NULL
owner	varchar(32)	User who created the table	NOT NULL
table_name	varchar(128)	Name of the table	NOT NULL
rowid_column	varchar(32)	Name of the ObjectID column in the table
description	varchar(65)	The user-defined text description of the table
object_flags	integer	Stores the registration properties of the table, which include the following: The table has a registered row ID. ArcSDE controls the row ID. The table has a geometry column. The table is a multiversioned view. The table can be row locked. The table has a raster column. The table is a view of another table. The table has a geocoding locator column. Data definition language operations are restricted. Data manipulation language operations are restricted. The table is hidden. The table has single row IDs. The table has an XML column. The table has a layer that stores double coordinates. The interior states of this versioned table can be edited. This is a base save table. This table has trusted shapes. This is an archiving table. This table is in load-only I/O mode. This is a history table.	NOT NULL
registration_date	integer	The date the table was registered with ArcSDE	NOT NULL
config_keyword	varchar(32)	Configuration keyword specified when the table was registered with ArcSDE; determines the storage of the table and its indexes in the database
minimum_id	integer	The minimum row_id value of the table
imv_view_name	varchar(32)	The name of a multiversioned view of the given table

tables_modified

The tables_modified table records when changes are made to the system tables. This information is used to eliminate unnecessary reads of tables that have not changed.

Field name	Field type	Description	Null?
table_name	varchar(32)	Name of the ArcSDE system table that was modified	NOT NULL
time_last_modified	datetime year to second	Date and time the table was modified	NOT NULL

version

The version table maintains information about the version of ArcSDE with which the database expects to operate. The table contains the specific release identification for the most recently installed version of ArcSDE.

The version table and other ArcSDE system tables are updated after a new version of ArcSDE is installed.

Field name	Field type	Description	Null?
major	integer	Number of the major release; for example, for ArcSDE 9.3, the major release number is 9.	NOT NULL
minor	integer	Number indicating the version of the minor release; for example, for ArcSDE 9.3, the minor release number is 3.	NOT NULL
bugfix	integer	Number of the patch or service pack installed	NOT NULL
description	varchar(96)	System-defined description of the ArcSDE installation	NOT NULL
release	integer	Complete release number, for example, 92009	NOT NULL
sdesvr_rel_low	integer	Indicates the lowest release number of server allowed to run on this instance	NOT NULL

versions

The versions table contains information about versioned geodatabases.

Each version is identified by a name, with an owner, description, and associated database state. This table defines the different versions that the database contains and provides a list of available versions to be presented to the user. These versions are used to access specific database states by the application. The version name and ID are unique.

When the versions table is first created by ArcSDE, a default version is inserted into the table. This default version is named DEFAULT, is owned by the ArcSDE administrator, and is granted PUBLIC access. The initial state_id is set to 0, and the description string reads Instance Default Version. Since the default version has been granted PUBLIC access, any user can change the state of the default.

Field name	Field type	Description	Null?
name	varchar(64)	The unique name of the version	NOT NULL
owner	varchar(32)	The version owner	NOT NULL
version_id	integer	The unique identifier of the version	NOT NULL
status	integer	Specifies whether the version is available to the public or if it is privately accessed by the owner	NOT NULL
state_id	int8	The identifier of the database state to which this version points	NOT NULL
description	varchar(65)	An optional text description of the version
parent_name	varchar(64)	The name of the parent of this version
parent_owner	varchar(32)	The name of the owner of the parent version
parent_version_id	integer	The identifier of the version that is the parent of this version
creation_time	datetime	The date and time that this version was created	NOT NULL