ALM Project Database Reference
td.RESULTS Table
Description
The results of a RUN.
Remarks

There can be more than one result record for a RUN.

The data in this table is populated by the testing tool.

Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key RES_IDThe record ID.int4   
 RES_NAMEThe name of the item.varchar255   
 RES_TYPEA value from the "Result Type" project list.varchar40   
 RES_DESCRIPTIONA free text description of this item.varchar16  
 RES_MODIFIED_BYThe user who last changed this item.varchar60   
 RES_RUN_IDThe RUN.RN_RUN_ID of the results owner.int4   
 RES_VTSThe version time stamp.varchar20   
 RES_VER_STAMPThe version number of this record.int4   
Indexes
IndexDescriptionPrimaryUnique
RESULTS_PK 
Triggers
TriggerDescription
AUTR1815529430_RESULTS 
Objects that depend on td.RESULTS
 Database ObjectObject TypeDescriptionDep Level
AUTR1815529430_RESULTS triggerAUTR1815529430_RESULTSTrigger 1
Objects that td.RESULTS depends on
 Database ObjectObject TypeDescriptionDep Level
td.AUDIT_LOG tabletd.AUDIT_LOGTableEvents on which history is recorded.1
td.AUDIT_PROPERTIES tabletd.AUDIT_PROPERTIESTableDetails of the changes recorded in the AUDIT_LOG table.1
See Also