RTblRelships Example Six

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:

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  =  6
Z_DstVE_Z  =  6
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

(c) 1988-1998 Microsoft Corporation. All Rights Reserved.