Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| DeleteReason | Unknown | 0 | null |
|
|
Deletion reason - Reason provided for the deletion |
||
| ID | Unknown | 0 | null |
|
|
Primary key - Unique identifier for each deletion record, auto-incrementing integer |
||
| pkId | int identity | 4 | √ | null |
|
|
Primary key identifier - Primary key for the deleted history record |
|
| HistID | int | 4 | null |
|
|
History identifier - Unique identifier for the history record |
||
| DateArchived | datetime | 16,3 | √ | null |
|
|
Archive timestamp - When the record was archived |
|
| RecordData | Unknown | 0 | null |
|
|
Original record data - Serialized data of the original record for potential recovery |
||
| RecordId | Unknown | 0 | null |
|
|
Original record ID - Primary key of the original record that was deleted |
||
| TableName | varchar | 50 | √ | null |
|
|
Source table - Name of the table from which the record was deleted |
|
| FieldName | varchar | 50 | √ | null |
|
|
Field name - Name of the field that was deleted |
|
| UserId | Unknown | 0 | null |
|
|
Deletion user - User who performed the deletion operation |
||
| ValueBefore | varchar | 4000 | √ | null |
|
|
Value before - Value of the field before the change that led to deletion |
|
| ValueAfter | varchar | 4000 | √ | null |
|
|
Value after - Value of the field after the change that led to deletion |
|
| ArchivedBy | int | 4 | √ | null |
|
|
Archive user - User who archived the deleted record |
|
| InsertID | int | 4 | √ | null |
|
|
Insert identifier - Reference to the original insert operation |
|
| FieldID | int | 4 | √ | null |
|
|
Field identifier - Reference to specific field that was deleted |
|
| fkInvoicePresentID | nvarchar | 40 | √ | null |
|
|
Invoice present reference - Foreign key to invoice present record |
|
| ActionId | int | 4 | √ | null |
|
|
Action identifier - Reference to the action that caused the deletion |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion timestamp - When the record was deleted |
|
| DeletedBy | datetime | 16,3 | √ | null |
|
|
Deletion user - User who performed the deletion |