Public Interface Export Function › Internal Design Objects › Access and Connection Objects › LINKAGE (Linkage Between Records)

LINKAGE (Linkage Between Records)

The Linkage table represents all linkages and directed connections between two tables (RECORDs), not necessarily distinct.

It records the type of the linkage (Pointer_Type = F for foreign key), the record that the linkage comes from (Record_From_ID), the record that the linkage points to (Record_To_ID), and the identifier (Identifier_ID) of the to record being used to choose the foreign key fields. The referential constraint option (REF_CONSTRT_OPT) represents the referential integrity option for the relationship that the linkage implements. The reason for the linkage is indicated using the Implementation_ID (a relationship or partitioning implementation). A linkage is used in the implementation of a relationship or partitioning.