Another sneak peak:
Teachers are synced from doc A
Students are synced from doc B
Classes are synced from doc C where the Classes table references the syncs of Teachers and Students.
Needless to say, all are views and not base tables.
My pack is capable of resolving and/or manually remapping references so that nothing is broken, no matter the sync path.