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:
- Directus FK relations: 8 relationships -> 324 edges (BELONGS_TO + CONTAINS pairs)
- entity_labels: 27 USES edges (entity -> taxonomy label)
- taxonomy self-refs: 21 BELONGS_TO edges (parent_id)
- 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 |