P3D Pack 1 Phase 4C — Species Mapping Strategy Design Report
P3D Pack 1 Phase 4C — Species Mapping Strategy Design Report
Date: 2026-05-11 Author: Opus 4.7
Status flags
phase4c_status=PASS
mode=DESIGN_AND_DRYRUN_PROMPT_ONLY
phase4b_discovery=PASS_ACCEPTED
species_seed_allowed=false
birth_backfill_allowed=false
migration_allowed=false
discriminator_strategy_analyzed=true
qt001_backfill_plan_included=true
post_implementation_design_rule_acknowledged=true
next_required_action=GPT_REVIEW_PHASE4C_DESIGN_AND_DRYRUN_PROMPT
Paths
| Artifact | Path |
|---|---|
| Design | ...design/p3d-pack1-phase4c-species-mapping-strategy-qt001-backfill-design.md |
| Mission prompt | ...prompts/p3d-pack1-phase4c-readonly-dryrun-species-mapping-qt001-prompt.md |
| This report | ...reports/p3d-pack1-phase4c-species-mapping-strategy-design-report.md |
Top 7 strategy decisions/questions
-
fn_birth_registry_auto KHÔNG đọc discriminator columns — schema hỗ trợ nhưng trigger function bỏ qua. Discriminator-based species resolution cần function enhancement (separate governance) hoặc post-birth correction. Đây là finding mới mà GPT cần biết.
-
Không có single species nào đúng cho cả design_doc_section (atom) và law_unit (compound nếu nesting preserved). Species ↔ composition là 1:1 trong entity_species. Hai unit_kinds với containment khác nhau KHÔNG THỂ share species mà cả hai đều đúng.
-
Staged approach C5 + D-C: SPE-GOV primary bây giờ (pilot compliance) + migration-time species assignment cho law_unit + discriminator rows as documentation. Pragmatic, law-compliant, no function patch.
-
unit_version: H1 (no mapping needed) — subordinate strategy, 0 birth rows, species mapping has no effect. Defer.
-
QT-001 backfill plan: 5-step procedure aligned. Dry-run in Phase 4C prompt computes exact proposed species/composition per mapping option for 12 rows.
-
Phase 5 nesting decision is the key dependency. Preserve TAC nesting → atom wrong → SPE-GOV wrong long-term. Flatten → atom fine → SPE-GOV viable.
-
Mission prompt style adopted. Prompt = mục tiêu (G1-G10) + tiêu chí PASS/FAIL + ràng buộc. Không bash/SQL. Agent implements. Prompt đồng thời là thiết kế (đọc lại, nâng cấp dễ).
Confirmation
GPT + User review bắt buộc trước dispatch. Không agent, không seed, không migration.