Previous Topic: RECORD_REFERENCE (Record Reference)Next Topic: REL_MUTL_EXCL (Mutually Exclusive Relationship)


REL_IDENT (Relationship Identifier)

Column Name

Coltype

Description

MODEL_ID

NUMERIC

ID of the containing model

TBNAME

STRING

REL_IDENT

ID

NUMERIC

Identifier (not unique)

ORG_ENCY_ID

NUMERIC

Original encyclopedia identifier

ORG_ID

NUMERIC

Original object identifier

SEQ

NUMERIC

Sequence within entity type or subtype.

Use ORDER BY SEQ to return relationship identifiers in the same order as specified in the toolset.

NAME

STRING

Name of identifier

PRIMARY_KEY

CHARACTER

Primary identifier for entity type?

  • Y-Yes
  • N-No

ENTITY_ID

NUMERIC

ID of the entity type or subtype for which this relationship is an identifier.

Join with ENTITY_TYPE or ENTITY_SUBTYP.

RELATIONSHIP_ID

NUMERIC

ID of the relationship.

Join with RELATIONSHIP.