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 |