# Workflow Process Timer The `WorkflowProcessTimer` table is part of the [PostgreSQL database schema](https://docs.workflowengine.io/database-schema/postgresql/) used by Workflow Engine. The `WorkflowProcessTimer` table stores scheduled timer work for process instances. This page lists the table columns in database order together with types, nullability, primary keys, defaults, and indexes. ## Table columns The `WorkflowProcessTimer` table contains 7 columns in database order. Data types and default expressions use the syntax defined by PostgreSQL. Table: WorkflowProcessTimer columns | Position | Column | Database type | Nullable | Primary key | Default | |----------|--------|---------------|----------|-------------|---------| | 1 | `Id` | `uuid` | No | Yes | - | | 2 | `ProcessId` | `uuid` | No | No | - | | 3 | `RootProcessId` | `uuid` | No | No | - | | 4 | `Name` | `character varying(256)` | No | No | - | | 5 | `NextExecutionDateTime` | `timestamp without time zone` | No | No | - | | 6 | `Ignore` | `boolean` | No | No | - | | 7 | `TenantId` | `character varying(128)` | Yes | No | - | ## Database indexes The `WorkflowProcessTimer` table defines 6 database indexes. Definitions retain the column or field order and sort direction used by the database. Table: WorkflowProcessTimer indexes | Index | Unique | Definition | |-------|--------|------------| | `WorkflowProcessTimer_Ignore_idx` | No | `CREATE INDEX "WorkflowProcessTimer_Ignore_idx" ON public."WorkflowProcessTimer" USING btree ("Ignore")` | | `WorkflowProcessTimer_Name_idx` | No | `CREATE INDEX "WorkflowProcessTimer_Name_idx" ON public."WorkflowProcessTimer" USING btree ("Name")` | | `WorkflowProcessTimer_NextExecutionDateTime_idx` | No | `CREATE INDEX "WorkflowProcessTimer_NextExecutionDateTime_idx" ON public."WorkflowProcessTimer" USING btree ("NextExecutionDateTime")` | | `WorkflowProcessTimer_ProcessId_Name_idx` | Yes | `CREATE UNIQUE INDEX "WorkflowProcessTimer_ProcessId_Name_idx" ON public."WorkflowProcessTimer" USING btree ("ProcessId", "Name")` | | `WorkflowProcessTimer_ProcessId_idx` | No | `CREATE INDEX "WorkflowProcessTimer_ProcessId_idx" ON public."WorkflowProcessTimer" USING btree ("ProcessId")` | | `WorkflowProcessTimer_pkey` | Yes | `CREATE UNIQUE INDEX "WorkflowProcessTimer_pkey" ON public."WorkflowProcessTimer" USING btree ("Id")` |