Tables


SchemaSpy Analysis of bi_home

Generated on Fri Oct 22 14:00 UTC 2021

XML Representation
Insertion Order Deletion Order
TABLES 53
VIEWS 0
COLUMNS 444
Constraints 129
Anomalies 3
Routines 0

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