Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| HistID | int identity | 4 | √ | null |
|
|
History primary key - Unique identifier for each history record |
||||
| DateArchived | datetime | 16,3 | √ | null |
|
|
Archive date - Date and time when the change was recorded |
||||
| TableName | varchar | 50 | √ | null |
|
|
Source table - Name of the table where the change occurred |
||||
| FieldName | varchar | 50 | √ | null |
|
|
Changed field - Name of the field that was modified |
||||
| 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 |
|
|
Archived by user - UserID of the person who made the change |
||||
| InsertID | int | 4 | √ | null |
|
|
Record identifier - Primary key of the record that was changed |
||||
| FieldID | int | 4 | √ | null |
|
|
Field identifier - Numeric identifier for the field that was changed |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__History_CPTCode | Primary key | Asc | HistID |
Relationships
Close relationships within degrees of separation
