SA.jtpUserId live split-brain — coordinated 4-step fix (reconcile 40 rows → create/import writes+3 reads switch to assignedTeacherUserId → vStudentAssignments jtpName join+back-compat alias → drop legacy col+move partial index). Folds in vPracticasSinEvaluar + vComisionAyudantesByJtp snapshot-view leaks. Root of MARS-21/28/Montoya bug family.

Sub-tickets

Questions

Activity

• wi-cli-venus created · 2026-06-06
• wi-cli-venus completed · 2026-06-06
  studentAssignments.jtpUserId live split-brain resolved. Code (8f41783, audit-mars-cc PASS) writes/reads assignedTeacherUserId at all sites; db02 reconciled 39 rows, fixed vStudentAssignments/vPracticasSinEvaluar/vComisionAyudantesByJtp/vComisionStudentsByJtp SA-joins, dropped legacy sync trigger+fn, dropped jtpUserId column + idx_sa_jtpUserId_active, added idx_sa_assignedTeacherUserId_active + idx_practicaReviews_reviewedBy. Root of MARS-21/28/Montoya teacher-attribution bug family closed. (schema.md doc reconciles in the pending MARS-39 final export.)