Attachments.
Column Name | Description | Datatype | Length | Allow Nulls | Default | |
---|---|---|---|---|---|---|
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 record ID. | int | 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 was used only in Quality Center 9.2. | int | 4 | |||
CR_DESCRIPTION | A description of the attachment. | varchar | 16 | ![]() | ||
CR_VC_CUR_VER | For backward compatibility. Field may be removed in future version. | varchar | 50 | ![]() | ||
CR_VC_USER_NAME | The name of the item. | varchar | 60 | ![]() |