---
id: TST-PFM-INT-504
title: integration executions table
kind: integration
product_area: platform
module: integrations
revision: 1
status: draft
source_sha:
  services-platform: ad3f6a6582843008ed0f5a17b131878d15829af1
  macroservice-libraries: 54536a441935c6e09fdb7f96f0bec71c52ba4e03
  react-console: baf6dae382d6f41dce976c7f848667ccc37e076f
repository: services-platform
files:
  - modules/integrations/tests/integration/db/integration-executions.table.integration.spec.js
implements: []
environment: local
implementation_state: implemented
latest_result: not-run
latest_run_at: null
latest_run_ref: null
conformance: not-verified
estimated_minutes: 5
isolation: >-
  Use the suite-owned database fixtures and its declared cleanup; prepare the test database before
  integration or lifecycle execution.
evidence:
  - >-
    services-platform:modules/integrations/tests/integration/db/integration-executions.table.integration.spec.js
test_cases:
  - source: >-
      services-platform:modules/integrations/tests/integration/db/integration-executions.table.integration.spec.js#is
      partitioned by range on started_at, with this month’s partition and the two after it
    provenance: test
  - source: >-
      services-platform:modules/integrations/tests/integration/db/integration-executions.table.integration.spec.js#writes
      an execution into the partition of its own month
    provenance: test
  - source: >-
      services-platform:modules/integrations/tests/integration/db/integration-executions.table.integration.spec.js#refuses
      a status outside the lifecycle
    provenance: test
  - source: >-
      services-platform:modules/integrations/tests/integration/db/integration-executions.table.integration.spec.js#refuses
      an unknown execution with no lookup due
    provenance: test
  - source: >-
      services-platform:modules/integrations/tests/integration/db/integration-executions.table.integration.spec.js#accepts
      an unknown execution with its lookup due, the premise of the refusal above
    provenance: test
  - source: >-
      services-platform:modules/integrations/tests/integration/db/integration-executions.table.integration.spec.js#refuses
      a digest that is not a lowercase hex SHA-256
    provenance: test
  - source: >-
      services-platform:modules/integrations/tests/integration/db/integration-executions.table.integration.spec.js#refuses
      a summary over 4 KB
    provenance: test
  - source: >-
      services-platform:modules/integrations/tests/integration/db/integration-executions.table.integration.spec.js#holds
      one key per tenant and capability whatever the month of the execution holding it
    provenance: test
  - source: >-
      services-platform:modules/integrations/tests/integration/db/integration-executions.table.integration.spec.js#lets
      the same key be held for another capability
    provenance: test
  - source: >-
      services-platform:modules/integrations/tests/integration/db/integration-executions.table.integration.spec.js#refuses
      a key longer than 128 characters
    provenance: test
dependency_evidence:
  provenance: test
  source: >-
    services-platform:modules/integrations/tests/integration/db/integration-executions.table.integration.spec.js
  reviewed:
    - Suite introduction
    - Fixture setup
    - Client substitutions
    - Assertions and cleanup
---
# integration executions table

## Verification Boundary

This database and service suite exercises integration executions table. Its registration records the executable definition; no run result is asserted.

## What This Suite Proves

The suite contains executable checks, but no detailed scenario binding is verified in this pass.

## What It Does Not Prove

In-process execution does not establish deployed infrastructure or a real provider response. Several bindings can supply different parts of a detailed scenario; no single-file completeness is implied.

## Real Dependencies and Test Doubles

The suite definition identifies its database fixtures and replaced clients, hooks, clocks or executors. Integration runs use the prepared database; lifecycle runs exercise the in-process route or adapter path.

## Must Not Be Doubled

The database constraints, transactions and service behavior claimed by an integration binding must execute. Replaced external seams cannot establish live provider or infrastructure behavior.