basquetWi + New ticket
mars MARS-483 · child of EVO-55 Fleet audit: createdBy/At + deletedBy/At + changelog/archive coverage on every table Backlog

Audit createdBy/At + deletedBy/At + changelog/archive coverage

Backlog normal dmdb-mars-cc

Per EVO-55. Phase 1 (read-only gap report): audit every prod table for missing createdBy/createdAt, missing deletedBy actor-tracking (deletedAt-without-deletedBy is the common gap), missing changelog/archive coverage per shared/md/evolutiva-archive.md. Report gaps to PM. No DDL yet - column-add + backfill plan returns to PM/Elazar first (Class-A, db-mars-cc owns DDL + backfill).

Sub-tickets

No sub-tickets.
+ Add sub-ticket

Questions

No questions.

Activity

  • wi-cli-venus created · 4w ago
    parent=#2075
  • wi-cli-venus commented · 4w ago
    Phase 1 read-only only, no DDL. Dispatched to db-mars-cc.
  • wi-cli-venus assigned · 4w ago
    db-mars-cc / db
  • wi-cli-venus commented · 4w ago
    Phase 1 = read-only gap report only, no DDL. Dispatched to db-mars-cc.
  • wi-cli-venus commented · 4w ago
    Phase-1 gap report received from db-mars-cc (41 tables swept via information_schema+pg_trigger). Fully covered: comisiones/periodos/studentAssignments/teacherComisionMemberships/users. Gap1 (missing createdBy, real gaps after crediting semantic-equivalent cols): comisiones/periodos/studentAssignments/teacherComisionMemberships/users/userRoles/lookupOptions/practicaTeeth/practicaToothConductos/accessRequests/accountSwitchLinks/supportTicketNotifySubscriptions/systemSettings/notifications/emailOutbox. Gap2 (deletedAt w/o deletedBy): practicas(+Archive)/userRoles/lookupOptions/accountSwitchLinks/supportTickets/supportTicketMessages/supportTicketNotifySubscriptions/practicaImages(+Archive)/practicaTeeth(+Archive)/practicaToothConductos(+Archive). Gap3 (no archive/changelog coverage): userRoles/lookupOptions/supportTickets+Messages+NotifySubscriptions/accessRequests(trigger notify-only, no archive table)/accountSwitchLinks/practicaComentarios/studentPostgradoProgression/systemSettings/userNotificationPrefs. usersArchive has no visible timestamps - phase2 verify. Recommended exempt (infra/telemetry, append-only): appEvents family, dbperfSnapshots, matviewRefreshLog/Runs, practicasIntegrityInventory, practicaEditLocks, rectificarReminderState. Relayed to pmmaster-evolutiva-cc. No DDL done.
  • wi-cli-venus commented · 4w ago
    Addendum (db-mars-cc, final): usersArchive is NOT a gap - uses modern JSONB-snapshot archive shape (archiveId/archiveSeq/archiveOp/archivedAt/archivedBy/archiveReason/rowBefore/rowAfter); dropped from missing-createdAt list. Cross-checked vs evolutiva-archive.md policy - gap(3) list confirmed standing: userRoles/lookupOptions/supportTickets+Messages+NotifySubscriptions/accessRequests/accountSwitchLinks/studentPostgradoProgression/systemSettings are mutable w/ no archive twin; practicaReviews append-only=compliant; appEvents correctly exempt. Report final. Relayed to pmmaster-evolutiva-cc.
chore
4w ago by wi-cli-venus
4w ago