mars MARS-492 · child of EVO-57 Audit-trail schema normalization (coverage + field-name naming), planned per-project Deferred

EVO-57 Mars: audit-trail schema normalization plan (coverage + naming)

Backlog normal unassigned

Per EVO-57: plan (not build) audit-trail schema normalization for Mars — (A) coverage: createdBy/At+deletedBy/At+changelog/archive on SENSITIVE-data tables only (Elazar ruling #5a exempts telemetry/queue/non-sensitive), using MARS-483's completed gap report as input; (B) naming: normalize all audit/soft-delete/changelog/historial field names to one convention, integrating existing Historial pattern (MARS-410) not duplicating it. Deliverable = plan only (approach + migration sequencing), no DDL. Build WITH coder-mars-cc+db-mars-cc+audit-mars-ca, file child bwis as needed, report bwi ref + outline to pmmaster-evolutiva-cc.

Sub-tickets — 0/5 done

WP1 naming: deletedBy -> deletedByUserId dual-column shim

MARS-493 Deferred

WP2+WP3: add deletedByUserId + createdByUserId coverage columns

MARS-494 Deferred

WP4a: archive twins + triggers for userRoles + lookupOptions

MARS-495 Deferred

WP4b: archive twins + triggers for supportTickets/Messages/NotifySubscriptions + accessRequests + accountSwitchLinks

MARS-496 Deferred

WP4c: archive twins + triggers for practicaReviews + practicaComentarios + studentPostgradoProgression

MARS-497 Deferred

+ Add sub-ticket

Questions

No questions.

Activity

wi-cli-venus created · 4w ago

parent=#2093
wi-cli-venus statusChanged · 4w ago

status=backlog
wi-cli-venus assigned · 4w ago

--body
wi-cli-venus commented · 4w ago

--body
wi-cli-venus statusChanged · 4w ago

HOLD — Elazar re-scope 2026-07-17: no blanket coverage, per-table justification required, DEFERRED, no release GO. Do not execute as drafted.