Workflow Form
The workflowform table is part of the MySQL database schema used by Workflow Engine. The workflowform table stores versioned form definitions used by Workflow Engine. This page lists the table columns in database order together with types, nullability, primary keys, defaults, and indexes.
Table columns
The workflowform table contains 9 columns in database order. Data types and default expressions use the syntax defined by MySQL.
| Position | Column | Database type | Nullable | Primary key | Default |
|---|---|---|---|---|---|
| 1 | Id | binary(16) | No | Yes | - |
| 2 | Name | varchar(512) | No | No | - |
| 3 | Version | int | No | No | - |
| 4 | CreationDate | datetime | No | No | CURRENT_TIMESTAMP |
| 5 | UpdatedDate | datetime | No | No | CURRENT_TIMESTAMP |
| 6 | Definition | longtext | No | No | - |
| 7 | Lock | int | No | No | - |
| 8 | TenantId | varchar(128) | Yes | No | - |
| 9 | TenantIdForUniqueIndex | varchar(128) | Yes | No | - |
Database indexes
The workflowform table defines 2 database indexes. Definitions retain the column or field order and sort direction used by the database.
| Index | Unique | Definition |
|---|---|---|
PRIMARY | Yes | `Id` |
ix_workflowform_name_version_tenantid | Yes | `Name`, `Version`, `TenantIdForUniqueIndex` |