Checkpoint — Topic Axis Self-Operated Advance 2026-06-04
Checkpoint — Topic Axis Self-Operated Advance (short SSOT)
Date: 2026-06-04 Macro: TOPIC_AXIS_SELF_OPERATED_DECISION_QUEUE_UI_CONTENT_AUTOMATION Final status: PARTIAL — every safe/additive/reversible branch self-operated and committed live; only genuine human/legal decisions remain. Execution mode: EXECUTION_MODE. prod = query_pg RO + ssh contabo root → docker exec postgres psql -U directus RW. Live mutation: YES — 3 additive reversible objects (below). 0 taxonomy node, 0 promotion, 0 activation, 0 approval approved, 0 source-tag change.
Live objects committed
- 14
approval_requestsrows AXR-TOPIC-01..14, ALL status=pending (211→225). The human gate as an operational row-by-row queue covering all 7 decision categories. Side-effect: +14 governed provenance births (1,152,873→1,152,887; normal approval-insert path; disclosed; unretirable). v_axis_topic_governance_gap(read-only, 8 rows, all OWNER_MISSING).v_axis_topic_automation_candidates(read-only, 49 rows = 7 topics × 7 routing patterns, non-executing).
Status fields
- Approval workflow: LIVE queue, 14 pending, no fake approval (verified via independent MCP read-back).
- UI/API: DEPLOY-READY — 10 routes (7 prior + 3 NEW: approval-queue, governance-gap, automation-candidates) + tests + checklist (doc 03). Redeploy operator-gated.
- Content-map: COMPLETE — 7 candidates classified; knowledge_graph deep-mapped (10 IU hub, ∩architecture×3); cross-topic shared-IU adjacency graph found (doc 04).
- Automation bridge: PLAN LIVE as a view + pilot rows queued (AXR-TOPIC-13 verbs, AXR-TOPIC-14 KG).
- Governance bootstrap: GAP LIVE as a view + pending request AXR-TOPIC-12 (no active ownership faked; gov_object_ownership stays 0).
- End-to-end proof: COMPLETE, 9/9 on live data.
Two findings
action='add'approval_requests auto-approve (fn_auto_approve_add) → AI proposals must useaction='review'.- approval_requests births on insert; MCP RO role can't see triggers via
information_schema→ usepg_trigger.
Live numbers (2026-06-04, post-commit)
AX-TOPIC=CANDIDATE; assignments 25/7; surface 7; pivots 14; decision queue 7; taxonomy 58 (FAC-08=0 nodes); births 1,152,887; edges 2,199; gov ownership 0; gov scopes 6; approval_requests 225 (14 AXR-TOPIC pending); event types 45; source topic tags 25/16 IU.
Next macro
Primary: INFORMATION_PIECE_CONTENT_WORK_ON_CANDIDATE_TOPIC_SURFACE (no human gate; actionable now). Parallel: RP_UI_AXIS_SURFACE_DEPLOY (operator) + TOPIC_AXIS_OWNER_DECISION_AND_TAXONOMY_PROMOTION (owner drains AXR-TOPIC-* queue).
Exact blocker
GOV-COUNCIL FAC-08 root approval (Điều-32) + owner authorisation for unretirable taxonomy births + real owner_gov_code/OSPA for ownership + axis-law ratification. No engineering blocker. All queued as AXR-TOPIC-* pending rows.
Report path
knowledge/dev/reports/architecture/topic-axis-self-operated-decision-ui-content-automation-2026-06-04/ (docs 00–10).
Rollback: /tmp/axis_self_operated_rollback.sql.
Continues checkpoint-rp-ui-axis-decision-queue-2026-06-04.md.