Workflow Scheme
The WorkflowScheme table is part of the PostgreSQL database schema used by Workflow Engine. The WorkflowScheme table stores editable workflow scheme definitions by code. This page lists the table columns in database order together with types, nullability, primary keys, defaults, and indexes.
Table columns
The WorkflowScheme table contains 7 columns in database order. Data types and default expressions use the syntax defined by PostgreSQL.
| Position | Column | Database type | Nullable | Primary key | Default |
|---|---|---|---|---|---|
| 1 | Code | character varying(256) | No | No | - |
| 2 | Scheme | text | No | No | - |
| 3 | CanBeInlined | boolean | No | No | false |
| 4 | InlinedSchemes | character varying(1024) | Yes | No | - |
| 5 | Tags | character varying(1024) | Yes | No | - |
| 6 | Id | uuid | No | Yes | - |
| 7 | TenantId | character varying(128) | Yes | No | - |
Database indexes
The WorkflowScheme table defines 2 database indexes. Definitions retain the column or field order and sort direction used by the database.
| Index | Unique | Definition |
|---|---|---|
WorkflowScheme_Code_TenantId_idx | Yes | CREATE UNIQUE INDEX "WorkflowScheme_Code_TenantId_idx" ON public."WorkflowScheme" USING btree ("Code", "TenantId") NULLS NOT DISTINCT |
WorkflowScheme_pkey | Yes | CREATE UNIQUE INDEX "WorkflowScheme_pkey" ON public."WorkflowScheme" USING btree ("Id") |