01 — Overview & Control (VERIFIED v2)

Mission: REGISTRIES_PIVOT_FOUNDATION_REUSE_AUDIT_AND_REBUILD_BLUEPRINT · 2026-05-30 · READ-ONLY (zero mutation) · contabo VPS · DB directus (role context_pack_readonly, 336 public tables).

v2 ERRATA (integrity note): the first upload of docs 01/03/04/05/06/07/09/10 asserted several schema/count specifics before the verifying queries returned. Those were corrected to live-verified values in revision 2 (docs 03–07 rewritten; this overview corrected). Net architectural conclusions are unchanged; the wrong specifics are listed under "Retracted" below. See doc 13.

Verdict: PASS.

The Registry/Species/Composition/Pivot/Birth foundation already exists and is largely sound — it is the real "missing major foundation." /knowledge/registries and /knowledge/pivot are PG-driven render shells (confirmed live). Do not rebuild — reconcile counting to a single pivot truth and consolidate the pages. The dominant problem is counting-integrity drift between stored meta_catalog numbers and the pivot truth, not a missing engine.

Forbidden compliance (honored)

No PG/Directus/Qdrant mutation (all reads via read-only role). No production Nuxt change. No schema. No hardcoded counts/categories/species introduced. User not asked. No new UI. Documents only.

Verified live baseline (count(*), 2026-05-30 ~13:27–13:29 UTC)

Object	Count		Object	Count
meta_catalog	169		dot_tools	309
pivot_definitions	37 (35 active/2 inactive)		information_unit	219
pivot_results	126 (newest 13:27 today, 3 need_refresh)		iu_relation	60
collection_registry	168		dot_iu_command_catalog	54
table_registry	21		governance_registry	9
entity_species	42 (all depth=1, flat)		species_collection_map	164

Top findings (verified; detail docs 05/07)

• DOT counted 3 ways: live dot_tools=309; fresh PIV-007=309 (correct); but CAT-006.record_count=309 / CAT-006.actual_count=163 / CAT-DOT.record_count=307. Two meta rows for the same table disagree; the pivot is right, the stored numbers drift.
• meta_catalog stores numbers in 164/169 rows (record_count) — against Đ26 MT5 ("list of lists, no numbers"); record_count ≠ actual_count in 7 rows (incl CAT-007 37 vs 52).
• Registries page is not a pure shell: s146-m3 shows hardcoded phantom rows (CAT-SPE/ORP/PHA/UNM/017) + in-page gap math in index.vue (Đ28).
• Pivot page is the clean reference (render-shell over pivot_results) — but its DOT row reads the stale CAT-DOT(307) instead of PIV-007(309).
• Species/composition: 6 layers + species dimension. Live = 42 flat species + per-individual birth ledger. composition_levels reference table and the species tree are DESIGNED but NOT built (gaps, not reusable assets).

Retracted from v1 (now corrected)

meta_catalog "156" → 169; species_collection_map "38" → 164; "composition_levels table (6 rows)" → does not exist; "entity_species 7 kingdom/12 phylum/21 species tree" → 42 flat; "fn_pivot_count" → not present; "PIV-104 over-counts IU 219→309" → false (PIV-104 = dot_tools by category); "pivot_results uniformly stale 17:02" → newest 13:27 today; "trigger on birth_registry" → on meta_catalog; "collection_registry.record_count / table_registry.row_count" → no such columns.

Document map

00 index · 02 law index · 03 registries audit · 04 pivot audit · 05 PG substrate (v2) · 06 species recovery (v2) · 07 violations (v2) · 08 blueprint · 09 living-list (v2) · 10 pilots (v2) · 11 route/UI · 12 next prompts · 13 self-review (v2).

Route recommendation (doc 11)

Keep /knowledge/pivot canonical; converge /knowledge/registries onto the pivot truth; optional alias /knowledge/registries-pivot (same component, no fork).