|
Quality Center Database |
|
|
Quality Center Database |
Version control table for attachments.
| Column Name | Description | Datatype | Length | Allow Nulls |
|
|---|---|---|---|---|---|
| CR_ENTITY | The name of the table containing the item to which the file or URL is attached. | VarChar | 30 | ||
| CR_KEY_1 | The string representation of the key in the table specified in CR_ENTITY. The key can be the ID field or a compound key. If a compound key, the values of the key fields are separated by a tilde (~). | VarChar | 40 | ||
 |
CR_REF_ID | The CROS_REF.CR_REF_ID of the item under version control. | Integer | 4 | |
| CR_REFERENCE | The file name or URL. If a file, CR_REFERENCE is CR_ENTITY + CR_KEY_1 + the name of the original uploaded file. | VarChar | 255 | 
|
|
| CR_REF_TYPE | The type of attachment: either File or Internet Web Address. | VarChar | 20 |
|
|
| CR_REF_SUBTYPE | This property is used only in Quality
Center 9.2. It's use will be discontinued in later versions. A value of enum TDAPI_ATTACH_SUBTYPE. |
Integer | 4 | ||
| CR_DESCRIPTION | A description of the attachment. | LongVarChar | 16 |
|
|
| CR_VC_CUR_VER | For backward compatibility. Field may be removed in future version. | VarChar | 50 |
|
|
| |
CR_VC_USER_NAME | The user who locked the entity. | VarChar | 60 |
| Index | Primary | Unique |
|---|---|---|
| VCCR_PRIMARYKEY |
|
|
| VCCR_ENTITY_KEY_IDX | ||
| VCCR_VC_USER_NAME_IDX |
Copyright 2002-2007 Mercury Interactive Corporation. |
|
Documentation comments or suggestions? Please send feedback to SW-Doc@hp.com |