Sub-ticket of PLUTO-449 Support ticket short human-readable reference (SOP-###) on /admin/soporte + /[id]. supportTickets has only a uuid today (LEAN schema, no ticketNumber). Add a STABLE, IMMUTABLE short-ref column assigned at insert (NOT row-order-derived — shifts on delete, breaks citability). Scheme TBD by Elazar (rec: SOP-<year>-<per-year seq> e.g. SOP-2026-007; alt: flat SOP-NNN). db: add nullable column (archive-fn to_jsonb expand-only NOT NULL trap — new cols on trigger-archived supportTickets MUST be nullable) + monotonic assignment (sequence or per-year counter) + backfill existing tickets in createdAt order; archive sentinel on the backfill. coder: use the ref as the detail-page title/reference, render as a self-link, add a 'copiar enlace' button copying the full ticket URL (https://evolutiva.pensanta.com/admin/soporte/[id]); also surface the ref as the link text in the /admin/soporte list. GATING: DB schema change -> audit pre-impl design-ping + pre-apply review on the migration + post-push PTD. SEQUENCING: touches support surface shared with PLUTO-444 (uncommitted support-actions.ts) — order to avoid collision. Blocked on Elazar's scheme pick. · pluto