Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| HistID | int identity | 4 | √ | null |
|
|
History primary key - Unique identifier for each audit history record |
|
| DateArchived | datetime | 16,3 | √ | null |
|
|
Archive timestamp - Date and time when the change was recorded in the audit history |
|
| TableName | varchar | 50 | √ | null |
|
|
Source table name - Name of the table where the original change occurred |
|
| FieldName | varchar | 50 | √ | null |
|
|
Changed field name - Name of the specific field that was modified |
|
| ValueBefore | varchar | 4000 | √ | null |
|
|
Previous value - Value of the field before the change was made |
|
| ValueAfter | varchar | 4000 | √ | null |
|
|
New value - Value of the field after the change was made |
|
| ArchivedBy | int | 4 | √ | null |
|
|
Change user reference - Links to AccessUser table for the user who made the change |
|
| InsertID | int | 4 | √ | null |
|
|
Record identifier - Primary key of the record that was modified in the source table |
|
| FieldID | int | 4 | √ | null |
|
|
Field identifier - Numeric identifier for the field that was changed |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__History___E1BE56CD4B1446BA | Primary key | Asc | HistID |
Relationships
Close relationships within degrees of separation
