Patient registry implementation — pacientes table (dniNormalizado UNIQUE) + nullable pacienteId FK on practicas + DNI autocomplete/mismatch-warn per db/design/wi494-patient-registry.md

Sub-tickets

Questions

Activity

• system created · 2026-05-22
  wi cli
• system completed · 2026-05-22
  Patient registry implemented — db: pacientes table (dniNormalizado UNIQUE) + practicas.pacienteId nullable FK + pg_trgm GIN/B-tree indexes; coderhelp: app-side DNI normalize helpers, role-gated lookupPacienteByDni, crearPractica resolves/inserts pacientes in-txn (ON CONFLICT DO NOTHING + COALESCE no-overwrite backfill), optional Nombre del paciente field with DNI-blur lookup-suggest + amber non-blocking mismatch warning. Full prefix-typeahead name-search deferred per design doc. Shipped a9979a6 v0.36.0, audit PASS.