WI#2 follow-up: harmonize studentAssignmentsArchive with assignedTeacherUserId rename

Sub-tickets

Questions

Activity

• system created · 2026-05-18
  wi cli
• system note · 2026-05-18
  Studentassignments base table has the new column + sync trigger (db-mars Stage 1). Archive table studentAssignmentsArchive still has only jtpUserId. Affected: entity-changelog.ts lines 127, 165, 176, 366, 387, 403 (rawColumn + SELECT + JOIN on alias 'a' = studentAssignmentsArchive). WI#2 stage 2 (SHAs 052e634+b841f35) intentionally retained jtpUserId on these archive references. To complete: db adds assignedTeacherUserId column to studentAssignmentsArchive + backfill + sync trigger, then code swap to assignedTeacherUserId. Gate on Elazar's Stage 5 (drop old col) decision.
• system completed · 2026-05-19
  v1.108.1 d93ab37 archive-side assignedTeacherUserId swap, audit PASS