ALM Project Database Reference
td.REQ_TYPE Table
Description
Types of requirements.
Remarks
The table is installed already populated with predefined types: Folder, Group, Undefined, Functional, Business, Testing. Additional types are added by the project administrator.
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key TPR_TYPE_IDThe record ID.int4   
 TPR_NAMEThe type name.varchar80   
 TPR_ICON_STREAMObsolete. The encoded graphic icon in Quality Center versions prior to ALM 11.00. Replaced by TPR_ICON_STREAM2.varchar2000  
 TPR_PREFIXThe recommended prefix for requirements of this type. For example, if TPR_PREFIX for the type is BIZ, requirements of the type should have names like BIZ_REQ1. ALM does not change the names of existing requirements if TPR_PREFIX is changed.varchar10  
 TPR_EDITING_CONTROLFor future use.varchar255  
 TPR_HAS_DIRECT_COVERAGEA value of 1 indicates that this type of requirement can have direct test coverage.varchar1   
 TPR_RISK_ANALYSIS_TYPEA value of enum TDAPI_RBT_REQUIREMENT_TYPE_RISK_ANALYSIS_TYPE. See the API reference for possible values.int4   
 TPR_RICH_TEXT_TEMPLATEThe HTML representation of the requirement type's Rich Text Template document.varchar16  
 TPR_ICON_STREAM2The encoded graphic icon.varchar16  
 TPR_ICON_REF

For internal use.

varchar256  
 TPR_DEFAULT_CHILD_TYPE_ID

For internal use.

int4  
 TPR_IS_DOCUMENT_ROOT

For internal use.

varchar1  
Indexes
IndexDescriptionPrimaryUnique
TPR_NAME_LWR_IDX  
TPR_PRIMARYKEY 
Objects that depend on td.REQ_TYPE
 Database ObjectObject TypeDescriptionDep Level
AUTR81022_REQ triggerAUTR81022_REQTrigger 2
MVTR_REQ triggerMVTR_REQTrigger 2
td.REQ tabletd.REQTableDetails of individual requirements and the structure of the requirements tree.1
See Also