System tables of a geodatabase stored in Oracle

System tables of a geodatabase stored in Oracle
Release 9.3

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.

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

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

Field name

Field type

Description

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

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

Field name

Field type

Description

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

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

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.

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

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

Please visit the Feedback page to comment or give suggestions on ArcGIS Server Help.
Copyright © Environmental Systems Research Institute, Inc.