ArcGIS Server Banner

System tables of a geodatabase stored in Oracle

System tables of a geodatabase stored in Oracle

Release 9.3 E-mail This TopicPrintable VersionGive Us feedback
Note:This topic was updated for 9.3.1.

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

To see a diagram of the geodatabase system tables, click here. (You need Adobe Reader to open this file.)

The following is an alphabetical list of the geodatabase system tables as they appear in an Oracle DBMS. You can use the links below to jump to a section of the list.


A B C D E F G H I J K L M


N O P Q R S T U V W X Y Z

NOTE: The system tables should not be altered using anything other than the ArcGIS software.

COLUMN_REGISTRY

The COLUMN_REGISTRY table manages all registered columns.

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

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 Term; Character Array

6 = SE_BLOB_TYPE—Variable Length Data

7 = SE_DATE_TYPE—Struct tm 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 Term; Character Array

15 = SE_NCLOB_TYPE—UNICODE Character Large Object

20 = SE_POINT_TYPE—Point UDT

21 = SE_CURVE_TYPE—LineString UDT

22 = SE_LINESTRING_TYPE—LineString UDT

23 = SE_SURFACE_TYPE—Polygon UDT

24 = SE_POLYGON_TYPE— Polygon UDT

25 = SE_GEOMETRYCOLLECTION_TYPE 25 /* MultiPoint UDT */

26 = SE_MULTISURFACE_TYPE—LineString UDT

27 = SE_MULTICURVE_TYPE—LineString UDT

28 = SE_MULTIPOINT_TYPE—MultiPoint UDT

29 = SE_MULTILINESTRING_TYPE—MultiLineString UDT

30 = SE_MULTIPOLYGON_TYPE—MultiPolygon UDT

31 = SE_GEOMETRY_TYPE—Geometry UDT

NOT NULL
COLUMN_SIZE NUMBER(38) The registered column value's length
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; properties include

  • Column has a row ID
  • SDE controls the row ID column
  • Column allows NULLS
  • Column stores Oracle LONG RAW data
  • Column stores BLOB data
  • Column stores CLOB data
  • Column stores ST_GEOMETRY geometry data
  • Column stores binary geometry data
  • Column stores UDT geometry data
  • Column stores Oracle LOB geometry data
  • Column stores binary raster data
  • Column stores UDT raster data
  • Column stores XML data
  • Column stores dates
  • Column stores time
  • Column stores a time stamp
  • Column stores a unicode string

NOT NULL
OBJECT_ID NUMBER(38) 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 not present if the geodatabase has never been compressed.


Field name Field type Description
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
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 was begun

NOT NULL
START_STATE_COUNT NUMBER(38) The number of states present when compress began

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 VARCHAR2(20) Indicates whether or not the compress operation was successfully completed

DBTUNE

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


Field name Field type Description
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

GCDRULES

The GCDRULES table stores the geocoding rules that are used by address locators to match addresses. Each record in the GCDRULES table corresponds to a geocoding rule file.


Field name Field type Description
ID NUMBER(9) The table's primary key

NOT NULL
STYLE VARCHAR(32) Name of the geocoding rule set
TYPE VARCHAR(3) The type of geocoding rule file; represented by a three-letter code

cls = Classification table

dct = Match key dictionary

pat = Pattern

stn = Standardization processes

mat = Matching specification

tbl = Additional tables (optional)
DATA BLOB The contents of the geocoding rule file

GDB_ANNOSYMBOLS

The GDB_ANNOSYMBOLS table contains feature class annotation.


Field name Field type Description
ID NUMBER(38) Uniquely identifies an annotation symbol

Primary key

NOT NULL
SYMBOL BLOB Stores the annotation symbology

GDB_ATTRRULES

The GDB_ATTRRULES table contains the attribute rules in the geodatabase.


Field name Field type Description
RULEID NUMBER(38) Identification number of the attribute rule; corresponds to the RuleID column in the GDB_VALIDRULES table

Primary key
SUBTYPE NUMBER(38) Subtype code associated with the rule
FIELDNAME NVARCHAR2(32) Field with which the rule is associated
DOMAINNAME NVARCHAR2(160) Name assigned to the attribute domain in the geodatabase; references DomainName field in the GDB_DOMAINS table

GDB_CODEDDOMAINS

The GDB_CODEDDOMAINS table contains values for each coded value domain.


Field name Field type Description
DOMAINID NUMBER(38) Unique identifier of the domain; corresponds to the ID field in the GDB_DOMAINS table

Primary key

NOT NULL
CODEDVALUES BLOB Contains the set of coded values and their descriptions

NOT NULL

GDB_DEFAULTVALUES

The GDB_DEFAULTVALUES table contains the default values for fields at the subtype or object class level.


Field name Field type Description
CLASSID NUMBER(38) The object class ID; foreign key to the ID field of the GDB_OBJECTCLASSES table

NOT NULL
FIELDNAME NVARCHAR2(32) The name of the field to which the default value applies

NOT NULL
SUBTYPE NUMBER(38) Subtype code for which the default value is specified for a particular field

NOT NULL
DEFAULTSTRING NVARCHAR2(160) The text that is the default value for a field that is a string type
DEFAULTNUMBER NUMBER(38,8) The numeric value that is the default for a field that is an integer type

GDB_DOMAINS

The GDB_DOMAINS table contains the attribute constraints associated with attribute rules of the GDB_ATTRRULES table.


Field name Field type Description
ID NUMBER(38) Unique identifier of the domain.

Primary key.

NOT NULL.
OWNER NVARCHAR2(32) User who created the attribute domain.

NOT NULL.
DOMAINNAME NVARCHAR2(160) Name assigned to the attribute domain in the geodatabase.

NOT NULL.
DESCRIPTION NVARCHAR(255) Optional text describing the attribute domain.

DOMAINTYPE NUMBER(38) Code indicating whether this is a range (1) or coded value (2) domain.

NOT NULL.
FIELDTTYPE NUMBER(38) Code indicating what type of field the domain applies to:

0 = Short integer

1 = Long integer

2 = Float

3 = Double

4 = Text

5 = Date

NOT NULL.
MERGEPOLICY NUMBER(38) Code indicating the policy to use to assign to the resultant feature when two features are merged:

1 = sum values—The attribute of the feature that results from a merge will be the sum of the values of the two original (premerge) features.

2 = geometry weighted—The attribute of the feature that results from a merge is the weighted average of the values of the attributes of the original (premerge) features. The average is based on the original features' geometry.

3 = default value—The attribute of the feature created as a result of the merge will be the same as the default value of the feature class or subtype. (Note: This is the only merge policy value available for nonnumeric fields and coded value domains.)

NOT NULL.
SPLITPOLICY NUMBER(38) Code indicating the policy to be used for assigning attributes to the features that result from splitting one feature:

1 = Geometry ratio—The attributes of the features resulting from the split are a ratio of the original feature's (presplit) value. The ratio is based on the ratio in which the geometry is divided by the split.

2 = Duplicate—The attribute of the features resulting from the split are the same as the original object's (presplit) attribute value.

3 = Default value—The attributes of features resulting from the split take on the default value for the attribute as defined in the feature class or subtype.

NOT NULL.

GDB_EDGECONNRULES

The GDB_EDGECONNRULES table contains one record per edge connectivity rule in a geometric network.


Field name Field type Description
RULEID NUMBER(38) The unique ID for a rule in the geodatabase and foreign key to the ID field in the GDB_ValidRules table

NOT NULL
FROMCLASSID NUMBER(38) The Object Class ID of the from feature class and the foreign key to the ID in the GDB_GeomNetworks table

NOT NULL
FROMSUBTYE NUMBER(38) The subtype of the from edge feature class

NOT NULL
TOCLASSID NUMBER(38) The Object Class ID of the to feature class and the foreign key to the ID in the GDB_GeomNetworks table

NOT NULL
TOSUBTYPE NUMBER(38) The subtype of the to edge feature class

NOT NULL
JUNCTIONS BLOB Contains information related to the junction feature class

NOT NULL

GDB_EXTENSIONDATASETS

The GDB_EXTENSIONDATASETS table contains information about the dataset extensions (such as network datasets or terrain datasets) in a geodatabase.


Field name Field type Description
ID NUMBER(38) Unique identification number for the network dataset

Primary key

NOT NULL
OWNER NVARCHAR2(32) Owner of the dataset
NAME NVARCHAR2(160) Name of the dataset
DATASETID NUMBER(38) Foreign key to DATASETID field in related tables

NOT NULL
PROPERTIES BLOB Properties specific to the dataset
DATASETTYPE NUMBER(38) The type of dataset within the geodatabase

GDB_EXTENSIONS

The GDB_EXTENSIONS table stores the extensions registered with this geodatabase.


Field name Field type Description
ID NUMBER(38) Unique identifier of the workspace extension

Primary key

NOT NULL
NAME NVARCHAR2(160) Name of the workspace extension

NOT NULL
CLSID NVARCHAR2(38) GUID that uniquely identifies the extension of an object class

NOT NULL

GDB_FEATURECLASSES

The GDB_FEATURECLASSES table contains information on all the feature classes in the geodatabase.


Field name Field type Description
OBJECTCLASSID NUMBER(38) Foriegn key to the ID field in the GDB_OBJECTCLASSES table

NOT NULL
FEATURETYPE NUMBER(38) Code representing the type of feature

1 = point, multipoint, line, polygon, or multipatch

7 = junctions

8 = simple edges

10 = complex edges

11 = annotation

13 = dimension

14 = raster

NOT NULL
GEOMETRYTYPE NUMBER(38) Code representing the type of geometry of the feature class

1 = point

2 = multipoint

3 = line

4 = polygon (including annotation and dimension)

9 = multipatch

NOT NULL
SHAPEFIELD NVARCHAR2(32) Name of the shape field in the feature class

NOT NULL
GEOMNETWORKID NUMBER(38) Foreign key to ID field in the GDB_GeomNetworks table
GRAPHID NUMBER(38) Foreign key to ID GDB_Networks table

GDB_FEATUREDATASET

The GDB_FEATUREDATASET table contains the feature datasets (groupings of feature classes) in the geodatabase.


Field name Field type Description
ID NUMBER(38) Uniquely identifies the feature dataset

Primary key

NOT NULL
OWNER NVARCHAR2(32) User who created the feature dataset
NAME NVARCHAR2(160) Name of the feature dataset

NOT NULL
SRID NUMBER(38) Spatial reference ID number; foreign key to SPATIAL_REFERENCES table

NOT NULL

GDB_FIELDINFO

The GDB_FIELDINFO table contains the field name, default domain names values, and default string and number values for each attribute field associated with a feature class.


Field name Field type Description
CLASSID NUMBER(38) Foreign key to the ID field in the GDB_OBJECTCLASSES table

NOT NULL
FIELDNAME NVARCHAR2(160) Name of the field in the table

NOT NULL
ALIASNAME NVARCHAR2(160) Alternate name assigned to the field (Aliases can be altered after field creation, the field name cannot.)
MODELNAME NVARCHAR2(160) Alternate name assigned to the field used to identify a type of field without requiring a hard-coded name
DEFAULTDOMAINNAME NVARCHAR2(160) Name of the domain associated with the field
DEFAULTVALUESTRING NVARCHAR2(160) If the field is type text, the default value assigned to it
DEFAULTVALUENUMBER NUMBER(38,8) If the field is a numeric type, the default value assigned to it
ISREQUIRED NUMBER(38) 0 (not a required field) or 1 (a required field)
ISSUBTYPEFIXED NUMBER(38) Denotes whether subtype is set for the field

0 = yes

1 = no
ISEDITABLE NUMBER(38) 0 (not editable) or 1 (editable)

GDB_GEOMNETWORKS

The GDB_GEOMNETWORKS table contains one record per geometric network in the geodatabase. If no stand-alone logical networks exist in the geodatabase, there will be a one-to-one mapping of the GDB_GEOMNETWORKS and GDB_NETWORKS tables.


Field name Field type Description
ID NUMBER(38) Unique ID and primary key for geometric network in the geodatabase

NOT NULL
OWNER NVARCHAR2(32) The name of the user who created the geometric network

NOT NULL
NAME NVARCHAR2(160) The name of the geometric network, which must be unique in a personal geodatabase

NOT NULL
NETWORKTYPE NUMBER(38) The type of geometric network

NOT NULL
DATASETID NUMBER(38) Foreign key to ID field in GDB_OBJECTCLASSES table

NOT NULL

GDB_HISTORICALMARKERS

The GDB_HISTORICALMARKERS table contains a list of markers used for navigating moments in a historical version.


Field name Field type Description
HM_NAME NVARCHAR(64) The name of the historical marker
HM_TIMESTAMP DATE The moment the historical marker references

GDB_JNCONNRULES

The GDB_JNCONNRULES contains one record per junction connectivity rule in a geometric network.


Field name Field type Description
RULEID NUMBER(38) Primary key; the unique ID for a rule in a geodatabase and the foreign key to the ID field in the GDB_VALIDRULES table

NOT NULL
EDGECLASSID NUMBER(38) The Object Class ID of the edge feature class and the foreign key to the ID field in the GDB_GeomNetworks table

NOT NULL
EDGESUBTYPE NUMBER(38) The subtype of the edge feature class

NOT NULL
JUNCTIONCLASSID NUMBER(38) The Object Class ID of the junction feature class and the foreign key to the ID field in the GDB_GEOMNETWORKS table

NOT NULL
JUNCTIONSUBTYPE NUMBER(38) The subtype of the junction feature class

NOT NULL
EDGEMINCARD NUMBER(38) The minimum edge cardinality (the minimum number of edges to which a junction can connect)

NOT NULL
EDGEMAXCARD NUMBER(38) The maximum edge cardinality (the maximum number of edges to which a junction can connect)

NOT NULL
JUNCTIONMINCARD NUMBER(38) The minimum junction cardinality (the minimum number of junctions to which an edge can connect)

NOT NULL
JUNCTIONMAXCARD NUMBER(38) The maximum junction cardinality (the maximum number of junctions to which an edge can connect)

NOT NULL
ISDEFAULT NUMBER(38) Will contain a value of 0 or 1 indicating if a junction is a default junction and has been created automatically

GDB_NETCLASSES

The GDB_NETCLASSES table contains one record per feature class that participates in a geometric network in a geodatabase.


Field name Field type Description
CLASSID NUMBER(38) The Object Class ID of a feature class in a geodatabase and the foreign key to the ID field in the GDB_GEOMNETWORKS table

NOT NULL
NETWORKID NUMBER(38) The unique ID for a geometric network in a geodatabase

NOT NULL
ENABLEDFIELD NVARCHAR2(32) The Enabled field name for the feature class (usually "Enabled")

Every feature class in a geometric network must have an enabled field.

NOT NULL
ANCILLARYROLE NUMBER(38) Indicates whether the junction feature class acts as a source or a sink in a geometric network

NOT NULL
ANCILLARYFIELD NVARCHAR2(32) The AncillaryRole field name for the feature class (usually "AncillaryRole")

NOT NULL

GDB_NETWEIGHTASOCS

The GDB_NETWEIGHTASOCS table contains one record per association between the network classes and the network weights of the geometric networks.


Field name Field type Description
NETWORKID NUMBER(38) The unique ID for a geometric network in a geodatabase and a foreign key to the ID field in the GDB_GEOMNETWORKS table

NOT NULL
WEIGHTID NUMBER(38) The unique ID of a weight in a geometric network and the foreign key to the ClassID field in the GDB_NETCLASSES table

NOT NULL
TABLENAME NVARCHAR2(160) The name of the table containing the field with which the network weight has been associated

NOT NULL
FIELDNAME NVARCHAR2(32) The name of the field with which the weight has been associated

NOT NULL

GDB_NETWEIGHTS

The GDB_NETWEIGHTS table contains one record per weight in a geodatabase.


Field name Field type Description
OID NUMBER(38) The unique ID of a weight in a geodatabase

NOT NULL
NETWORKID NUMBER(38) The unique ID for the geometric network in a geodatabase and the foreign key to the ID fields in the GDB_GEOMNETWORKS, GDB_NETWORKS, and GDB_EXTENSIONDATASETS tables

NOT NULL
NAME NVARCHAR2(160) The name of the weight, which must be unique in each network

NOT NULL
WEIGHTID NUMBER(38) The unique ID of the weight in the geometric network

NOT NULL
WEIGHTTYPE NUMBER(38) A value indicating the type of network weight

NOT NULL
BITGATESIZE NUMBER(38) A value from 0 to 31 indicating the size of the BitGate weight

(NonBitGate weights have a value of 0.)
ELEMENTTYPES NUMBER(38) Denotes the type of network weight

GDB_NETWORKS

The GDB_NETWORKS table contains one record per logical network in the geodatabase. If no stand-alone logical networks exist within the geodatabase, there will be a one-to-one mapping between the GDB_GEOMNETWORKS and the GDB_NETWORKS tables.


Field name Field type Description
ID NUMBER(38) The unique ID and primary key of the logical network in a geodatabase.

NOT NULL.
OWNER NVARCHAR2(32) The name of the user who created the logical network.
NAME NVARCHAR2(160) The name of the logical network.

NOT NULL.
NETWORKTYPE NUMBER(38) A value indicating the type of network.

All networks created using ArcGIS Desktop will have a value of 1=esriNTUtilityNetwork.

NOT NULL.
DATASETID NUMBER(38) The ID of the feature dataset in which the geometric network resides.

Foreign key to the ID field in the GDB_FEATUREDATASETS table.

NOT NULL.
INDEXTYPE NUMBER(38) Not currently implemented.
NORMALIZED NUMBER(38) A value of either 0 or 2, which indicates whether the network is narrow or wide.

Narrow networks contain feature classes with ObjectIDs less than 10,000; wide networks can contain feature classes with ObjectIDs greater than 10,000.

NOT NULL.

GDB_OBJECTCLASSES

The GDB_OBJECTCLASSES contains all the object classes in the geodatabase. This includes the feature classes, relationship classes, and business (or base) tables.


Field name Field type Description
ID NUMBER(38) Unique identifier for the object class

Primary key

NOT NULL
OWNER NVARCHAR2(32) User who owns the object class

NOT NULL
NAME NVARCHAR2(160) Name of the object class

NOT NULL
ALIASNAME NVARCHAR2(160) Alternative name of the object class
MODELNAME NVARCHAR2(160) Alternate name of the object class; used to identify the type of entity without requiring a hard-coded name
CLSID NVARCHAR2(38) GUID that uniquely identifies the type of object class

NOT NULL
EXTCLSID NVARCHAR2(38) GUID that uniquely identifies the extension of an object class
EXTPROPS BLOB Stores the properties of the associated class extension
DATASETID NUMBER(38) Foreign key to the ID field in the GDB_FEATUREDATASET table

SUBTYPEFIELD NVARCHAR2(32) Name of the field in the object class for defining subtypes

NOT NULL

GDB_RANGEDOMAINS

The GDB_RANGEDOMAINS table contains the range of values for each range domain.


Field name Field type Description
DOMAINID NUMBER(38) Foreign key to the ID field in the GDB_DOMAINS table

NOT NULL
MINVALUE NUMBER(38,8) The lowest allowable value in the range

NOT NULL
MAXVALUE NUMBER(38,8) The greatest allowable value in the range

NOT NULL

GDB_RASTERCATALOGS

The GDB_RASTERCATALOGS table stores a reference to each raster catalog in the geodatabase.


Field name Field type Description
OBJECTCLASSID NUMBER(38) Foreign key to the ID field in the GDB_OBJECTCLASSES table

NOT NULL
RASTERFIELD NVARCHAR2(32) Name of the raster field

NOT NULL
ISRASTERDATASET NUMBER(38) 0 (not a raster dataset) or 1 (a raster dataset)

NOT NULL

GDB_RELCLASSES

The GDB_RELCLASSES table contains the table relationships in the geodatabase. All the system metadata required to manage relationships, such as the cardinality and the IDs of the origin and destination classes, is stored in the GDB_RELCLASSES table.


Field name Field type Description
ID NUMBER(38) Unique identifier of the relationship class.

Primary key.

NOT NULL.
OWNER NVARCHAR2(32) User who owns the relationship class.

NOT NULL.
NAME NVARCHAR2(160) Name of the relationship class.

NOT NULL.
ORIGINCLASSID NUMBER(38) ID of the origin object class.

NOT NULL.
DESTCLASSID NUMBER(38) ID of the destination object class.

NOT NULL.
FORWARDLABEL NVARCHAR2(255) Label that describes the relationship when navigating from origin class to destination class.
BACKWARDLABEL NVARCHAR2(255) Label that describes the relationship when navigating from destination class to origin class.
CARDINALITY NUMBER(38) Code representing the type of cardinality of the relationship class:

1 = one to one

2 = one to many

3 = many to many

NOT NULL.
NOTIFICATION NUMBER(38) Code indicating the notification direction:

1 = none (no messages propagated)

2 = forward (origin to destination)

3 = backward

4 = both (forward and backward notification)

NOT NULL.
ISCOMPOSITE NUMBER(38) If a relationship class is composite, destination objects cannot exist independently of their related origin objects.

Possible values are

0 (is simple, not composite) or 1 (is composite).

NOT NULL.
ISATTRIBUTED NUMBER(38) Indicates whether or not this is an attributed relationship.

NOT NULL.
ORIGINPRIMARYKEY NVARCHAR2(32) The name of the primary key field of the origin object class.

NOT NULL.
DESTPRIMARYKEY NVARCHAR2(32) The name of the primary key field in the destination object class.

NOT NULL.
ORIGINFOREIGNKEY NVARCHAR2(32) The name of the foreign key field of the origin object class.

NOT NULL.
DESTFOREIGNKEY NVARCHAR2(32) The name of the foreign key field in the destination object class.

NOT NULL.
DATASETID NUMBER(38) Foreign key to the GDB_FEATUREDATASET table.

NOT NULL.

GDB_RELEASE

The GDB_RELEASE table stores geodatabase version release information as a single record.


Field name Field type Description
MAJOR NUMBER(38) Number of the release for the geodatabase. For example, ArcGIS 8 was the first major release for the geodatabase, 9 was the second.

NOT NULL.
MINOR NUMBER(38) Number indicating the version of the major release. For example, for ArcSDE 9.1, this would be 1.

NOT NULL.
BUGFIX NUMBER(38) Not in use at this time.

The number of the patch or service pack installed. If 0, no service pack or patch is installed.

NOT NULL.

GDB_RELRULES

The GDB_RELRULES table contains the object class relationship rules.


Field name Field type Descripton
RULEID NUMBER(38) Unique identifier of the rule and foreign key to the ID field in the GDB_VALIDRULES table

Primary key

NOT NULL
ORIGINSUBTYPE NUMBER(38) The subtype of the origin feature class

NOT NULL
ORIGINMINCARD NUMBER(38) Minimum number of origin features to which a destination feature can connect

NOT NULL
ORIGINMAXCARD NUMBER(38) Maximum number of origin features to which a destination feature can connect

NOT NULL
DESTSUBTYPE NUMBER(38) The subtype of the destination feature class

NOT NULL
DESTMINCARD NUMBER(38) Minimum number of destination features to which an origin feature can connect

NOT NULL
DESTMAXCARD NUMBER(38) Maximum number of destination features to which an origin feature can connect

NOT NULL

GDB_REPLICADATASETS

The GDB_REPLICADATASETS table contains information relating to each dataset that was checked out or replicated.


Field name Field type Description
ID NUMBER(38) The unique ID for each record in the table

Primary key

NOT NULL
REPLICAID NUMBER(38) The ID of the replica in the parent database

NOT NULL
DATASETTYPE NUMBER(38) Code for the type of each dataset in the replica

(See esriDatasetType constants on EDN for a list of the codes and their meaning.)

NOT NULL
DATASETID NUMBER(38) The ID of each dataset in the replica

NOT NULL
PARENTOWNER NVARCHAR2(32) The owner of the data in the parent geodatabase

NOT NULL
PARENTDB NVARCHAR2(32) The name of the database in the parent database

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
ID NUMBER(38) Unique identifier for row.

NOT NULL.
REPLICAID NUMBER(38) Foreign key to the ID field in the GDB_REPLICAS table.

NOT NULL.
EVENT NUMBER(38) Indicates if 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_REPLICAS

The GDB_REPLICAS table contains the metadata for each replica in the geodatabase.


Field name Field type Description
ID NUMBER(38) Unique identifier for the replica (child) version

Primary key

NOT NULL
NAME NVARCHAR2(32) Name of the replica (child) version of the geodatabase

NOT NULL
OWNER NVARCHAR2(32) User who owns the replica (child) version of the geodatabase

NOT NULL
VERSION NVARCHAR2(32) Name of the replica version in the parent geodatabase

NOT NULL
PARENTID NUMBER(38) ID of the replica in the parent geodatabase

NOT NULL
REPDATE DATE Date and time the replica was created

NOT NULL
DEFQUERY BLOB Contains the replica description, which describes datasets and filters that define the replica

NOT NULL
REPGUID NVARCHAR2(36) The GUID value that uniquely identifies the replica across geodatabases

NOT NULL
REPCINFO NVARCHAR2(1800) The connection information for the relative replicas geodatabase
ROLE NUMBER(38) Indicates if a replica has the role of parent or child

NOT NULL

GDB_REPLICASEX

The GDB_REPLICASEX table has additional information about each replica that is stored in the GDB_REPLICAS table. It also has one record of metadata for each replica.


Field name Field type Description
ID NUMBER(38) Unique identifier for the row.

Primary key.

NOT NULL.
REPLICAID NUMBER(38) Foreign key to ID field in GDB_REPLICAS table.

NOT NULL.
RPROPS BLOB Extra replica properties, such as generation numbers or replica state, are stored in this field.
DPROPS BLOB Replica description parameters.

NOT NULL.

GDB_SPATIALRULES

The GDB_SPATIALRULES table is not in use at this time.


Field name Field type Description
RULEID NUMBER(38) Primary key

NOT NULL
SUBTYPE NUMBER(38)

NOT NULL
SPATIALREL NUMBER(38)

NOT NULL
DISTANCE NUMBER(38,8)

NOT NULL
REFCLASSID NUMBER(38)

NOT NULL
REFSUBTYPE NUMBER(38)

NOT NULL

GDB_SUBTYPES

The GDB_SUBTYPES table contains the valid subtypes of the geodatabase object classes.


Field name Field type Description
ID NUMBER(38) Unique identifier of the subtype

NOT NULL
CLASSID NUMBER(38) Foreign key to the ID field in the GDB_OBJECTCLASSES table

NOT NULL
SUBTYPECODE NUMBER(38) Numeric code value representing a subtype; foreign key to SUBTYPE field in GDB_DEFAULTVALUES table and DESTCLASSSUBTYPE field in the GDB_TOPORULES table

NOT NULL
SUBTYPENAME NVARCHAR2(160) Name of the subtype; corresponds to the Subtype Description on the Subtypes tab of the Feature Class Properties dialog box in ArcCatalog

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
TABLE_NME NVARCHAR2(160) Name of the geodatabase system table
LAST_MODIFIED_COUNT NUMBER(38) Keeps a count of the number of times a system table is modified; incrementally increases each time the system table is modified

GDB_TOOLBOXES

The GDB_TOOLBOXES table contains one record of metadata for each toolbox in the geodatabase.


Field name Field type Description
ID NUMBER(38) Unique identifier for the toolbox

Primary key

NOT NULL
DATABASENAME NVARCHAR2(32) Not used
OWNER NVARCHAR2(32) User who created the toolbox in the geodatabase

NOT NULL
NAME NVARCHAR2(160) Name given to the toolbox

NOT NULL
DISPLAY_NAME NVARCHAR2(255) Label for the toolbox

ALIAS NVARCHAR2(255) Alternative name for the toolbox
HELPFILE NVARCHAR2(255) Path to the help file containing the help topic for the toolbox
HELPCONTEXT NUMBER(38) Help context ID from the help file for the help topic associated with the toolbox

GDB_TOPOCLASSES

The GDB_TOPOCLASSES table contains one record per each feature class in a topology.


Field name Field type Description
CLASSID NUMBER(38) Unique identifier of the topology class;

foreign key to ID field in the GDB_OBJECTCLASSES table

NOT NULL
TOPOLOGYID NUMBER(38) Foreign key to ID field in GDB_TOPOLOGIES table

NOT NULL
WEIGHT NUMBER(38,8) Not in use
XYRANK NUMBER(38) The rank in the x,y domain assigned to the feature class in the topology

NOT NULL
ZRANK NUMBER(38) The rank in the z domain assigned to the feature class in the topology

NOT NULL
EVENTSONANALYZE NUMBER(38) Indicates if an event is broadcast when topology is validated

NOT NULL

GDB_TOPOLOGIES

The GDB_TOPOLOGIES table contains one record per topology in the geodatabase.


Field name Field type Description
ID NUMBER(38) Primary key and the unique ID for the topology in the geodatabase

NOT NULL
OWNER VARCHAR2(32) The owner of the topology (the user who created the topology)

NOT NULL
NAME VARCHAR2(160) The name of the topology

NOT NULL
DATASETID NUMBER(38) The feature dataset in which the topology resides and the foreign key to the ID field in the GDB_FEATUREDATASETS table

NOT NULL
PROPERTIES BLOB Stores information such as the cluster tolerance, max error count, state, and configuration keyword

GDB_TOPORULES

The GDB_TOPORULES table contains one record per rule in each topology.


Field name Field type Description
RULEID NUMBER(38) Unique identifier of the topology rule; foreign key to the ID field in the GDB_VALIDRULES table

NOT NULL
ORIGINCLASSID NUMBER(38) Foreign key to CLASSID field in GDB_TOPOCLASSES table

NOT NULL
ORIGINSUBTYPE NUMBER(38) Foreign key to SUBTYPECODE field in GDB_SUBTYPES table

NOT NULL
ALLORIGINSUBTYPES NUMBER(38) Indicates if rule applies to all subtypes in the origin feature class

NOT NULL
DESTCLASSID NUMBER(38) Foreign key to CLASSID field in GDB_TOPOCLASSES table

NOT NULL
DESTSUBTYPE NUMBER(38) Foreign key to SUBTYPECODE field in GDB_SUBTYPES table

NOT NULL
ALLDESTSUBTYPES NUMBER(38) Indicates if rule applies to all subtypes in the destination feature class

NOT NULL
TOPOLOGYRULETYPE NUMBER(38) The type of topology rule

NOT NULL
NAME VARCHAR2(160) User-defined name associated with the topology rule
RULEGUID VARCHAR(38) GUID that uniquely identifies the topology rule

NOT NULL

GDB_USERMETADATA

The GDB_USERMETADATA table stores user-defined metadata for all parts of the geodatabase including object classes, feature classes, feature datasets, logical networks, and relationship classes.


Field name Field type Description
ID NUMBER(38) Uniquely identifies the metadata record

Primary key

NOT NULL
DATABASENAME VARCHAR2(32) Not used
OWNER VARCHAR2(32) The owner of the metadata

NOT NULL
NAME VARCHAR2(160) Name of the dataset to which the metadata refers

NOT NULL
DATASETTYPE NUMBER(38) Code for the type of dataset to which the metadata refers

NOT NULL
XML BLOB Metadata content

NOT NULL

GDB_VALIDRULES

The GDB_VALIDRULES table contains all the valid rules of the geodatabase. This includes the attribute rules, edge connectivity rules, junction connectivity rules, relationship rules, topology rules, geocoding rules, and spatial rules.


Field name Field type Description
ID NUMBER(38) Uniquely identifies a rule

Primary key

NOT NULL
RULETYPE NUMBER(38) The type of validation rule

NOT NULL
CLASSID NUMBER(38) Foreign key to ID field in GDB_OBJECTCLASSES table

NOT NULL
RULECATEGORY NUMBER(38) Not in use at this time

NOT NULL
HELPSTRING NVARCHAR2(160) Not in use at this time

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
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; code 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
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 accepting 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
SDE_ID NUMBER(38) 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 NUMBER(38) Foreign key to layer_id field in LAYERS table

NOT NULL
AUTOLOCK CHAR(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 CHAR(1) The type of layer lock can either be

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

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, to index geometry values, and to properly create and manage the associated DBMS tables.


Field name Field type Description
LAYER_ID NUMBER(38) Unique identifier for the layer

Primary key

NOT NULL
DESCRIPTION NVARCHAR2(65) The optional layer description

DATABASE_NAME NVARCHAR2(32) Not used
OWNER NVARCHAR2(32) The user who created the layer in the geodatabase

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:
  • Layer stores single precision or double precision coordinates.
  • Layer stores 3D coordinates.
  • Layer stores measures.
  • Layer has autolocking enabled or disabled.
  • Layer is in load only I/O mode or normal I/O mode.
  • Layer stores annotation.
  • Layer stores CAD data.
  • Layer is a view of another layer.
  • 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, 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 vlue 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 measure value of the layer
MAXM FLOAT(64) Maximum measure value of the layer
CDATE NUMBER(38) The layer creation date

NOT NULL
LAYER_CONFIG NVARCHAR2(32) Configuration keyword with which the layer was created
OPTIMAL_ARRAY_SIZE NUMBER(38) Geometry array buffer size
STATS_DATE NUMBER(38) When 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; corresponds 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
LINEAGE_NAME NUMBER(38) Foreign key 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

LOCATORS

The LOCATORS table stores information about locator objects.


Field name Field type Description
LOCATOR_ID NUMBER(38) Unique identifier of the locator

Primary key

NOT NULL
NAME NVARCHAR2(32) The name of the locator

NOT NULL
OWNER NVARCHAR2(32) The name of the user who owns the locator

NOT NULL
CATEGORY NVARCHAR2(32) The category of the locator; address locators have a category value of Address.

NOT NULL
TYPE NUMBER(38) The type of locator; values in this column are represented as

  • 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 NVARCHAR2(64) The description of the locator

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 METADATA table defines a single property for a locator.


Field name Field type Description
RECORD_ID NUMBER(38) Unique identifier for the record

Primary key

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
STATE_ID NUMBER(38) The ID of the state in which this table was modified; foreign key to the STATES table

NOT NULL
REGISTRATION_ID NUMBER(38) The registration ID of the table that was modified in the state; foreign key to the TABLE_REGISTRY table

NOT NULL

OBJECT_LOCKS

The OBJECT_LOCKS table maintains locks on geodatabase objects.


Field name Field type Description
SDE_ID NUMBER(38) Process identification number of the process that locked the geodatabase object; references sde_id column in SDE_process_information table

NOT NULL
OBJECT_ID NUMBER(38) ID from the OBJECT_CLASSES table 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 CHAR(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 CHAR(1) The type of object lock, which includes

"S" for shared

"E" for 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
SDE_ID NUMBER(38) Process identification number

NOT NULL
SERVER_ID NUMBER(38) The operating system process ID of the server process

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 or not 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
RASTERCOLUMN_ID NUMBER(38) The primary key of the raster column table

NOT NULL
DESCRIPTION VARCHAR2(65) The 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 whose storage parameters determine 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, this value 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
ARCHIVING_REGID NUMBER(38) The table's registration ID
HISTORY_REGID NUMBER(38) The archive table's registration ID
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 creation date of the archive
ARCHIVE_FLAGS NUMBER(38) Not currently used

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
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 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
COLUMN_ID NUMBER(38) The XML column's identifier and the table's primary key; this value is assigned by ArcSDE at the time the XML column is created.

NOT NULL.
REGISTRATION_ID NUMBER(38) The identifier of the business table containing the XML column; a foreign key to the ArcSDE table registry.

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 uncompressed; by default, documents are compressed. (Compressed documents provide better performance.)

SDE_XML_INDEX_TAGS

An XML column may 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 an XML column's XPath index.


Field name Field type Description
INDEX_ID NUMBER(38) The identifier of the XPath index associated with an 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.

(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 may be used to identify an XPath.

For example, the Z39.50 communication protocol uses numeric codes to refer to content that may be searched. This column is not used by the ArcIMS Z39.50 Connector.
DESCRIPTION NVARCHAR2(64) Text identifying the content that should be contained in the XML element or attribute.
IS_EXCLUDED NUMBER(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 XML column that has an XPath index.


Field name Field type Description
INDEX_ID NUMBER(38) The identifier of the XPath index.

Primary key.

NOT NULL.
INDEX_NAME NVARCHAR2(32) The name of the XPath index.

For XPath indexes associated with an ArcIMS Metadata Service, the name will be "ims_xml#", where # is the identifier of the XML column in the metadata service's business table.

NOT NULL.
OWNER NVARCHAR2(32) The database user who owns the XML column.

For ArcIMS Metadata Services, this is the user specified in the service's ArcXML configuration file.
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.

For XPath indexes associated with an ArcIMS Metadata Service, only the index type SE_XML_INDEX_DEFINITION is supported.
DESCRIPTION NVARCHAR2(64) Text identifying the XPath index.

If an index definition file was used to create the index, the index's description may 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 uses memory.


Field name Field type Description
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
SRID NUMBER(38) Spatial reference identifier number

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
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) X,y 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 VARCHAR2(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 state 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
LINEAGE_NAME NUMBER(38) Name that describes a state

NOT NULL
LINEAGE_ID NUMBER(38) Unique ID of individual states

NOT NULL

STATE_LOCKS

The STATE_LOCKS table maintains the version state locks.


Field name Field type Description
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) ID of the state that is locked

NOT NULL
AUTOLOCK CHAR(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 CHAR(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
STATE_ID NUMBER(38) A unique ID for this state, assigned by ArcSDE

Primary key

NOT NULL
OWNER NVARCHAR2(32) The user who created this state

NOT NULL
CREATION_TIME DATE The date/time this state was created

NOT NULL
CLOSING_TIME DATE The date/time that this state was closed

PARENT_STATE_ID NUMBER(38) This state’s parent's STATE_ID

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
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
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
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 VARCHAR2(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.


Field name Field type Description
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 OFFSET

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 VARCHAR2(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
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, which includes

"S" for shared

"E" for 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
REGISTRATION_ID NUMBER(38) Unique identifier for the registration of the table

Primary key

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 text description of the table

OBJECT_FLAGS NUMBER(38) Stores the registration properties of the table, which include

  • The table has a registered row ID.
  • SDE 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 onlly I/O mode.
  • This is a history table.

NOT NULL
REGISTRATION_DATE NUMBER(38) The date the table was registered

NOT NULL
CONFIG_KEYWORD NVARCHAR2(32) Configuration keyword with which the table was created

MINIMUM_ID NUMBER(38) The minimum row_id value of the table

IMV_VIEW_NAME NVARCHAR2(32) The name of a multiversioned 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
MAJOR NUMBER(38) Number of the major release; for example, for ArcSDE 9.1, the major release number would be 9.

NOT NULL.
MINOR NUMBER(38) Number indicating the version of the major release; for example, for ArcSDE 9.1, the minor release number would be 1.

NOT NULL.
BUGFIX NUMBER(38) Number of the patch or service pack installed.

NOT NULL.
DESCRIPTION NVARCHAR2(96) 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.


Field name Field type Description
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 ID 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 ID 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 this version's parent version
PARENT_OWNER NVARCHAR2(32) The name of the owner of the parent version
PARENT_VERSION_ID NUMBER(38) The ID of the version which is the parent of this version
CREATION_TIME DATE The date/time that this version was created

NOT NULL