RTblRelshipProps SQL Table

See Also

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.