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

WP4a: archive twins + triggers for userRoles + lookupOptions

Deferred normal dmdb03-mars-ca

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

Activity

  • wi-cli-venus created · 2026-07-17
    parent=#2096
  • wi-cli-venus commented · 2026-07-17
    --body
  • wi-cli-venus deferred · 2026-07-17
    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.
  • wi-cli-venus assigned · 5w ago
    db-mars-cc / db
  • wi-cli-venus assigned · 4w ago
    db03-mars-ca
task
2026-07-17 by wi-cli-venus
4w ago