---
id: TST-PFM-INT-500
title: integration connections 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-connections.table.integration.spec.js
implements:
  - ATS-PFM-INT-004-03
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-connections.table.integration.spec.js
test_cases:
  - source: >-
      services-platform:modules/integrations/tests/integration/db/integration-connections.table.integration.spec.js#refuses
      a second connection of the same name under the installation
    provenance: test
  - source: >-
      services-platform:modules/integrations/tests/integration/db/integration-connections.table.integration.spec.js#refuses
      the same provider account connected twice under the installation
    provenance: test
  - source: >-
      services-platform:modules/integrations/tests/integration/db/integration-connections.table.integration.spec.js#accepts
      the account again beside a disconnected connection of it
    provenance: test
  - source: >-
      services-platform:modules/integrations/tests/integration/db/integration-connections.table.integration.spec.js#refuses
      a connection naming an installation of another tenant
    provenance: test
  - source: >-
      services-platform:modules/integrations/tests/integration/db/integration-connections.table.integration.spec.js#refuses
      a disconnected connection with no disconnection instant
    provenance: test
  - source: >-
      services-platform:modules/integrations/tests/integration/db/integration-connections.table.integration.spec.js#refuses
      a status outside the state machine
    provenance: test
  - source: >-
      services-platform:modules/integrations/tests/integration/db/integration-connections.table.integration.spec.js#trims
      every string and stores a blank one as null
    provenance: test
  - source: >-
      services-platform:modules/integrations/tests/integration/db/integration-connections.table.integration.spec.js#answers
      another tenant none of the tenant’s connections, with no predicate
    provenance: test
  - source: >-
      services-platform:modules/integrations/tests/integration/db/integration-connections.table.integration.spec.js#refuses
      a UUID
    provenance: test
  - source: >-
      services-platform:modules/integrations/tests/integration/db/integration-connections.table.integration.spec.js#refuses
      an uppercase id
    provenance: test
  - source: >-
      services-platform:modules/integrations/tests/integration/db/integration-connections.table.integration.spec.js#refuses
      an id with a double underscore
    provenance: test
  - source: >-
      services-platform:modules/integrations/tests/integration/db/integration-connections.table.integration.spec.js#refuses
      an id Rhythm keeps for the connections it ships
    provenance: test
  - source: >-
      services-platform:modules/integrations/tests/integration/db/integration-connections.table.integration.spec.js#accepts
      an id in the grammar, the negative control
    provenance: test
  - source: >-
      services-platform:modules/integrations/tests/integration/db/integration-connections.table.integration.spec.js#refuses
      the id of another connection of the same tenant
    provenance: test
  - source: >-
      services-platform:modules/integrations/tests/integration/db/integration-connections.table.integration.spec.js#accepts
      the id of a connection of another tenant, the primary key being (tenant_id, id)
    provenance: test
dependency_evidence:
  provenance: test
  source: >-
    services-platform:modules/integrations/tests/integration/db/integration-connections.table.integration.spec.js
  reviewed:
    - Suite introduction
    - Fixture setup
    - Client substitutions
    - Assertions and cleanup
---
# integration connections table

## Verification Boundary

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

## What This Suite Proves

The bindings identify the detailed outcomes asserted by this suite. Test-level evidence retains the individual checks, including cases where several suites contribute to one scenario.

## 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.