RTblRelships Example Six
This example shows pinning information.
If an origin versioned relationship has a pinned target version, the RTblVersions table includes an auxiliary row to indicate which target version is pinned. For example, the following figure shows an origin versioned relationship with a pinned target version.
To accommodate this origin versioned relationship, RTblVersions includes four rows with the following values, where the four rows correspond to the four arrows (counting the double arrow as two):
OrgID = 008
Z_OrgBrID_Z = 2
Z_OrgVS_Z = 3
Z_OrgVE_Z = 3
DstID = 984
Z_DstBrID_Z = 0
Z_DstVS_Z = 4
Z_DstVE_Z = 4
RelTypeID = 522
Z_RelFlags_Z = 2
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 = 5
RelTypeID = 522
Z_RelFlags_Z = 2
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
Z_RelFlags_Z = 1
OrgID = 008
Z_OrgBrID_Z = 2
Z_OrgVS_Z = 3
Z_OrgVE_Z = 3
DstID = 984
Z_DstBrID_Z = 0
Z_DstVS_Z = 6
Z_DstVE_Z = 6
RelTypeID = 522
Z_RelFlags_Z = 2