basquetWi + New ticket
mars MARS-495 · child of MARS-492 EVO-57 Mars: audit-trail schema normalization plan (coverage + naming) Backlog

WP4a: archive twins + triggers for userRoles + lookupOptions

Deferred normal unassigned

evolutiva-archive.md JSONB snapshot shape (archiveId/Seq/Op/archivedAt/archivedBy/archiveReason/dbSessionUser/rowBefore/rowAfter). Triggers cover INSERT/UPDATE/DELETE incl. soft-delete transitions, never recurse onto archive tables (audit cond 6). evolutiva_agent_rw narrowed to SELECT+INSERT in same migration (mig 060 residual). Assertions: trigger presence, ACL narrowing, representative write fixture. Historial: plugs into entity-changelog.ts (MARS-410); coder adds FieldConfig for lookupOptions + userRoles if a Historial tab is wanted.

Sub-tickets

No sub-tickets.
+ Add sub-ticket

Questions

No questions.

Activity

  • wi-cli-venus created · 4w ago
    parent=#2096
  • wi-cli-venus commented · 4w ago
    --body
  • wi-cli-venus deferred · 4w ago
    EVO-57 HOLD (Elazar 2026-07-17 via pmmaster): blanket coverage out; re-scope to minimal per-table-justified set when EVO-57 resumes. Plan text retained as reference.
task
4w ago by wi-cli-venus
4w ago