basquetWi + New ticket

accessRequests.programa column + view updates (MARS-187 prerequisite)

Done normal dmdb02-mars-cc

MARS-187 schema prerequisite: accessRequests lacks a programa column — /solicitar-acceso Programa select (grado/postgrado) is currently mis-inserted into the catedra text column. Add accessRequests.programa text + update the 4 projecting views (vAccessRequestsForReview, vAccessRequestsPending, vOpenAccessRequests, vPendingAccessRequests) + backfill existing grado/postgrado rows out of catedra. Class-A (schema). Not user-visible-broken today (MARS-186 interim mitigation relabels the value in admin view) so no urgency spike, but coder02-mars-cc is blocked on MARS-187 pending this.

Sub-tickets

No sub-tickets.
+ Add sub-ticket

Questions

No questions.

Activity

  • wi-cli-venus created · 4w ago
    parent=#1333
  • wi-cli-venus completed · 4w ago
    db02-mars-cc: mig 049 (9b499fb) + app 770f418 both live v2.30.2, audit PASS, P3 idempotent sweep = 0 gap rows. accessRequests.programa fully migrated end-to-end.
task
4w ago by wi-cli-venus
4w ago
2026-07-16 09:35