Absorb LMS
Explore the interactive ERD
Table & Field Reference
user_group
| Column | Type | Keys |
|---|---|---|
groups_id | Unknown | PKFK |
user_id | Unknown | PKFK |
groups
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
date_added | Unknown | |
date_edited | Unknown | |
is_automatic | Unknown | |
name | Unknown |
prerequisite_course_info
| Column | Type | Keys |
|---|---|---|
course_id | Unknown | PKFK |
prerequisite_id | Unknown | PKFK |
prerequisite_competency_definition_info
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
prerequisite_id | Unknown | PKFK |
competency_definition_id | Unknown |
prerequisite
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown | |
prerequisite_type | Unknown | |
required_number | Unknown |
venue
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
address | Unknown | |
city | Unknown | |
country | Unknown | |
details | Unknown | |
max_class_size | Unknown | |
meeting_id | Unknown | |
name | Unknown | |
password | Unknown | |
phone_number | Unknown | |
postal_code | Unknown | |
province | Unknown | |
type | Unknown | |
url | Unknown | |
username | Unknown |
country
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
code | Unknown | |
name | Unknown |
chapter_enrollment
| Column | Type | Keys |
|---|---|---|
course_id | Unknown | PK |
id | Unknown | PK |
user_id | Unknown | PKFK |
chapter_id | Unknown | FK |
lesson_id | Unknown | FK |
session_id | Unknown | FK |
course_enrollment_id | Unknown | |
date_completed | Unknown | |
date_enrolled | Unknown | |
date_started | Unknown | |
full_name | Unknown | |
name | Unknown | |
progress | Unknown | |
score | Unknown | |
status | Unknown | |
time_spent | Unknown |
lesson
| Column | Type | Keys |
|---|---|---|
course_id | Unknown | PK |
id | Unknown | PK |
chapter_id | Unknown | FK |
description | Unknown | |
height | Unknown | |
name | Unknown | |
notes | Unknown | |
orders | Unknown | |
passing_score | Unknown | |
ref_id | Unknown | |
type | Unknown | |
url | Unknown | |
use_popup | Unknown | |
weight | Unknown | |
width | Unknown |
session_schedule
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
session_id | Unknown | FK |
venue_id | Unknown | FK |
date_end | Unknown | |
date_start | Unknown | |
meeting_id | Unknown | |
meeting_password | Unknown | |
meeting_username | Unknown | |
time_zone_id | Unknown |
department
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
parent_id | Unknown | FK |
company_name | Unknown | |
currency_id | Unknown | |
date_added | Unknown | |
date_edited | Unknown | |
email_address | Unknown | |
external_id | Unknown | |
name | Unknown | |
phone_number | Unknown | |
use_department_contact_details | Unknown |
curriculum_group_course
| Column | Type | Keys |
|---|---|---|
curriculum_group_id | Unknown | PKFK |
curriculum_id | Unknown | PKFK |
id | Unknown | PKFK |
orders | Unknown |
curriculum_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
curriculum_id | Unknown | PKFK |
name | Unknown | |
orders | Unknown | |
required_number_of_courses | Unknown |
user_role_info
| Column | Type | Keys |
|---|---|---|
role_id | Unknown | PK |
user_id | Unknown | PKFK |
id | Unknown | FK |
user_email_address
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
user_id | Unknown | PKFK |
email_address | Unknown |
user_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
users_id | Unknown | PKFK |
value | Unknown |
users
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
country_id | Unknown | FK |
department_id | Unknown | FK |
language_id | Unknown | FK |
province_id | Unknown | FK |
active_status | Unknown | |
address | Unknown | |
address_2 | Unknown | |
city | Unknown | |
date_added | Unknown | |
date_edited | Unknown | |
date_hired | Unknown | |
date_terminated | Unknown | |
email_address | Unknown | |
external_id | Unknown | |
first_name | Unknown | |
gender | Unknown | |
has_username | Unknown | |
is_admin | Unknown | |
is_instructor | Unknown | |
is_learner | Unknown | |
job_title | Unknown | |
last_login_date | Unknown | |
last_name | Unknown | |
location | Unknown | |
middle_name | Unknown | |
notes | Unknown | |
password | Unknown | |
phone | Unknown | |
postal_code | Unknown | |
supervisor_id | Unknown | |
username | Unknown |
tags
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown |
course_resource
| Column | Type | Keys |
|---|---|---|
course_id | Unknown | PKFK |
resource_id | Unknown | PKFK |
course_tag
| Column | Type | Keys |
|---|---|---|
course_id | Unknown | PKFK |
id | Unknown | PKFK |
course_prerequisite
| Column | Type | Keys |
|---|---|---|
course_id | Unknown | PKFK |
id | Unknown | PKFK |
course_editor_info
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
course_id | Unknown | PKFK |
editor_id | Unknown |
course_enrollment_info
| Column | Type | Keys |
|---|---|---|
enrollment_course_id | Unknown | PK |
course_id | Unknown | PKFK |
course_price
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
course_id | Unknown | PKFK |
price | Unknown |
course_competency_definition
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
course_id | Unknown | PKFK |
competency_definition_id | Unknown |
course
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
category_id | Unknown | FK |
access_date | Unknown | |
active_status | Unknown | |
allow_course_evaluation | Unknown | |
audience | Unknown | |
certificate_url | Unknown | |
company_cost | Unknown | |
company_time | Unknown | |
date_added | Unknown | |
date_edited | Unknown | |
description | Unknown | |
expire_duration_days | Unknown | |
expire_duration_hours | Unknown | |
expire_duration_months | Unknown | |
expire_duration_years | Unknown | |
expire_type | Unknown | |
expiry_date | Unknown | |
external_id | Unknown | |
goals | Unknown | |
learner_cost | Unknown | |
learner_time | Unknown | |
name | Unknown | |
notes | Unknown | |
type | Unknown | |
vendor | Unknown |
role
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
date_added | Unknown | |
date_edited | Unknown | |
description | Unknown | |
name | Unknown |
custom_filed_definition_possible_value
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
custom_field_definition_id | Unknown | PKFK |
name | Unknown |
custom_field_definition
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
behavior | Unknown | |
custom_field | Unknown | |
is_private | Unknown | |
name | Unknown | |
type | Unknown |
user_enrollment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | PKFK |
certificate_id | Unknown | FK |
course_collection_id | Unknown | FK |
course_id | Unknown | FK |
course_version_id | Unknown | FK |
enrollment_key_id | Unknown | FK |
accepted_terms_and_conditions | Unknown | |
access_date | Unknown | |
avatar | Unknown | |
course_name | Unknown | |
credits | Unknown | |
date_added | Unknown | |
date_completed | Unknown | |
date_due | Unknown | |
date_edited | Unknown | |
date_expire | Unknown | |
date_started | Unknown | |
full_name | Unknown | |
is_active | Unknown | |
job_title | Unknown | |
progress | Unknown | |
score | Unknown | |
status | Unknown | |
time_spent | Unknown | |
time_spent_ticks | Unknown |
category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
parent_id | Unknown | FK |
description | Unknown | |
name | Unknown |
course_version
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
course_id | Unknown | FK |
date_added | Unknown | |
name | Unknown | |
notes | Unknown | |
version_number | Unknown |
competency
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | PKFK |
category_name | Unknown | |
date_acquired | Unknown | |
level | Unknown | |
name | Unknown |
resource
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
description | Unknown | |
file | Unknown | |
name | Unknown |
question_bank_option
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
question_bank_question_id | Unknown | PKFK |
is_correct | Unknown | |
name | Unknown | |
orders | Unknown |
question_bank_question
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
question_bank_id | Unknown | FK |
attachment | Unknown | |
correct_reply | Unknown | |
incorrect_reply | Unknown | |
name | Unknown | |
question_type | Unknown |
lesson_enrollment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
course_id | Unknown | PKFK |
lesson_id | Unknown | PKFK |
chapter_enrollment_id | Unknown | FK |
chapter_id | Unknown | FK |
user_id | Unknown | FK |
attempt | Unknown | |
course_enrollment_id | Unknown | |
date_added | Unknown | |
date_completed | Unknown | |
date_edited | Unknown | |
date_enrolled | Unknown | |
date_started | Unknown | |
failure | Unknown | |
full_name | Unknown | |
last_attempt | Unknown | |
name | Unknown | |
progress | Unknown | |
score | Unknown | |
status | Unknown | |
time_spent | Unknown | |
type | Unknown |
session_enrollment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
course_id | Unknown | PKFK |
session_id | Unknown | PKFK |
user_id | Unknown | FK |
course_enrollment_id | Unknown | |
date_completed | Unknown | |
date_edited | Unknown | |
date_enrolled | Unknown | |
date_started | Unknown | |
full_name | Unknown | |
name | Unknown | |
progress | Unknown | |
score | Unknown | |
status | Unknown | |
time_spent | Unknown |
attendance
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
session_id | Unknown | PK |
session_schedule_id | Unknown | PKFK |
session_enrollment_id | Unknown | FK |
user_id | Unknown | FK |
date_edited | Unknown | |
is_present | Unknown |
session_instructor_info
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
course_id | Unknown | PKFK |
session_id | Unknown | PKFK |
instructor_id | Unknown |
session_approval_info
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
course_id | Unknown | PKFK |
session_id | Unknown | PKFK |
approval_id | Unknown | FK |
session_schedule_info
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
course_id | Unknown | PKFK |
session_id | Unknown | PKFK |
session_schedule_id | Unknown |
session
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
instructor_led_course_id | Unknown | PK |
allow_self_enrollment | Unknown | |
approval_type | Unknown | |
attendance_reminder | Unknown | |
date_added | Unknown | |
date_edited | Unknown | |
description | Unknown | |
enrollment_end_date | Unknown | |
enrollment_start_date | Unknown | |
external_id | Unknown | |
is_waitlist_enabled | Unknown | |
maximum_class_size | Unknown | |
minimum_class_size | Unknown | |
name | Unknown | |
notes | Unknown |
languages
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
abbreviation | Unknown | |
name | Unknown | |
native_name | Unknown |
coupon_course
| Column | Type | Keys |
|---|---|---|
coupon_id | Unknown | PKFK |
course_id | Unknown | PKFK |
coupon
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
department_id | Unknown | FK |
code | Unknown | |
date_added | Unknown | |
date_edited | Unknown | |
description | Unknown | |
discount | Unknown | |
discount_type | Unknown | |
expiry_date | Unknown | |
is_active | Unknown | |
max_uses | Unknown | |
name | Unknown |
user_certificate
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | PKFK |
enrollment_id | Unknown | FK |
acquired_date | Unknown | |
course_name | Unknown | |
date_added | Unknown | |
date_edited | Unknown | |
expiry_date | Unknown | |
full_name | Unknown | |
notes | Unknown |
user_session_detail_class
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
_fivetran_id | Unknown | PKFK |
user_id | Unknown | PKFK |
session_id | Unknown | FK |
venue_id | Unknown | FK |
meeting_description | Unknown | |
meeting_url | Unknown | |
timezone | Unknown | |
utc_end_date | Unknown | |
utc_start_date | Unknown |
user_session_detail
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
instructor_led_course_id | Unknown | FK |
user_id | Unknown | FK |
approval_type | Unknown | |
description | Unknown | |
enrollment_count | Unknown | |
enrollment_end_date | Unknown | |
enrollment_limit | Unknown | |
enrollment_minimum | Unknown | |
enrollment_start_date | Unknown | |
id | Unknown | |
is_waitlist_enabled | Unknown | |
name | Unknown |
chapter_lesson
| Column | Type | Keys |
|---|---|---|
chapter_id | Unknown | PKFK |
lesson_id | Unknown | PKFK |
chapter
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown | |
orders | Unknown |
question_bank
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown |
province
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
country_id | Unknown | FK |
name | Unknown |
enrollment_key_course
| Column | Type | Keys |
|---|---|---|
course_id | Unknown | PKFK |
enrollment_key_id | Unknown | PKFK |
course_collection_id | Unknown | FK |
session_id | Unknown | FK |
enrollment_key_signup_field
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
enrollment_key_id | Unknown | PKFK |
custom_field_definition_id | Unknown | FK |
behavior | Unknown | |
default_value | Unknown | |
is_behavior_changeable | Unknown | |
name | Unknown | |
type | Unknown |
enrollment_key
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
department_id | Unknown | FK |
language_id | Unknown | FK |
date_added | Unknown | |
date_edited | Unknown | |
expiry_date | Unknown | |
external_id | Unknown | |
key_name | Unknown | |
max_uses | Unknown | |
name | Unknown | |
send_new_user_message_on_enrollment | Unknown | |
start_date | Unknown | |
times_used | Unknown | |
user_enrollment_id | Unknown | |
username_type | Unknown |