# Workflow Process Instance The `WorkflowProcessInstance` table is part of the [PostgreSQL database schema](https://docs.workflowengine.io/database-schema/postgresql/) used by Workflow Engine. The `WorkflowProcessInstance` table stores the current state and execution metadata for process instances. This page lists the table columns in database order together with types, nullability, primary keys, defaults, and indexes. ## Table columns The `WorkflowProcessInstance` table contains 19 columns in database order. Data types and default expressions use the syntax defined by PostgreSQL. Table: WorkflowProcessInstance columns | Position | Column | Database type | Nullable | Primary key | Default | |----------|--------|---------------|----------|-------------|---------| | 1 | `Id` | `uuid` | No | Yes | - | | 2 | `StateName` | `character varying(256)` | Yes | No | - | | 3 | `ActivityName` | `character varying(256)` | No | No | - | | 4 | `SchemeId` | `uuid` | No | No | - | | 5 | `PreviousState` | `character varying(256)` | Yes | No | - | | 6 | `PreviousStateForDirect` | `character varying(256)` | Yes | No | - | | 7 | `PreviousStateForReverse` | `character varying(256)` | Yes | No | - | | 8 | `PreviousActivity` | `character varying(256)` | Yes | No | - | | 9 | `PreviousActivityForDirect` | `character varying(256)` | Yes | No | - | | 10 | `PreviousActivityForReverse` | `character varying(256)` | Yes | No | - | | 11 | `IsDeterminingParametersChanged` | `boolean` | Yes | No | - | | 12 | `ParentProcessId` | `uuid` | Yes | No | - | | 13 | `RootProcessId` | `uuid` | No | No | - | | 14 | `TenantId` | `character varying(128)` | Yes | No | - | | 15 | `StartingTransition` | `text` | Yes | No | - | | 16 | `SubprocessName` | `text` | Yes | No | - | | 17 | `CreationDate` | `timestamp without time zone` | No | No | `LOCALTIMESTAMP` | | 18 | `LastTransitionDate` | `timestamp without time zone` | Yes | No | - | | 19 | `CalendarName` | `character varying(256)` | Yes | No | - | ## Database indexes The `WorkflowProcessInstance` table defines 3 database indexes. Definitions retain the column or field order and sort direction used by the database. Table: WorkflowProcessInstance indexes | Index | Unique | Definition | |-------|--------|------------| | `IX_CalendarName` | No | `CREATE INDEX "IX_CalendarName" ON public."WorkflowProcessInstance" USING btree ("CalendarName")` | | `WorkflowProcessInstance_RootProcessId_idx` | No | `CREATE INDEX "WorkflowProcessInstance_RootProcessId_idx" ON public."WorkflowProcessInstance" USING btree ("RootProcessId")` | | `WorkflowProcessInstance_pkey` | Yes | `CREATE UNIQUE INDEX "WorkflowProcessInstance_pkey" ON public."WorkflowProcessInstance" USING btree ("Id")` |