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
