Description
Records of deleted assets for tracing.
Columns
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | DAI_ID | The record ID. | int | 4 | |||
| DAI_ASSET_ID | The ID of the deleted asset in the table given in DAI_ASSET_TYPE. | int | 4 | ||||
| DAI_ASSET_PATH | For TEST, RESOURCE, and COMPONENT, the path is <QC entity path>\<entity id>. For USER_ASSET, the path is <QC owner entity path>\<owner entity id>\<user asset id> | varchar | 255 |  | |||
| DAI_ASSET_NAME | The name of the deleted entity as it appears in the user interface. | varchar | 255 | | |||
| DAI_ASSET_TYPE | For example:
TEST, RESOURCES, COMPONENT, or, USER_ASSET | varchar | 40 | ||||
| DAI_ASSET_DISPLAY_TYPE | The type of the deleted entity as it appears in the user interface. | varchar | 255 | | |||
| DAI_ASSET_DESCRIPTION | A description of the deleted asset. | varchar | 16 | | |||
| DAI_DELETED_BY | The user who deleted the user asset. | varchar | 60 | ||||
| DAI_DELETED_DATE | The date the user asset was deleted. | datetime | 4 | ||||
| DAI_OWNER_ID | For entities that have an owner, the ID of the owner. For example, user assets that are QuickTest Professional actions are owned by the QTP test, so this field would store the ID of the test. | int | 4 | | |||
| DAI_OWNER_TYPE | The type of the owner entity. For example, TEST. | varchar | 40 | | |||
| DAI_OWNER_DISPLAY_TYPE | The owner type as it appears in the user interface. For example, QUICKTEST_TEST. | varchar | 255 | | |||
| DAI_OWNER_NAME | The owner name as it appears in the user interface. | varchar | 255 | | |||
| DAI_OWNER_DESCRIPTION | The description of the owner. | varchar | 16 | |
Indexes
| Index | Description | Primary | Unique |
|---|---|---|---|
| DELETED_ASSET_INFO_IDX1 | |||
| DELETED_ASSET_INFO_LWR_UIX | | ||
| DELETED_ASSET_INFO_PK | | |
See Also