ALM Project Database Reference
td.ENTITY_SUBTYPE_RELATIONS Table
Description
Relations between subtypes of related entities.
Remarks
If two entities are related, it still may be that not all subtypes of each are related to all the subtypes of the other. This table contains the finer grained relations between the subtypes of one entity and the subtypes of another.
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
 ESTR_RELATION_NAME

The name of the relation.

The format is <entity>to<entity><relation description>.  For example, requirementToAttachmentAttachment,  requirementToRequirementContainment, and so on.

This name is not unique. Different subtypes may have the same relationship. For example, the relation requirementToRequirementContainment where a folder subtype is the source can have several instances with different subtypes of requirement on the target side.


The ID of the subtype-subtype pair.		varchar80   
 ESTR_SOURCE_SUBTYPE_IDEither "*", for all the subtypes of the source entity, or the ENTITY_SUBTYPES.EST_ID of the subtype.varchar100   
 ESTR_TARGET_SUBTYPE_IDEither "*", for all the subtypes of the target entity, or the ENTITY_SUBTYPES.EST_ID of the subtype.varchar100   
 ESTR_STATUSON if this relation exists, or OFF if there is no relation between the two subtypes.varchar10   
 ESTR_IS_DEFAULT

IF Y, this is the default relation among the relations between the subtypes of the entities.

For example, a TEST of subtype QTP can be associated with RUNs of subtypes QTP and MANUAL. If the relation between the QTP subtype of a TEST and the QTP subtype of a Run is the default, then when a QTP TEST's RUN is created, it will be of subtype QTP unless set otherwise.

varchar1  
Indexes
IndexDescriptionPrimaryUnique
ESTR_RELATION_IDX  
See Also