UFM Step 4: Create Relationships

Create the following relationships. If you are using the sample data, these may already exist. UFM also requires the Conduit_Conductor relationship. This should have been created in the basic configuration for Conduit Manager.

ConduitSystem_DuctBank

  • Origin Table: ConduitSystem

  • Destination Table: DuctBank

  • Relationship Type: Simple

  • Notification: None

  • Cardinality: One to Many

  • Attributes: none

  • Primary Key: ObjectID

  • ConduitSystem Foreign Key: RelConduitSystemObjectId

PriUGElectricLineSegment_Duct

  • Origin Table: PriUGElectricLineSegment

  • Destination Table: Duct

  • Relationship Type: Simple

  • Notification: None

  • Cardinality: Many to Many (M - N)

  • Attributes: PhaseDesignation (long integer)

  • Conductor Primary Key: ObjectID

  • Conductor Foreign Key: PrimaryConductorOID

  • Duct Primary Key: ObjectID

  • Duct Foreign Key: DuctOID

SecUGElectricLineSegment_Duct

  • Origin Table: SecUGElectricLineSegment

  • Destination Table: Duct

  • Relationship Type: Simple

  • Notification: None

  • Cardinality: Many to Many (M - N)

  • Attributes: PhaseDesignation (long integer)

  • Conductor Primary Key: ObjectID

  • Conductor Foreign Key: SecondaryUGOID

  • Duct Primary Key: ObjectID

  • Duct Foreign Key: DuctOID

QR code for this page

Was this helpful?