Description
Attachments.
Columns
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
| 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 user who checked out the item under version control. If the item is not checked out, this field is blank. | varchar | 60 | |
Indexes
| Index | Description | Primary | Unique |
|---|---|---|---|
| CR_ENTITY_KEY_IDX | |||
| CR_PRIMARYKEY | | |
See Also