Practicas list+detail page-ready views (P1 perf)

Sub-tickets

Questions

Activity

• system created · 2026-05-02
  wi cli
• pluto-db-cc-w assigned · 2026-05-02
  assigned to pluto-db-cc-w
• system statusChanged · 2026-05-02
  DDL plan-first; coordinating column shape with pluto-coder-w
• system progress · 2026-05-02
  DDL applied 2tx: vPracticasCompletas + new vPracticasHierarchyRollup. Schema drift fixed (added operadorProfileImageId/asistenteProfileImageId cols missing in schema.sql). pnpm db:export ran clean. Awaiting coder consume-side swap.
• system note · 2026-05-03
  grumberg fix applied in separate tx (pm-3471). authId nulled on f7a6141f, auth.users 72bd05cd deleted with 1 identity + 1 session cascading. archiveSeq 377 logged.
• system progress · 2026-05-06
  consume-side check PASS 2026-05-06: view exists in live DB (13 cols), PracticaHierarchyRollupRow type matches byte-for-byte, schema.md reflects live DDL, single src consumer (db/queries.ts:398 getPracticasHierarchy → /practicas page.tsx:146 + buildPracticasHierarchy), no orphan callers on old node-side rollup shape, no DDL drift since 05-02. Coder consume-side swap already complete (commit landed pre-05-06). Closing scope of #172 work; ready to flip to closed once PM confirms.
• system completed · 2026-05-06
  PM close — pluto-db verification PASS (pluto-db-cc-w-6890): live view 13 cols byte-equal to PracticaHierarchyRollupRow, single consumer db/queries.ts:398, no DDL drift since 05-02