Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each automation history record |
|
| WorkflowActionID | int | 4 | null |
|
|
Workflow action reference - Links to the specific workflow action that was executed |
||
| PrimaryKeyID | int | 4 | √ | null |
|
|
Primary key reference - Reference to the primary key of the record that triggered the automation |
|
| HistoryLogs | nvarchar | 1073741823 | √ | null |
|
|
Execution logs - Detailed logs of the automation execution including steps performed and results |
|
| DateCreated | datetime | 16,3 | √ | null |
|
|
Execution date - Date and time when the automation was executed |
|
| IsReplaced | bit | 1 | √ | null |
|
|
Replacement flag - Boolean indicating if this automation execution was replaced by a subsequent run |
|
| SubmissionId | int | 4 | √ | null |
|
|
Submission reference - Links to submission records if the automation involved data submission |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_AutomationHistories | Primary key | Asc | ID |
Relationships
Close relationships within degrees of separation
