HP ALM Database Reference
td.ENTITY_SUBTYPE_RELATIONS Table
Description
Relations between subtypes of related entities.
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

Related Objects

td Schema
Project Data Tables Database