RP UI Axis — 01 Live Axis Surface & SSOT Confirmation
01 — Live Axis Surface & SSOT Confirmation
All objects re-verified against production on 2026-06-04 (not trusted from prior reports).
Execution channel
query_pg(MCP): role read-only,transaction_read_onlyenforced, 5s timeout, LIMIT 500.- RW:
ssh contabo → docker exec -i postgres psql -U directus -d directus→current_user=directus,transaction_read_only=off.directusowns the axis objects (consistent with prior macro). - Mode classified: EXECUTION_MODE (additive only).
Live substrate (verified counts)
| Object | Expected (SSOT) | Live 2026-06-04 | Match |
|---|---|---|---|
| axis_registry rows | 1 | 1 (AX-TOPIC = CANDIDATE) | ✓ |
| axis_assignment rows | 25 | 25 | ✓ |
| axis_assignment distinct nodes | 7 | 7 | ✓ |
| v_registries_pivot_axis_surface rows | 7 | 7 | ✓ |
| v_axis_topic_pivots rows | 14 | 14 | ✓ |
| fn_topic_node_substrate | LIVE | LIVE (tested) | ✓ |
AX-TOPIC registry row (live)
axis_code=AX-TOPIC, axis_name="Chu de noi dung (Topic Axis)", domain=content_topic, node_source=taxonomy, node_filter={facet_id:9, facet_code:FAC-08}, relation_source=taxonomy.parent_id UNION universal_edges[broader,narrower,related], lifecycle_field=taxonomy.status, owner_governance_ref="GOV-COUNCIL (pending ratification)", substrate_resolver=fn_topic_node_substrate, pivots_ref=v_axis_topic_pivots, status=CANDIDATE, approval_ref=NULL.
FAC-08 facet (live)
taxonomy_facets.id=9, code=FAC-08, name="Chủ đề nội dung?", status=active, cardinality=single, max_labels_per_entity=0. The facet is active; it has 0 taxonomy nodes (taxonomy WHERE facet_id=9 = 0). Taxonomy total = 58, active = 57.
7 candidate nodes (live, with evidence)
| node_code | IU/assignments | evidence tags |
|---|---|---|
| TOPIC-CAND:knowledge_graph | 10 | 10 |
| TOPIC-CAND:architecture | 5 | 5 |
| TOPIC-CAND:governance | 3 | 3 |
| TOPIC-CAND:dot_trigger | 3 | 3 |
| TOPIC-CAND:workflow | 2 | 2 |
| TOPIC-CAND:cut_pipeline | 1 | 1 |
| TOPIC-CAND:render_pipeline | 1 | 1 |
Total 25 assignments / 7 nodes. Source provenance: iu_metadata_tag WHERE tag_key LIKE 'topic:%' = 25 tags / 16 distinct IUs / 7 distinct keys — exactly matches axis_assignment. Source tags untouched. Every assignment carries evidence_ref = 'iu_metadata_tag:<uuid>', source='inferred', status='candidate', _dot_origin='MACRO:topic-axis-ratify-apply-pilot-2026-06-04'.
Surface view (live)
All 7 rows: lifecycle_status=candidate, governance_status=UNGOVERNED_CANDIDATE, parent_codes=[], has_multiple_parents=false, warning_flags={CANDIDATE_NODE, ORPHAN_TOPIC_NODE}, grouping_status=OK, pin_state=UNPINNED. DAG machinery present (arrays everywhere) but no edges yet.
Pivots view (live)
PIV-310 Documents Total = 5,737 FINAL_COMPUTABLE (grew from 5,723 — confirms it reads live). PIV-320 Approved root topics = 0 NEEDS_GOV_COUNCIL_APPROVAL. PIV-321/322 Topic nodes/candidates = 7 CANDIDATE. PIV-323 edges = 0. PIV-326 IU-by-topic assignments = 25. PIV-327/328 workflows/DOTs by topic = 0 DEFER_NO_SOURCE. PIV-329 orphan topics = 7. PIV-332 governance gap = 7.
Resolver (live test on TOPIC-CAND:knowledge_graph)
Returned: 10 information_units, 10 evidence_tags, taxonomy_node=null, birth_record=null, governance_owner=null, parent_codes=[], lifecycle_status=candidate, empty documents/workflows/dots. Exactly correct for an ungoverned candidate — proves no birth was triggered.
Governance / approval substrate (live existence)
universal_edges ✓ (2,199 rows), approval_requests ✓ (live working table; request_types: birth_orphan/reclassify/schema_modify/fix_repair_dot/accuracy_drift/new_dot/schema_add — no axis/topic type yet), event_type_registry ✓, governance_object_ownership ✓ but 0 rows system-wide, governance_responsibility_scope ✓, registry_pin ✓, iu_metadata_tag ✓.
Conclusion
SSOT confirmed against live prod with zero drift (only PIV-310 grew, as expected for a live count). Safe to proceed in EXECUTION_MODE with additive-only work.