ALM Project Database Reference
td.FAVORITES Table
Description
User-defined settings that are saved for reuse.
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key FAV_IDThe record ID.int4   
 FAV_PARENT_IDThe FAVORITE_FOLDERS.FF_ID of the folder that contains this item.int4   
 FAV_NAMEThe name of the item.varchar255   
 FAV_FILTER_DATAAn XML string containing the filter.varchar16  
 FAV_LAYOUT_DATAAn XML containing the display attributes.varchar16  
 FAV_IS_PUBLICY if the item is public.varchar1   
 FAV_OWNERFor private items, user name of the user who created the item.varchar60   
 FAV_MODULEThe ALM context of the item.varchar50   
 FAV_VER_STAMPThe version number of this record.int4  
 FAV_FORMAT_VERSION

For internal use.

int4   
 FAV_WORKSPACE_DATA

For internal use.

varchar16  
Indexes
IndexDescriptionPrimaryUnique
FAVORITES_FORMAT_VER_IDX   
FAVORITES_NAME_LWR_UK  
FAVORITES_PK 
Objects that depend on td.FAVORITES
 Database ObjectObject TypeDescriptionDep Level
td.VF_FAVORITE_HAS_SHARES viewtd.VF_FAVORITE_HAS_SHARESView 1
See Also