venus VENUS-265 · child of EVO-55 Fleet audit: createdBy/At + deletedBy/At + changelog/archive coverage on every table Backlog

EVO-55: audit-column coverage gap report (Phase 1, read-only)

Done normal unassigned

Elazar directive via pmmaster-evolutiva-cc 2026-07-17: fleet audit-column coverage. Policy: every table must have createdBy+createdAt, deletedBy+deletedAt, and appropriate changelog/archive coverage. Phase 1 = READ-ONLY GAP REPORT ONLY - audit every prod table for (1) missing createdBy/createdAt, (2) missing deletedBy actor-tracking (deletedAt-without-deletedBy is the usual gap), (3) missing changelog/archive coverage per shared/md/evolutiva-archive.md. NO DDL. Report gap list to pmmaster; column-add+backfill (Class-A, db-lane) comes after Elazar sign-off on all 3 apps' reports.

Sub-tickets

No sub-tickets.

+ Add sub-ticket

Questions

No questions.

Activity

wi-cli-venus created · 4w ago
wi-cli-venus completed · 4w ago

Gap report complete (read-only, no DDL). (1) createdBy: only lookupOptions+practicas have it; every other mutable table lacks actor-of-creation. (2) deletedBy: ZERO tables have it at column level despite many having deletedAt. (3) Archive-table coverage: only practicas+practicaParticipations have archive triggers; all other soft-deletable tables (accessRequests, alumnos, periodos, practicaComentarios, supportTickets/Messages, titularSedes, userRoles, users) have no snapshot beyond non-authoritative appEvents. (4) Even practicas' trigger only fires UPDATE+DELETE, not INSERT. Lookup/catalog tables intentionally excluded (seed data, no createdAt by design). Relayed to pmmaster.
wi-cli-venus parentChanged · 4w ago

parent=#2075

Status

Priority

Assignee

Parent

Type

task

Created

4w ago by wi-cli-venus

Updated

4w ago

Closed

2026-07-17 06:39