IU Core MVP — 01 Precheck + Live Schema Survey

Date: 2026-05-21 · Macro: v0.6-iu-core-mvp-pg-native-parent-child-structure-ops-authoring Production mutation: NONE · DDL executed: NO · DB write: NO

Host / repo precheck — PASS

• Host: Nguyens-MacBook-Air.local (Darwin 25.5.0 arm64) — MacBook/dev host. Correct.
• Repo: /Users/nmhuyen/iu-cutter-build/repo/iu-cutter exists.
• Branch: main · HEAD before work: f111d4a · tree clean (no dirty files).
• Recent log: f111d4a O10 generic intake, fdcf580 O8F, cad989a O8D.
• KB read/upload via Agent Data MCP: confirmed working.

VPS read-only survey — PASS

SSH root@38.242.240.89 (vmi3080463); docker exec postgres psql -U directus -d directus. All queries read-only. No write, no DDL.

iu=158  uv=165  iu_lifecycle_log=60  information_unit.parent_or_container_ref NOT NULL = 0
IU_CORE tables present (iu_sql_link/iu_sql_event_route/iu_outbound_route/
  iu_route_attempt/iu_tree_path/iu_relation/iu_structure_operation) = NONE
event tables present: event_outbox, event_pending, event_type_registry, universal_edges
event_type_registry: system/issue_opened, system/issue_resolved,
  system/issue_archived, system/red_zone_violation  (NO iu/iu_sql events)
event_outbox NOT NULL cols: id, event_domain, event_type, event_stream,
  delivery_lane, event_subject_table, canonical_address, actor_ref,
  source_system, payload_classification, safe_payload, occurred_at, created_at
  (event_subject_ref is NULLABLE)
cutter_governance: cut_change_set, cut_change_set_affected_row,
  review_decision, verify_result — all present

Reconciliation against the three prior briefs

The survey was cross-checked against, and fully agrees with:

• v0.6-iu-pg-native-trigger-model-survey-design (report 2026-05-21)
• v0.6-iu-pg-native-ddl-authoring-brief (2026-05-21)
• v0.6-iu-parent-child-split-merge-brief (2026-05-21)

Brief assumption	Live today	Verdict
information_unit ≈ 158 rows	158	MATCH
unit_version ≈ 165 rows	165	MATCH
iu_lifecycle_log = 60 rows	60	MATCH
parent_or_container_ref exists, 0 live parents	column exists, 0 parented	MATCH
no iu_sql_link / route / relation tables	none present	MATCH (greenfield)
event_type_registry has no IU event types	only 4 system types	MATCH
event substrate (outbox/pending/registry) exists	all present	MATCH

No schema contradiction found. The IU-core surface is greenfield — zero drift risk for additive CREATE TABLE DDL.

Roadmap input

~/Desktop/ROADMAP - Miếng thông tin.docx read. Confirms this macro targets roadmap groups 2 (Miếng↔SQL/PG-native), 3 (add/split/merge/delete), 4 (parent-child multi-level) and the mandatory two-way trigger model.

Verdict

Precheck PASS. Host, repo, KB, and read-only DB access all confirmed. Live schema reconciled with all three briefs with zero contradictions. Authoring may proceed.