---

title: 00 — Package Index — Registries/Pivot OS Agency Surface Master Design date: 2026-05-30 status: PASS (master design + dress-rehearsal plan, READ-ONLY, zero mutation) route_target: /knowledge/registries-pivot

Registries/Pivot OS Agency Surface — Master Design & Dress Rehearsal

Mission: REGISTRIES_PIVOT_OS_AGENCY_SURFACE_MASTER_DESIGN_AND_DRESS_REHEARSAL Class: master design + no-hardcode audit + PG-first pivot data contract + dress-rehearsal plan. Host: contabo VPS · DB: Docker postgres → database directus · PG role: context_pack_readonly (READ ONLY tx). Mutation this session: NONE (no PG/Directus/Qdrant write, no Nuxt prod change, no schema).

Documents

1. 01-overview-control.md — overview, control, Gate 0 evidence
2. 02-law-source-compliance.md — law/source compliance map
3. 03-registries-page-audit.md — /knowledge/registries audit + UX-idea classification
4. 04-pivot-page-audit.md — /knowledge/pivot audit
5. 05-pg-substrate-mapping.md — live PG substrate mapping + reuse verdicts
6. 06-no-hardcode-doctrine-and-audit.md — banned patterns + audit findings
7. 07-data-contract.md — PG-first recursive drill-down node/tree contract
8. 08-pivot-only-count-design.md — every number → pivot source / PIVOT_MISSING
9. 09-route-ui-structure-recommendation.md — route strategy + recursive UI structure
10. 10-dress-rehearsal-plan.md — backend/API/Nuxt rehearsal (design only)
11. 11-test-acceptance-harness.md — no-hardcode/parity/pivot-only/drill/leaf tests
12. 12-implementation-prompts.md — gated implementation prompts
13. 13-self-review.md — self-review + acceptance verdict + integrity erratum

Headline verdicts

• Foundation already exists — pivot engine (37 pivot_definitions, pivot_count(), pivot_results 126), registry/species/birth substrate all live. The new surface is a convergence/render-shell, not new infrastructure.
• Route: build /knowledge/registries-pivot as the convergence target (OS Agency canonical surface) that supersedes /knowledge/registries and absorbs /knowledge/pivot's clean counting; legacy routes redirect after parity. Net counting surfaces do not increase (reconciles mission's "new canonical route" with prior council's "no third drift surface").
• No-hardcode verdict: /knowledge/registries VIOLATES Điều 28 (phantom hardcoded rows + Nuxt-side gap math + reads meta_catalog.record_count). /knowledge/pivot is mostly compliant render-shell but mixes 2 stale meta_catalog-sourced rows (DOT 307, Collections 168) into an otherwise pivot table.
• Pivot-only count verdict: achievable. Composition/species/DOT/collection/birth/page/workflow/task counts already have a pivot (PIV-001..021, PIV-101..106, PIV-201..207, MTX-*). PIVOT_MISSING: grand-total objects, Information Units (219), KG edges, drift-count, stale-count, total-active-pivots, orphan-totals, coverage (missing-birth/iu/dot/pivot) — proposed as new pivot_definitions rows / read-only views (Điều 26 + Điều 32 gated, doc 08).
• Drill-down (user addendum): the surface is a recursive registry drill-down, not a flat dashboard — count>1 ⇒ backend generates an inner layer; depth is variable; leaf = the object's own DB/relationship substrate (doc 07).
• Implementation readiness: design-complete; blocked only on count-integrity reconcile + GPT/User ratification. No implementation/mutation performed.
• Integrity note: initial drafts of docs 02/05/07/08 (written before the delayed MCP result-batch flushed) contained fabricated pivot codes/owners/tables; all corrected against live data before any KB upload (doc 13 erratum).