Database Properties
Database Type: PostgreSQL - 13.4
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| quizAttemptResponses | 0 | 6 | 13 | 0 | Table | Quiz Attempt Responses created by learners |
| userLicenses | 0 | 3 | 6 | 0 | Table | User provisioned access to Licenses |
| ltiAttempts | 0 | 4 | 8 | 0 | Table | LTI Responses created by learners |
| sections | 2 | 2 | 6 | 0 | Table | Sections created by the learning site |
| redemptionCodeGroups | 1 | 1 | 7 | 0 | Table | Redemption Code Groups created by the learning site |
| discountGroupTags | 0 | 3 | 4 | 0 | Table | Tags associated with Discount Groups |
| assignmentSubmissions | 0 | 4 | 9 | 0 | Table | Assignment Submissions created by learners |
| courseGroups | 5 | 1 | 14 | 0 | Table | Course Groups created by the learning site. Course Groups encompass all sessions of a Course |
| productTags | 0 | 3 | 4 | 0 | Table | Tags associated with Products |
| bundleTags | 0 | 3 | 4 | 0 | Table | Tags associated with Bundles |
| onboardingSurveyResponses | 0 | 3 | 7 | 0 | Table | Onboarding Survey Responses created by learners |
| licenses | 2 | 3 | 5 | 0 | Table | Licenses created by the learning site |
| awardTypes | 1 | 1 | 7 | 0 | Table | Award Types created by the learning site |
| courseGroupCustomFields | 0 | 2 | 5 | 0 | Table | Custom Fields associated with Course Groups |
| redemptionCodes | 0 | 2 | 8 | 0 | Table | Redemption Codes created by the learning site |
| certificates | 0 | 2 | 12 | 0 | Table | Certificates earned by learners |
| courseActions | 0 | 3 | 8 | 0 | Table | Course Actions created by learners |
| waitlists | 0 | 3 | 8 | 0 | Table | Waitlist status and history of users within courses |
| milestoneCourses | 0 | 4 | 8 | 0 | Table | Milestone Courses created by the learning site |
| migrations | 0 | 0 | 1 | 30 | Table | Migrations created by the learning site |
| pickableGroups | 1 | 1 | 6 | 0 | Table | Pickable Groups (aka A La Carte Collections) created by the learning site |
| scormAttemptResponses | 0 | 5 | 11 | 0 | Table | Scorm Attempt Responses (aka Interactions) created by learners |
| userLearningPaths | 0 | 3 | 5 | 0 | Table | User provisioned access to Learning Paths |
| learningPaths | 4 | 1 | 27 | 0 | Table | Learning Paths created by the learning site |
| products | 1 | 1 | 6 | 0 | Table | Products created by the learning site |
| users | 18 | 2 | 33 | 0 | Table | Users created by the learning site. |
| tags | 7 | 1 | 3 | 0 | Table | Tags created by the learning site |
| quizAttempts | 1 | 4 | 13 | 0 | Table | Quiz Attempts created by learners |
| discountGroups | 1 | 1 | 6 | 0 | Table | Discount Groups (aka Collections) created by the learning site |
| bundles | 2 | 1 | 8 | 0 | Table | Bundles created by the learning site |
| courseGroupTags | 0 | 3 | 4 | 0 | Table | Tags associated with Course Groups |
| pickableGroupTags | 0 | 3 | 4 | 0 | Table | Tags associated with Pickable Groups |
| userBundles | 0 | 3 | 4 | 0 | Table | User provisioned access to Bundles |
| userCourseProgresses | 0 | 3 | 9 | 0 | Table | Learner progress in Courses |
| learningPathActions | 0 | 4 | 8 | 0 | Table | Learning Path Actions created by learners |
| registrationCodes | 1 | 1 | 9 | 0 | Table | Registration Codes created by the learning site |
| clientTags | 0 | 3 | 4 | 0 | Table | Tags associated with Clients |
| lessons | 1 | 3 | 6 | 0 | Table | Lessons created by the learning site |
| meetings | 0 | 0 | 9 | 0 | Table | Meetings created by the learning site |
| testimonials | 0 | 3 | 10 | 0 | Table | Testimonials created by learners |
| onboardingSurveys | 1 | 2 | 4 | 0 | Table | Onboarding Surveys created by the learning site |
| companies | 50 | 0 | 4 | 0 | Table | Companies (aka Learning Sites) |
| userCourses | 0 | 3 | 5 | 0 | Table | User provisioned access to Courses |
| awards | 0 | 4 | 12 | 0 | Table | Awards earned by learners |
| questionChoices | 0 | 2 | 9 | 0 | Table | Slectable choices for Questions |
| scormAttempts | 1 | 4 | 12 | 0 | Table | Scorm Attempts created by learners |
| learningPathTags | 0 | 3 | 4 | 0 | Table | Tags associated with Learning Paths |
| registrationCodeRedemptions | 0 | 2 | 5 | 0 | Table | Registration Code Redemptions created by the learning site |
| milestones | 2 | 2 | 5 | 0 | Table | Milestones created by the learning site |
| questions | 2 | 1 | 6 | 0 | Table | Available questions |
| topics | 6 | 4 | 24 | 0 | Table | Topics created by the learning site |
| courses | 14 | 2 | 20 | 0 | Table | Courses created by the learning site |
| clients | 5 | 1 | 5 | 0 | Table | Clients created by the learning site |