dot-iu-cutter v0.2 — P0-6 + P0-5 Remainder DDL Authoring Report

document_path: knowledge/dev/laws/dieu44-trien-khai/v0.2-ddl-authoring/dot-iu-cutter-v0.2-p0-6-p0-5-remainder-ddl-authoring-report-2026-05-16.md
revision: r2
supersedes: r1 (2026-05-16)
date: 2026-05-16
author: Agent (Claude Code CLI, Opus 4.7 1M)
sovereign: User / anh Huyên
verifier: GPT (P0-6 + P0-5-remainder r2 DDL re-revision review — PENDING)
phase: v0.2 — P0-6 + P0-5-remainder DDL AUTHORING REVISION (consolidated report r2)
a1_status: RESOLVED by r2
ddl_authored: true
ddl_executed: false
dry_run_started: false
dry_run_allowed: false (until GPT r2 review PASS)
production_migration_allowed: false

---

§1 — r2 Statement (mandatory facts)

A-1_resolved_by_r2: TRUE
live_parent_PK: cutter_governance.decision_backlog_entry PRIMARY KEY (entry_id); entry_id uuid
  (production read-only catalog observation, 2026-05-16; SELECT-only; zero mutation)
r1_status: SUPERSEDED — DO NOT EXECUTE r1 (referenced non-existent decision_id column)
fk_count_after_r2: 7 (unchanged)
cutter_governance_table_count_after_later_execution: 12 (unchanged: 8 → 12)
production_migration_allowed: FALSE
dry_run_allowed: FALSE (until GPT r2 review PASS)
gpt_selected_fix: rename child columns to the entry_id family

§2 — Files & Revisions (all in …/v0.2-ddl-authoring/)

#	File	Rev	r2 change
1	…-p0-6-p0-5-remainder-ddl-draft-2026-05-16.sql.md	r2	child column renames + FK targets → decision_backlog_entry(entry_id); r1 supersede banner; A-1 resolution §1
2	…-p0-6-p0-5-remainder-verification-plan-2026-05-16.md	r2	V-DBE-PK expected = (entry_id,uuid); FK checks V-10d/e on entry_id; V-21/V-21a rename assertions
3	…-p0-6-p0-5-remainder-rollback-draft-2026-05-16.md	r2	body unchanged (structural DROP; no column-name dependency); revision bumped for package coherence + status flags
4	…-p0-6-p0-5-remainder-risk-review-note-2026-05-16.md	r2	RS-2 retired (A-1 resolved); RS-12 added (r1 stale-exec guard); risk class STANDARD unchanged
5	…-p0-6-p0-5-remainder-ddl-authoring-report-2026-05-16.md	r2	this consolidated report

No file remained r1. All 5 are r2 so the package carries a single coherent revision and the r1-superseded / dry-run-gated flags everywhere. File 3's body is unchanged (it never referenced child column names — pure DROP TABLE); only its header/status were bumped, which is documented in that file's §0.

§3 — Exact r2 Column-Name Changes

decision_backlog_history:
  decision_id            -> entry_id            (FK -> decision_backlog_entry(entry_id))
decision_backlog_dependency:
  from_decision_id        -> from_entry_id       (FK -> decision_backlog_entry(entry_id))
  to_decision_id          -> to_entry_id         (FK -> decision_backlog_entry(entry_id))
review_decision: NO CHANGE (FKs target manifest_envelope/manifest_unit_block/self)
escalation_ref: NO CHANGE (SOFT uuid to decision_backlog_entry; no FK; name kept)
forbidden_in_r2: decision_id / from_decision_id / to_decision_id (none survive)
column_counts_unchanged: review_decision=25, history=9, dependency=6, sweep_log=10

§4 — FK Summary After r2 (7 in-schema FKs; 0 cross-schema)

#	FK	Child → Parent	Status
1	review_decision_manifest_fk	review_decision.manifest_id → manifest_envelope.envelope_id	unchanged
2	review_decision_unit_block_fk	review_decision(manifest_id, manifest_unit_local_id) → manifest_unit_block(envelope_id, unit_local_id)	unchanged (nullable composite, MATCH SIMPLE)
3	review_decision_prior_fk	review_decision.prior_review_decision_id → review_decision.review_decision_id	unchanged (self)
4	review_decision_superseded_fk	review_decision.superseded_by_review_decision_id → review_decision.review_decision_id	unchanged (self)
5	decision_backlog_history_entry_fk	decision_backlog_history.entry_id → decision_backlog_entry.entry_id	r2 corrected
6	decision_backlog_dependency_from_fk	decision_backlog_dependency.from_entry_id → decision_backlog_entry.entry_id	r2 corrected
7	decision_backlog_dependency_to_fk	decision_backlog_dependency.to_entry_id → decision_backlog_entry.entry_id	r2 corrected

Soft refs (no PG FK): review_decision.escalation_ref → decision_backlog_entry, review_decision.cut_change_set_ref → cut_change_set. decision_backlog_sweep_log = zero FK. Cross-schema FK: none.

§5 — Verification / Rollback Summary (r2)

verification_r2: pre-exec hard gate now CONFIRMS decision_backlog_entry PK =
  (entry_id, uuid); V-10d/V-10e assert history/dependency FKs target entry_id;
  V-21a asserts no residual decision_id-family column; all read-only, NOT executed
rollback_r2: structural DROP of the 4 empty tables (body unchanged from r1);
  no inter-batch parent→child FK; decision_backlog_entry NOT dropped/altered;
  post-rollback count back to 8; NOT executed
risk_r2: STANDARD (carried; A-1 fix is a name correction, risk-neutral)

§6 — Readiness for GPT Re-Review

r2_status: ready_for_gpt_re_review
all_5_docs_r2: TRUE
internally_consistent: TRUE
  - DDL ↔ verification ↔ rollback ↔ report names all use entry_id family
  - A-1 resolved + r1 superseded stated in every doc
  - FK count 7, table count 8→12, no forbidden object — all unchanged
  - risk STANDARD carried
ddl_executed: FALSE
dry_run_started: FALSE
dry_run_allowed: FALSE (until GPT r2 review PASS)
production_migration_allowed: FALSE
next_gate: GPT re-review of the r2 package → (if PASS) explicit dry-run
  authorization → fresh isolated dry-run env. Agent self-advance PROHIBITED.

§7 — Negative Confirmations

r1_superseded_do_not_execute: TRUE
no_DDL_executed: TRUE
no_psql_invoked_for_mutation: TRUE (A-1 resolved via prior read-only catalog SELECT only)
no_dry_run_started: TRUE
no_dry_run_env_provisioned: TRUE
no_production_touch: TRUE
no_DB_mutation: TRUE
no_PG_enum / no_lookup_table / no_dieu24_lookup_FK / no_cross_schema_FK: TRUE
no_CHECK / no_trigger / no_DEFAULT / no_seed / no_backfill: TRUE
no_decision_id_family_name_in_r2: TRUE
no_self_advance: TRUE
protected_dry_run_envs_untouched: TRUE
output_form: p0_6_p0_5_remainder_ddl_authoring_report_r2

§8 — Cross-References

a1_halt_gpt_review: knowledge/dev/laws/dieu44-trien-khai/reviews/dot-iu-cutter-v0.2-p0-6-p0-5-remainder-a1-halt-gpt-review-2026-05-16.md
dry_run_halt_docs:  knowledge/dev/laws/dieu44-trien-khai/v0.2-dry-run/dot-iu-cutter-v0.2-p0-6-p0-5-remainder-dry-run-*-2026-05-16.md
design_set:         knowledge/dev/laws/dieu44-trien-khai/v0.2-design/dot-iu-cutter-v0.2-p0-6-p0-5-remainder-*  + p0-6-review-decision + p0-5-*
this_set_r2:        knowledge/dev/laws/dieu44-trien-khai/v0.2-ddl-authoring/dot-iu-cutter-v0.2-p0-6-p0-5-remainder-*-2026-05-16*  (all r2)

End of P0-6 + P0-5-remainder DDL authoring report (r2, A-1 resolved).