SQL Server
The Workflow Engine SQL Server schema contains 14 persistence tables. Each table has a separate reference page that lists its purpose, columns, database-specific types, nullability, primary keys, defaults, and indexes. The provider supports SQL Server 2016 or later. Use the object list below.
The SQL Server persistence provider uses 14 tables to store Workflow Engine process definitions, runtime state, timers, history, and provider data. Open a table page below to review its columns, database types, keys, defaults, and indexes.
Supported database version
The Workflow Engine SQL Server persistence provider supports SQL Server 2016 or later. The provider source on GitHub contains the implementation for the objects listed on this page.
Database objects
The SQL Server schema contains the following 14 tables. Each table links to a separate page with its purpose, columns, database types, nullability, primary keys, defaults, and indexes.
| Object | Type | Purpose |
|---|---|---|
| VersionInfo | Table | Records which Workflow Engine migrations have been applied. |
| WorkflowApprovalHistory | Table | Stores approval decisions associated with process instances. |
| WorkflowForm | Table | Stores versioned form definitions used by Workflow Engine. |
| WorkflowGlobalParameter | Table | Stores tenant-aware runtime values and other global parameters. |
| WorkflowInbox | Table | Maps process instances with identities that have pending inbox items. |
| WorkflowProcessInstance | Table | Stores the current state and execution metadata for process instances. |
| WorkflowProcessInstancePersistence | Table | Stores persisted parameter values for process instances. |
| WorkflowProcessInstanceStatus | Table | Stores process execution status, locks, and runtime ownership. |
| WorkflowProcessScheme | Table | Stores compiled process schemes used by running process instances. |
| WorkflowProcessTimer | Table | Stores scheduled timer work for process instances. |
| WorkflowProcessTransitionHistory | Table | Stores the transition history recorded for process instances. |
| WorkflowRuntime | Table | Stores registered runtime nodes and their coordination state. |
| WorkflowScheme | Table | Stores editable workflow scheme definitions by code. |
| WorkflowSync | Table | Stores coordination locks used by Workflow Engine runtime services. |
Frequently asked questions
What is the minimum supported SQL Server version?
The Workflow Engine SQL Server persistence provider supports SQL Server 2016 or later.
How many tables are in the Workflow Engine SQL Server schema?
The SQL Server schema contains 14 tables. The Database objects section links to a separate reference page for each table.
Why can the SQL Server schema differ from another provider?
The SQL Server provider uses database-specific data types, identifier rules, defaults, and index syntax while implementing the same Workflow Engine persistence contracts.