HP ALM Database Reference
td.VER_CTRL Table

Description

Version control locking for Tests.

Columns

 Column NameDescriptionDatatypeLengthAllow NullsDefault
Primary Key VC_OBJECT_KEYThe string representation of the key of the locked object of the entity identified by VC_OBJECT_TYPE.varchar50  
Primary Key VC_USER_NAMEThe user name of the user locking the object.varchar255  
 VC_STATUSThe locked object status. This is a value from the VC Status custom list.varchar20 
 VC_DATEThe date the object was locked.datetime4 
 VC_TIMEThe time the object was locked.varchar10 
 VC_VERSIONThe locked object’s version.varchar50 
 VC_COMMENTSUser comment.varchar16 
Primary Key VC_OBJECT_TYPEThe entity type of the locked object.int4  
 VC_OBJECT_REFERENCE

The TS_TEST_ID of the locked TEST object.

The field is not used for other entity types.

int4 
 VC_USER_03User-defined field.varchar40 
 VC_USER_04User-defined field.varchar40 
 VC_USER_05User-defined field.varchar40 
 VC_USER_06User-defined field.varchar40 
 VC_USER_07User-defined field.varchar40 
 VC_USER_08User-defined field.varchar40 
 VC_USER_09User-defined field.varchar40 
 VC_USER_10User-defined field.varchar40 
 VC_USER_11User-defined field.varchar40 
 VC_USER_12User-defined field.varchar40 
 VC_VERSION_NUMBERThe version number.int4 

See Also