# Workflow Process Transition History The `WORKFLOWPROCESSTRANSITIONH` table is part of the [Oracle database schema](https://docs.workflowengine.io/database-schema/oracle/) used by Workflow Engine. The `WORKFLOWPROCESSTRANSITIONH` 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 `WORKFLOWPROCESSTRANSITIONH` table contains 17 columns in database order. Data types and default expressions use the syntax defined by Oracle. Table: WORKFLOWPROCESSTRANSITIONH columns | Position | Column | Database type | Nullable | Primary key | Default | |----------|--------|---------------|----------|-------------|---------| | 1 | `ID` | `RAW(16)` | No | Yes | - | | 2 | `PROCESSID` | `RAW(16)` | No | No | - | | 3 | `EXECUTORIDENTITYID` | `NVARCHAR2(256)` | Yes | No | - | | 4 | `ACTORIDENTITYID` | `NVARCHAR2(256)` | Yes | No | - | | 5 | `EXECUTORNAME` | `NVARCHAR2(256)` | Yes | No | - | | 6 | `ACTORNAME` | `NVARCHAR2(256)` | Yes | No | - | | 7 | `FROMACTIVITYNAME` | `NVARCHAR2(256)` | Yes | No | - | | 8 | `TOACTIVITYNAME` | `NVARCHAR2(256)` | No | No | - | | 9 | `TOSTATENAME` | `NVARCHAR2(256)` | Yes | No | - | | 10 | `TRANSITIONTIME` | `DATE` | No | No | - | | 11 | `TRANSITIONCLASSIFIER` | `NVARCHAR2(256)` | No | No | - | | 12 | `ISFINALISED` | `CHAR(1)` | No | No | - | | 13 | `FROMSTATENAME` | `NVARCHAR2(256)` | Yes | No | - | | 14 | `TRIGGERNAME` | `NVARCHAR2(256)` | Yes | No | - | | 15 | `STARTTRANSITIONTIME` | `TIMESTAMP(6)` | Yes | No | - | | 16 | `TRANSITIONDURATION` | `NUMBER(10,0)` | Yes | No | - | | 17 | `TENANTID` | `NVARCHAR2(128)` | Yes | No | - | ## Database indexes The `WORKFLOWPROCESSTRANSITIONH` table defines 3 database indexes. Definitions retain the column or field order and sort direction used by the database. Table: WORKFLOWPROCESSTRANSITIONH indexes | Index | Unique | Definition | |-------|--------|------------| | `IDX_WORKFLOWPROCESSTRANSITIONH` | No | `PROCESSID` | | `IDX_WORKFLOWPROCESSTRANSITIONH_EX` | No | `EXECUTORIDENTITYID` | | `PK_WORKFLOWPROCESSTRANSITIONH` | Yes | `ID` |