Task: Add the run detail tables

Table of Contents

This page documents a task in the Trace a process run and the trade groups it creates — the remaining work story. It captures the goal, current status, acceptance, and any notes or results.

1. Goal

Each kind of run records its own facts in a detail table keyed by the run.

2. Status

Field Value
State BACKLOG
Parent story Trace a process run and the trade groups it creates — the remaining work
Now Not yet started.
Waiting on The run record, which each detail table keys to.
Next Add the detail table of the pilot process first.
Last touched 2026-10-08

3. Acceptance

  • Compression, allocation, merge, roll, sweep and bulk book move detail tables exist, each keyed by the process run with an enforced foreign key.
  • The process named by a run states which detail table, if any, a run of that process carries; a pgTAP test refuses a detail row of the wrong process.
  • No detail table is keyed by a trade activity: the activity is the stamp on an amendment, and the run is the parent here.

4. Plan

(Implementation strategy. Written when work starts; key decisions are distilled into the parent story's * Decisions at close, but the plan itself stays — it is the historical record of what we did.)

5. Measurements

Every number this task claims about a tree, with the command that produced it and the commit it was measured at. A number without both is not a measurement, because a clean-up record describes a tree and trunk moves under a branch: a consumer count, a gate's component count and a suite's size all change with no code changing, and the reader of a bare number cannot tell which tree it came from. Where the raw output matters, put it in an evidence/ file beside the task and name that file in the Command column.

What Value Command Commit
       

6. Notes

7. Test Scenarios

Manual QA scenarios (scaffolded via compass add test_scenario) that verify this task. Link new ones here as they're created; the scenario doc itself links back via its "Verifies task" field.

Scenario State Notes
     

8. PRs

PR Title
   

9. Review

Comment summary File Decision Notes
       

10. Result

Emacs 29.3 (Org mode 9.6.15)