Meta Data Services Programming
RTblWorkspaceItems SQL Table
RTblWorkspaceItems stores information about which repository object versions are included within a workspace.
| Column name | Data type | Description |
|---|---|---|
| IntID | RTIntID | The internal identifier for the workspace object. |
| Z_BranchID_Z | RTBrID | The branch identifier for repository API versioning. It is reserved for proprietary use by the repository engine. The value of this column is always zero. |
| Z_VS_Z | RTVerID | An identifier for repository API versioning. It is reserved for proprietary use by the repository engine. The value of this column is always zero. |
| Z_VE_Z | RTVerID | An identifier for repository API versioning. It is reserved for proprietary use by the repository engine. The value of this column is always VERINFINITY. |
| Z_ItemIntID_Z | RTIntID | The internal identifier of the object version present in the workspace. |
| Z_ItemBranchID_Z | RTBrID | The branch identifier of the object version present in the workspace. |
| Z_ItemVS_Z | RTVerID | The version-within-branch identifier of the object version present in the workspace. |
| Z_ItemFlag_Z | RTFlags | A set of flags indicating whether the object version is checked out to the workspace. A value of 0 indicates that the object version is not checked out. A value of 2 indicates that the object version is checked out. |
Remarks
The RTblWorkspaceItems table tracks which object version is part of a workspace. A workspace can have only a single version of any given object.
The primary key is formed from the IntID, Z_BranchID_Z, Z_VS_Z, Z_ItemIntID_Z, Z_ItemBranchID_Z, and Z_ItemVS_Z columns.