MODEL_ID

NUMERIC

ID of the containing model

TBNAME

STRING

RELATIONSHIP

ID

NUMERIC

Unique identifier

ORG_ENCY_ID

NUMERIC

Original encyclopedia identifier

ORG_ID

NUMERIC

Original object identifier

NAME

STRING

Relationship name

TRANSFERABLE

CHARACTER

Transferable?

• Y-Yes
• N-No

OPT

CHARACTER

Optionality:

• M-Always
• O-Sometimes

OPT_EXPECTED_PCT

NUMERIC

Expected optionality (percent)

CARD

CHARACTER

Cardinality:

• 1-One
• M-One or many

MIN_CARD

NUMERIC

Cardinality, at least

MAX_CARD

NUMERIC

Cardinality, at most

AVG_CARD

NUMERIC

Cardinality, on average

CARD_MIN_ABS_EST

CHARACTER

Absolute or estimated minimum cardinality:

• E-Estimated
• A-Absolute

CARD_MAX_ABS_EST

CHARACTER

Absolute or estimated maximum cardinality:

• E-Estimated
• A-Absolute

CASCADE_OPTION

CHARACTER

Cascade option (Deletion Rule) for second entity type:

• D-Cascade delete
• R-Restrict (disallow)
• N-Nullify (disassociate)
• C-Deletion rule not set

MOD_OR_REF

CHARACTER

Associate option:

• M-Modifying
• R-Referencing

DISPLAY_NAME

CHARACTER

Display relationship name?

• Y-Yes
• N-No

TYPE

CHAR

Type of relationship:

• B-Persistent
• D-Transient

ENCAP_LEVEL

CHAR

Level of encapsulation:

• space-Public
• P-Protected
• E-Encapsulation

SOURCE_ENTITY_ID

NUMERIC

ID of the entity type or subtype from which this relationship comes.

Join with ENTITY_TYPE or ENTITY_SUBTYP.