New LMSUser and LMSCourse tables

[marcospri]

• DD: New LMSUser and LMSCourse tables
  

• PoC: New LMSCourse and LMSUser tables #6568

Tasks

• Migration for LMSUser and related tables

• Migration for LMSCourse and related tables

• SQLAlchemy models for LMSUser and related tables

• SQLAlchemy models for LMSCourse and related tables

• Migration: fix lms_course_membership.lms_user_id FK to point to the right table #6590

• Keep LMSCourse and LMSUser up to date on every launch #6589

• Keep LMSCourseMembership up to date on every launch #6584

• Migration: backfill LMSUser based on rows in User #6579

• Migration: backfill LMSCourses from grouping rows #6586

• Fix the LMSCourse backfill from grouping migration #6612

• Migration: Backfill LMSUSerApplication instance #6591

• Migration: Backfill LMSCourseApplication instance #6592

• Upsert lms_course.copied_form_id #6593

• Migration: Backfill lms course copied from #6594

• Relate assignments to lms_course (instead of or on top of the grouping relationship on assignment.course_id)

• Backfill LMSCourseMembership #6856

• Switch all reads on the LMS codebase to the new code

• Update report system and metabase queries to target the new tables

• Delete the code that maintains the old tables

• Delete the old tables.

Follow up

• [WIP] Store custom_canvas_course_id in a column #6560