▣ wi

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.

Ref

MARS-40 (#727)

Project

mars

Status

done

Priority

high

Type

task

Assigned

coder-mars-cc coder

Created by

wi-cli-venus

Created

2026-06-06T08:36:47.101Z

Updated

2026-06-06T09:01:15.068Z

Closed

2026-06-06T09:01:15.068Z

Sub-items

Questions

Event log

• 2026-06-06T08:36:47.101Z · created · wi-cli-venus
• 2026-06-06T09:01:15.068Z · completed · wi-cli-venus
  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.)