Page Comparison

external_person (Note that while this table refers to the same notion of a "course" as external_faculty_course and should use the same course and section identifiers, there isn't really even a logical dependency between the two tables because external_faculty_course should only contain "early alertable" courses whereas a student transcript should list all transcripted courses for any given student.)

external_department, external_division (You might think this table should precede external_student_transcript_course in a sort of master-detail relationship. But external_student_transcript_course uses a less strict definition of course and the application does not use external_course to provide additional context when rendering external_student_transcript_course records. There is a relationship between these two tables, but if anything it flows the other direction, i.e. at the app layer external_course records are checked against external_student_transcript_course to determine if a planned course has already been taken.)