RTblRelships SQL Table

See Also

This SQL table describes the relationships stored in the Repository. The primary key for this table includes these columns: OrgID, RelTypeID, Z_OrgBrID_Z, Z_OrgVS_Z, DstID, Z_DstBrID_Z, Z_DstVS_Z, and Z_RelFlags_Z.

Column Name

Data Type

Description

OrgID	RTIntID	The internal identifier for the origin object of the relationship.
Z_OrgBrID_Z	RTBrID	Indicates the branch of the version graph containing the origin object version.
Z_OrgVS_Z	RTVerID	Indicates the lower bound of the range of origin object versions having version-to-version relationships described by this row.
Z_OrgVE_Z	RTVerID	Indicates the upper bound of the range of origin object versions having version-to-version relationships described by this row. Can be a special value indicating that the range is unbounded.
Z_OrgLClock_Z	RTLClock	For internal use only.
DstID	RTIntID	The internal identifier for the destination object of the relationship.
Z_DstBrID_Z	RTBrID	For Relationship rows, indicates the branch of the version graph containing the destination object version. For Auxiliary rows, can indicate the branch containing the pinned object version of an origin versioned relationship.
Z_DstVS_Z	RTVerID	For Relationship rows, indicates the lower bound of the range of destination object versions having version-to-version relationships described by this row. For Auxiliary rows, can indicate the pinned object version of an origin versioned relationship.
Z_DstVE_Z	RTVerID	Indicates the upper bound of the range of destination object versions having version-to-version relationships described by this row.
Z_DstLClock_Z	RTLClock	For internal use only.
OrgTypeID	RTIntID	The internal identifier for the class to which the origin object conforms. Redundantly stored in this table for performance reasons.
RelTypeID	RTIntID	The internal identifier for the relationship type.
DstTypeID	RTIntID	The internal identifier for the class to which the destination object conforms. Redundantly stored in this table for performance reasons.
PrevDstID	RTIntID	For each auxiliary row describing an item in a sequenced relationship collection, this column contains the internal identifier of the previous relationship in the collection sequence. For other auxiliary rows and for relationship rows, this column is null.
DstName	RTNameString	The name of the destination object. More precisely, the name (as defined by this naming relationship) by which each origin version (in the range of origin versions) refers to each destination version (in the range of destination versions). If the relationship is not a naming relationship, then this field is null.
DstNameLong	RTLongString	If the name of the destination object is longer than what can be fit into the DstName field, then this field contains the full name. Otherwise, this field is null.
Z_RelFlags_Z	RTFlags	A value of 2 indicates that the row is a Relationship row; 1 indicates it is an Auxiliary row.

Remarks

There are two kinds of row in this table: Relationship rows and Auxiliary rows.

Each Relationship row describes one or more Version-to-Version relationships:

In the simplest case, a Relationship row describes exactly one version-to-version relationship. (See Example 1.)
In the ideal case, a Relationship row describes as large a range as possible. (See Example 2.)
A Relationship row can describe an unbounded range. (See Example 3.)
In some situations, several Relationship rows exist when one would theoretically suffice. (See Example 4.)

Each Auxiliary row contains pinning and sequencing information for an origin versioned relationship:

An Auxiliary row can contain sequencing information. (See Example 5.)
An Auxiliary row can contain pinning information. (See Example 6.)
An Auxiliary row can contain both pinning and sequencing information. (See Example 7.)

Not every origin versioned relationship has a corresponding auxiliary row. If the origin versioned relationship is not part of a sequencing collection and does not have any member of its TargetVersions collection pinned, it does not have an auxiliary row.