System tables of a geodatabase stored in Oracle

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 enterprise 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.

CautionCaution:

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?

TABLE_NAME

NVARCHAR2(160)

Name of the table that contains the registered column

NOT NULL

OWNER

NVARCHAR2(32)

Owner of the table in which the column resides (the user who created the table)

NOT NULL

COLUMN_NAME

NVARCHAR2(32)

Name of the registered column

NOT NULL

SDE_TYPE

NUMBER(38)

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

COLUMN_SIZE

NUMBER(38)

The length of the registered column value

DECIMAL_DIGITS

NUMBER(38)

Number of integers to the right of the decimal in the column value

DESCRIPTION

NVARCHAR2(65)

A description of the type of column

OBJECT_FLAGS

NUMBER(38)

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

NUMBER(38)

Set to the RASTERCOLUMN_ID of the RASTER_COLUMNS table if the column is a raster column or the LAYER_ID of the LAYERS table if this column is a geometry column

COMPRESS_LOG

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

NoteNote:

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

Field name

Field type

Description

Null?

SDE_ID

NUMBER(38)

Process identification number of the compress operation; references SDE_ID column in PROCESS_INFORMATION table

NOT NULL

SERVER_ID

NUMBER(38)

System process_id of the ArcSDE server process that performed or is performing the compress operation

NOT NULL

NOT NULL

DIRECT_CONNECT

VARCHAR2(1)

Y (yes) or N (no) if the client is making a direct connection to the geodatabase

NOT NULL

COMPRESS_START

DATE

The date and time the compress operation started

NOT NULL

START_STATE_COUNT

NUMBER(38)

The number of states present when compress started

NOT NULL

COMPRESS_END

DATE

The date and time the compress operation completed

END_STATE_COUNT

NUMBER(38)

The number of remaining states after the compress operation

COMPRESS_STATUS

NVARCHAR2(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

NVARCHAR2(32)

The configuration keyword

NOT NULL

PARAMETER

NVARCHAR2(32)

The configuration parameter

NOT NULL

CONFIG_STRING

NCLOB

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

NUMBER(38)

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

BLOB

Property set representing the attribute pairs

PROPERTIES

NUMBER(38)

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

NUMBER(38)

Unique identifier for the row

NOT NULL

UUID

CHARACTER(38)

Unique identifier of the item

NOT NULL

NAME

NVARCHAR2(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

NVARCHAR2(226)

Label that describes the relationship from the context of the origin item

BACKWARDLABEL

NVARCHAR2(226)

Label that describes the relationship from the context of the destination item

ORIGITEMTYPEID

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

NUMBER(4)

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

NUMBER(38)

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

NVARCHAR2(226)

Name of the item (logical)

PHYSICALNAME

NVARCHAR2(226)

Fully qualified name of the item

PATH

NVARCHAR2(512)

The unique relative path to the item

URL

NVARCHAR2(255)

The associated URL for the item; used with catalog services

PROPERTIES

NUMBER(38)

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

NUMBER(38)

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

NUMBER(38)

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

NVARCHAR2(255)

Stores the shape field name for feature classes

DATASETINFO2

NVARCHAR2(255)

Stores information for feature classes that participate in topologies

DEFINITION

NUMBER(38)

Stores information about the item

DOCUMENTATION

NUMBER(38)

Data definition of the item (metadata)

ITEMINFO

NUMBER(38)

Storage information for the item, such as symbology, that is independent of the underlying dataset

SHAPE

ST_GEOMETRY

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

NUMBER(38)

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

NVARCHAR2(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

NUMBER(38)

Unique identifier for the row

NOT NULL

REPLICAID

NUMBER(38)

Corresponds to the OBJECTID field in the GDB_ITEMS table

NOT NULL

EVENT

NUMBER(38)

Indicates whether an import (1) or an export (2) has been logged

ERRORCODE

NUMBER(38)

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

DATE

The date on which the event occurred

NOT NULL

SOURCEBEGINGEN

NUMBER(38)

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

NUMBER(38)

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

NUMBER(38)

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

NVARCHAR2(160)

Name of the geodatabase system table that was modified

NOT NULL

LAST_MODIFIED_COUNT

NUMBER(38)

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

NVARCHAR2(32)

The database in which the feature table is stored

F_TABLE_SCHEMA

NVARCHAR2(32)

Schema in which the business table is stored

NOT NULL

F_TABLE_NAME

NVARCHAR2(160)

Name of the business table of the dataset

NOT NULL

F_GEOMETRY_COLUMN

NVARCHAR2(32)

Name of the geometry column in the business table

NOT NULL

G_TABLE_CATALOG

NVARCHAR2(32)

The database in which the geometry column is stored

G_TABLE_SCHEMA

NVARCHAR2(32)

Schema in which the table that contains the geometry column is stored

NOT NULL

G_TABLE_NAME

NVARCHAR2(160)

Name of the table that contains the geometry column

NOT NULL

STORAGE_TYPE

NUMBER(38)

Code for the storage type of the geometry; could represent either WKB, WKT, BINARY, or SDO_GEOMETRY

GEOMETRY_TYPE

NUMBER(38)

Code for the geometry type that the column stores; could represent either point, multipoint, linestring, multilinestring, polygon, or multipolygon

COORD_DIMENSION

NUMBER(38)

Code for the coordinate dimension:

  • 0 = point
  • 1 = linear
  • 2 = area

MAX_PPR

NUMBER(38)

Maximum points per row (no longer used by ArcSDE)

SRID

NUMBER(38)

Spatial reference ID

NOT NULL

INSTANCES

The INSTANCES table is used to track geodatabases stored in a user's (other than the sde user's) schema. This table is stored in the master SDE geodatabase.

Field name

Field type

Description

Null?

INSTANCE_ID

NUMBER(38)

Unique identifier for the user-schema geodatabase primary key

NOT NULL

INSTANCE_NAME

NVARCHAR2(32)

Name of the user-schema geodatabase

NOT NULL

CREATION_DATE

DATE

Date the geodatabase was created in the user's schema

NOT NULL

STATUS

NUMBER(38)

The current status of the user-owned geodatabase; will contain one of three values:

  • 1 = The geodatabase is open and currently accepting connections.
  • 2 = The geodatabase is paused or stopped and is currently not acceptiing connections.
  • 3 = The instance has lost its connection to the DBMS.

NOT NULL

TIME_LAST_MODIFIED

DATE

The last time the user-schema geodatabase was modified

NOT NULL

LAYER_LOCKS

The LAYER_LOCKS table maintains the locks on feature classes.

Field name

Field type

Description

Null?

SDE_ID

NUMBER(38)

Process identification number of the process that has locked the layer; corresponds to the sde_id column in PROCESS_INFORMATION table

NOT NULL

LAYER_ID

NUMBER(38)

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

NUMBER(38)

The minimum x-coordinate of the bounding box used to define the features within an area locked during an area lock

MINY

NUMBER(38)

The minimum y-coordinate of the bounding box used to define the features within an area locked during an area lock

MAXX

NUMBER(38)

The maximum x-coordinate of the bounding box used to define the features within an area locked during an area lock

MAXY

NUMBER(38)

The maximum y-coordinate of the bounding box used to define the features within an area locked during an area lock

LOCK_TIME

DATE

The date and time the layer lock was acquired

NOT NULL

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.

Field name

Field type

Description

Null?

LAYER_ID

NUMBER(38)

The unique identifier for the layer

NOT NULL

DESCRIPTION

NVARCHAR2(65)

User-defined description of the layer

DATABASE_NAME

NVARCHAR2(32)

Not used

OWNER

NVARCHAR2(32)

The user who created the layer

NOT NULL

TABLE_NAME

NVARCHAR2(160)

Name of the business table of the layer

NOT NULL

SPATIAL_COLUMN

NVARCHAR2(32)

Name of the spatial column in the layer

EFLAGS

NUMBER(38)

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

LAYER_MASK

NUMBER(38)

Stores additional internal properties about the layer

GSIZE1

FLOAT(64)

Size of first spatial grid

GSIZE2

FLOAT(64)

Size of second spatial grid

GSIZE3

FLOAT(64)

Size of third spatial grid

MINX

FLOAT(64)

Minimum x-coordinate value of the layer

MINY

FLOAT(64)

Minimum y-coordinate value of the layer

MAXX

FLOAT(64)

Maximum x-coordinate value of the layer

MAXY

FLOAT(64)

Maximum y-coordinate value of the layer

MINZ

FLOAT(64)

Minimum z-coordinate value of the layer

MAXZ

FLOAT(64)

Maximum z-coordinate value of the layer

MINM

FLOAT(64)

Minimum m-coordinate value of the layer

MAXM

FLOAT(64)

Maximum m-coordinate value of the layer

CDATE

NUMBER(38)

The date the layer was created

NOT NULL

LAYER_CONFIG

NVARCHAR2(32)

The configuration keyword that was specified when the layer was created

OPTIMAL_ARRAY_SIZE

NUMBER(38)

Geometry array buffer size

STATS_DATE

NUMBER(38)

The date statistics were last calculated for a layer

MINIMUM_ID

NUMBER(38)

The minimum feature ID value of a binary layer

SRID

NUMBER(38)

Spatial reference identification number; foreign key to srid value in the SPATIAL_REFERENCES table

NOT NULL

BASE_LAYER_ID

NUMBER(38)

Stores the base layer's layer_id value for a layer that is actually a view

NOT NULL

SECONDARY_SRID

NUMBER(38)

Used to store high-precision coordinate reference to project data when the data was basic precision and was converted to high precision

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

NUMBER(38)

Corresponds to the LINEAGE_NAME field in the STATE_LINEAGES table

NOT NULL

TIME_LAST_MODIFIED

DATE

The date and time the lineage was last modified

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

NUMBER(38)

Unique identifier for the record

NOT NULL

OBJECT_NAME

NVARCHAR2(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_OWNER

NVARCHAR2(32)

The name of the user who owns the record

NOT NULL

OBJECT_TYPE

NUMBER(38)

Always a value of 2 for locator properties

NOT NULL

CLASS_NAME

NVARCHAR2(32)

Always a value of SDE_internal for locator properties

PROPERTY

NVARCHAR2(32)

The name of the locator property

PROP_VALUE

NVARCHAR2(255)

The value of the locator property

DESCRIPTION

NVARCHAR2(65)

Not used for locator properties

CREATION_DATE

DATE

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

NUMBER(38)

The identifier of the state in which this table was modified; corresponds to the ID column in the STATES table

NOT NULL

REGISTRATION_ID

NUMBER(38)

The registration ID of the table that was modified in the state; corresponds to the REGISTRATION_ID in 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

NUMBER(38)

Process identification number of the process that locked the geodatabase object; references SDE_ID column in PROCESS_INFORMATION table

NOT NULL

OBJECT_ID

NUMBER(38)

Identifier of the affected dataset

NOT NULL

OBJECT_TYPE

NUMBER(38)

Object lock type, for example, version,state_tree lock used by internal applications

NOT NULL

APPLICATION_ID

NUMBER(38)

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

LOCK_TIME

DATE

The date and time the object lock was acquired

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

NUMBER(38)

Process identification number

NOT NULL

SERVER_ID

NUMBER(38)

The operating system process ID of the server process

NOT NULL

AUDSID

NUMBER(38)

The gsrvr process ID

NOT NULL

START_TIME

DATE

Date and time process was started

NOT NULL

RCOUNT

NUMBER(38)

The number of reads that have been processed

NOT NULL

WCOUNT

NUMBER(38)

The number of writes that have been processed

NOT NULL

OPCOUNT

NUMBER(38)

Total number of operations a process has executed

NOT NULL

NUMLOCKS

NUMBER(38)

The number of locks that the process currently has open

NOT NULL

FB_PARTIAL

NUMBER(38)

Total number of partial features shipped by the process

NOT NULL

FB_COUNT

NUMBER(38)

Total number of buffers loaded by the process

NOT NULL

FB_FCOUNT

NUMBER(38)

Total number of features buffered by the process

NOT NULL

FB_KBYTES

NUMBER(38)

Total number of kilobytes buffered by the process

NOT NULL

OWNER

NVARCHAR2(30)

The name of the connected user

NOT NULL

DIRECT_CONNECT

VARCHAR2(1)

Indicates whether process was made with a direct connection: T (true) or F (false)

NOT NULL

SYSNAME

NVARCHAR2(32)

The operating system that the client machine is running

NOT NULL

NODENAME

NVARCHAR2(255)

The connected client machine name

NOT NULL

XDR_NEEDED

VARCHAR2(1)

Records whether client is using XDR to communicate with the gsrvr: T (true) or F (false)

NOT NULL

PROXY_YN

VARCHAR2(1)

Indicates whether a connection is for a proxy login

PARENT_SDE_ID

NUMBER(38)

The SDE_ID of the parent login of the proxy

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

NUMBER(38)

The primary key of the raster column table

NOT NULL

DESCRIPTION

NVARCHAR2(65)

The user-defined description of the raster table

DATABASE_NAME

NVARCHAR2(32)

Not used

OWNER

NVARCHAR2(32)

The owner of the raster column's business table

NOT NULL

TABLE_NAME

NVARCHAR2(160)

The business table name

NOT NULL

RASTER_COLUMN

NVARCHAR2(32)

The raster column name

NOT NULL

CDATE

NUMBER(38)

The date the raster column was added to the business table

NOT NULL

CONFIG_KEYWORD

NVARCHAR2(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

NUMBER(38)

Defined during the creation of the raster, establishes value of the raster table's raster_id column

BASE_RASTERCOLUMN_ID

NUMBER(38)

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

NUMBER(38)

Set to 256 for a geodatabase raster

NOT NULL

SRID

NUMBER(38)

Spatial reference identifier number; references 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

NUMBER(38)

The registration ID of the business table

HISTORY_REGID

NUMBER(38)

The registration ID of the archive table

FROM_DATE

NVARCHAR2(32)

The name of the from date field

TO_DATE

NVARCHAR2(32)

The name of the to date field

ARCHIVE_DATE

NUMBER(38)

The date the archive was created

ARCHIVE_FLAGS

NUMBER(38)

Not currently used

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

NUMBER(38)

The unique identifier for the layer

NOT NULL

MINX

NUMBER(38)

Minimum x-coordinate value of the layer

NOT NULL

MINY

NUMBER(38)

Minimum y-coordinate value of the layer

NOT NULL

MAXX

NUMBER(38)

Maximum x-coordinate value of the layer

NOT NULL

MAXY

NUMBER(38)

Maximum y-coordinate value of the layer

NOT NULL

MINZ

NUMBER(38)

Minimum z-coordinate value of the layer

MINM

NUMBER(38)

Minimum m-coordinate value of the layer

MAXZ

NUMBER(38)

Maximum z-coordinate value of the layer

MAXM

NUMBER(38)

Maximum m-coordinate value of the layer

TOTAL_FEATURES

NUMBER(38)

The total number of features in the feature class

NOT NULL

TOTAL_POINTS

NUMBER(38)

The total number of points (vertices) in the feature class

NOT NULL

VERSION_ID

NUMBER(38)

Unique identifier for the geodatabase version

LAST_ANALYZED

DATE

The date and time the feature class was last analyzed and statistics updated

NOT NULL

SDE_LOGFILE_POOL

The 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 Oracle.

SDE_TABLES_MODIFIED

The SDE_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

NVARCHAR2(32)

Name of the ArcSDE system table that was modified

NOT NULL

TIME_LAST_MODIFIED

DATE

Date and time the table was modified

NOT NULL

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

NUMBER(38)

The XML column's identifier; assigned by ArcSDE at the time the XML column is created

NOT NULL

REGISTRATION_ID

NUMBER(38)

The identifier of the business table containing the XML column; corresponds to the REGISTRATION_ID column in the TABLE_REGISTRY table

NOT NULL

COLUMN_NAME

NVARCHAR2(32)

Name of the XML column in the business table

NOT NULL

INDEX_ID

NUMBER(38)

The identifier of the XPath index associated with the XML column, if one exists; a foreign key to the XML indexes table

MINIMUM_ID

NUMBER(38)

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 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

NUMBER(38)

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

NUMBER(38)

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

NUMBER(38)

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.)

NOT NULL

DATA_TYPE

NUMBER(38)

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

NUMBER(38)

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

NVARCHAR2(64)

Text identifying the content that should be contained in the XML element or attribute

IS_EXCLUDED

NUMBER(38)

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

NUMBER(38)

The identifier of the XPath index

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.

INDEX_TYPE

NUMBER(38)

A value indicating the type of XPath index

  • 1 = index type SE_XML_INDEX_TEMPLATE
  • 2 = index type SE_XML_INDEX_DEFINITION

DESCRIPTION

NVARCHAR2(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

NVARCHAR2(32)

The initialization parameter name

NOT NULL

CHAR_PROP_VALUE

NVARCHAR2(512)

The character value of the initialization parameter

NUM_PROP_VALUE

NUMBER(38)

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

NUMBER(38)

Spatial reference identifier

NOT NULL

DESCRIPTION

NVARCHAR2(64)

The text description of the spatial reference system

AUTH_NAME

NVARCHAR2(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 value.

AUTH_SRID

NUMBER(38)

The ID of the spatial reference system as defined by the authority cited in AUTH_NAME

FALSEX

FLOAT(64)

The x offset used when transforming ground coordinates to internal system coordinates

NOT NULL

FALSEY

FLOAT(64)

The y offset used when transforming ground coordinates to internal system coordinates

NOT NULL

XYUNITS

FLOAT(64)

The scale factor to apply when transforming ground coordinates to internal system coordinates

NOT NULL

FALSEZ

FLOAT(64)

The z offset to use when transforming z values to internal system coordinates

NOT NULL

ZUNITS

FLOAT(64)

The scale factor to use when transforming z values to internal system coordinates

NOT NULL

FALSEM

FLOAT(64)

The measure offset to use when transforming measure values to internal system coordinates

NOT NULL

MUNITS

FLOAT(64)

The scale factor to use when transforming measure values to internal system coordinates

NOT NULL

XYCLUSTER_TOL

FLOAT(64)

Xy-coordinate cluster tolerance for topological processing

ZCLUSTER_TOL

FLOAT(64)

Z-coordinate cluster tolerance for topological processing

MCLUSTER_TOL

FLOAT(64)

Measure cluster tolerance for topological processing

OBJECT_FLAGS

NUMBER(38)

Stores object attributes, including precision

NOT NULL

SRTEXT

NVARCHAR2(1024)

Name and descriptor for the spatial reference as seen in the ArcGIS interface

NOT NULL

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

NUMBER(38)

Name that describes a state

NOT NULL

LINEAGE_ID

NUMBER(38)

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

NUMBER(38)

Process identification number of the process that locked the state; references SDE_ID column in PROCESS_INFORMATION table

NOT NULL

STATE_ID

NUMBER(38)

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

LOCK_TIME

DATE

The date and time the state lock was acquired

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

NUMBER(38)

A unique identifier for this state, assigned by ArcSDE

NOT NULL

OWNER

NVARCHAR2(32)

The user who created this state

NOT NULL

CREATION_TIME

DATE

The date and time this state was created

NOT NULL

CLOSING_TIME

DATE

The date and time this state was closed

PARENT_STATE_ID

NUMBER(38)

This STATE_ID of the parent state

NOT NULL

LINEAGE_NAME

NUMBER(38)

References the state's lineage stored in the STATE_LINEAGES table

NOT NULL

ST_COORDINATE_SYSTEMS

The ST_COORDINATE_SYSTEMS table contains all coordinate systems registered with the Spatial Type. This table is updated when ArcSDE is installed and, when needed, upgraded. It can also be updated to include user-defined coordinate systems by using the ST_CSRegister function.

Along with the ST_SPATIAL_REFERENCES table, the ST_COORDINATE_SYSTEMS table describes coordinate systems and projections available to the ST_Geometry type.

Field name

Field type

Description

Null?

NAME

NVARCHAR2(128)

Coordinate system name

TYPE

NVARCHAR2(128)

Type of coordinate system: PROJECTED, GEOGRAPHIC, or UNSPECIFIED

DEFINITION

NVARCHAR2(2048)

Well-known text description of the coordinate system

ORGANIZATION

NVARCHAR2(128)

Name of the organization that defined the coordinate system

ID

NUMBER(38)

Coordinate system ID defined by the organization

NOT NULL

DESCRIPTION

NVARCHAR2(256)

Description for the coordinate system indicating its application

ST_GEOMETRY_COLUMNS

This table holds the schema, geometry type, and spatial reference information for every ST_Geometry column created or added to a table object or view. Inserting ST_Geometry column information to this table is done using stored procedures to register/unregister tables or views. The table/column metadata must be registered to this table before creating a spatial index.

Creating a table with an ST_Geometry column does not insert ST_Geometry metadata. When you create a spatial index on a table, an entry will be inserted in the ST_GEOMETRY_COLUMNS and ST_GEOMETRY_INDEX tables.

This table is used to perform selections and DML metadata operations. Stored procedures are used to insert and delete entries from the ST_GEOMETRY_COLUMNS table.

Field name

Field type

Description

Null?

OWNER

NVARCHAR2(32)

Schema name owning the table

NOT NULL

TABLE_NAME

NVARCHAR2(32)

Unqualified table name having one or more spatial types

NOT NULL

COLUMN_NAME

NVARCHAR2(32)

Name of the geometry column

NOT NULL

GEOMETRY_TYPE

NVARCHAR2(32)

Geometry types associated with the column

PROPERTIES

NUMBER(38)

A bit mask containing application information such as entity, table status, load/normal mode, table, or view

SRID

NUMBER(38)

Spatial reference value from ST_SPATIAL_REFERENCES table

NOT NULL

GEOM_ID

NUMBER(38)

Uniquely defines a record; used as reference key to the index_id in ST_GEOMETRY_INDEX table

NOT NULL

ST_GEOMETRY_INDEX

This table holds the spatial index information for an ST_Geometry column. The spatial index for an ST_Geometry type is a domain index referred to in the CREATE INDEX statement.

Grid sizes and SRID are defined in the PARAMETERS clause of the CREATE INDEX statement. When using ALTER INDEX REBUILD, the SRID value should not be changed. If it is, the SRID values for all features will also need to be updated in a separate table UPDATE statement. To specify grid sizes and an SRID, use the st_grids and st_srid keywords:

CREATE INDEX shape_idx1 ON SCOTT.PARCELS (shape) 
INDEXTYPE IS SDE.ST_SPATIAL_INDEX
PARAMETERS('st_grids=1,0,0 st_srid=1');

OWNER, TABLE_NAME, and COLUMN_NAME uniquely identify an ST_SPATIAL_INDEX domain index.

Field name

Field type

Description

Null?

OWNER

NVARCHAR2(32)

Schema owner

TABLE_NAME

NVARCHAR2(32)

Unqualified table name

COLUMN_NAME

NVARCHAR2(32)

Name of the geometry column

INDEX_ID

NUMBER(38)

Uniquely identifies the domain index

NOT NULL

GRID

SDE.SP_GRID_INFO

Grid type containing multilevel integer grid information

SP_GRID_INFO is a GRID_TYPE column object consisting of three NUMBER grid values.

SRID

NUMBER(38)

SRID and spatial reference information

NOT NULL

COMMIT_INT

NUMBER(38)

XML commit interval for spatial index rows; the number of rows affected before issuing a COMMIT. The default value is 1000.

VERSION

NUMBER(38)

Domain index version number

STATUS

NVARCHAR2(10)

Describes the index status (1 = Active or 0 = Disabled). Loading can disable the index for performance reasons. The default is active.

INDEX_NAME

NVARCHAR2(30)

Name of the ST_SPATIAL_INDEX (domain index)

UNIQUENESS

VARCHAR2(9)

Indicates whether the domain index is UNIQUE or NONUNIQUE

DISTINCT_KEYS

NUMBER(38)

Number of distinct domain index keys

BLEVEL

NUMBER(38)

Depth of the domain index from its root block to its leaf block

LEAF_BLOCKS

NUMBER(38)

Number of leaf blocks for the domain index

CLUSTERING_FACTOR

NUMBER(38)

Indicates how ordered the rows in the table are based on the values of the index; if the CLUSTERING_FACTOR value is close to the number of blocks, the table is well ordered. In this case, the index entries in a single leaf block tend to point to rows in the same data blocks. If the CLUSTERING_FACTOR value is near the number of rows, the table is randomly ordered, in which case it is unlikely the index entries in the same leaf block point to rows in the same data blocks.

DENSITY

NUMBER(38)

Average number of features per grid cell

NUM_ROWS

NUMBER(38)

Number of rows in the table containing the ST_Geometry and ST_SPATIAL_INDEX

NUM_NULLS

NUMBER(38)

Number of NULL ST_Geometry values in the table containing the ST_Geometry and ST_SPATIAL_INDEX

SAMPLE_SIZE

NUMBER(38)

Size of the data sample used when collecting DBMS statistics

LAST_ANALYZED

DATE

Date on which the table was most recently analyzed

USER_STATS

NVARCHAR2(3)

Indicates whether statistics were entered directly by the user (YES) or not (NO)

ST_FUNCS

SDE.ST_FUNCS_ARRAY

User-defined operator selectivity and cost values; when set, defined values override derived selectivity and system-defined operator costs.

ST_SPATIAL_REFERENCES

This table contains all spatial references available to the ST_Geometry type. Spatial tables must be referenced correctly for you to analyze them individually or combine them to see relationships. This means they must have a spatial reference and coordinate system.

The ST_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.

Along with the ST_COORDINATE_SYSTEMS table, the ST_SPATIAL_REFERENCES table describes coordinate systems and projections available to the ST_Geometry type. Included in this table schema are scale and offsets for coordinates (x,y,z) and measures (m). This information is used to convert decimal values into integers and negative values into positive values for storage and performance reasons.

The ST_SPATIAL_REFERENCES table is prepopulated with spatial references defined by the European Petroleum Survey Group (EPSG). The EPSG codes are used for the spatial reference identifier (SRID) to make it easier to share data across databases. Other spatial references get added to the table when you import data if the incoming spatial reference does not match an exisitng spatial reference.

Field name

Field type

Description

Null?

SR_NAME

NVARCHAR2(128)

Spatial reference name

NOT NULL

SRID

NUMBER(38)

Spatial reference ID

NOT NULL

X_OFFSET

FLOAT(126)

Offset applied to x-coordinate values

NOT NULL

Y_OFFSET

FLOAT(126)

Offset applied to y-coordinate values

NOT NULL

XYUNITS

FLOAT(126)

Scale factor applied to x- and y-coordinates after applying offset

NOT NULL

Z_OFFSET

FLOAT(126)

Offset applied to z-coordinate values

NOT NULL

Z_SCALE

FLOAT(126)

Scale factor applied to z-coordinates after applying ioffset

NOT NULL

M_OFFSET

FLOAT(126)

Offset applied to measures

NOT NULL

M_SCALE

FLOAT(126)

Scale factor applied to measures after applying offset

NOT NULL

MIN_X

FLOAT(126)

Minimum possible x-value for coordinates

NOT NULL

MAX_X

FLOAT(126)

Maximum possible x-value for coordinates

NOT NULL

MIN_Y

FLOAT(126)

Minimum possible y-value for coordinates

NOT NULL

MAX_Y

FLOAT(126)

Maximum possible y-value for coordinates

NOT NULL

MIN_Z

FLOAT(126)

Minimum possible z-value for coordinates

MAX_Z

FLOAT(126)

Maximum possible z-value for coordinates

MIN_M

FLOAT(126)

Minimum possible m-value for measures

MAX_M

FLOAT(126)

Maximum possible m-value for measures

CS_ID

NUMBER(38)

Foreign key to the ST_COORDINATE_SYSTEMS table

CS_NAME

NVARCHAR2(128)

Name of the coordinate system for this spatial reference system

NOT NULL

CS_TYPE

NVARCHAR2(128)

Type of coordinate system: PROJECTED, GEOGRAPHIC, or UNSPECIFIED

NOT NULL

ORGANIZATION

NVARCHAR2(128)

Name of the organization that defined the coordinate system

ORG_COORDSYS_ID

NUMBER(38)

Coordinate system ID defined by the organization

DEFINITION

NVARCHAR2(2048)

Well-known text description of the coordinate system

NOT NULL

DESCRIPTION

NVARCHAR2(256)

Description for the spatial reference system, indicating its application

TABLE_LOCKS

The TABLE_LOCKS table maintains the locks on ArcSDE registered tables.

Field name

Field type

Description

Null?

SDE_ID

NUMBER(38)

Process identification number of the process that locked the table; references SDE_ID column in PROCESS_INFORMATION table

NOT NULL

REGISTRATION_ID

NUMBER(38)

Foreign key to registration_id field in the TABLE_REGISTRY table

NOT NULL

LOCK_TYPE

NCHAR(1)

The type of table lock

  • S = Shared
  • E = Exclusive

NOT NULL

LOCK_TIME

DATE

The date and time the table lock was acquired

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

NUMBER(38)

Unique identifier for the registration of the table

NOT NULL

TABLE_NAME

NVARCHAR2(160)

Name of the table

NOT NULL

OWNER

NVARCHAR2(32)

User who created the table

NOT NULL

ROWID_COLUMN

NVARCHAR2(32)

Name of the ObjectID column in the table

DESCRIPTION

NVARCHAR2(65)

The user-defined text description of the table

OBJECT_FLAGS

NUMBER(38)

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 versioned 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

NUMBER(38)

The date the table was registered with ArcSDE

NOT NULL

CONFIG_KEYWORD

NVARCHAR2(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

NUMBER(38)

The minimum row_id value of the table

IMV_VIEW_NAME

NVARCHAR2(32)

The name of a versioned view of the given table

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

NUMBER(38)

Number of the major release; for example, for ArcSDE 9.3, the major release number is 9.

NOT NULL

MINOR

NUMBER(38)

Number indicating the version of the minor release; for example, for ArcSDE 9.3, the minor release number is 3.

NOT NULL

BUGFIX

NUMBER(38)

Number of the patch or service pack installed

NOT NULL

DESCRIPTION

NVARCHAR2(96)

System-defined description of the ArcSDE installation

NOT NULL

RELEASE

NUMBER(38)

Complete release number, for example, 92009

NOT NULL

SDE_SVR_REL_LOW

NUMBER(38)

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

NVARCHAR2(64)

The unique name of the version

NOT NULL

OWNER

NVARCHAR2(32)

The version owner

NOT NULL

VERSION_ID

NUMBER(38)

The unique identifier of the version

NOT NULL

STATUS

NUMBER(38)

Specifies whether the version is available to the public or if it is privately accessed by the owner

NOT NULL

STATE_ID

NUMBER(38)

The identifier of the database state to which this version points

NOT NULL

DESCRIPTION

NVARCHAR2(65)

An optional text description of the version

PARENT_NAME

NVARCHAR2(64)

The name of the parent of this version

PARENT_OWNER

NVARCHAR2(32)

The name of the owner of the parent version

PARENT_VERSION_ID

NUMBER(38)

The identifier of the version that is the parent of this version

CREATION_TIME

DATE

The date and time that this version was created

NOT NULL

4/2/2015