Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
History primary key - Unique identifier for each job history record |
|
| FieldID | int | 4 | √ | null |
|
|
Field identifier - Numeric identifier for the field that was changed |
|
| TableName | varchar | 50 | √ | null |
|
|
Source table - Name of the table where the automated change occurred |
|
| FieldName | varchar | 50 | √ | null |
|
|
Changed field - Name of the field that was modified by the job |
|
| ValueBefore | varchar | 4000 | √ | null |
|
|
Previous value - Value of the field before the automated change |
|
| ValueAfter | varchar | 4000 | √ | null |
|
|
New value - Value of the field after the automated change |
|
| CreatedDate | datetime | 16,3 | √ | null |
|
|
Job execution date - Date and time when the job was executed |
|
| JobName | varchar | 200 | √ | null |
|
|
Job name - Name of the automated job that made the change |
|
| CompanyID | int | 4 | √ | null |
|
|
Company reference - Company identifier for multi-tenant job processing |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__NightlyJ__3214EC2776CBD922 | Primary key | Asc | ID |
Relationships
Close relationships within degrees of separation
