S162-P3 Report: Quality Infrastructure

Date: 2026-04-04 | Session: S162 Status: ALL PASS — Phase 1 Nền KG COMPLETE

Kết quả

• kg_quality_log: PASS (11 columns, 2 FKs, 2 indexes)
• evolution_snapshots: PASS (6 columns, 1 index)
• Views: 3/3 (kg_quality_latest, kg_quality_issues, kg_evolution_latest)
• Baseline snapshot: PASS (1 row, scope=global)
• Directus sync: PASS (both tables schema=True)

Schema Details

• kg_quality_log columns: id, dot_code, run_at, scope, metric_name, metric_value, threshold_code, status, details, resolved_at, resolved_by
• FKs:
  • dot_code → dot_tools(code)
  • threshold_code → kg_thresholds(dimension)
• kg_thresholds FK target: dimension (TEXT, UNIQUE) — not 'code' (no code column exists)
• CHECK: status IN ('pass','warn','fail')

Baseline Metrics

• entity_count: 40
• edge_count: 2193
• dot_count: 252
• kg_dot_count: 36
• domain_count (kg.*): 10
• config_tables: 7
• quality_log_entries: 0

Directus Visibility

• kg_quality_log: visible (schema=True)
• evolution_snapshots: visible (schema=True)
• Views: NOT visible in Directus (Directus doesn't auto-register PG views)
• API data access: requires Directus permission configuration (items return 0 without explicit policy)

Issues Found

• Directus API returns 0 items for evolution_snapshots — permissions not configured for public/role access. PG data exists (verified via psql). Non-blocking for Phase 1.
• Views not visible in Directus Admin — expected behavior (Directus manages tables, not views). Views accessible via direct PG query or custom endpoints.

Phase 1 Nền KG — FINAL SUMMARY

Component	Count	Status
KG config tables	7	LIVE
KG quality tables	2	LIVE
KG monitoring views	3	LIVE
entity_species.kg_metadata	1 column	LIVE
universal_edges +3 columns	confidence, valid_time, provenance	LIVE
DOT-KG registered	36 (18 cặp)	REGISTERED
KG sub-domains	10	LIVE
Baseline snapshot	1	RECORDED
→ EKGF Cấp 2	Foundation complete	READY