An annotational property is a property that is associated with an individual Repository object or relationship, and is not required to exist for all Repository objects or relationships of a particular type. This SQL table contains one row for each annotational property instance that is attached to a relationship. The OrgID, RelTypeID, DstID, and PropID columns compose the primary key for this table. A single non-unique index is defined on the concatenation of the PropID and PropValue columns.
Column Name | Data Type | Description |
OrgID | RTIntID | The internal identifier for the origin object of the relationship. |
RelTypeID | RTIntID | The internal identifier for the relationship type. |
DstID | RTIntID | The internal identifier for the destination object of the relationship. |
PropID | RTIntID | The internal identifier for the inverted property definition object to which this annotational property instance conforms. |
PropValue | RTShortString | The value of the annotational property instance. |
Remarks
Remember, when you set an annotational property on a relationship, the property applies to every version-to-version relationship of that type between any version of the origin object and any version of the destination object. That’s why this table does not include columns such as Z_OrgBrID_Z, Z_OrgVS_Z, Z_DstBrID_Z and Z_DstVS_Z – columns that help identify version-to-version relationships.