ALM Project Database Reference
td.LIBRARY_PARTS_DEFS Table
Description
The individual items in a library
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key LIBPRT_IDThe record ID.int4   
 LIBPRT_LIB_IDThe LIBRARIES.LIB_ID of the library that contains this part. int4   
 LIBPRT_NAMEThe name of the library part.varchar255   
 LIBPRT_VER_STAMPThe version number of this record.int4  
 LIBPRT_DESCRIPTIONA free text description of this item.varchar16  
 LIBPRT_ROOT_ENTITYThe type of this entity. If a TEST folder, this value is ALL_LISTS.varchar30  
 LIBPRT_ROOT_KEYThe ID of this entity.varchar40  
 LIBPRT_ROOT_FILTERFor future use.varchar16  
 LIBPRT_ASSIGNED_ROOT_KEYThe ID of the containing entity in the exported library.varchar40  
Indexes
IndexDescriptionPrimaryUnique
LIBPRT_PRIMARYKEY 
LIBPRT_ROOT_IDX  
LIBPRT_UNIQUE_NAME_IDX  
See Also