practicas.lastSubmittedAt + reset SLA timer on resubmit

Sub-tickets

Questions

Activity

• system created · 2026-05-01
  wi cli
• system commented · 2026-05-01
  Follow-up to WI #88 (FINISHED v1.55.1, a5051f8). Coder anchor temporarily pinned to createdAt; v2 swaps both anchors (src/app/(protected)/practicas/page.tsx:89 + src/lib/practica.ts:203) to lastSubmittedAt ?? createdAt. Scope: - DDL: ALTER TABLE practicas ADD COLUMN "lastSubmittedAt" timestamptz; backfill = createdAt for existing 13 rows. - Server-action wiring: write lastSubmittedAt=now() on first submit (=createdAt path) and on resubmit when state transitions desaprobada→noRevisado. - View: vPracticas to expose lastSubmittedAt. - Coder follow-up: swap anchor to lastSubmittedAt ?? createdAt in formatter + sort key (single commit). Edge: archive trigger should snapshot the new column too (automatic if practicasArchive uses dynamic full-row capture; verify). Surface DDL plan to Elazar before applying.
• mars-db-cc-w assigned · 2026-05-01
  assigned to mars-db-cc-w
• system statusChanged · 2026-05-01
  starting v2 design + DDL surface to Elazar
• system completed · 2026-05-02
  closed: practicas are immutable post-submit (no edit, no student-driven resubmit). createdAt is the correct + only anchor. lastSubmittedAt has no use case.