HP ALM Database Reference
td.LIBRARY_FOLDERS Table

Description

Library Folders.

Remarks

The tree structure is stored in two ways. Each record holds a pointer to the parent; and the tree is stored in the path.

Columns

 Column NameDescriptionDatatypeLengthAllow NullsDefault
Primary Key LIBFOL_IDThe record ID.int4  
 LIBFOL_PARENT_IDThe record ID of the folder that contains this item.int4  
 LIBFOL_NAMEThe folder name.varchar255  
 LIBFOL_VER_STAMPThe version number of this record.int4 
 LIBFOL_DESCRIPTIONA free text description of this item.varchar16 
 LIBFOL_HAS_ATTACHMENTSY if this item has attachments.varchar1 
 LIBFOL_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  

See Also