Database Properties
Database Type: PostgreSQL - 08.00.0002
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| forums | 0 | 6 | 9 | 36739 | Table | Forum created by the learning site |
| quizattemptresponses | 0 | 6 | 19 | 1440196950 | Table | Quiz Attempt Response created by the User |
| locations | 0 | 2 | 12 | 6616 | Table | |
| userlicenses | 0 | 12 | 9 | 22647008 | Table | User provisioned access to Licenses |
| ltiattempts | 0 | 8 | 9 | 7056626 | Table | LTI Attempt created by the User |
| sections | 18 | 4 | 10 | 2574577 | Table | Section created by the learning site |
| redemptioncodegroups | 4 | 0 | 9 | 30860 | Table | |
| discountgrouptags | 0 | 6 | 7 | 4044 | Table | |
| registrations | 0 | 1 | 16 | 3910286 | Table | Registration created by the User |
| creditactions | 0 | 4 | 18 | 86113 | Table | |
| assignmentsubmissions | 0 | 6 | 16 | 3238688 | Table | Assignment Submission created by the User |
| emailactivity | 0 | 2 | 8 | 289535303 | Table | |
| firehose_test_table | 0 | 0 | 4 | 0 | Table | |
| coursegroups | 8 | 2 | 17 | 750065 | Table | |
| views | 0 | 20 | 21 | 1980061876 | Table | |
| producttags | 0 | 4 | 7 | 2359 | Table | |
| bundletags | 0 | 6 | 7 | 2040 | Table | |
| coursecustomfields | 0 | 4 | 8 | 656091 | Table | |
| onboardingsurveyresponses | 0 | 10 | 11 | 23251569 | Table | Onboarding Survey Response created by the User |
| organizations | 13 | 0 | 3 | 2851 | Table | Organization created by the learning site |
| licenses | 22 | 10 | 8 | 2321080 | Table | License created by the learning site |
| awardtypes | 0 | 1 | 9 | 3568 | Table | Award Type created by the learning site |
| coursegroupcustomfields | 0 | 4 | 8 | 2147521 | Table | |
| redemptioncodes | 0 | 6 | 11 | 9085910 | Table | |
| certificates | 4 | 16 | 24 | 34643248 | Table | |
| courseactions | 0 | 10 | 13 | 312839585 | Table | Course Action created by the User |
| waitlists | 0 | 6 | 8 | 2653 | Table | |
| milestonecourses | 0 | 6 | 11 | 770364 | Table | Milestone Course created by the learning site |
| awsdms_apply_exceptions | 0 | 0 | 6 | 0 | Table | |
| subscriptionreactivations | 0 | 0 | 19 | 5376 | Table | Subscription Reactivation created by the User |
| pickablegroups | 4 | 4 | 9 | 1181 | Table | Pickable Group created by the learning site |
| certificatefieldsblocks | 4 | 2 | 8 | 8937 | Table | |
| scormattemptresponses | 0 | 8 | 15 | 115453613 | Table | SCORM Attempt Response created by the User |
| userlearningpaths | 0 | 8 | 11 | 6802143 | Table | |
| licensecourses | 0 | 8 | 8 | 14048927 | Table | License Course created by the learning site |
| emailcaptures | 0 | 1 | 14 | 1868646 | Table | Email Capture created by the learning site |
| courseinstructormessages | 0 | 1 | 21 | 4202 | Table | Course Instructor Message created by the User |
| newslettersignups | 0 | 1 | 7 | 575313 | Table | Newsletter Signup created by the learning site |
| learningpaths | 28 | 4 | 31 | 58635 | Table | Learning Path created by the learning site |
| subscriptioncancels | 0 | 1 | 19 | 59111 | Table | Subscription Cancel created by the User |
| products | 4 | 4 | 9 | 5533 | Table | Product created by the learning site |
| roles | 0 | 0 | 21 | 28372 | Table | |
| rlocks | 0 | 0 | 5 | 456 | Table | |
| users | 133 | 6 | 36 | 31435777 | Table | User created by the learning site |
| purchases | 0 | 10 | 40 | 2156351 | Table | Purchase created by the User |
| tags | 24 | 2 | 7 | 132145 | Table | |
| quizattempts | 0 | 11 | 17 | 214690726 | Table | Quiz Attempt created by the User |
| discountgroups | 4 | 2 | 9 | 4000 | Table | Discount Group created by the learning site |
| bundles | 22 | 2 | 11 | 4384 | Table | Bundle created by the learning site |
| coursegrouptags | 0 | 6 | 7 | 1752861 | Table | |
| pickablegrouptags | 0 | 6 | 7 | 429 | Table | |
| userbundles | 0 | 6 | 7 | 2620012 | Table | User provisioned access to Bundles |
| clientcourses | 0 | 6 | 7 | 7795988 | Table | Client Course created by the learning site |
| usercourseprogresses | 0 | 10 | 11 | 98131286 | Table | |
| learningpathactions | 0 | 10 | 14 | 30352650 | Table | Learning Path Action created by the User |
| competencyassessmentresponses | 0 | 8 | 14 | 219271 | Table | |
| comments | 4 | 8 | 17 | 4295402 | Table | |
| registrationcodes | 4 | 2 | 11 | 73532 | Table | |
| clienttags | 0 | 6 | 7 | 61315 | Table | |
| lessons | 10 | 6 | 9 | 4843554 | Table | Lesson created by the learning site |
| meetings | 4 | 4 | 13 | 653086 | Table | |
| testimonials | 0 | 5 | 16 | 15104549 | Table | Testimonial created by the User |
| competencyassessmentattempts | 0 | 8 | 16 | 63267 | Table | |
| actions | 0 | 3 | 12 | 12232924 | Table | Action created by the User |
| onboardingsurveys | 8 | 4 | 7 | 2006 | Table | Onboarding Survey created by the learning site |
| viewtimes | 0 | 18 | 15 | 2331028154 | Table | View Time created by the User |
| companies | 378 | 3 | 9 | 3054 | Table | Company created by the learning site |
| coursetags | 0 | 8 | 5 | 3383702 | Table | This table is deprecated. Data no longer current. Course tag created by the learning site. |
| usercourses | 0 | 6 | 11 | 112633212 | Table | |
| usertopicprogresses | 0 | 6 | 7 | 0 | Table | |
| visits | 0 | 4 | 20 | 180124918 | Table | Visit created by the User |
| awards | 0 | 9 | 16 | 40267443 | Table | Award created by the User |
| questionchoices | 0 | 4 | 12 | 17604373 | Table | |
| coursecertificates | 0 | 1 | 21 | 435950 | Table | Course Certificate created by the User |
| scormattempts | 4 | 10 | 18 | 49140727 | Table | SCORM Attempt created by the User |
| learningpathtags | 0 | 6 | 7 | 63276 | Table | |
| registrationcoderedemptions | 0 | 6 | 8 | 2260403 | Table | |
| userattendedmeetings | 0 | 8 | 10 | 1346464 | Table | |
| milestones | 8 | 8 | 9 | 169211 | Table | Milestone created by the learning site |
| creditbatches | 0 | 4 | 12 | 2465 | Table | |
| certificatefields | 0 | 6 | 9 | 8295 | Table | |
| questions | 4 | 2 | 9 | 9750741 | Table | |
| subscriptionpurchases | 0 | 10 | 42 | 1140821 | Table | Subscription Purchase created by the User |
| topics | 12 | 12 | 27 | 14116345 | Table | Topic created by the learning site |
| sectioncompletions | 0 | 8 | 8 | 149092599 | Table | |
| competencyassessments | 0 | 4 | 7 | 985 | Table | |
| redemptioncoderedeems | 0 | 1 | 18 | 2368998 | Table | Redemption Code Redeem created by the User |
| sessions | 0 | 1 | 27 | 133982157 | Table | Session created by the User |
| courses | 128 | 8 | 28 | 1309413 | Table | Course created by the learning site |
| clients | 66 | 2 | 13 | 292724 | Table | Client created by the learning site |