ArcGIS Server Banner

Schematic datasets in a geodatabse in DB2

Schematic datasets in a geodatabse in DB2
Release 9.3 E-mail This TopicPrintable VersionGive Us feedback
Note:This topic was updated for 9.3.1.

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 in a DB2 database management system (DBMS) in ArcCatalog:

Schematic dataset in ArcCatalog

Top of page

Schematic datasets in a DB2 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 INTEGER Unique identifier of the schematic dataset

NOT NULL
MAJOR INTEGER Release number of the dataset version; not used at this time

NOT NULL
MINOR INTEGER Minor release number of the dataset version; not used at this time

NOT NULL
BUGFIX INTEGER Patch or service pack number of the dataset version; not used at this time

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

NOT NULL
EXTCLSID VARCHAR(38) Not currently in use
SPATIALREF VARCHAR(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 INTEGER Release number of the system tables; not used at this time

NOT NULL
MINOR INTEGER Minor release number of the system tables; not used at this time

NOT NULL
BUGFIX INTEGER 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 INTEGER The unique identifier used when creating new diagram types for the object class

NOT NULL
DUMMY INTEGER 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 INTEGER Uniquely identifies the relationship between a diagram type and element type

NOT NULL
DIAGRAMCLASSID INTEGER Foreign key to the ID field in the SCH<ID>_DIACLASS table

NOT NULL
ELEMENTCLASSID INTEGER 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 INTEGER Uniquely identifies a data source

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

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

NOT NULL
LABEL VARCHAR(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 INTEGER Uniquely identifies a diagram type

NOT NULL
OBJECTCLASSID INTEGER Foreign key to the ID field in the SCH_UNIQUEID table

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

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

NOT NULL
PARENTID INTEGER ID of the parent diagram class entry

NOT NULL
DATASOURCEID INTEGER Foreign key to the ID field of SCH<ID>_DATASRC

BUILDERCLSID VARCHAR(38) Class ID for the schema builder (custom query, network dataset, or standard)

LINKERCLSID VARCHAR(38) Component managing feature to element relationship method

ALGORITHMCLSID VARCHAR(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 INTEGER Uniquely identifies an element type

NOT NULL
OBJECTCLASSID INTEGER Foreign key to ID in GDB_OBJECTCLASSES table

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

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

NOT NULL
PARENTID INTEGER ID of the parent element class entry

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

NOT NULL
RELATIOINCLSID VARCHAR(38) Relationship to a feature class

ASSOCIATEDDSID INTEGER Data source ID of related feature class

ASSOCIATEDOCID INTEGER ID of the related feature classes from the GDB_OBJECTCLASSES table

DATASOURCEID INTEGER 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 INTEGER Unique identifier for the folder

NOT NULL
NAME VARCHAR(255) Name of the folder

NOT NULL
PFID INTEGER 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 INTEGER Uniquely identifies the association between an element and a feature

NOT NULL
SCHEMATICID INTEGER Unique ID for an element

NOT NULL
DATASOURCEID INTEGER Foreign key to the ID field in the SCH<ID>_DATASRC table

UCID INTEGER Class ID of the related feature

UOID INTEGER Object ID of the related feature

USID INTEGER Subtype ID of the related feature

UEID INTEGER 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 INTEGER Uniquely identifies a diagram

NOT NULL
NAME VARCHAR(255) Name of the diagram

NOT NULL
FOLDERID INTEGER Foreign key to the SCH<ID>_FOLDER table

NOT NULL
DIAGRAMCLASSID INTEGER Foreign key to SCH<ID>_DIACLASS table's OBJECTCLASSID field

NOT NULL
LASTUPDATE TIMESTAMP Date and time of last user update

VERSION VARCHAR(255) If generated from versioned data, lists which version

CREATIONDATE TIMESTAMP Date and time diagram was created

CREATOR VARCHAR(100) Name of the user that created the diagram

UPDATEDBY VARCHAR(100) Name of the user that last updated the diagram

SPATIALREF VARCHAR(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 INTEGER Uniquely identifies an element

NOT NULL
DIAGRAMCLASSID INTEGER Foregn key to the SCH<ID>_DIACLASS table's OBJECTCLASSID field

NOT NULL
DIAGRAMOBBJECTID INTEGER Foreign key to the SCH<ID>D_<Diagram_Type_Name> table

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

NOT NULL
ISINITIAL INTEGER Indicates whether this element was part of the initial creation list

NOT NULL
ISDISPLAYED INTEGER Indicates whether this element is currently displayed

NOT NULL
RELATIONOBJECTID INTEGER Object ID of related feature in relationship

RELATIONCLASSID INTEGER Class ID of related feature in relationship

DATASOURCEID INTEGER Foreign key to SCH<ID>_DATASRC table

UCID INTEGER Class ID of corresponding feature

UOID INTEGER Object ID of corresponding feature

USID INTEGER Subtype ID of corresponding feature

UEID INTEGER Enabled value of corresponding feature

SUBTYPE INTEGER Subtype of feature

PROPERTYSET BLOB Holds attribute information

INITIALX DECIMAL(31) X positon of element when created

INITIALY DECIMAL(31) 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 INTEGER Uniquely identifies relationship rule

NOT NULL
ORDERNUMBER INTEGER Indicates in which order rules will be run

NOT NULL
ACTIVE INTEGER Indicates whether or not the rule is active

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

NOT NULL
PROPERTYSET BLOB Property page values

The following link will take you to a diagram of the tables involved in a schematic dataset:

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