# Workflow Process Scheme The `WORKFLOWPROCESSSCHEME` table is part of the [Oracle database schema](https://docs.workflowengine.io/database-schema/oracle/) 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. Table: WORKFLOWPROCESSSCHEME columns | 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. Table: WORKFLOWPROCESSSCHEME indexes | Index | Unique | Definition | |-------|--------|------------| | `IDX_WORKFLOWPROCESSSCHEME_SCHEMECODE_TENANTID_ROOTSCHEMEID_ISOBSOLETE` | No | `SCHEMECODE, TENANTID, ROOTSCHEMEID, ISOBSOLETE` | | `PK_WORKFLOWPROCESSSCHEME` | Yes | `ID` |