---
id: TST-PFM-INT-630
title: Workflow storage column definitions
kind: unit
product_area: platform
module: integrations
revision: 1
status: draft
source_sha:
  services-platform: ad3f6a6582843008ed0f5a17b131878d15829af1
  macroservice-libraries: 54536a441935c6e09fdb7f96f0bec71c52ba4e03
  react-console: baf6dae382d6f41dce976c7f848667ccc37e076f
repository: macroservice-libraries
files:
  - packages/workflow-actions/src/columns.spec.ts
implements: []
environment: mock
implementation_state: implemented
latest_result: not-run
latest_run_at: null
latest_run_ref: null
conformance: not-verified
estimated_minutes: 1
isolation: 'The test process owns its inputs, fake clocks and any replaced runtime ports.'
test_cases:
  - provenance: test
    source: >-
      macroservice-libraries:packages/workflow-actions/src/columns.spec.ts#follow the snake_case naming
      standard: plural tables, properties equal to columns, named keys, indexes and checks
  - provenance: test
    source: >-
      macroservice-libraries:packages/workflow-actions/src/columns.spec.ts#the run table carries 05 §4’s
      columns, with batch_sequence, halt_batch and occurrence_facts beside them
  - provenance: test
    source: >-
      macroservice-libraries:packages/workflow-actions/src/columns.spec.ts#the run table’s key, its three
      indexes and a check for every closed vocabulary and every jsonb document
  - provenance: test
    source: >-
      macroservice-libraries:packages/workflow-actions/src/columns.spec.ts#the batch table is a pointer
      per batch lane: the batch, its group, the claim and when it was queued
  - provenance: test
    source: >-
      macroservice-libraries:packages/workflow-actions/src/columns.spec.ts#the timer table carries 08
      §4’s columns, with sys_last_modified_at for retention
  - provenance: test
    source: >-
      macroservice-libraries:packages/workflow-actions/src/columns.spec.ts#the timer table’s
      one-per-occurrence unique index, the sweep’s indexes and its checks
  - provenance: test
    source: >-
      macroservice-libraries:packages/workflow-actions/src/columns.spec.ts#renders the DDL a migration
      would create: the closed vocabularies spelled out, the partial due index on scheduled timers
  - provenance: test
    source: >-
      macroservice-libraries:packages/workflow-actions/src/columns.spec.ts#a host may name the tables
      differently
  - provenance: test
    source: >-
      macroservice-libraries:packages/workflow-actions/src/columns.spec.ts#forces tenant isolation on
      runs and timers, adds the reconciler’s and the sweep’s read policies, and only grants on the exempt
      batch queue
  - provenance: test
    source: >-
      macroservice-libraries:packages/workflow-actions/src/columns.spec.ts#gives a host that applied
      0.1.0’s statements the reconcile policy alone
  - provenance: test
    source: >-
      macroservice-libraries:packages/workflow-actions/src/columns.spec.ts#states the batch queue’s
      exemption with its reason
  - provenance: test
    source: >-
      macroservice-libraries:packages/workflow-actions/src/columns.spec.ts#joins the statements the way
      the migrator reads them
  - provenance: test
    source: >-
      macroservice-libraries:packages/workflow-actions/src/columns.spec.ts#refuses a schema, role or
      table name it may not write into DDL
evidence:
  - 'macroservice-libraries:packages/workflow-actions/src/columns.spec.ts'
---
# Workflow storage column definitions

## Verification Boundary

This unit suite exercises workflow storage column definitions within the shared package. It records engineering coverage at the pinned revision without claiming a deployed run.

## What This Suite Proves

The source assertions cover the package behavior under controlled inputs. No detailed capability or feature scenario binding is verified in this registration.

## What It Does Not Prove

The suite does not establish deployed authorization, database behavior, provider effects or a complete customer workflow.

## Real Dependencies and Test Doubles

Imported package functions execute against the source-defined fixtures. Runtime ports, clocks and external transport responses remain controlled wherever the suite replaces them.

## Must Not Be Doubled

The shared function under test and its result assertions must execute. Returning an expected answer from a substitute does not prove the package behavior.