HP ALM Database Reference
td.VC_COMPONENT Table

Description

Versions of the entity that are checked out under version control.

Remarks

The versions in this table are not available to users in the Quality Center UI until they are checked in. They are visible to the user who checked out the version and to privileged users. Descriptions of the table and columns are in the referenced entity table. For example, for details of VC_TEST,see the TEST table.

Columns

 Column NameDescriptionDatatypeLengthAllow NullsDefault
Primary Key CO_VC_CHECKOUT_USER_NAMEThe user who checked out the item under version control.varchar60  
Primary Key CO_IDThe record ID.int4  
 CO_FOLDER_IDThe ID of the folder that contains this item.int4  
 CO_NAMEThe name of the item.varchar255 
 CO_VERSION varchar255 
 CO_PHYSICAL_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 
 CO_RESPONSIBLE varchar60 
 CO_CREATED_BYThe user name of the user who created this item.varchar60 
 CO_STATUS varchar70 
 CO_CREATION_DATEThe server date when this item was created.datetime4 
 CO_DESCDescription of the item.varchar16 
 CO_DEV_COMMENTSComments.Commentsvarchar16 
 CO_STEPS_DATA varchar16 
 CO_VER_STAMPThe version number of this record.int4 
 CO_IS_ITERATABLE varchar1 
 CO_DEFAULT_PICTURE_ID int4 
 CO_IS_OBSOLETE varchar1 
 CO_SRC_ID int4  
 CO_DELETION_DATE datetime4 
 CO_DELETED_FROM_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 
 CO_DATA varchar16 
 CO_SCRIPT_TYPE varchar60 
 CO_HAS_PICTURE varchar1 
 CO_TEXT_SYNCFor internal use. Do not change data.varchar1 
 CO_APP_AREA_ID int4 
 CO_VTSThe version time stamp.varchar20 
 CO_USER_01User-defined field.varchar40 
 CO_USER_02User-defined field.varchar40 
 CO_USER_03User-defined field.varchar40 
 CO_USER_04User-defined field.varchar40 
 CO_USER_05User-defined field.varchar40 
 CO_USER_06User-defined field.varchar40 
 CO_USER_07User-defined field.varchar40 
 CO_USER_08User-defined field.varchar40 
 CO_USER_09User-defined field.varchar40 
 CO_USER_10User-defined field.varchar40 
 CO_USER_11User-defined field.varchar40 
 CO_USER_12User-defined field.varchar40 
 CO_USER_13User-defined field.varchar40 
 CO_USER_14User-defined field.varchar40 
 CO_USER_15User-defined field.varchar40 
 CO_USER_16User-defined field.varchar40 
 CO_USER_17User-defined field.varchar40 
 CO_USER_18User-defined field.varchar40 
 CO_USER_19User-defined field.varchar40 
 CO_USER_20User-defined field.varchar40 
 CO_USER_21User-defined field.varchar40 
 CO_USER_22User-defined field.varchar40 
 CO_USER_23User-defined field.varchar40 
 CO_USER_24User-defined field.varchar40 
 CO_BPTA_FLOW_TEST_ID int4 
 CO_BPTA_COMPONENT_TYPE int4 
 CO_BPTA_CHANGE_DETECTED int4 
 CO_BPTA_CHANGE_TIMESTAMP varchar30 
 CO_BPTA_LAST_UPDATE_TIMESTAMP varchar30 
 CO_BPTA_SOR_ID int4 
 CO_BPTA_LOCATION_ID_IN_APP varchar255 
 CO_VC_VERSION_NUMBERThe version ID of the entity.int4 
 CO_VC_STATUSThe version status: Checked in, checked out, or read only.varchar20 
 CO_VC_CHECKIN_USER_NAMEThe user name of the user who checked in this version.varchar60 
 CO_VC_CHECKIN_DATEThe date this version was checked in according to the server clock.datetime4 
 CO_VC_CHECKIN_TIMEThe time this version was checked in according to the server clock.varchar10 
 CO_VC_CHECKIN_COMMENTSComments.The user's comments when checking in the item.varchar16 
 CO_VC_CHECKOUT_DATEThe date the version was checked out according to the server clock.datetime4 
 CO_VC_CHECKOUT_TIMEThe time this version was checked out according to the server clock.varchar10 
 CO_VC_CHECKOUT_COMMENTSComments.The user's comments when checking out the item.varchar16 
 CO_SUBTYPE_ID varchar50 
 CO_HAS_MANUAL_SCRIPT varchar1 
 CO_HAS_AUTO_SCRIPT varchar1 

See Also

Related Objects

td Schema
Shadow Tables