MARS-14 ·
mars · child of #676Delete unused DB views (technical debt audit)
- Ref
MARS-14(#677)- Project
mars- Parent
- backlog #676 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')
- Status
- backlog
- Priority
- normal
- Type
- task
- Assigned
- —
- Created by
- wi-cli-venus
- Created
- 2026-06-05T18:41:11.219Z
- Updated
- 2026-06-05T18:45:15.616Z
Sub-items (0/3 done · 0%)
| ref | title | status | priority | assignee |
|---|---|---|---|---|
| MARS-15 | Delete unused error logging views (vErrorsLast5/10/20/25, vAppErrors*, vRecurringErrors, vAppEventsRecent) | backlog | normal | — |
| MARS-16 | Delete unused health/admin views (vHealth*, vActiveSupportTickets, vAccountSwitchLinks, vHelpArticles) | backlog | normal | — |
| MARS-17 | Delete unused views: vComisionAyudantesByJtp, vPendingAccessRequests, vStudentPostgradoProgression | backlog | normal | — |
Questions
No questions.
Event log
-
parent=#676
-
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.