BulkDeletionData Table
The BulkDeletionData table stores objects that have been marked for bulk deletion.
Note: To cater for multi-tenant mode, this table may contain data for
multiple tenants. Access requires that the database
TenantID has been set in the SQL Server
connection context information. That setting filters an underlying table to produce this
view of data for the single, selected tenant.|
Database Column |
Details |
|---|---|
BulkDeletionDataID
|
Type: integer. Key. Generated ID Auto-increment primary key for this table. |
ObjectToBeDeletedID
|
Type: integer. Key Foreign key ID of the object marked for deletion. |
ObjectTypeID
|
Type: integer. Key The type of object marked for deletion (e.g., Asset, PurchaseOrder, etc.).Foreign key ID of the object BulkDeletionObjectType |
DateAdded
|
Type: datetime. Key. Nullable Date and time when the object was marked for deletion. |
MarkedBy
|
Type: text (max 128 characters). Nullable ID of the compliance operator context when marked for deletion. |
DateDeleted
|
Type: datetime. Nullable Date and time when the object was deleted. |