mars MARS-14 · child of MARS-13 Tech-debt sweep: catalog unused DB objects (tables/columns/views, e.g. 0-row #395/#396, redundant text cols #394) + dead app-code fields/exports; file one deletion WI per finding (Elazar 06-05: stop brushing off 'legacy field we dont use') Backlog

Delete unused DB views (technical debt audit)

Done normal dmdb02-mars-cc

Sub-tickets — 3/3 done

Delete unused error logging views (vErrorsLast5/10/20/25, vAppErrors*, vRecurringErrors, vAppEventsRecent)

MARS-15 Done

dmdb02-mars-cc

Delete unused health/admin views (vHealth*, vActiveSupportTickets, vAccountSwitchLinks, vHelpArticles)

MARS-16 Done

dmdb02-mars-cc

Delete unused views: vComisionAyudantesByJtp, vPendingAccessRequests, vStudentPostgradoProgression

MARS-17 Done

dmdb02-mars-cc

+ Add sub-ticket

Activity

wi-cli-venus created · 2026-06-05
wi-cli-venus parentChanged · 2026-06-05

parent=#676
wi-cli-venus note · 2026-06-05

DO NOT mass-drop. Per-object verify: code refs + triggers + FK + view-on-view + agent/ops usage + scheduled jobs. KNOWN false-positives: vAppEventsRecent = access-request triage lookup (mars-db-extras) — IN USE. Archive views/tables = forensic audit ledger — KEEP unless Elazar signs off. Each DROP needs audit cross-review + PM go.
wi-cli-venus assigned · 2026-07-16

db02-mars-cc / db
wi-cli-venus commented · 2026-07-17

Checkpoint (db02-mars-cc): 33 views have 0 src-refs but ALL have >=1 fleet-doc reference (health/triage/friction/diagnostic views used ad-hoc via psql/MCP) - zero are 0-src+0-doc, none are grep-alone drop candidates (per project_second_instance_parallel_dispatch memory: 0 src refs != unused). Real work = semantic dedup of superseded twins (friction family, vAppEvents25/50/100, capped/uncapped alert-error pairs) - next pass, per-family, needs audit before any drop.
wi-cli-venus commented · 2026-07-17

--body
wi-cli-venus commented · 2026-07-17

--body
wi-cli-venus completed · 5w ago

All three child deletion batches are done: MARS-15 (error-logging views), MARS-16 (health/admin views), MARS-17 (vComisionAyudantesByJtp, vPendingAccessRequests, vStudentPostgradoProgression). The work this parent tracked was actually performed, so this is done rather than obsolete. Note for the record: vComisionAyudantesByJtp, vStudentPostgradoProgression, vAppErrorsRecent and vAppAlertsRecent are present in the live catalog again - they were re-created later as real consumers appeared, not left un-dropped. That re-creation is not a defect and not a reopen of this WI.