Previous Topic: LIBRARY_USAGE (Library Usage)Next Topic: LNK_DATA_RTND (Link Dialog Flow Data Returned)


LINKAGE (Linkage Between Records)

Column Name

Coltype

Description

MODEL_ID

NUMERIC

ID of the containing model

TBNAME

STRING

LINKAGE

ID

NUMERIC

Unique identifier

ORG_ENCY_ID

NUMERIC

Original encyclopedia identifier

ORG_ID

NUMERIC

Original object identifier

NAME

STRING

Name of the Linkage

POINTER_TYPE

CHARACTER

Pointer type:

F-Foreign key

DB2_OR_IEF_ENF

CHARACTER

Enforced by:

  • D-DB2
  • I-System

REF_CONSTRT_OPT

CHARACTER

Referential constraint option for the relationship it implements:

  • D-Cascade delete
  • R-Restrict
  • N-Nullify

RECORD_FROM_ID

NUMERIC

ID of the record this linkage is from.

Join with RECORD.

RECORD_TO_ID

NUMERIC

ID of the record this linkage is to.

Join with RECORD.

IDENTIFIER_ID

NUMERIC

ID of the identifier that this linkage targets.

Join with IDENTIFIER.

IMPLEMENTATON_ID

NUMERIC

ID of the implementation this linkage is used in.

Join with REL_PART_IMPL.