Previous Topic: Permitted ValuesNext Topic: Identifiers


Relationships

The Relationship Definition names both the from and to entity types (or subtypes) and both the forward and backward relationship memberships. The combination of these four items must be unique but can be in any order.

The following table describes the content of each field type:

Field Name

Content

MODEL_NAME

Host Encyclopedia name of the model

RECORD_TYPE

O (Object Record)

OBJECT_TYPE

RELATIONSHIP

OBJECT_NAME

Relationship ID1

REF_OBJ_1

Name of from entity.

Ex: CUSTOMER

REF_OBJ_2

Name of entity

Ex: ORDER

REF_OBJ_3

Unused

NUM_PROP_12

Forward rel minimum number of occurrences

NUM_PROP_2

Forward rel maximum number of occurrences

NUM_PROP_3

Forward rel average number of occurrences

NUM_PROP_4

Forward rel percent optional

NUM_PROP_5

Backward rel minimum number of occurrences

NUM_PROP_6

Backward rel maximum number of occurrences

NUM_PROP_7

Backward rel average number of occurrences

NUM_PROP_8

Backward rel percent optional

CHAR_PROP_12

Forward rel transferable:

Y (Yes)

N (No)

CHAR_PROP_2

Forward rel optionality:

M (Always)

O (Sometimes)

CHAR_PROP_3

Forward rel cardinality:

1 (One)

M (Many)

CHAR_PROP_4

Abs or est flag for min occurrences:

A (Abs)

E (Est)

CHAR_PROP_5

Backward rel transferable:

Y (Yes)

N (No)

CHAR_PROP_6

Backward rel optionality:

M (Always)

O (Sometimes)

CHAR_PROP_7

Backward rel cardinality:

1 (One)

M (Many)

CHAR_PROP_8

Abs or est flag for max occurrences:

A (Abs)

E (Est)

NAME_1

Name of forward relationship.

Ex: PLACES

NAME_2

Name of backward relationship:

Ex: PLACED BY

You must include the relationship ID if the relationship: