HP ALM Database Reference
td.ENTITY_SUBTYPE_FIELDS Table

Description

Fields that do not necessarily belong to all subtypes of an entity.

Remarks

This table identifies a field in a primary entity table as belonging to a subtype.

Descriptive IDs are used instead of simple record IDs because subtypes can be created by various tools and extensions. Since this can be done in any order, an ordinary record ID based on order of creation does not identify the subtype-field pair across projects or installations.

Columns

 Column NameDescriptionDatatypeLengthAllow NullsDefault
 ESTF_SUBTYPE_IDThe identifier of this field as a member of a specific subtype.The ENTITY_SUBTYPES.EST_ID of the subtype tovarchar100  
 ESTF_SF_COLUMN_NAMEThe name of the column in the primary entity type table. For example, TS_USER_17 from the TEST table.varchar40  
 ESTF_ENTITY_TABLE_NAMEThe name of the table that contains the primary entity type. For example: TEST, REQ, and so on.varchar40  

See Also