HP ALM Database Reference
td.BL_ALL_LISTS Table

Description

Baseline table for the entity.

Remarks

For descriptions of the table and columns, see the referenced entity table. For example, for details of HIST_TEST, see the TEST table.

Columns

 Column NameDescriptionDatatypeLengthAllow NullsDefault
Primary Key AL_BL_IDThe ID of the Baseline to which this version is pinned.int4  
Primary Key AL_ITEM_ID int4  
 AL_FATHER_IDThe ID of the parent entity.int4 
 AL_DESCRIPTIONA free text description of this item.varchar255 
 AL_NO_OF_SONS int4 
 AL_SYSTEM varchar1 
 AL_ABSOLUTE_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  
 AL_VIEW_ORDER int4 
 AL_MEMO varchar16 
 AL_ATTACHMENTA value of Y indicates that the item has at least one attachment.varchar1 
 AL_ITEM_VERSION int4 
 AL_VER_STAMPThe version number of this record.int4 
 AL_VTSThe version time stamp.varchar20 

See Also

Related Objects

td Schema
Shadow Tables