KB-72FC

S137A Backfill Report

2 min read Revision 1
reports137abackfillarchitecture-v3

S137A Backfill Report — Architecture v3.0 Phase 4

Session: S137A | Date: 2026-03-19 | Status: COMPLETE

Assembly Gate

Cau 0: YES — PG functions + INSERT data only.

lifecycle_log Backfill (Rule 8: 730 -> 0)

Created fn_backfill_lifecycle_log() — dynamic from meta_catalog. 827 rows inserted across 19 managed collections. Rule 8 Liveness violations: 730 -> 0.

universal_edges Backfill (Rule 4: 730 -> 563)

Created fn_backfill_universal_edges() — 3 edge sources:

  1. Directus FK relations: 8 relationships -> 324 edges (BELONGS_TO + CONTAINS pairs)
  2. entity_labels: 27 USES edges (entity -> taxonomy label)
  3. taxonomy self-refs: 21 BELONGS_TO edges (parent_id)
  4. Taxonomy -> taxonomy_facets: 78 edges (not available via managed-only FK)

Total: 450 edges created.

Remaining 563 Rule 4 violations: standalone entities with no FK relationships (dot_tools=111, collection_registry=105, trigger_registry=84, etc.). This is expected — Rule 4 is warning severity.

Engine Results Post-Backfill

Total violations: 1659 -> 762 (delta: -897)

Rule Before After Change
1 Identity 0 0 =
2 Registry 0 0 =
3 Classification 199 199 = (out of scope)
4 Connectivity 730 563 -167
5 Countability 0 0 =
6 Birth Control 0 0 =
8 Liveness 730 0 -730
9 Uniqueness 0 0 =
10 Traceability 0 0 =

Verification

# Check Result
1 lifecycle_log >700 rows PASS (827)
2 Rule 8 = 0 PASS
3 universal_edges >0 FK rows PASS (450)
4 Rule 4 < 730 PASS (563)
5 Delta << 0 PASS (-897)
6 Smoke test 17/17 PASS
7 verify_counts 0 PASS
8 Health Check 11/11 PASS