1

MODEL_ID

4

INTEGER

ID of the containing model

2

TBNAME

16

CHAR

LINKAGE

3

ID

4

INTEGER

Unique Identifier

4

ORG_ID

4

INTEGER

Original object identifier

5

NAME

32

VARCHAR

Name of the linkage.

6

POINTER_TYPE

1

CHAR

Pointer type: F (Foreign key)

7

DB2_OR_IEF_ENF

1

CHAR

Enforced by:

• D (DB2)
• I (System)

8

REF_CONSTRT_
OPT

1

CHAR

Referential constraint option for the relationship it implements:

• D (Cascade delete)
• R (Restrict)
• N (Nullify)

9

RECORD_FROM_
ID

4

INTEGER

ID of the record this linkage is from. Join with RECORD.

10

RECORD_TO_ID

4

INTEGER

ID of the record this linkage is to. Join with RECORD.

11

IDENTIFIER_ID

4

INTEGER

ID of the identifier that this linkage targets

12

IMPLEMENTATON_ID

4

INTEGER

ID of the implementation where this linkage is used.

Join with REL_PART_IMPL.