Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| HistID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each audit record |
||||
| DateArchived | datetime | 16,3 | √ | null |
|
|
Archive date - Timestamp when the change was recorded |
||||
| TableName | varchar | 50 | √ | null |
|
|
Table name - Name of the database table that was modified |
||||
| FieldName | varchar | 50 | √ | null |
|
|
Field name - Name of the specific field that was changed |
||||
| ValueBefore | varchar | 4000 | √ | null |
|
|
Previous value - Value of the field before the change |
||||
| ValueAfter | varchar | 4000 | √ | null |
|
|
New value - Value of the field after the change |
||||
| ArchivedBy | int | 4 | √ | null |
|
|
Changed by user - UserID of the person who made the change |
||||
| InsertID | int | 4 | √ | null |
|
|
Insert identifier - Reference to the specific record that was modified |
||||
| FieldID | int | 4 | √ | null |
|
|
Field identifier - Unique identifier for the field that was changed |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__History__0F04BA4A | Primary key | Asc | HistID |
| IX_datearchived | Performance | Desc | DateArchived |
| IX_FieldID | Performance | Asc | FieldID |
| IX_FieldName | Performance | Asc | FieldName |
| IX_History | Performance | Asc | TableName |
| IX_InsertID | Performance | Asc | InsertID |
| IX_Tablename | Performance | Asc | TableName |
Relationships
Close relationships within degrees of separation
