SQL Tables per Data Object

Object Tables Join on
SchoolInfo SchoolInfo (no sub-tables)
LearnerPersonal LearnerPersonalOtherAddress,

OtherEmail,

OtherId,

OtherPhoneNumber

 OwnerRefId, OwnerType

OwnerRefId, OwnerType

OwnerRefId, OwnerType

OwnerRefId, OwnerType

LearnerSchoolEnrolment LearnerSchoolEnrolment (no sub-tables)
WorkforcePersonal WorkforcePersonalCurrentAssignment

OtherAddress,

OtherEmail,

OtherId,

OtherPhoneNumber

OwnerRefId, OwnerType

OwnerRefId, OwnerType

OwnerRefId, OwnerType

OwnerRefId, OwnerType

OwnerRefId, OwnerType

SchoolGroupType SchoolGroupType (no sub-tables)
SchoolGroup SchoolGroupTeacher OwnerRefId, OwnerType
LearnerGroupEnrolment LearnerGroupEnrolment (no sub-tables)
ContactPersonal ContactPersonalOtherAddress,

OtherEmail,

OtherId,

OtherPhoneNumber

OwnerRefId, OwnerType

OwnerRefId, OwnerType

OwnerRefId, OwnerType

OwnerRefId, OwnerType

LearnerContact LearnerContact (no sub-tables)
LearnerSpecialNeeds LearnerSpecialNeedsSENType OwnerRefId, OwnerType
LearnerAttendance LearnerAttendance (no sub-tables)
LearnerAttendanceSummary LearnerAttendanceSummary (no sub-tables)
PersonPicture PersonPicture[1] (no sub-tables)
LearnerExclusion LearnerExclusion (no sub-tables)
LearnerEntitlement LearnerEntitlementEntitlementPeriod OwnerRefId, OwnerType
LearnerBehaviourIncident LearnerBehaviourIncidentEmployee

Learner

Action

OwnerRefId, OwnerType

OwnerRefId, OwnerType

OwnerRefId, OwnerType

TermInfo TermInfo (no sub-tables)
Cycle CyclePeriod

TTDay

TTDayDate

OwnerRefId, OwnerType

OwnerRefId, OwnerType

OwnerRefId, OwnerType, TTDayId

TTRoom TTRoom (no sub-tables)
TTTeacher TTTeacher (no sub-tables)
TTSubject TTSubject (no sub-tables)
TeachingGroup TeachingGroupGroupTeacher OwnerRefId, OwnerType
Lesson LessonTeacher OwnerRefId, OwnerType
AssessmentResultGradeSet AssessmentResultGradeSetGradeSet

Grade

 OwnerRefId, OwnerType

OwnerRefId, OwnerType, GradeSetId

AssessmentSession AssessmentSession (no sub-tables)
AssessmentResultComponent AssessmentResultComponentSubject

AssessmentStageRefId

MarkSet

OwnerRefId, OwnerType OwnerRefId, OwnerType OwnerRefId, OwnerType
AssessmentResultComponentGroup AssessmentResultComponentGroupAssessmentResultComponentRefId OwnerRefId, OwnerType
AssessmentLearnerSet AssessmentLearnerSetLearnerPersonalRefId OwnerRefId, OwnerType
LearnerAssessmentResult LearnerAssessmentResultAssessmentSessionRefId  OwnerRefId, OwnerType


[1] PersonPicture can also optionally save images out to a folder on the local disk, with files named by RefId.