Appearance
dbo.n8nExecutions
Info Generated by
scripts/Generate-DataDictionary.ps1- do not edit by hand. Edit descriptions inschemas/tables/dbo.n8nExecutions.jsonand regenerate.
Columns
| # | Column | Type | Nullable | Flags | Description |
|---|---|---|---|---|---|
| 1 | id | bigint | no | Primary key identifying this n8n workflow execution. | |
| 2 | finished | bit | no | Flag indicating whether the n8n workflow execution ran to completion (1) or not (0). | |
| 3 | mode | varchar(50) | yes | How the n8n execution was triggered, e.g. 'trigger', 'manual', 'webhook', 'retry'. | |
| 4 | retryOf | bigint | yes | ID of the earlier execution this one is a retry of, if applicable. | |
| 5 | retrySuccessId | bigint | yes | ID of the later execution that successfully retried this one, if this execution was subsequently retried successfully. | |
| 6 | startedAt | datetime | no | Date and time the n8n workflow execution started. | |
| 7 | stoppedAt | datetime | no | Date and time the n8n workflow execution finished or stopped. | |
| 8 | workflowId | varchar(255) | no | Foreign key to n8nFlows.id identifying the workflow that was executed. | |
| 9 | waitTill | datetime | yes | Date and time the execution is paused until, for workflows waiting on a delay or webhook resume. |
Indexes
| Name | Type | Unique | PK | Key columns | Included | Filter |
|---|---|---|---|---|---|---|
| PK__n8nExecu__3213E83F4BF5D3F8 | CLUSTERED | yes | yes | id | ||
| nci_msft_1_n8nExecutions_C1A9FCF167DAD1769A6543FA56548DDD | NONCLUSTERED | workflowId, startedAt | finished |
Relationships (inferred)
| From | To | Confidence |
|---|---|---|
| dbo.n8nExecutions.workflowId | dbo.n8nFlows.id | high |
Referenced by
Procedures: dbo.spN8nQueueEscalationFailedExecutions, dbo.spN8nUpsertExecution

