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