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