Clinical KB: outstanding content and provenance work

[BigSimmo]

Summary

Post-cleanup storage audit passed on Supabase Clinical KB Database (sjrfecxgysukkwxsowpy). Canonical data is clean and deduplicated (185 differentials, 328 medications, 226 services under primary owner 4f1b3c19-3c39-4597-b9df-168c8e6007ff). Remaining work is content enrichment and provenance, not corruption repair.

Background

Recent cleanup completed:

• Removed 62 empty presentation differential stubs
• Deduplicated secondary-owner copies
• Enriched 9 services with verified contacts
• Verification pass: services/medications/differentials metadata normalized
• Unique index on differential_records (owner_id, slug, kind)

Live audit confirmed counts, no duplicate slugs, no secondary-owner rows, and intact payloads for diagnosis records.

Tasks

• Import presentation-level content — 31 presentation topics were never imported; only diagnosis records exist today. Add presentation navigation content (or define product decision to stay diagnosis-only).
• Enrich differential sections — Content gaps (not corruption): ~97/185 diagnoses missing immediateActions; ~134/185 missing investigations in payload.
• Document provenance — clinical_registry_record_sources is empty (0 rows). Link services/registry records to source PDFs/documents used during import.

Acceptance criteria

• Presentation strategy documented (import 31 topics or explicit diagnosis-only scope).
• Differential coverage targets agreed and tracked (e.g. % with immediateActions / investigations).
• clinical_registry_record_sources populated for imported services (or documented pipeline to backfill from documents / import batches).
• Re-run Supabase audit: counts unchanged unless intentional; no new duplicate (owner_id, slug, kind) rows.

References

• Supabase project: Clinical KB Database (sjrfecxgysukkwxsowpy)
• Related repos: BigSimmo/Differentials, BigSimmo/Medications, BigSimmo/Services (content may originate there)

[BigSimmo]

Closing as duplicate of #289.