# Absorb LMS schema ERD

Table and field reference for the Fivetran Absorb LMS connector.

## Table & Field Reference

### user_group

| Column | Type | Keys |
| --- | --- | --- |
| groups_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |

### 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 | PK, FK |
| prerequisite_id | Unknown | PK, FK |

### prerequisite_competency_definition_info

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| prerequisite_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| curriculum_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| orders | Unknown |  |

### curriculum_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| curriculum_id | Unknown | PK, FK |
| name | Unknown |  |
| orders | Unknown |  |
| required_number_of_courses | Unknown |  |

### user_role_info

| Column | Type | Keys |
| --- | --- | --- |
| role_id | Unknown | PK |
| user_id | Unknown | PK, FK |
| id | Unknown | FK |

### user_email_address

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| email_address | Unknown |  |

### user_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| users_id | Unknown | PK, FK |
| 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 | PK, FK |
| resource_id | Unknown | PK, FK |

### course_tag

| Column | Type | Keys |
| --- | --- | --- |
| course_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### course_prerequisite

| Column | Type | Keys |
| --- | --- | --- |
| course_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### course_editor_info

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| course_id | Unknown | PK, FK |
| editor_id | Unknown |  |

### course_enrollment_info

| Column | Type | Keys |
| --- | --- | --- |
| enrollment_course_id | Unknown | PK |
| course_id | Unknown | PK, FK |

### course_price

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| course_id | Unknown | PK, FK |
| price | Unknown |  |

### course_competency_definition

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| course_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| lesson_id | Unknown | PK, FK |
| 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 | PK, FK |
| session_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| session_id | Unknown | PK, FK |
| instructor_id | Unknown |  |

### session_approval_info

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| course_id | Unknown | PK, FK |
| session_id | Unknown | PK, FK |
| approval_id | Unknown | FK |

### session_schedule_info

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| course_id | Unknown | PK, FK |
| session_id | Unknown | PK, FK |
| 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 | PK, FK |
| course_id | Unknown | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |
| user_id | Unknown | PK, FK |
| 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 | PK, FK |
| lesson_id | Unknown | PK, FK |

### 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 | PK, FK |
| enrollment_key_id | Unknown | PK, FK |
| course_collection_id | Unknown | FK |
| session_id | Unknown | FK |

### enrollment_key_signup_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| enrollment_key_id | Unknown | PK, FK |
| 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 |  |

## Relationships

- user_group(user_id) → users(id)
- user_group(groups_id) → groups(id)
- prerequisite_course_info(course_id) → course(id)
- prerequisite_course_info(prerequisite_id) → prerequisite(id)
- prerequisite_competency_definition_info(prerequisite_id) → prerequisite(id)
- chapter_enrollment(user_id) → users(id)
- chapter_enrollment(chapter_id) → chapter(id)
- chapter_enrollment(lesson_id) → lesson(id)
- chapter_enrollment(session_id) → session(id)
- lesson(chapter_id) → chapter(id)
- session_schedule(venue_id) → venue(id)
- session_schedule(session_id) → session(id)
- department(parent_id) → department(id)
- curriculum_group_course(id) → course(id)
- curriculum_group_course(curriculum_group_id) → curriculum_group(id)
- curriculum_group_course(curriculum_id) → curriculum_group(curriculum_id)
- curriculum_group(curriculum_id) → course(id)
- user_role_info(user_id) → users(id)
- user_role_info(id) → role(id)
- user_email_address(user_id) → users(id)
- user_custom_field(users_id) → users(id)
- users(department_id) → department(id)
- users(province_id) → province(id)
- users(language_id) → languages(id)
- users(country_id) → country(id)
- course_resource(resource_id) → resource(id)
- course_resource(course_id) → course(id)
- course_tag(id) → tags(id)
- course_tag(course_id) → course(id)
- course_prerequisite(id) → course(id)
- course_prerequisite(course_id) → course(id)
- course_editor_info(course_id) → course(id)
- course_enrollment_info(course_id) → course(id)
- course_price(course_id) → course(id)
- course_competency_definition(course_id) → course(id)
- course(category_id) → category(id)
- custom_filed_definition_possible_value(custom_field_definition_id) → custom_field_definition(id)
- user_enrollment(user_id) → users(id)
- user_enrollment(certificate_id) → user_certificate(id)
- user_enrollment(course_version_id) → course_version(id)
- user_enrollment(course_collection_id) → course(id)
- user_enrollment(enrollment_key_id) → enrollment_key(id)
- user_enrollment(course_id) → course(id)
- category(parent_id) → category(id)
- course_version(course_id) → course(id)
- competency(user_id) → users(id)
- question_bank_option(question_bank_question_id) → question_bank_question(id)
- question_bank_question(question_bank_id) → question_bank(id)
- lesson_enrollment(user_id) → users(id)
- lesson_enrollment(chapter_id) → chapter(id)
- lesson_enrollment(chapter_enrollment_id) → chapter_enrollment(id)
- lesson_enrollment(lesson_id) → lesson(id)
- lesson_enrollment(course_id) → lesson(course_id)
- session_enrollment(user_id) → users(id)
- session_enrollment(session_id) → session(id)
- session_enrollment(course_id) → session(instructor_led_course_id)
- attendance(user_id) → users(id)
- attendance(session_enrollment_id) → session_enrollment(id)
- attendance(session_schedule_id) → session_schedule(id)
- session_instructor_info(course_id) → session(instructor_led_course_id)
- session_instructor_info(session_id) → session(id)
- session_approval_info(approval_id) → users(id)
- session_approval_info(course_id) → session(instructor_led_course_id)
- session_approval_info(session_id) → session(id)
- session_schedule_info(course_id) → session(instructor_led_course_id)
- session_schedule_info(session_id) → session(id)
- coupon_course(course_id) → course(id)
- coupon_course(coupon_id) → coupon(id)
- coupon(department_id) → department(id)
- user_certificate(enrollment_id) → user_enrollment(id)
- user_certificate(user_id) → users(id)
- user_session_detail_class(session_id) → session(id)
- user_session_detail_class(venue_id) → venue(id)
- user_session_detail_class(_fivetran_id) → user_session_detail(_fivetran_id)
- user_session_detail_class(user_id) → user_session_detail(user_id)
- user_session_detail(instructor_led_course_id) → course(id)
- user_session_detail(user_id) → users(id)
- chapter_lesson(lesson_id) → lesson(id)
- chapter_lesson(chapter_id) → chapter(id)
- province(country_id) → country(id)
- enrollment_key_course(course_id) → course(id)
- enrollment_key_course(session_id) → session(id)
- enrollment_key_course(course_collection_id) → course(id)
- enrollment_key_course(enrollment_key_id) → enrollment_key(id)
- enrollment_key_signup_field(custom_field_definition_id) → custom_field_definition(id)
- enrollment_key_signup_field(enrollment_key_id) → enrollment_key(id)
- enrollment_key(department_id) → department(id)
- enrollment_key(language_id) → languages(id)