Workflow Process Transition History
The WorkflowProcessTransitionHistory table is part of the PostgreSQL database schema used by Workflow Engine. The WorkflowProcessTransitionHistory table stores the transition history recorded for process instances. This page lists the table columns in database order together with types, nullability, primary keys, defaults, and indexes.
Table columns
The WorkflowProcessTransitionHistory table contains 17 columns in database order. Data types and default expressions use the syntax defined by PostgreSQL.
| Position | Column | Database type | Nullable | Primary key | Default |
|---|---|---|---|---|---|
| 1 | Id | uuid | No | Yes | - |
| 2 | ProcessId | uuid | No | No | - |
| 3 | ExecutorIdentityId | character varying(256) | Yes | No | - |
| 4 | ActorIdentityId | character varying(256) | Yes | No | - |
| 5 | ExecutorName | character varying(256) | Yes | No | - |
| 6 | ActorName | character varying(256) | Yes | No | - |
| 7 | FromActivityName | character varying(256) | No | No | - |
| 8 | ToActivityName | character varying(256) | No | No | - |
| 9 | ToStateName | character varying(256) | Yes | No | - |
| 10 | TransitionTime | timestamp without time zone | No | No | - |
| 11 | TransitionClassifier | character varying(256) | No | No | - |
| 12 | FromStateName | character varying(256) | Yes | No | - |
| 13 | TriggerName | character varying(256) | Yes | No | - |
| 14 | IsFinalised | boolean | No | No | - |
| 15 | StartTransitionTime | timestamp without time zone | Yes | No | - |
| 16 | TransitionDuration | bigint | Yes | No | - |
| 17 | TenantId | character varying(128) | Yes | No | - |
Database indexes
The WorkflowProcessTransitionHistory table defines 4 database indexes. Definitions retain the column or field order and sort direction used by the database.
| Index | Unique | Definition |
|---|---|---|
WorkflowProcessTransitionHistory_ActorIdentityId_idx | No | CREATE INDEX "WorkflowProcessTransitionHistory_ActorIdentityId_idx" ON public."WorkflowProcessTransitionHistory" USING btree ("ActorIdentityId") |
WorkflowProcessTransitionHistory_ExecutorIdentityId_idx | No | CREATE INDEX "WorkflowProcessTransitionHistory_ExecutorIdentityId_idx" ON public."WorkflowProcessTransitionHistory" USING btree ("ExecutorIdentityId") |
WorkflowProcessTransitionHistory_ProcessId_idx | No | CREATE INDEX "WorkflowProcessTransitionHistory_ProcessId_idx" ON public."WorkflowProcessTransitionHistory" USING btree ("ProcessId") |
WorkflowProcessTransitionHistory_pkey | Yes | CREATE UNIQUE INDEX "WorkflowProcessTransitionHistory_pkey" ON public."WorkflowProcessTransitionHistory" USING btree ("Id") |