Workflow Process Scheme
The WORKFLOWPROCESSSCHEME table is part of the Oracle database schema used by Workflow Engine. The WORKFLOWPROCESSSCHEME table stores compiled process schemes used by running process instances. This page lists the table columns in database order together with types, nullability, primary keys, defaults, and indexes.
Table columns
The WORKFLOWPROCESSSCHEME table contains 11 columns in database order. Data types and default expressions use the syntax defined by Oracle.
| Position | Column | Database type | Nullable | Primary key | Default |
|---|---|---|---|---|---|
| 1 | ID | RAW(16) | No | Yes | - |
| 2 | SCHEME | CLOB | No | No | - |
| 3 | DEFININGPARAMETERS | CLOB | Yes | No | - |
| 4 | DEFININGPARAMETERSHASH | NVARCHAR2(24) | Yes | No | - |
| 5 | SCHEMECODE | NVARCHAR2(256) | No | No | - |
| 6 | ISOBSOLETE | CHAR(1) | No | No | 0 |
| 7 | ROOTSCHEMECODE | NVARCHAR2(256) | Yes | No | - |
| 8 | ROOTSCHEMEID | RAW(16) | Yes | No | - |
| 9 | ALLOWEDACTIVITIES | CLOB | Yes | No | - |
| 10 | STARTINGTRANSITION | CLOB | Yes | No | - |
| 11 | TENANTID | NVARCHAR2(128) | Yes | No | - |
Database indexes
The WORKFLOWPROCESSSCHEME table defines 2 database indexes. Definitions retain the column or field order and sort direction used by the database.
| Index | Unique | Definition |
|---|---|---|
IDX_WORKFLOWPROCESSSCHEME_SCHEMECODE_TENANTID_ROOTSCHEMEID_ISOBSOLETE | No | SCHEMECODE, TENANTID, ROOTSCHEMEID, ISOBSOLETE |
PK_WORKFLOWPROCESSSCHEME | Yes | ID |