P3D — B3-F1 Soft Gate Design Report (revised)

Date: 2026-05-12 Rev: 2

---

b3f1_soft_gate_design_status=REVISED
b3f1a_mode=READ_ONLY_COMPILE_ONLY
b3f1b_execution_allowed=false
create_function_allowed=false
create_trigger_allowed=false
pg_mutation_allowed=false
hard_gate_allowed=false
raise_exception_allowed=false
two_pass_rule_compliant=true
next_recommended_action=GPT_REVIEW_B3F1_REVISED_DESIGN_AND_B3F1A_PROMPT

Artifacts

#	Path
1	design/p3d-birth-system-b3f1-soft-gate-design.md (rev 2)
2	prompts/p3d-birth-system-b3f1a-soft-gate-shape-probe-and-sql-artifact-prompt-DRAFT.md (new)
3	This report (rev 2)

4 fixes from GPT review

1. Two-pass compliant — B3-F1a compile-only → GPT review → B3-F1b execute. No derive+execute in one run.
2. Trigger coverage expanded — 5 columns: governance_role, coverage_status, coverage_scope_status, coverage_exemption_reason, coverage_review_owner.
3. system_issues shape probed live — Phase 1 full schema introspection before any compile. BLOCKED if insufficient.
4. Dedup from live shape — Probe unique constraints/indexes. Prefer structured key. Fallback to entity_ref+category+status check only with live-supported status semantics; do not hardcode terminal statuses such as resolved/closed without evidence.

SQL artifacts (produced by B3-F1a, stored in KB)

artifacts/p3d-birth-system-b3f1a-soft-gate-compiled-function.sql.md
artifacts/p3d-birth-system-b3f1a-soft-gate-compiled-trigger.sql.md
artifacts/p3d-birth-system-b3f1a-soft-gate-rollback.sql.md
artifacts/p3d-birth-system-b3f1a-soft-gate-full-scan-query.sql.md

---

B3-F1 Report revised | Two-pass | 2026-05-12