Copy/Paste Agent Prompt — B3-P Policy Storage DDL rev2

Date: 2026-05-12 Recommended effort: medium Mode: DDL only — add PG-native coverage policy columns to collection_registry

Prompt

Run the approved P3D Birth B3-P Policy Storage DDL prompt rev2.

Recommended effort: medium.

Read first:

knowledge/dev/laws/dieu44-trien-khai/reviews/gpt-final-review-b3p-ddl-rev2-approved-population-pending-2026-05-12.md
knowledge/dev/laws/dieu44-trien-khai/prompts/p3d-birth-b3p-policy-storage-ddl-prompt-DRAFT.md
knowledge/dev/laws/dieu44-trien-khai/reports/p3d-birth-system-b3p-rev2-policy-prompt-hardening-report.md

Then execute exactly:

knowledge/dev/laws/dieu44-trien-khai/prompts/p3d-birth-b3p-policy-storage-ddl-prompt-DRAFT.md

Goal:

Add the 6 approved coverage policy columns and CHECK constraints to collection_registry, with DDL-only safety controls.

Approved policy columns:

coverage_status
coverage_scope_status
coverage_exemption_reason
coverage_review_owner
coverage_decided_at
coverage_decided_by

Hard boundaries:

• DDL allowed: ALTER TABLE ADD COLUMN and ADD CONSTRAINT only.
• No data mutation.
• No trigger creation.
• No function creation.
• No DROP during forward execution.
• No policy population.
• No B3-A trigger install.
• No B3-F onboarding gate.
• No 5C2 migration.
• No UI/Nuxt change.
• No external tools.
• Stop on any existing incompatible column/constraint.
• Use advisory lock and single transaction.
• Log compiled SQL and rollback SQL before execution.

Expected report path:

knowledge/dev/laws/dieu44-trien-khai/reports/p3d-birth-system-b3p-policy-storage-ddl-execution-report.md

Final response format:

b3p_ddl_status=PASS|PARTIAL|BLOCKED|LOCK_BUSY
resolved_schema=<schema>
resolved_collection_registry_table=<table>
columns_added=<N>
columns_already_existed=<N>
columns_blocked_conflict=<N>
constraints_added=<N>
constraints_already_existed=<N>
constraints_blocked_conflict=<N>
added_column_names=<list>
added_constraint_names=<list>
compiled_sql_logged=true|false
rollback_sql_logged=true|false
execution_log_path=<path>
report_path=knowledge/dev/laws/dieu44-trien-khai/reports/p3d-birth-system-b3p-policy-storage-ddl-execution-report.md
no_data_mutation=true
post_ddl_verified=true|false
next_recommended_action=GPT_REVIEW_DDL_RESULT_THEN_B3P_POPULATION

Return only the final response format plus critical blocker notes. Do not write a long essay.