MySQL
The Workflow Engine MySQL 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 MySQL 8.0 or later. Use the object list below.
The MySQL 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 MySQL persistence provider supports MySQL 8.0 or later. The provider source on GitHub contains the implementation for the objects listed on this page.
Database objects
The MySQL 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 MySQL version?
The Workflow Engine MySQL persistence provider supports MySQL 8.0 or later.
How many tables are in the Workflow Engine MySQL schema?
The MySQL schema contains 14 tables. The Database objects section links to a separate reference page for each table.
Why can the MySQL schema differ from another provider?
The MySQL provider uses database-specific data types, identifier rules, defaults, and index syntax while implementing the same Workflow Engine persistence contracts.