Data warehouse API data model reference
Diagram
The diagram below shows the entities that make up the data warehouse model:

Orange denote unique keys
Blue denote entity relationships.
Use the following steps to generate a better readable version of above diagram:
In your browser go to http://pragmatiqa.com/xodata/#
For "Choose Access Option" select "Metadata URL"
Fill in the url of the full Data Warehouse model reference: https://reporting.itslearning.com/odata/engine7/$metadata
Click on the green button labeled "Get Details" to generate a diagram

Entities, Relationships and Use in itslearning
Below is a list of all entities including description, fields, relationships and overview of how/where they appear in itslearning. You can navigate from entity to entity through the relationship links.
- AssessmentGrade
- AssessmentScale
- AssessmentStatus
- ConsumerType
- Course
- CourseElementFileAssociation
- CourseMembership
- CourseProfile
- CourseTemplate
- CourseVisit
- Date
- ElementCategory
- ElementType
- File
- LearningObjective
- CourseElement
- LearningObjectiveAssessment
- LearningObjectiveAssessmentStatus
- LearningObjectiveCourseElement
- LearningObjectiveProgress
- Organization
- OrganizationMembership
- Plan
- PlanElement
- Scorm
- ScormStatus
- SiteProfile
- Term
- Time
- User
- UserCourseSession
- UserElementSession
- UserGrade
- UserLogin
- UserSession
- UserAttendance
- CalendarEvent
- LearningItem