RTblVersions SQL Table

See Also

This SQL table describes Repository object versions. The IntID, Z_BranchID_Z, Z_VS_Z, Z_PredBrID_Z, and Z_PredVer_Z columns form the primary key for this table.

Column Name Data Type Description

IntID RTIntID The internal identifier for the object.
Z_BranchID_Z RTBrID A branch identifier. Indicates the branch of the Version Graph containing this object version.
Z_VS_Z RTVerID A version-within-branch identifier. Differentiates the version described by this row from other versions on the same branch.
Z_PredBr_Z RTBrID A branch identifier. For a Version Row, this column indicates the branch containing the predecessor creation version of the current object version. For a Merge Row, this column indicates the branch containing the object version that was the predecessor of the merge operation.
Z_PredVer_Z RTVerID A version-within-branch identifier. For a Version Row, this column indicates the predecessor creation version of the current object version. For a Merge Row, this column indicates the object version that was the predecessor of the merge operation.
TypeID RTIntID The internal identifier of the class to which the version conforms.
VerIntID RTIntID The internal identifier of this version.
Z_VState_Z RTFlags Indicates whether the object version is frozen or not and whether it is checked out or not. The object version is frozen only if the last (least significant) bit is set. the object version is checked out only if the second-last bit is set.
Z_PredFlags_Z RTFlags Indicates whether this row is a Version row or a Merge row. 1 = Version row; 2 = Merge row.
Z_SuccInc_Z RTSuccInc For internal use only.
Z_LClock_Z RTLClock For internal use only.

Remarks

Each row of this table is either a Version Row or a Merge Row. Each Version row describes an object version. Each Merge row indicates that one or more merge operations occurred between the same pair or object versions.

Because a Repository object can have many versions, it can have many Version rows. But each object has exactly one version row that describes the first version of the object. Within that Version row, the values of Z_PredBrID_Z and ZPredVer__Z are special constants indicating that the first version has no predecessor.

Because an object version can have zero, one, or many non-creation predecessors, each object version can have zero, one, or many Merge rows.