# Workflow Approval History The `workflowapprovalhistory` table is part of the [MySQL database schema](https://docs.workflowengine.io/database-schema/mysql/) used by Workflow Engine. The `workflowapprovalhistory` table stores approval decisions associated with process instances. This page lists the table columns in database order together with types, nullability, primary keys, defaults, and indexes. ## Table columns The `workflowapprovalhistory` table contains 11 columns in database order. Data types and default expressions use the syntax defined by MySQL. Table: workflowapprovalhistory columns | Position | Column | Database type | Nullable | Primary key | Default | |----------|--------|---------------|----------|-------------|---------| | 1 | `Id` | `binary(16)` | No | Yes | - | | 2 | `ProcessId` | `binary(16)` | No | No | - | | 3 | `IdentityId` | `varchar(256)` | Yes | No | - | | 4 | `AllowedTo` | `longtext` | Yes | No | - | | 5 | `TransitionTime` | `datetime` | Yes | No | - | | 6 | `Sort` | `bigint` | Yes | No | - | | 7 | `InitialState` | `varchar(1024)` | No | No | - | | 8 | `DestinationState` | `varchar(1024)` | No | No | - | | 9 | `TriggerName` | `varchar(1024)` | Yes | No | - | | 10 | `Commentary` | `longtext` | Yes | No | - | | 11 | `TenantId` | `varchar(128)` | Yes | No | - | ## Database indexes The `workflowapprovalhistory` table defines 3 database indexes. Definitions retain the column or field order and sort direction used by the database. Table: workflowapprovalhistory indexes | Index | Unique | Definition | |-------|--------|------------| | `IdentityId` | No | ``IdentityId`` | | `PRIMARY` | Yes | ``Id`` | | `ProcessId` | No | ``ProcessId`` |