Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| HistID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each history record |
||||
| DateArchived | datetime | 16,3 | √ | null |
|
|
Archive date - Date when the change was archived to history |
||||
| 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 | ntext | 1073741823 | √ | null |
|
|
Previous value - Value of the field before the change was made |
||||
| ValueAfter | ntext | 1073741823 | √ | null |
|
|
New value - Value of the field after the change was made |
||||
| ArchivedBy | int | 4 | √ | null |
|
|
Archived by user - UserID of the person who made the change |
||||
| InsertID | int | 4 | √ | null |
|
|
Insert identifier - Identifier for the record that was inserted or modified |
||||
| FieldID | int | 4 | √ | null |
|
|
Field identifier - Numeric identifier for the field that was changed |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__History__041 | Primary key | Asc | HistID |
Relationships
Close relationships within degrees of separation
