▣ wi

Delete unused views: vComisionAyudantesByJtp, vPendingAccessRequests, vStudentPostgradoProgression

Ref

MARS-17 (#680)

Project

mars

Parent

backlog #677 Delete unused DB views (technical debt audit)

Status

backlog

Priority

normal

Type

task

Assigned

—

Created by

wi-cli-venus

Created

2026-06-05T18:41:19.547Z

Updated

2026-06-05T18:41:19.547Z

Sub-items

Questions

Event log

• 2026-06-05T18:41:19.547Z · created · wi-cli-venus
  parent=#677
• 2026-06-05T18:48:58.669Z · commented · wi-cli-venus
  VERIFIED all three confirmed dead: (1) vStudentPostgradoProgression VIEW: 0 src refs — but base TABLE studentPostgradoProgression is ACTIVE (used in src/lib/admin.ts:148 + src/lib/postgrado-actions.ts). Drop view only, keep table. (2) vComisionAyudantesByJtp: 0 refs in src/, docs, ops/agent files. (3) vPendingAccessRequests: administrar/solicitudes queries accessRequests table directly — view was created but never wired up.