14 — Safe Live Artifacts Report

All artifacts in directus DB. Applied 2026-06-04 in one transaction. BIRTH-FREE: birth_registry 1,163,522 before == 1,163,522 after. Reversible via uwc_rollback.sql.

Tables created (8 + 1 log; trigger-free, no birth)

workflow_discovery_source_registry (16 rows), workflow_scanner_registry (5), wf_census_digest (16), wf_orphan_digest (7), wf_rp_coverage_digest (6), wf_source_adapter_health (16), wf_metric_snapshot (1), wf_classification_drift (6 BASELINE), wf_scanner_run_log (5).

Functions created (6)

fn_dot_wf_universal_census, fn_dot_wf_orphan_detector, fn_dot_wf_rp_visibility_proof, fn_dot_wf_source_adapter_health, fn_dot_wf_classification_drift, fn_dot_wf_run_all. All read-only against production + idempotent digest writes.

Views created (16)

v_universal_workflow_source_census, v_universal_workflow_coverage_matrix, v_universal_workflow_uncovered_objects, v_universal_workflow_classification_summary, v_workflow_orphan_components, v_workflow_unmanaged_process_clusters, v_workflow_rp_missing_processes, v_workflow_phantom_process_candidates, v_registries_pivot_process_coverage_proof, v_registries_pivot_process_missing_surface, v_registries_pivot_process_operational_status, v_workflow_discovery_source_health, v_workflow_discovery_source_missing_adapter, v_process_axis_review_action_queue_v2, v_process_axis_census_action_items, v_process_axis_universal_workflow_dashboard.

Inserts into existing trigger-free tables

• process_axis_action_vocabulary: +2 (REGISTER_SOURCE_ADAPTER, REQUEST_MERGE), is_checkbox=false.
• process_axis_ai_review: +7 coverage verdicts (verified no triggers on this table before insert).

Forbidden actions — NONE taken

No process birth, no owner approval, no event activation, no production DOT execution, no REAL_RUN, no agent_api mutation, no source IU edit, no workflow execution, no dot_tools insert, no checkbox/direct-mutation approval, no fake AI review.

Verification (MCP read-back, RO query_pg)

All 16 views queryable without timeout (they read digest tables). Coverage matrix, RP coverage proof, orphan digest, adapter health, dashboard, and census action items all returned coherent live values. Birth count re-checked post-apply = 1,163,522.

Rollback

Staged at /opt/incomex/docs/mcp-writes/universal-workflow-census-2026-06-04/uwc_rollback.sql — drops 16 views, 6 functions, 9 tables, and the 2 vocab + 7 review rows. Reversible.