HP ALM Database Reference
td.CYCL_FOLD Table

Description

The test set folder tree.

Columns

 Column NameDescriptionDatatypeLengthAllow NullsDefault
Primary Key CF_ITEM_IDThe record ID.int4  
 CF_ITEM_NAMEThe folder name.varchar255 
 CF_ITEM_PATHThe highest level node has path AAA. Each child node down the tree inherits the parent path and adds three letters,where the current level numeration is concatenated to the inherited path. For example, the child requirements of the first node (AAA) have paths of AAAAAA, AAAAAB, AAAAAC, and so on. The characters V and W are not used.varchar255  
 CF_FATHER_IDThe CF_ITEM_ID of the folder containing this item. Root folders have CF_FATHER_ID = 0.int4 
 CF_VIEW_ORDERThe order in which the folder appears among other children of the same parent folder. int4 
 CF_WORKFLOWFor backward compatibility. Field may be removed in future version.varchar16 
 CF_ATTACHMENTA value of Y indicates that the folder has at least one attachment.varchar1 
 CF_VER_STAMPThe revision number of this record. Increments each time the record is updated.int4 
 CF_VTSThe version time stamp. The time the record was last changed according the the database server clock.varchar20 
 CF_DESCRA description of the folder.varchar16 
 CF_NO_OF_SONSThe number of direct child nodes, not including children of those child nodes.int4 
 CF_ASSIGN_RCYCThe RELEASE_CYCLES.RCYC_ID of the release cycle with which the folder is associated.int4 

See Also