Backup pluto DB + delete practicas test data — testing phase ended, client wants test data wiped. Order: (1) pg_dump backup to /gdrive/backup/, (2) delete practicas test rows + dependent FKs, (3) report counts.

Sub-tickets

Questions

Activity

• system created · 2026-05-13
  wi cli
• system completed · 2026-05-13
  Atomic wipe + practicaLookupValues redesign. Wiped: 247 practicas + 584 archive + 6 docente notas + 6 docente notas archive + 269 student assignments + 16 student assignments archive + 2189 practicaLookupValues rows (table dropped). Added: 2 inline FK columns on practicas (dificultadPercibidaOptionId, tabaquismoOptionId) + 6 per-attribute side tables (practicaAnestesias, practicaTecnicasQuirurgicas, practicaDiagnosticosRadiograficos, practicaComplicacionesIntraoperatorias, practicaAntecedentesPersonales, practicaCaracteristicasPieza). Code: 1a1ee9f v1.59.17. Inline fix to wave-2 archive trigger (RETURN NEW on DELETE → RETURN OLD). Backup: 2026-05-13-0538-pre-redesign-wipe-WI350.dump.