Workflow Process Scheme

OptimaJet Team Updated 2026-10-12 2 min read 298 words

The WorkflowProcessScheme table is part of the SQL Server 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 SQL Server.

WorkflowProcessScheme columns
Position	Column	Database type	Nullable	Primary key	Default
1	`Id`	`uniqueidentifier`	No	Yes	-
2	`Scheme`	`ntext`	No	No	-
3	`DefiningParameters`	`ntext`	Yes	No	-
4	`DefiningParametersHash`	`nvarchar(24)`	Yes	No	-
5	`SchemeCode`	`nvarchar(256)`	No	No	-
6	`IsObsolete`	`bit`	No	No	`((0))`
7	`RootSchemeCode`	`nvarchar(256)`	Yes	No	-
8	`RootSchemeId`	`uniqueidentifier`	Yes	No	-
9	`AllowedActivities`	`nvarchar(max)`	Yes	No	-
10	`StartingTransition`	`nvarchar(max)`	Yes	No	-
11	`TenantId`	`nvarchar(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.

WorkflowProcessScheme indexes
Index	Unique	Definition
`IX_SchemeCode_TenantId_RootSchemeId_IsObsolete`	No	`[SchemeCode], [TenantId], [RootSchemeId], [IsObsolete]`
`PK_WorkflowProcessScheme`	Yes	`[Id]`

Previous Workflow Process Instance Status Next Workflow Process Timer