Logical Data Model
Owned by Jugal Joshi (Unlicensed)
Logical Data Model
Our Logical Data Model is a simplified model of our underlying Learndot database. We aim to make this model simple and readable. Feel free to reach out to our Learndot Support Team with questions or clarifications around any of the data attributes.
Account
| Fields | Label | Type | Description |
|---|---|---|---|
| ID | id | Integer | Internal Learndot ID |
| Name | name | String | Name of Account |
| Country Alpha 2 Code | country_alpha2Code | String | |
| City | city | String | |
| Region | region | String | |
| Postal Code | postalCode | String | |
| Tax ID | taxID | String | |
| Phone | phone | String | |
| Fax | fax | String | |
| Logo URL | logo | String | URL to uploaded logo image |
| Last Modified Date | modified | Date/Time | Timestamp for last modified date |
| Last Modified Contact | modifiedBy_id | Contact | ID for last Contact that modified record |
| Created Date | created | Date/Time | Timestamp for creation date |
| Created By Contact | createdBy_id | Contact | ID for Contact that created record |
| Custom Field 01 | customField01 | String | referring to the custom fields in Learndot. Click here to learn more. |
| Custom Field 02 | customField02 | String | |
| Custom Field 03 | customField03 | String | |
| Custom Field 04 | customField04 | String | |
| Custom Field 05 | customField05 | String | |
| Custom Field 06 | customField06 | String | |
| Custom Field 07 | customField07 | String | |
| Custom Field 08 | customField08 | String | |
| Custom Field 09 | customField09 | String | |
| Custom Field 10 | customField10 | String | |
| ExternalId | ExternalId | String | Reflects the ExternalId field in Learndot. |
Catalog Item
| Fields | Label | Type | Description |
|---|---|---|---|
| Identifier | identifier | String | A unique key for the item formed by the concatenation of type of item with the non-unique id. e.g. "product-15" |
| Name | name | String | The text name of the respective component from the catalog. |
| Type of Item | type | String | Options:
|
| Status | status | String | Options:
|
| Price Currency | priceCurrency | String | e.g. USD |
| Price Amount | priceAmount | Number | e.g. 2000.00 |
Category
| Fields | Label | Description |
|---|---|---|
| Identifier | identifier | A unique key for the category formed by the concatenation of the type of the category with non-unique id. e.g. "knowledge_category-51" |
| Name | name | The text name of the category |
Contact
| Fields | Label | Type | Description |
|---|---|---|---|
| ID | id | Integer | |
| String | |||
| First Name | firstName | String | |
| Last Name | lastName | String | |
| Street 1 | street1 | String | |
| Street 2 | street2 | String | |
| City | city | String | |
| Region | region | String | |
| Postal Code | postalCode | String | |
| Country Alpha 2 Code | country_alpha2code | String | |
| Birth Date | birthDate | Date | |
| Title | title | String | |
| Department | department | String | |
| Salutation | salutation | String | |
| Office Phone | officephone | String | |
| Mobile Phone | mobilephone | String | |
| Home Phone | homephone | String | |
| Fax | fax | String | |
| Email Verified | emailverified | Boolean | |
| Enabled | enabled | Boolean | |
| Staff Enabled | staffEnabled | Boolean | |
| Tax ID | taxID | String | |
| Last Password Reset | lastPasswordReset | Date/Time | |
| Last Successful Login | lastSuccessfulLogin | Date/Time | |
| Name | name | String | |
| Number of Successful Logins | numberOfSuccessfulLogins | Integer | |
| Number of Forum Posts | numberOfForumPosts | Integer | |
| Created Date | created | Date/Time | |
| Account | account_id | Account | |
| Referrer URL | referrerUrl | LongText | |
| Landing URL | landingUrl | LongText | |
| Provider Id | provider_id | BigInt | |
| Expert Status | expertStatus | String | |
| Custom Field 01 | customField01 | String | referring to the custom fields in Learndot. Click here to learn more. |
| Custom Field 02 | customField02 | String | |
| Custom Field 03 | customField03 | String | |
| Custom Field 04 | customField04 | String | |
| Custom Field 05 | customField05 | String | |
| Custom Field 06 | customField06 | String | |
| Custom Field 07 | customField07 | String | |
| Custom Field 08 | customField08 | String | |
| Custom Field 09 | customField09 | String | |
| Custom Field 10 | customField10 | String | |
| External ID | externalId | String | |
| Receive Promotional Offers | receivePromotionalOffers | Boolean | |
| Receive News Letter | receiveNewsletter | Boolean | |
| Open Id | openId | String |
Course
| Fields | Label | Type | Description |
|---|---|---|---|
| Id | id | Integer | Unique Learndot ID |
| Name | name | String | |
| Type | type | String | Options:
|
Enrollment
| Fields | Label | Type | Description |
|---|---|---|---|
| Status | status | String | |
| Completion Date | completionDate | Date/Time | |
| Expiry Date | expiryDate | Date/Time | |
| Score | score | Integer | |
| Total Seconds Tracked | totalSecondsTracked | Integer | |
| Confidence | confidence | Integer | |
| Id | id | Integer | |
| Component | component_id | Learning Component | |
| Contact | contact_id | Contact | |
| Event | event_id | Event | |
| Created Date | created | Date/Time | |
| Modified Date | modified | Date/Time | |
| Provider | provider_id | Provider | |
| Order Item | orderitem_id | Order Item | |
| Parent Id | parentId | bigint | |
| Top Id | topId | bigint | |
| Custom Field 01 | customField01 | String | referring to the custom fields in Learndot. Click here to learn more. |
| Custom Field 02 | customField02 | String | |
| Custom Field 03 | customField03 | String | |
| Custom Field 04 | customField04 | String | |
| Custom Field 05 | customField05 | String | |
| Custom Field 06 | customField06 | String | |
| Custom Field 07 | customField07 | String | |
| Custom Field 08 | customField08 | String | |
| Custom Field 09 | customField09 | String | |
| Custom Field 10 | customField10 | String | |
| UUID | uuid | String |
Event
From Events:
Events represent Instructor Led Training taking place at a particular time, in a particular Location.
| Fields | Label | Type | Description |
|---|---|---|---|
| Capacity | capacity | Integer | |
| Course ID | course_id | Course | |
| ID | id | Integer | Unique Learndot ID |
| Location ID | location_id | Location | Relationship to Location Object |
| Total Hours | totalHours | Integer | |
| Provider ID | provider_id | Provider | Relationship to Provider Object |
| Type | type | String | Options:
|
| Language | language | String | |
| Equipment Provided | equipmentProvided | Boolean | 0 or 1 |
| Refreshments Provided | refreshmentsProvided | Boolean | 0 or 1 |
| Food Provided | foodProvided | Boolean | 0 or 1 |
| Snacks Provided | snacksProvided | Boolean | 0 or 1 |
| Start Time | startTime | Date/Time | Timestamp of when the Class is scheduled to start Time zone: UTC+0 |
| Status | status | String | Options:
|
| Session URL | sessionURL | String | |
| End Time | endTime | DateTime | Time zone: UTC+0 |
| Version | courseVersion | String | |
| Note | notes | LongText | |
| Regular Price Amount | regularPriceAmount | Decimal | |
| Regular Price Currency | regularPriceCurrency | Varchar | |
| Custom Field 01 | customField01 | string | |
| Custom Field 02 | customField02 | string | |
| Custom Field 03 | customField03 | string | |
| Custom Field 04 | customField04 | string | |
| Custom Field 05 | customField05 | string | |
| Custom Field 06 | customField06 | string | |
| Custom Field 07 | customField07 | string | |
| Custom Field 08 | customField08 | string | |
| Custom Field 09 | customField09 | string | |
| Custom Field 10 | customField10 | string | |
| urlName | urlName | string |
Instructor
| Fields | Label | Type | Description |
|---|---|---|---|
| Contact | contact_id | Contact | Relationship to Contact Object |
| Event | event | Event | Relationship to Event Object |
| Modified Date | modified | Date/Time | event modified date |
| Id | id | String | Concatenation of Event Id and Contact Id to form a unique Id. |
Lead
| Fields | Label | Type | Description |
|---|---|---|---|
| Id | id | Integer | |
| Status | status | String | |
| Created Date | created | Date/Time | |
| Contact | contact_id | Contact | |
| Subject | subject | string | |
| Quantity | quantity | Integer |
Learning Component
| Fields | Label | Type | Description |
|---|---|---|---|
| Id | id | Integer | |
| Name | name | String | |
| Language | language | String | |
| Type | type | String | |
| ExpiryDays | expiryDays | Integer |
Location
| Fields | Label | Type | Description |
|---|---|---|---|
| Id | id | Integer | |
| City | city | String | |
| Region | region | String | |
| Country Alpha 2 Code | country_alpha2Code | String | |
| Postal Code | postalCode | String | |
| Name | name | String | |
| Timezone | timezone | String | |
| Online | online | Boolean | A flag to indicate if Location is Virtual (Online). |
Order
| Fields | Label | Type | Description |
|---|---|---|---|
| Id | id | Integer | |
| Status | status | String | |
| Contact | contact_id | Contact | |
| Account | account_id | Account | |
| Payment | payment_id | Payment | |
| Created Date | created | Date/Time | |
| Created By Contact | createdBy_id | Contact | |
| Modified Date | modified | Date/Time | |
| Modified By Contact | modifiedBy_id | Contact | |
| Total | total | Decimal | |
| discountrule_id | discountrule_id | Integer | |
| coupon_code | code | string | |
| discountrule_name | discountrule_name | string |
Order Item
| Fields | Label | Type | Description |
|---|---|---|---|
| Category | category | String | |
| Contact | contact_id | Contact | |
| Created Date | created | Date/Time | |
| Discount | discount | Decimal | |
| Id | id | Integer | |
| Order | order_id | Order | |
| Account | account_id | Account | |
| Paid | paid | Boolean | |
| Payment | payment_id | Payment | |
| Price Amount | priceAmount | Decimal | |
| Provider | provider_id | Provider | |
| Status | status | String | |
| Catalog Item | catalogItem | Catalog Item | |
| Tax Amount | taxAmount | Decimal | |
| Total | total | Decimal | |
| Training Credits | trainingCredits | Decimal | |
| Value Amount | valueAmount | Decimal | |
| Value Currency | valueCurrency | String | |
| Target Type | targetType | varchar | |
| Target Id | targetId | bigint |
Payment
| Fields | Label | Type | Description |
|---|---|---|---|
| Id | id | Integer | |
| First Name | firstName | String | |
| Last Name | lastName | String | |
| Account Name | account_name | String | |
| Tax Id | taxId | String | |
| Tax Country Alpha 2 Code | taxcountry_alpha2Code | String | |
| Phone | phone | String | |
| String | |||
| Currency | currency | String | |
| Failure Message | failureMessage | String | |
| Status | status | String | |
| Street 1 | street1 | String | |
| Street 2 | street2 | String | |
| City | city | String | |
| Region | region | String | |
| Postal Code | postalCode | String | |
| Country 2 Alpha 2 Code | country_alpha2Code | String | |
| Date Processed | processingDate | Date/Time | |
| Processing Number | processingNumber | String | |
| Payment Type | type | String | Options:
|
| Amount | amount | Decimal | |
| Order | order_id | Order | |
| Created Date | created | Date/Time | |
| Value Amount | valueAmount | Decimal | |
| Value Currency | valueCurrency | String |
Provider
| Fields | Label | Type | Description |
|---|---|---|---|
| Id | id | Integer | |
| Name | name | String |
Training Credit Account
| Fields | Label | Type | Description |
|---|---|---|---|
| Id | id | Integer | |
| Name | name | String | |
| Created | created | Date/Time | |
| Balance | balance | Decimal |
Training Credit Expiry
| Fields | Label | Type | Description |
|---|---|---|---|
| Training Credit Account | account_id | Training Credit Account | |
| Expiry | expiry | Date/Time | |
| Amount | amount | Decimal |
Training Credit Redemption Request
| Fields | Label | Type | Description |
|---|---|---|---|
| Amount | amount | Decimal | |
| Id | id | Integer | |
| Status | status | String | |
| Training Credit Account | account_id | Training Credit Account | |
| Order | order_id | Order | |
| Requester Contact | requester_id | Contact | |
| Payment | payment_id | Payment | |
| Created Date | created | Date/Time | |
| Expiry Date | expiry | Date/Time |
Training Credit Transaction
| Fields | Label | Type | Description |
|---|---|---|---|
| Amount | amount | Decimal | |
| Reconciled | reconciled | Boolean | |
| Training Credit Account | account_id | Training Credit Account | |
| Created Date | created | Date/Time | |
| Value Amount | valueAmount | Decimal | |
| Value Currency | valueCurrency | String |
Training Credit Transaction Owner
| Fields | Label | Type | Description |
|---|---|---|---|
| ID | Id | Big_Int (Big Integer) | This field is a concatenation of Owner Id and Account Id |
| Owner ID | owner_id | Integer | This field refers to Contact Id in Contact table |
| Account ID | account_id | Integer | This field refers to the Id in training credit account table |
Course Requirement
| Fields | Label | Type | Description |
|---|---|---|---|
| ID | id | Integer | |
| Component ID | component_id | Integer | |
| Pathway ID | pathway_id | Integer | |
| Component Name | name | String | |
| Course Type | type | String | Type: Course,Module,Section |
Enrolment Root
| Fields | Label | Type | Description |
|---|---|---|---|
| enrolment_id | enrolment_id | Integer | related to the enrolment table id |
| root_id | root_id | Integer | it is a root of the enrolment (course) |
Enrolment Parent
| Fields | Label | Type | Description |
|---|---|---|---|
| enrolment_id | enrolment_id | Integer | related to the enrolment table id |
| parent_id | parent_id | Integer | referring to the parent of the enrolment |
Tables from Hosted Videos:
Actions
| Fields | Label | Type | Description |
|---|---|---|---|
| ID | id | char | Id of the action |
| Session ID | session_id | char | What session did this Action belong to |
| Name | name | varchar | Name of the action (for example, Play, Pause, Seek, and others) |
| Performed At | performed_at | datetime | When was this Action performed |
| Fullscreen | fullscreen | tinyint | Was a Fullscreen performed? |
| Volume | volume | float | Was the Volume toggle adjusted? |
| Video Current Time | video_current_time | float | What was the time in the Video when the Action was performed in seconds? |
| Progress | progress | float | Percentage of how much of the video was consumed |
| Seek To | seek_to | float | To what point in the video did the learner drag the video slider to? |
| Seek From | seek_from | float | From what point in the video the did learner drag the video slider from? |
| Created At | created_at | datetime | What was the timestamp when this action inserted into the Database |
| Modified At | modified_at | datetime | What was the timestamp when this action was updated into the Database |
| Order | order | int |
Sessions
| Fields | Label | Type | Description |
|---|---|---|---|
| ID | id | char | Id of the Active session |
| Enrollment ID | enrollment_id | char | This is the same as the Learners enrollment UUID |
| Lesson ID | lesson_id | varchar | This is the Learndot eLearning component Id |
| Lesson Name | lesson_name | varchar | This is the Learndot eLearning component name |
| User ID | user_id | varchar | This is the Learndot Contact Id |
| User Name | user_name | varchar | This is the Learndot Contact name |
| Browser | browser | varchar | What browser was the Learner using |
| OS | os | varchar | What Operating System was the Learner using |
| Screen Width | screen_width | int | What is the Screen width |
| Screen Height | screen_height | int | What is the Screen height |
| Session Start | session_start | datetime | At what time was the session started? |
| Video Width | video_width | int | What was the width of the video |
| Video Height | video_height | int | What was the height of the video |
| Video ID | video_id | varchar | What is the UUID of the video |
| Video Length | video_length | float | How long is the video in terms of duration in seconds |
| Video Name | video_name | varchar | This is the eLearning component name |
| Created At | created_at | datetime | when was this session inserted into the database |
| Modified At | modified_at | datetime | when was the last update performed on this session |
Watched Segments
| Fields | Label | Type | Description |
|---|---|---|---|
| Session ID | session_id | char | Id of the Active session |
| Order | order | int | Order all segments by this field for a particular session to get their chronological order |
| Segment Started | segment_start | float | At what time stamp had the segment started in seconds |
| Segment Ended | segment_end | float | At what time stamp had the segment ended in seconds |
| Created At | created_at | datetime | When was the segment inserted into Database |
| Modified At | modified_at | datetime | When was the last update performed on this segment |