Workflow Process Assignment
The WorkflowProcessAssignment table is part of the SQLite database schema used by Workflow Engine. The WorkflowProcessAssignment table stores process assignment records retained by the provider schema. This page lists the table columns in database order together with types, nullability, primary keys, defaults, and indexes.
Table columns
The WorkflowProcessAssignment table contains 16 columns in database order. Data types and default expressions use the syntax defined by SQLite.
| Position | Column | Database type | Nullable | Primary key | Default |
|---|---|---|---|---|---|
| 1 | Id | TEXT | No | Yes | - |
| 2 | AssignmentCode | TEXT | No | No | - |
| 3 | ProcessId | TEXT | No | No | - |
| 4 | Name | TEXT | No | No | - |
| 5 | Description | TEXT | Yes | No | - |
| 6 | StatusState | TEXT | No | No | - |
| 7 | DateCreation | INTEGER | No | No | - |
| 8 | DateStart | INTEGER | Yes | No | - |
| 9 | DateFinish | INTEGER | Yes | No | - |
| 10 | DeadlineToStart | INTEGER | Yes | No | - |
| 11 | DeadlineToComplete | INTEGER | Yes | No | - |
| 12 | Executor | TEXT | No | No | - |
| 13 | Observers | TEXT | Yes | No | - |
| 14 | Tags | TEXT | Yes | No | - |
| 15 | IsActive | INTEGER | No | No | - |
| 16 | IsDeleted | INTEGER | No | No | - |
Database indexes
The WorkflowProcessAssignment table defines 5 database indexes. Definitions retain the column or field order and sort direction used by the database.
| Index | Unique | Definition |
|---|---|---|
WorkflowProcessAssignment_ProcessId_idx | No | CREATE INDEX "WorkflowProcessAssignment_ProcessId_idx" ON "WorkflowProcessAssignment" ("ProcessId") |
WorkflowProcessTimer_AssignmentCode_idx | No | CREATE INDEX "WorkflowProcessTimer_AssignmentCode_idx" ON "WorkflowProcessAssignment" ("AssignmentCode") |
WorkflowProcessTimer_Executor_idx | No | CREATE INDEX "WorkflowProcessTimer_Executor_idx" ON "WorkflowProcessAssignment" ("Executor") |
WorkflowProcessTimer_ProcessId_Executor_idx | No | CREATE INDEX "WorkflowProcessTimer_ProcessId_Executor_idx" ON "WorkflowProcessAssignment" ("ProcessId", "Executor") |
sqlite_autoindex_WorkflowProcessAssignment_1 | Yes | Id |