S122 — Taxonomy Foundation Report

Ngày: 2026-03-15 | PR: #508 | Agent: Claude Code CLI

Kết quả: 4/4 PASS, 11/11 verify

#	Deliverable	Status
D1	system_issues lifecycle (open/resolved/archived) + Layer 1 section removed	✅
D2	5 taxonomy collections (PG + Directus) with all constraints/triggers	✅
D3	Seed data: 6 facets + 55 labels + 36 matrix + 32 rules	✅
D4	v_all_entity_codes VIEW (1437 codes)	✅

Verification

• Composite FK blocks cross-facet child ✅
• Cycle detection blocks A→B→A ✅
• parent_facet auto-fill works ✅
• verify_counts() = 0 MISMATCH ✅
• CI GREEN ✅
• Production deployed and verified ✅

DOT Tools Created

• dot-schema-taxonomy-ensure
• dot-schema-taxonomy-pg-apply

Ghi chú

• Seed data import 55 labels (spec = 54, chênh 1 — cần verify)
• Report upload bởi Claude Desktop (agent CLI không upload)