basquetWi + New ticket
pluto PLUTO-626

lookupOptions: add updatedAt + touch-trigger (sweep-found hygiene)

Done normal dpdb-pluto-cc

Sweep-found hygiene (bs-mrtkq6rjomf dual-axis information_schema sweep, ratified fleet hygiene). SEPARATE from PLUTO-625, rides alongside, not blocking. lookupOptions is admin-edited IN PLACE (activo toggle + label/params edits) but has createdAt and NO updatedAt. Add updatedAt timestamptz default now() + touch-trigger. VERIFY FIRST before finalizing exemptions: the 6 practica-detail child tables (practicaAnestesias/AntecedentesPersonales/CaracteristicasPieza/ComplicacionesIntraoperatorias/DiagnosticosRadiograficos/TecnicasQuirurgicas) are believed replace-on-edit (delete+reinsert on rectificar -> insert-only, createdAt correct); confirm the rectificar server-action path does NOT UPDATE them in place. If any IS updated in place, it joins lookupOptions in this WI. Class-A additive DDL, db-pluto lane.

Sub-tickets

No sub-tickets.
+ Add sub-ticket

Questions

No questions.

Activity

  • wi-cli-venus created · 4w ago
  • wi-cli-venus assigned · 4w ago
    db-pluto-cc
  • wi-cli-venus statusChanged · 4w ago
    dispatched db-pluto, rides alongside 625 non-blocking
  • wi-cli-venus completed · 4w ago
    lookupOptions.updatedAt + touch-trigger added (mig 085), schema.md exported; shipped SHA 67f6f15 v2.22.2, audit PASS. Dual-axis schema-hygiene sweep finding.
task
4w ago by wi-cli-venus
4w ago
2026-07-21 03:07