ArcGIS Server Banner

Schematic datasets in a geodatabase in Oracle

Schematic datasets in a geodatabase in Oracle
Release 9.3 E-mail This TopicPrintable VersionGive Us feedback

NOTE: Requires Schematics extension

Schematic datasets are similar to feature datasets but they contain a collection of schematic diagram classes and schematic element classes (which are the schematic equivalent of feature classes). They are used to graphically visualize and manipulate network data.

A schematic dataset is always associated with a schematic project. When you create a schematic dataset in ArcCatalog, an associated schematic project is automatically created. A schematic project contains the graphic parameters and display rules for the schematic diagrams generated and stored in the schematic dataset.

Schematic datasets in ArcCatalog

The following is an example of a schematic dataset, schematic folders, and the schematic diagrams they contain in ArcCatalog:

Schematic dataset in ArcCatalog

Top of page

Schematic datasets in an Oracle DBMS

The following tables are used to store information on schematic datasets.

SCH_DATASET

Contains one record for each schematic dataset. The ID field in this table is used to identify the assosiated element and diagram tables.


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

NOT NULL
MAJOR NUMBER(38) Release number of the dataset version; not used at this time

NOT NULL
MINOR NUMBER(38) Minor release number of the dataset version; not used at this time

NOT NULL
BUGFIX NUMBER(38) Patch or service pack number of the dataset version; not used at this time

NOT NULL
DBNAME NVARCHAR2(32) Name of the database in which the schematic dataset is stored
OWNER NVARCHAR2(32) The user who created the schematic dataset
NAME NVARCHAR2(128) The name of the schematic dataset

NOT NULL
EXTCLSID NVARCHAR2(38) Not currently in use
SPATIALREF NVARCHAR2(1024) Default spatial reference used when creating new diagrams
BLOBS BLOB Stores the default parameters for the dataset, such as the default node symbol, text separator, and character

SCH_RELEASE

The SCH_RELEASE table is not currently in use.


Field name Field type Description
MAJOR NUMBER(38) Release number of the system tables; not used at this time

NOT NULL
MINOR NUMBER(38) Minor release number of the system tables; not used at this time

NOT NULL
BUGFIX NUMBER(38) Patch or service pack number of the system tables; not used at this time

NOT NULL

SCH_UNIQUEID

The SCH_UNIQUEID table stores the unique identifier of a diagram type.


Field name Field type Description
ID NUMBER(38) The unique identifier used when creating new diagram types for the object class

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

SCH<ID>_CLSENTRY

Stores the associations between the diagram types and the element types in a schematic dataset


Field name Field type Description
ID NUMBER(38) Uniquely identifies the relationship between a diagram type and element type

NOT NULL
DIAGRAMCLASSID NUMBER(38) Foreign key to the ID field in the SCH<ID>_DIACLASS table

NOT NULL
ELEMENTCLASSID NUMBER(38) Foreign key to the ID field in the SCH<ID>_ELTCLASS table

NOT NULL

SCH<ID>_DATASRC

Contains a list of all the data sources accessed by the schematic dataset


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

NOT NULL
NAME NVARCHAR2(255) Name of the data source

NOT NULL
CLSID NVARCHAR2(38) Class ID of the data source component

NOT NULL
LABEL NVARCHAR2(255) Not currently in use
CONNECTION BLOB Parameters of the connection; used to persist and restore the connection

NOT NULL

SCH<ID>_DIACLASS

Tracks all the diagram types present in a schematic dataset


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

NOT NULL
OBJECTCLASSID NUMBER(38) Foreign key to the ID field in the SCH_UNIQUEID table

NOT NULL
CREATIONNAME NVARCHAR2(255) Name of the diagram class when the table is created

NOT NULL
NAME NVARCHAR2(255) Current name of the diagram class (if it was changed from the original name)

NOT NULL
PARENTID NUMBER(38) ID of the parent diagram class entry

NOT NULL
DATASOURCEID NUMBER(38) Foreign key to the ID field of SCH<ID>_DATASRC
BUILDERCLSID NVARCHAR2(38) Class ID for the schema builder (custom query, network dataset, or standard)
LINKERCLSID NVARCHAR2(38) Component managing feature to element relationship method
ALGORITHMCLSID NVARCHAR2(38) Class ID of the algorithm that is automatically applied to diagrams of this type
BLOBS BLOB Stores all the attribute and symbology information

SCH<ID>_ELTCLASS

Maintains a list of all the element types for each dataset


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

NOT NULL
OBJECTCLASSID NUMBER(38) Foreign key to ID in GDB_ObjectClasses table

NOT NULL
CREATIONNAME NVARCHAR2(255) Name of the element class when the table is created

NOT NULL
NAME NVARCHAR2(255) Current name of the element class (if it changed)

NOT NULL
PARENTID NUMBER(38) ID of the parent element class entry

NOT NULL
ELEMENTTYPE NUMBER(38) Value specifying the type of element (node, link, etc.)

NOT NULL
RELATIOINCLSID NVARCHAR2(38) Relationship to a feature class
ASSOCIATEDDSID NUMBER(38) Data source ID of related feature class
ASSOCIATEDOCID NUMBER(38) ID of the related feature classes from the GDB_ObjectClasses table
DATASOURCEID NUMBER(38) Foreign key to the ID field in the SCH<ID>_DATASRC table
BLOBS BLOB Stores attribute and symbology

SCH<ID>_FOLDER

Maintains a list of all the folders created in a dataset


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

NOT NULL
NAME NVARCHAR2(255) Name of the folder

NOT NULL
PFID NUMBER(38) ID of the parent folder if nested

NOT NULL
XML BLOB Stores the metadata of the folder

SCH<ID>A_<ELEMENT_TYPE_NAME>

Tracks the associations between an element and a feature


Field name Field type Description
ID NUMBER(38) Uniquely identifies the association between an element and a feature

NOT NULL
SCHEMATICID NUMBER(38) Unique ID for an element

NOT NULL
DATASOURCEID NUMBER(38) Foreign key to the ID field in the SCH<ID>_DATASRC table
UCID NUMBER(38) Class ID of the related feature
UOID NUMBER(38) Object ID of the related feature
USID NUMBER(38) Subtype ID of the related feature
UEID NUMBER(38) Enabled ID of the related feature

SCH<ID>D_<DIAGRAM_TYPE_NAME>

Stores a list of all diagrams created using a particular diagram type (the one indicated by the <DIAGRAM_TYPE_NAME>)


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

NOT NULL
NAME NVARCHAR2(255) Name of the diagram

NOT NULL
FOLDERID NUMBER(38) Foreign key to the SCH<ID>_FOLDER table

NOT NULL
DIAGRAMCLASSID NUMBER(38) Foreign key to SCH<ID>_DIACLASS table's OBJECTCLASSID field

NOT NULL
LASTUPDATE DATE Date and time of last user update
VERSION NVARCHAR2(255) If generated from versioned data, lists which version
CREATIONDATE DATE Date and time diagram was created
CREATOR NVARCHAR2(100) Name of the user that created the diagram
UPDATEDBY NVARCHAR2(100) Name of the user that last updated the diagram
SPATIALREF NVARCHAR2(1024) Spatial coordinates
BLOBS BLOB Stores the current positioning of all elements in the diagram

SCH<ID>E_<ELEMENT_TYPE_NAME>

Stores a list of all the elements created using an element type

Element types define the attributes and symbology of an element.


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

NOT NULL
DIAGRAMCLASSID NUMBER(38) Foregn key to the SCH<ID>_DIACLASS table's OBJECTCLASSID field

NOT NULL
DIAGRAMOBBJECTID NUMBER(38) Foreign key to the SCH<ID>D_<Diagram_Type_Name> table

NOT NULL
SCHEMATICID NVARCHAR2(128) Uniquely identifies an element; consists of DIAGRAMOBJECTID, DIAGRAMCLASSID, DATASOURCEID, UCID, UOID, and USID

NOT NULL
ISINITIAL NUMBER(38) Indicates whether this element was part of the initial creation list

NOT NULL
ISDISPLAYED NUMBER(38) Indicates whether this element is currently displayed

NOT NULL
RELATIONOBJECTID NUMBER(38) Object ID of related feature in relationship
RELATIONCLASSID NUMBER(38) Class ID of related feature in relationship
DATASOURCEID NUMBER(38) Foreign key to SCH<ID>_DATASRC table
UCID NUMBER(38) Class ID of corresponding feature
UOID NUMBER(38) Object ID of corresponding feature
USID NUMBER(38) Subtype ID of corresponding feature
UEID NUMBER Enabled value of corresponding feature
SUBTYPE NUMBER(38) Subtype of feature
PROPERTYSET BLOB Holds attribute information
INITIALX NUMBER(32,20) X positon of element when created
INITIALY NUMBER(32,20) Y position of element when created

SCH<ID>R_<DIAGRAM_TYPE_NAME>

Stores a list of all the relationship rules for a diagram type


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

NOT NULL
ORDERNUMBER NUMBER(38) Indicates in which order rules will be run

NOT NULL
ACTIVE NUMBER(38) Indicates whether or not the rule is active

NOT NULL
CLSID NVARCHAR2(38) Class ID of the rule

NOT NULL
PROPERTYSET BLOB Property page values

Click the following link to see an example of schematic dataset system tables in the Oracle database showing implicit links:

Oracle schematic dataset diagram

Schematic datasets in XML

Exporting schematic datasets to XML is not presently supported.

Top of page

See Also

  • Feature datasets in a geodatabase stored in Oracle