# Workflow Process Scheme The `WorkflowProcessScheme` table is part of the [SQLite database schema](https://docs.workflowengine.io/database-schema/sqlite/) 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 9 columns in database order. Data types and default expressions use the syntax defined by SQLite. Table: WorkflowProcessScheme columns | Position | Column | Database type | Nullable | Primary key | Default | |----------|--------|---------------|----------|-------------|---------| | 1 | `Id` | `TEXT` | No | Yes | - | | 2 | `Scheme` | `TEXT` | No | No | - | | 3 | `SchemeCode` | `TEXT` | No | No | - | | 4 | `IsObsolete` | `INTEGER` | No | No | - | | 5 | `RootSchemeCode` | `TEXT` | Yes | No | - | | 6 | `RootSchemeId` | `TEXT` | Yes | No | - | | 7 | `AllowedActivities` | `TEXT` | Yes | No | - | | 8 | `StartingTransition` | `TEXT` | Yes | No | - | | 9 | `TenantId` | `TEXT` | 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 | |-------|--------|------------| | `WorkflowProcessScheme_SchemeCode_TenantId_RootSchemeId_Obs_idx` | No | `CREATE INDEX "WorkflowProcessScheme_SchemeCode_TenantId_RootSchemeId_Obs_idx" ON "WorkflowProcessScheme" ("SchemeCode", "TenantId", "RootSchemeId", "IsObsolete")` | | `sqlite_autoindex_WorkflowProcessScheme_1` | Yes | `Id` |