RTblRelColDefs SQL Table
RTblRelColDefs stores one row for each collection type defined in the repository database.
| Column name | Data type | Description |
|---|---|---|
| IntID | RTIntID | The internal identifier for the collection definition 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. |
| RelTypeID | RTIntID | Internal identifier of the relationship definition object. |
| Flags | RTFlags | Flags that determine the behavior of collections that conform to this collection type. |
| MinCount | RTCount | The minimum number of repository items that can occur in a collection of this type. This field can be NULL. This property is not enforced by the repository engine. |
| MaxCount | RTCount | The maximum number of repository items that can occur in a collection of this type. This field can be NULL. This property is not enforced by the repository engine. |
| IsOrigin | RTBoolean | Determines whether collections that conform to this collection type are origin collections (True), or destination collections (False). |
Remarks
The RTblRelColDefs associates relationship objects with a collection type. Collection types are distinguished by the CollectionDefFlag value. Flag values determine collection characteristics, while IsOrigin determines the collection type.
Each relationship in a repository is associated with two relationship collections: an origin collection and a destination collection. Each relationship collection conforms to a collection type. The collection type defines the role that the collection plays in the relationship.
The primary key for this table is formed from the IntID and PropID columns. A nonunique index is defined on concatenated values of the PropID and PropValue columns.
Z_BranchID_Z, Z_VS_Z, and Z_VE_Z are included to provide future support for versioning repository API definitions in case more than one version of this repository API structure is created.