HP ALM Database Reference
td.ANALYSIS_ITEM_FOLDERS Table

Description

Folders for reports and graphs.

Columns

 Column NameDescriptionDatatypeLengthAllow NullsDefault
Primary Key AIF_IDThe record ID.int4  
 AIF_PARENT_ID

If top-level folder, 0.

Otherwise the AIF_ID of the parent folder.

int4  
 AIF_NAMEThe folder name.varchar255  
 AIF_LOGICAL_NAMEA name, unique in the scope of this table, that refers to this record.varchar64  
 AIF_DESCRIPTIONThe folder description.varchar16 
 AIF_PATH

The position in the tree. The format is AAAAA, AAAAB, and so on.

The characters V and W are not used.

varchar255  
 AIF_IS_PUBLICIf Y, the folder is public. If N, the folder is private.varchar1 
 AIF_OWNER

For public folders, the user name who created the item.

For private folders, the user name of the current owner.

varchar60  
 AIF_VER_STAMPThe version of the item.int4  
 AIF_SEGMENT_IDThe ANALYSIS_SEGMENTS.AS_ID of the segment in which this item is presented in the user interface.int4 

See Also