A newer version of the Ed-Fi ODS / API is now available. See the Ed-Fi Technology Version Index for a link to the latest version.
Key Structure in the Ed-Fi ODS / API
Unified Keys in the As-Shipped Ed-Fi ODS
Running the SQL Query above on the as-shipped ODS data store results in the following report:
FOREIGN_TABLE_NAME | FOREIGN_COLUMN_NAME | PRIMARY_TABLE_NAME | CONSTRAINT_NAME | |
---|---|---|---|---|
AccountAccountCode | EducationOrganizationId | Account | FK_AccountAccountCode_Account | |
AccountAccountCode | EducationOrganizationId | AccountCode | FK_AccountAccountCode_AccountCode | |
AccountAccountCode | FiscalYear | Account | FK_AccountAccountCode_Account | |
AccountAccountCode | FiscalYear | AccountCode | FK_AccountAccountCode_AccountCode | |
BellScheduleClassPeriod | SchoolId | BellSchedule | FK_BellScheduleClassPeriod_BellSchedule | |
BellScheduleClassPeriod | SchoolId | ClassPeriod | FK_BellScheduleClassPeriod_ClassPeriod | |
CourseOffering | SchoolId | School | FK_CourseOffering_School | |
CourseOffering | SchoolId | Session | FK_CourseOffering_Session | |
DisciplineActionStudentDisciplineIncidentAssociation | StudentUSI | DisciplineAction | FK_DisciplineActionStudentDisciplineIncidentAssociation_DisciplineAction | |
DisciplineActionStudentDisciplineIncidentAssociation | StudentUSI | StudentDisciplineIncidentAssociation | FK_DisciplineActionStudentDisciplineIncidentAssociation_StudentDisciplineIncidentAssociation | |
Grade | SchoolId | GradingPeriod | FK_Grade_GradingPeriod | |
Grade | SchoolId | StudentSectionAssociation | FK_Grade_StudentSectionAssociation | |
GradebookEntry | SchoolId | GradingPeriod | FK_GradebookEntry_GradingPeriod | |
GradebookEntry | SchoolId | Section | FK_GradebookEntry_Section | |
GradebookEntry | SchoolYear | GradingPeriod | FK_GradebookEntry_GradingPeriod | |
GradebookEntry | SchoolYear | Section | FK_GradebookEntry_Section | |
ObjectiveAssessment | AcademicSubjectDescriptorId | Assessment | FK_ObjectiveAssessment_Assessment | |
ObjectiveAssessment | AcademicSubjectDescriptorId | ObjectiveAssessment | FK_ObjectiveAssessment_ObjectiveAssessment | |
ObjectiveAssessment | AssessedGradeLevelDescriptorId | Assessment | FK_ObjectiveAssessment_Assessment | |
ObjectiveAssessment | AssessedGradeLevelDescriptorId | ObjectiveAssessment | FK_ObjectiveAssessment_ObjectiveAssessment | |
ObjectiveAssessment | AssessmentTitle | Assessment | FK_ObjectiveAssessment_Assessment | |
ObjectiveAssessment | AssessmentTitle | ObjectiveAssessment | FK_ObjectiveAssessment_ObjectiveAssessment | |
ObjectiveAssessment | AssessmentVersion | Assessment | FK_ObjectiveAssessment_Assessment | |
ObjectiveAssessment | AssessmentVersion | ObjectiveAssessment | FK_ObjectiveAssessment_ObjectiveAssessment | |
ObjectiveAssessmentAssessmentItem | AcademicSubjectDescriptorId | AssessmentItem | FK_ObjectiveAssessmentAssessmentItem_AssessmentItem | |
ObjectiveAssessmentAssessmentItem | AcademicSubjectDescriptorId | ObjectiveAssessment | FK_ObjectiveAssessmentAssessmentItem_ObjectiveAssessment | |
ObjectiveAssessmentAssessmentItem | AssessedGradeLevelDescriptorId | AssessmentItem | FK_ObjectiveAssessmentAssessmentItem_AssessmentItem | |
ObjectiveAssessmentAssessmentItem | AssessedGradeLevelDescriptorId | ObjectiveAssessment | FK_ObjectiveAssessmentAssessmentItem_ObjectiveAssessment | |
ObjectiveAssessmentAssessmentItem | AssessmentTitle | AssessmentItem | FK_ObjectiveAssessmentAssessmentItem_AssessmentItem | |
ObjectiveAssessmentAssessmentItem | AssessmentTitle | ObjectiveAssessment | FK_ObjectiveAssessmentAssessmentItem_ObjectiveAssessment | |
ObjectiveAssessmentAssessmentItem | AssessmentVersion | AssessmentItem | FK_ObjectiveAssessmentAssessmentItem_AssessmentItem | |
ObjectiveAssessmentAssessmentItem | AssessmentVersion | ObjectiveAssessment | FK_ObjectiveAssessmentAssessmentItem_ObjectiveAssessment | |
ObjectiveAssessmentLearningObjective | AcademicSubjectDescriptorId | LearningObjective | FK_ObjectiveAssessmentLearningObjective_LearningObjective | |
ObjectiveAssessmentLearningObjective | AcademicSubjectDescriptorId | ObjectiveAssessment | FK_ObjectiveAssessmentLearningObjective_ObjectiveAssessment | |
ObjectiveAssessmentLearningObjective | AssessedGradeLevelDescriptorId | LearningObjective | FK_ObjectiveAssessmentLearningObjective_LearningObjective | |
ObjectiveAssessmentLearningObjective | AssessedGradeLevelDescriptorId | ObjectiveAssessment | FK_ObjectiveAssessmentLearningObjective_ObjectiveAssessment | |
ReportCardGrade | GradingPeriodDescriptorId | Grade | FK_ReportCardGrade_Grade | |
ReportCardGrade | GradingPeriodDescriptorId | ReportCard | FK_ReportCardGrade_ReportCard | |
ReportCardGrade | GradingPeriodSchoolYear | Grade | FK_ReportCardGrade_Grade | |
ReportCardGrade | GradingPeriodSchoolYear | ReportCard | FK_ReportCardGrade_ReportCard | |
ReportCardGrade | GradingPeriodSequence | Grade | FK_ReportCardGrade_Grade | |
ReportCardGrade | GradingPeriodSequence | ReportCard | FK_ReportCardGrade_ReportCard | |
ReportCardGrade | StudentUSI | Grade | FK_ReportCardGrade_Grade | |
ReportCardGrade | StudentUSI | ReportCard | FK_ReportCardGrade_ReportCard | |
ReportCardStudentCompetencyObjective | GradingPeriodDescriptorId | ReportCard | FK_ReportCardStudentCompetencyObjective_ReportCard | |
ReportCardStudentCompetencyObjective | GradingPeriodDescriptorId | StudentCompetencyObjective | FK_ReportCardStudentCompetencyObjective_StudentCompetencyObjective | |
ReportCardStudentCompetencyObjective | GradingPeriodSchoolId | ReportCard | FK_ReportCardStudentCompetencyObjective_ReportCard | |
ReportCardStudentCompetencyObjective | GradingPeriodSchoolId | StudentCompetencyObjective | FK_ReportCardStudentCompetencyObjective_StudentCompetencyObjective | |
ReportCardStudentCompetencyObjective | GradingPeriodSchoolYear | ReportCard | FK_ReportCardStudentCompetencyObjective_ReportCard | |
ReportCardStudentCompetencyObjective | GradingPeriodSchoolYear | StudentCompetencyObjective | FK_ReportCardStudentCompetencyObjective_StudentCompetencyObjective | |
ReportCardStudentCompetencyObjective | GradingPeriodSequence | ReportCard | FK_ReportCardStudentCompetencyObjective_ReportCard | |
ReportCardStudentCompetencyObjective | GradingPeriodSequence | StudentCompetencyObjective | FK_ReportCardStudentCompetencyObjective_StudentCompetencyObjective | |
ReportCardStudentCompetencyObjective | StudentUSI | ReportCard | FK_ReportCardStudentCompetencyObjective_ReportCard | |
ReportCardStudentCompetencyObjective | StudentUSI | StudentCompetencyObjective | FK_ReportCardStudentCompetencyObjective_StudentCompetencyObjective | |
ReportCardStudentLearningObjective | GradingPeriodDescriptorId | ReportCard | FK_ReportCardStudentLearningObjective_ReportCard | |
ReportCardStudentLearningObjective | GradingPeriodDescriptorId | StudentLearningObjective | FK_ReportCardStudentLearningObjective_StudentLearningObjective | |
ReportCardStudentLearningObjective | GradingPeriodSchoolId | ReportCard | FK_ReportCardStudentLearningObjective_ReportCard | |
ReportCardStudentLearningObjective | GradingPeriodSchoolId | StudentLearningObjective | FK_ReportCardStudentLearningObjective_StudentLearningObjective | |
ReportCardStudentLearningObjective | GradingPeriodSchoolYear | ReportCard | FK_ReportCardStudentLearningObjective_ReportCard | |
ReportCardStudentLearningObjective | GradingPeriodSchoolYear | StudentLearningObjective | FK_ReportCardStudentLearningObjective_StudentLearningObjective | |
ReportCardStudentLearningObjective | GradingPeriodSequence | ReportCard | FK_ReportCardStudentLearningObjective_ReportCard | |
ReportCardStudentLearningObjective | GradingPeriodSequence | StudentLearningObjective | FK_ReportCardStudentLearningObjective_StudentLearningObjective | |
ReportCardStudentLearningObjective | StudentUSI | ReportCard | FK_ReportCardStudentLearningObjective_ReportCard | |
ReportCardStudentLearningObjective | StudentUSI | StudentLearningObjective | FK_ReportCardStudentLearningObjective_StudentLearningObjective | |
Section | LocationSchoolId | Location | FK_Section_Location | |
Section | LocationSchoolId | School | FK_Section_School | |
SectionAttendanceTakenEvent | SchoolId | CalendarDate | FK_SectionAttendanceTakenEvent_CalendarDate | |
SectionAttendanceTakenEvent | SchoolId | Section | FK_SectionAttendanceTakenEvent_Section | |
SectionAttendanceTakenEvent | SchoolYear | CalendarDate | FK_SectionAttendanceTakenEvent_CalendarDate | |
SectionAttendanceTakenEvent | SchoolYear | Section | FK_SectionAttendanceTakenEvent_Section | |
SectionClassPeriod | SchoolId | ClassPeriod | FK_SectionClassPeriod_ClassPeriod | |
SectionClassPeriod | SchoolId | Section | FK_SectionClassPeriod_Section | |
SessionAcademicWeek | SchoolId | AcademicWeek | FK_SessionAcademicWeek_AcademicWeek | |
SessionAcademicWeek | SchoolId | Session | FK_SessionAcademicWeek_Session | |
SessionGradingPeriod | SchoolId | GradingPeriod | FK_SessionGradingPeriod_GradingPeriod | |
SessionGradingPeriod | SchoolId | Session | FK_SessionGradingPeriod_Session | |
SessionGradingPeriod | SchoolYear | GradingPeriod | FK_SessionGradingPeriod_GradingPeriod | |
SessionGradingPeriod | SchoolYear | Session | FK_SessionGradingPeriod_Session | |
StaffEducationOrganizationAssignmentAssociation | StaffUSI | Staff | FK_StaffEducationOrganizationAssignmentAssociation_Staff | |
StaffEducationOrganizationAssignmentAssociation | StaffUSI | StaffEducationOrganizationEmploymentAssociation | FK_StaffEducationOrganizationAssignmentAssociation_StaffEducationOrganizationEmploymentAssociation | |
StaffSchoolAssociation | SchoolId | Calendar | FK_StaffSchoolAssociation_Calendar | |
StaffSchoolAssociation | SchoolId | School | FK_StaffSchoolAssociation_School | |
StaffSchoolAssociation | SchoolYear | Calendar | FK_StaffSchoolAssociation_Calendar | |
StaffSchoolAssociation | SchoolYear | SchoolYearType | FK_StaffSchoolAssociation_SchoolYearType | |
StudentAcademicRecordReportCard | EducationOrganizationId | ReportCard | FK_StudentAcademicRecordReportCard_ReportCard | |
StudentAcademicRecordReportCard | EducationOrganizationId | StudentAcademicRecord | FK_StudentAcademicRecordReportCard_StudentAcademicRecord | |
StudentAcademicRecordReportCard | StudentUSI | ReportCard | FK_StudentAcademicRecordReportCard_ReportCard | |
StudentAcademicRecordReportCard | StudentUSI | StudentAcademicRecord | FK_StudentAcademicRecordReportCard_StudentAcademicRecord | |
StudentAssessmentItem | AcademicSubjectDescriptorId | AssessmentItem | FK_StudentAssessmentItem_AssessmentItem | |
StudentAssessmentItem | AcademicSubjectDescriptorId | StudentAssessment | FK_StudentAssessmentItem_StudentAssessment | |
StudentAssessmentItem | AssessedGradeLevelDescriptorId | AssessmentItem | FK_StudentAssessmentItem_AssessmentItem | |
StudentAssessmentItem | AssessedGradeLevelDescriptorId | StudentAssessment | FK_StudentAssessmentItem_StudentAssessment | |
StudentAssessmentItem | AssessmentTitle | AssessmentItem | FK_StudentAssessmentItem_AssessmentItem | |
StudentAssessmentItem | AssessmentTitle | StudentAssessment | FK_StudentAssessmentItem_StudentAssessment | |
StudentAssessmentItem | AssessmentVersion | AssessmentItem | FK_StudentAssessmentItem_AssessmentItem | |
StudentAssessmentItem | AssessmentVersion | StudentAssessment | FK_StudentAssessmentItem_StudentAssessment | |
StudentAssessmentStudentObjectiveAssessment | AcademicSubjectDescriptorId | ObjectiveAssessment | FK_StudentAssessmentStudentObjectiveAssessment_ObjectiveAssessment | |
StudentAssessmentStudentObjectiveAssessment | AcademicSubjectDescriptorId | StudentAssessment | FK_StudentAssessmentStudentObjectiveAssessment_StudentAssessment | |
StudentAssessmentStudentObjectiveAssessment | AssessedGradeLevelDescriptorId | ObjectiveAssessment | FK_StudentAssessmentStudentObjectiveAssessment_ObjectiveAssessment | |
StudentAssessmentStudentObjectiveAssessment | AssessedGradeLevelDescriptorId | StudentAssessment | FK_StudentAssessmentStudentObjectiveAssessment_StudentAssessment | |
StudentAssessmentStudentObjectiveAssessment | AssessmentTitle | ObjectiveAssessment | FK_StudentAssessmentStudentObjectiveAssessment_ObjectiveAssessment | |
StudentAssessmentStudentObjectiveAssessment | AssessmentTitle | StudentAssessment | FK_StudentAssessmentStudentObjectiveAssessment_StudentAssessment | |
StudentAssessmentStudentObjectiveAssessment | AssessmentVersion | ObjectiveAssessment | FK_StudentAssessmentStudentObjectiveAssessment_ObjectiveAssessment | |
StudentAssessmentStudentObjectiveAssessment | AssessmentVersion | StudentAssessment | FK_StudentAssessmentStudentObjectiveAssessment_StudentAssessment | |
StudentCompetencyObjectiveGeneralStudentProgramAssociation | StudentUSI | GeneralStudentProgramAssociation | FK_StudentCompetencyObjectiveGeneralStudentProgramAssociation_GeneralStudentProgramAssociation | |
StudentCompetencyObjectiveGeneralStudentProgramAssociation | StudentUSI | StudentCompetencyObjective | FK_StudentCompetencyObjectiveGeneralStudentProgramAssociation_StudentCompetencyObjective | |
StudentCompetencyObjectiveStudentSectionAssociation | StudentUSI | StudentCompetencyObjective | FK_StudentCompetencyObjectiveStudentSectionAssociation_StudentCompetencyObjective | |
StudentCompetencyObjectiveStudentSectionAssociation | StudentUSI | StudentSectionAssociation | FK_StudentCompetencyObjectiveStudentSectionAssociation_StudentSectionAssociation | |
StudentGradebookEntry | LocalCourseCode | GradebookEntry | FK_StudentGradebookEntry_GradebookEntry | |
StudentGradebookEntry | LocalCourseCode | StudentSectionAssociation | FK_StudentGradebookEntry_StudentSectionAssociation | |
StudentGradebookEntry | SchoolId | GradebookEntry | FK_StudentGradebookEntry_GradebookEntry | |
StudentGradebookEntry | SchoolId | StudentSectionAssociation | FK_StudentGradebookEntry_StudentSectionAssociation | |
StudentGradebookEntry | SchoolYear | GradebookEntry | FK_StudentGradebookEntry_GradebookEntry | |
StudentGradebookEntry | SchoolYear | StudentSectionAssociation | FK_StudentGradebookEntry_StudentSectionAssociation | |
StudentGradebookEntry | SectionIdentifier | GradebookEntry | FK_StudentGradebookEntry_GradebookEntry | |
StudentGradebookEntry | SectionIdentifier | StudentSectionAssociation | FK_StudentGradebookEntry_StudentSectionAssociation | |
StudentGradebookEntry | SessionName | GradebookEntry | FK_StudentGradebookEntry_GradebookEntry | |
StudentGradebookEntry | SessionName | StudentSectionAssociation | FK_StudentGradebookEntry_StudentSectionAssociation | |
StudentLearningObjectiveGeneralStudentProgramAssociation | StudentUSI | GeneralStudentProgramAssociation | FK_StudentLearningObjectiveGeneralStudentProgramAssociation_GeneralStudentProgramAssociation | |
StudentLearningObjectiveGeneralStudentProgramAssociation | StudentUSI | StudentLearningObjective | FK_StudentLearningObjectiveGeneralStudentProgramAssociation_StudentLearningObjective | |
StudentLearningObjectiveStudentSectionAssociation | StudentUSI | StudentLearningObjective | FK_StudentLearningObjectiveStudentSectionAssociation_StudentLearningObjective | |
StudentLearningObjectiveStudentSectionAssociation | StudentUSI | StudentSectionAssociation | FK_StudentLearningObjectiveStudentSectionAssociation_StudentSectionAssociation | |
StudentSchoolAssociation | SchoolId | Calendar | FK_StudentSchoolAssociation_Calendar | |
StudentSchoolAssociation | SchoolId | School | FK_StudentSchoolAssociation_School | |
StudentSchoolAssociation | SchoolYear | Calendar | FK_StudentSchoolAssociation_Calendar | |
StudentSchoolAssociation | SchoolYear | SchoolYearType | FK_StudentSchoolAssociation_SchoolYearType | |
StudentSchoolAttendanceEvent | SchoolId | School | FK_StudentSchoolAttendanceEvent_School | |
StudentSchoolAttendanceEvent | SchoolId | Session | FK_StudentSchoolAttendanceEvent_Session |