RTblRelships Example Seven
This example shows a combination of sequencing and pinning information.
An auxiliary row can include both sequencing and pinning information. For example, if a sequenced origin collection includes an origin versioned relationship with a pinned target version, the RTblVersions table includes an auxiliary row that indicates which target version is pinned and which item in the sequenced origin collection precedes the current one. For example, the following figure shows a sequences origin collection, one of whose items has a pinned target version.
To accommodate this relationship collection, RTblVersions includes:
- Five relationship rows, one for each version-to-version relationship
- Two auxiliary rows, one for each origin versioned relationship.
The auxiliary rows have the following values:
OrgID = 008
Z_OrgBrID_Z = 2
Z_OrgVS_Z = 3
Z_OrgVE_Z = 3
DstID = 984
Z_DstBrID_Z = 0
Z_DstVS_Z = 5
Z_DstVE_Z = NULL
RelTypeID = 522
PrevDstID = SEQUENCE_END
Z_RelFlags_Z = 1
OrgID = 008
Z_OrgBrID_Z = 2
Z_OrgVS_Z = 3
Z_OrgVE_Z = 3
DstID = 777
Z_DstBrID_Z = NULLBRANCH
Z_DstVS_Z = NULLVERSION
Z_DstVE_Z = NULL
RelTypeID = 522
PrevDstID = 984
Z_RelFlags_Z = 1