ArcGIS Server Banner

Schematic datasets in a geodatabase in Informix

Schematic datasets in a geodatabase in Informix
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 Informix 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 Int Unique identifier of the schematic dataset

Not null
major Int Release number of the dataset version; not used at this time

Not null
minor Int Minor release number of the dataset version; not used at this time

Not null
bugfix Int 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 Int Release number of the system tables; not used at this time

Not null
minor Int Minor release number of the system tables; not used at this time

Not null
bugfix Int 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 Int The unique identifier used when creating new diagram types for the object class

Not null
dummy Int 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 Int Uniquely identifies the relationship between a diagram type and element type

Not null
diagramclassid Int Foreign key to the id field in the sch<id>_diaclass table

Not null
elementclassid Int 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 Int 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 Int Uniquely identifies a diagram type

Not null
objectclassid Int 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 Int Id of the parent diagram class entry

Not null
datasourceid Int 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 Int Uniquely identifies an element type

Not null
objectclassid Int 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 Int Id of the parent element class entry
elementtype Int Value specifying the type of element (node, link, etc.)
relationclsid Varchar(38) Relationship to a feature class

associateddsid Int Data source id of related feature class

associatedocid Int Id of the related feature classes from the gdb_objectclasses table

datasourceid Int 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 Int Unique identifier for the folder

Not null
name Varchar(255) Name of the folder

Not null
pfid Int 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 Int Uniquely identifies the association between an element and a feature

Not null
schematicid Int Unique id for an element

Not null
datasourceid Int Foreign key to the id field in the sch<id>_datasrc table

ucid Int Class id of the related feature

uoid Int Object id of the related feature

usid Int Subtype id of the related feature

ueid Int 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 Int Uniquely identifies a diagram

Not null
name Varchar(255) Name of the diagram
folderid Int Foreign key to the sch<id>_folder table

Not null
diagramclassid Int Foreign key to sch<id>_diaclass table's objectclassid field

Not null
lastupdate Datetime Date and time of last user update

Not null
version Varchar(255) If generated from versioned data, lists which version

creationdate Datetime 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 Char(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 Int Uniquely identifies an element

Not null
diagramclassid Int Foregn key to the sch<id>_diaclass table's objectclass id field

Not null
diagramobjectid Int 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 Int Indicates whether this element was part of the initial creation list

Not null
isdisplayed Int Indicates whether this element is currently displayed

Not null
relationobjectid Int Object id of related feature in relationship

relationclassid Int Class id of related feature in relationship

datasourceid Int Foreign key to sch<id>_datasrc table

ucid Int Class id of corresponding feature

uoid Int Object id of corresponding feature

usid Int Subtype id of corresponding feature

ueid Int Enabled value of corresponding feature

subtype Int Subtype of feature

propertyset Blob Holds attribute information

initialx Decimal(32,20) X positon of element when created

initialy Decimal(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 Int Uniquely identifies relationship rule

Not null
ordernumber Int Indicates in which order rules will be run

Not null
active Int 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

Click the following link to see an example of schematic dataset system tables showing implicit links. Implicit links are denoted with the dashed lines.

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