User Defined Relationship Dialog

List of all the possible target object types for the network that the object selected in the Objects grid of the User Defined Objects dialog is associated with.

The list may contain user-defined object types as well as built-in, predefined, object types.

Target objects

Use the and the buttons to select the desired target object types.

The name of the relationship.

Name must start with a letter and cannot contain spaces, characters or uppercase text.

The naming convention is to use the target object(s) first, followed by the source object (e.g. targetobjecttype_sourceobjecttype).

The relationship in the screenshot above is being specified between a user defined survey type (source) defined for Asset networks (see ams__survey in dialog titlebar) and two user-defined object types (targets).

Relationship description.

Naming convention is of the type target - source.

Tip

This field appears in the Object Browser Window and helps identify the relationship.

Purpose of the relationship:

• Association
• Component
• Connection

See Object Relationships for more information.

Field in the source object that the relationship will be based on.

This field usually contains the id of the target type, or the US node ID (for Collection Pipe relationships only).

This dropdown list will contain all the text fields with a minimum of 16 characters that are available for the source object type.

Select a field or type in your own field name.

Enabled for Collection Pipes (cams_pipe) targets only.

Field in the source object that the relationship will be based on. This field usually contains the DS node ID.

This dropdown list will contain all the text fields with a minimum of 16 characters that are available for the source object type.

Select a field or type in your own field name.

Enabled for relationships with more than one target object type, such as Asset and Collection Pipe relationships.

Field in the source object that the relationship will be based on. This field usually contains the asset type of the target type (for asset relationship types) and the link suffix for Collection Pipe relationships.

This dropdown list will contain all the text fields with a minimum of 16 characters that are available for the source object type.

Select a field or type in your own field name.

SQL name for the relationship under the form of an SQL prefix identifying the target(s) (source -> target).

This is useful when querying tables using SQL.

Prefix must start with a letter and cannot contain spaces, characters or uppecase text.

SQL name for the relationship under the form of an SQL prefix identifying the source (target -> source).

This is useful when querying tables using SQL.

Prefix must start with a letter and cannot contain spaces, characters or uppercase text.

Use this button to automatically generate fields for the relationship.

Users can use these suggestions or type their own.

The table below shows the default suggestions.

Let us imagine we are creating a relationship between a user defined survey type called MySurvey (source) which is valid for Asset networks, and two user defined objects, a link object type called MyLink and a node object type called MyNode (target).

The rightmost column of the table contains the suggestions for a worked example.

The minimum number of user defined objects that can be associated with this relationship.

When deleting an object (using the context menu in the Object Browser Window), an error message will be generated if the deletion would cause the number of user defined objects, associated with this relationship, to fall below the specified minimum.

This field is set to 0 for all predefined object relationships.