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