---
id: TST-COM-FUL-024
title: Obligations table
kind: integration
product_area: commerce
module: fulfillment
revision: 1
status: draft
source_sha:
  services-commerce: c8b66a98e2490617aec38ba5c8165dd9bd0a8f9b
  react-console: baf6dae382d6f41dce976c7f848667ccc37e076f
repository: services-commerce
files:
  - modules/fulfillment/tests/integration/db/obligations.table.integration.spec.js
implements:
  - ATS-COM-FUL-004-03
  - ATS-COM-FUL-004-07
environment: local
implementation_state: implemented
latest_result: not-run
latest_run_at: null
latest_run_ref: null
conformance: not-verified
estimated_minutes: 3
isolation: >-
  Run-created workspace identifiers and fixture records in the prepared test database; concurrency
  cases own their extra connections.
evidence:
  - repository: services-commerce
    path: modules/fulfillment/tests/integration/db/obligations.table.integration.spec.js
    test_titles:
      - holds the two obligations (premise)
      - >-
        refuses a second obligation for the same subject, operation and unit, by
        obligations_subject_uq
      - lets another operation on the same subject in
      - 'refuses a second row under a taken authorization id, by obligations_authorization_uq'
      - >-
        refuses more completed than owed, and an operation or state outside the contract, by their
        checks
      - >-
        refuses moving a completed obligation anywhere but superseded, SQLSTATE RHC02, and lets it
        be superseded
      - 'lets a pending obligation move, and a cancelled one never again'
      - 'refuses deleting a line an obligation points at, by obligations_order_line_fk'
      - 'shows a tenant only its own obligations, and refuses one written into another tenant'
    scenario_anchors:
      - >-
        services-commerce:modules/fulfillment/tests/integration/db/obligations.table.integration.spec.js#refuses
        more completed than owed, and an operation or state outside the contract, by their checks
      - >-
        services-commerce:modules/fulfillment/tests/integration/db/obligations.table.integration.spec.js#refuses
        moving a completed obligation anywhere but superseded, SQLSTATE RHC02, and lets it be
        superseded
      - >-
        services-commerce:modules/fulfillment/tests/integration/db/obligations.table.integration.spec.js#refuses
        a second obligation for the same subject, operation and unit, by obligations_subject_uq
---

# Obligations table

## Verification Boundary

This suite checks obligations table against the prepared PostgreSQL database. Its entry points are the persistence and service functions used by the tests.

## What This Suite Proves

The bound scenarios identify the assertions this suite contributes. Source anchors retain the exact test cases; where a capability scenario has several contributing suites, a single binding does not imply that every branch runs here.

## What It Does Not Prove

Direct service and persistence calls do not establish the full HTTP permission contract, deployed scheduling or browser behavior. No execution result is claimed by this register.

## Real Dependencies and Test Doubles

The database and imported Commerce persistence services are real. Fixtures create the records owned by this run. Time-sensitive cases use a controlled clock where the source fixture supplies one.

## Must Not Be Doubled

Keep the database constraints, row visibility and persistence writes real when claiming this integration coverage. A canned repository response cannot replace the boundary being checked.