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