RTblVersions SQL Table
RTblVersions stores version information about repository objects.
| Column name | Data type | Description |
|---|---|---|
| IntID | RTIntID | The internal identifier for the object. |
| Z_BranchID_Z | RTBrID | A branch identifier. It indicates the branch of the version graph that contains this object version. |
| Z_VS_Z | RTVerID | A version-within-branch identifier. It 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 and whether it is checked out. 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. A value of 1 indicates that this is a version row. A value of 2 indicates that this is a merge row. |
| Z_SuccInc_Z | RTSuccInc | For internal use only. |
| Z_LClock_Z | RTLClock | For internal use only. |
Remarks
The RTblVersions table stores two row types: version rows and merge rows. Each row is either one type or the other. Version rows describe an object version. Merge rows indicate 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 multiple version rows to store information about each version. For each object, there is exactly one version row that describes the initial version of the object. Within the initial version row, the values of Z_PredBrID_Z and Z_PredVer_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.
The primary key is formed from the IntID, Z_BranchID_Z, Z_VS_Z, Z_PredBrID_Z, and Z_PredVer_Z columns.
See Also
RTblVersionAdminInfo SQL Table