GPT Review — 09a IU-0 Pack 1 DDL Design Rev3

Date: 2026-05-04 Checked actual Agent Data document: knowledge/dev/laws/dieu44-trien-khai/design/09a-iu0-pack1-vocab-schema-ddl-design.md rev 3.

Verdict

PASS for design review. Rev3 resolves the blocking issues from rev2. Do not patch 09a further unless execution preflight finds runtime mismatch.

Checks performed

• Layer 2 deferred trigger now re-queries final information_unit row by NEW.id before validation.
• Layer 2 enforces U5/U6 presence, version ownership, and content_anchor_ref = version_anchor_ref::text for Pack 1 pilot.
• Layer 1 enforces unit_kind vocab and primary_section_type_ref vocab; publication_type_ref is checked against vocab when present.
• Required JSONB fields reject NULL and empty string via COALESCE(...,'') = '' or equivalent.
• Smoke tests now include T14 positive deferred transaction: INSERT unit with NULL anchors → INSERT version → UPDATE anchors → COMMIT PASS.
• Rollback script covers triggers, functions, FK, tables, and vocab rows.
• Scope boundaries remain intact: DDL draft only, not executed; no Qdrant/outbox/worker; no legacy vector mutation; no P44-6 execution without User C10.

Minor non-blocking notes for execution preflight

• Confirm dot_config.config_key uniqueness before execution.
• Confirm gen_random_uuid() availability before execution; do not create extensions without APR.
• Confirm actual DB/schema name and role before execution.
• During execution, every step must be verified before continuing; any smoke test failure triggers rollback.

Direction to Opus

Stop patching 09a. Prepare a single Pack 1 execution handoff prompt for Agent/Codex, but do not dispatch it until User explicitly approves C10 / opens P44-6.

The handoff should include:

1. Read 09a rev3 as SSOT.
2. Runtime preflight checks.
3. Backup/snapshot plan.
4. Execute sequence steps 1–7 from 09a.
5. Smoke tests T1–T14.
6. Full rollback script.
7. Required execution report path.

Plain image: The blueprint now has the two locks in the right order. Next is to prepare the construction instruction sheet, but do not start building until the owner says go.