P3D Pack 1 — Design Addendum + Phase 2 Prompt — Report

Date: 2026-05-11 Author: Opus 4.7

Status

phase_status=PASS
mode=DESIGN_ADDENDUM_AND_PHASE2_PROMPT
pack1_design=PATCHED_WITH_INVENTORY
phase2_prompt=DRAFT_READY_FOR_GPT_REVIEW
implementation_allowed=false
no_mutation_performed=true
next_action=GPT_REVIEW_PHASE2_PROMPT

Deliverables

#	Output	Path	Status
1	Design addendum (full mapping + hash + vocab + fields)	design/p3d-pack1-design-addendum-post-inventory-2026-05-11.md	✅
2	Phase 2 DDL prompt DRAFT	prompts/p3d-pack1-phase2-ddl-extend-implementation-prompt.md	✅ DRAFT
3	Report (this file)	reports/p3d-pack1-design-addendum-and-phase2-prompt-report.md	✅

Key Findings from Inventory

1. Hash ≠ md5(body) on both sides (100% mismatch) — Phase 2 preflight MUST investigate actual algorithm
2. TAC has 11 extra UV columns IU doesn't have — Phase 2 adds 10 of them + 3 LU columns
3. Vocab FK on TAC, plain text on IU — reconciliation deferred to Phase 3 (FK addition)
4. 0 canonical_address overlap — clean migration space confirmed
5. Publication membership intact — 86 members, dense render_order, preserved as separate family

Phase 2 Scope (DDL only, no data)

• ADD 3 columns to information_unit (doc_code, section_type, section_code)
• ADD 10 columns to unit_version (title, description, review_state, provenance, editor, enacted_at, updated_at, vector_sync_status, vector_synced_at, vector_chunk_count)
• All NULLABLE (existing pilot rows get NULL)
• Hash investigation in preflight
• Gateway verify after DDL
• Rollback DDL ready

---

Report | 2026-05-11 | Opus 4.7