Create Relationship Classes

The following relationship classes must be created in your geodatabase as part of Conduit Manager's minimum configuration requirements.

Conduit_CrossSectionAnnotation

Origin table

Conduit feature class

Destination table:

Cross Section Annotation feature class

Relationship type:

Composite (when conduit is deleted, associated annotation is deleted)

Notification:

None (no generated messages)

Cardinality:

One to Many

Primary Key:

ObjectID of the Conduit

Foreign Key:

FeatureID

Conduit_Cable

Create a relationship between each conductor (or cable) class and the conduit feature class. For example, Conduit_PriUGElectricLineSegment, Conduit_SecUGElectricLineSegment, and Conduit_FiberCable.

Origin table:

Conduit feature class

Destination table:

Conductor (Cable) feature class

Relationship type:

Simple

Cardinality:

Many to Many

Attributed Relationship

Add fields:

ULS_Position (long integer), PhaseDesignation (long integer)

Origin (Conduit) Primary Key:

ObjectID

Destination (Conductor or Cable) Primary Key:

ObjectID

Conduit Foreign Key:

ULSObjectID

Cable (e.g. Conductor or Fiber Cable) Foreign Key:

UGObjectID

IMPORTANT: Currently the ULS_Position and PhaseDesignation fields must be named exactly as shown here. Model Name support is not available for attributed relationships. The Conduit Foreign Key and Conductor (Cable) Foreign Key fields must also be entered exactly as show above. Failure to enter this as documented will result in errors.

Conduit_UGStructure

Create a relationship between each underground structure feature class and the conduit feature class.

Origin table:

Conduit feature class

Destination table:

Underground Structure feature class

Relationship type:

Simple

Notification:

None (no generated messages)

Cardinality:

Many to Many

Primary Key:

ObjectID of Conduit

Foreign Key:

ObjectID of UG Structure

QR code for this page

Was this helpful?