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