# Skilljar schema ERD

Table and field reference for the Fivetran Skilljar connector.

## Table & Field Reference

### published_path_enrollment

| Column | Type | Keys |
| --- | --- | --- |
| domain_name | Unknown | PK |
| id | Unknown | PK |
| published_path_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| active | Unknown |  |
| enrolled_at | Unknown |  |
| expires_at | Unknown |  |
| offer_price_amount | Unknown |  |
| offer_price_currency_code | Unknown |  |
| order_id | Unknown |  |
| payment_processor | Unknown |  |
| purchase_id | Unknown |  |
| purchase_price_amount | Unknown |  |
| purchase_price_currency_code | Unknown |  |
| purchase_state | Unknown |  |
| purchased_at | Unknown |  |
| quantity | Unknown |  |
| tax_price_cents | Unknown |  |

### plan_enrollment

| Column | Type | Keys |
| --- | --- | --- |
| domain_name | Unknown | PK |
| id | Unknown | PK |
| plan_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| active | Unknown |  |
| enrolled_at | Unknown |  |
| expires_at | Unknown |  |
| offer_price_amount | Unknown |  |
| offer_price_currency_code | Unknown |  |
| order_id | Unknown |  |
| payment_processor | Unknown |  |
| purchase_id | Unknown |  |
| purchase_price_amount | Unknown |  |
| purchase_price_currency_code | Unknown |  |
| purchase_state | Unknown |  |
| purchased_at | Unknown |  |
| quantity | Unknown |  |
| tax_price_cents | Unknown |  |

### signup_field_option

| Column | Type | Keys |
| --- | --- | --- |
| domain_name | Unknown | PK |
| id | Unknown | PK |
| signup_field_id | Unknown | PK, FK |
| value | Unknown |  |

### signup_field

| Column | Type | Keys |
| --- | --- | --- |
| domain_name | Unknown | PK |
| id | Unknown | PK |
| active | Unknown |  |
| help_text | Unknown |  |
| label | Unknown |  |
| orders | Unknown |  |
| regex_validator | Unknown |  |
| regex_validator_error_text | Unknown |  |
| required | Unknown |  |
| type | Unknown |  |

### offer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| domain_name | Unknown | PK, FK |
| course_series_id | Unknown | FK |
| plan_id | Unknown | FK |
| published_course_id | Unknown | FK |
| active | Unknown |  |
| currency_code | Unknown |  |
| ends_at | Unknown |  |
| max_quantity | Unknown |  |
| price_cents | Unknown |  |
| sku | Unknown |  |
| starts_at | Unknown |  |
| type | Unknown |  |

### published_course

| Column | Type | Keys |
| --- | --- | --- |
| domain_name | Unknown | PK |
| id | Unknown | PK |
| course_id | Unknown | PK, FK |
| offer_id | Unknown | FK |
| course_lesson_count | Unknown |  |
| course_required_lesson_count | Unknown |  |
| course_url | Unknown |  |
| hidden | Unknown |  |
| registration_ends_at | Unknown |  |
| registration_required | Unknown |  |
| registration_starts_at | Unknown |  |
| slug | Unknown |  |
| timezone | Unknown |  |

### path_item

| Column | Type | Keys |
| --- | --- | --- |
| domain_name | Unknown | PK |
| id | Unknown | PK |
| published_path_id | Unknown | PK, FK |
| course_id | Unknown | FK |
| published_course_id | Unknown | FK |
| orders | Unknown |  |

### published_course_enrollment

| Column | Type | Keys |
| --- | --- | --- |
| domain_name | Unknown | PK |
| id | Unknown | PK |
| published_course_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| active | Unknown |  |
| enrolled_at | Unknown |  |
| expires_at | Unknown |  |
| offer_price_amount | Unknown |  |
| offer_price_currency_code | Unknown |  |
| order_id | Unknown |  |
| payment_processor | Unknown |  |
| purchase_id | Unknown |  |
| purchase_price_amount | Unknown |  |
| purchase_price_currency_code | Unknown |  |
| purchase_state | Unknown |  |
| purchased_at | Unknown |  |
| quantity | Unknown |  |
| tax_price_cents | Unknown |  |

### course_label

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

### course

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| enforce_sequential_navigation | Unknown |  |
| long_description_html | Unknown |  |
| modified_at | Unknown |  |
| short_description | Unknown |  |
| title | Unknown |  |

### plan

| Column | Type | Keys |
| --- | --- | --- |
| domain_name | Unknown | PK |
| id | Unknown | PK |
| offer_id | Unknown | FK |
| hidden | Unknown |  |
| name | Unknown |  |
| short_description | Unknown |  |
| slug | Unknown |  |
| title | Unknown |  |
| url | Unknown |  |

### domain_user

| Column | Type | Keys |
| --- | --- | --- |
| domain_name | Unknown | PK |
| user_id | Unknown | PK |
| access_code | Unknown |  |
| access_code_id | Unknown |  |
| active | Unknown |  |
| enrolled_at | Unknown |  |
| expires_at | Unknown |  |
| marketing_option | Unknown |  |
| pool_id | Unknown |  |
| pool_name | Unknown |  |

### users_published_course_all_enrollment

| Column | Type | Keys |
| --- | --- | --- |
| enrollment_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| user_published_course_id | Unknown | PK, FK |
| active | Unknown |  |
| course_progress_id | Unknown |  |
| expires_at | Unknown |  |

### users_published_course

| Column | Type | Keys |
| --- | --- | --- |
| course_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| domain_name | Unknown | FK |
| enrollment_id | Unknown | FK |
| certificate | Unknown |  |
| course_lesson_count | Unknown |  |
| course_progress_completed_at | Unknown |  |
| course_progress_completed_lesson_count | Unknown |  |
| course_progress_completed_required_lesson_count | Unknown |  |
| course_progress_credit_unit_plural | Unknown |  |
| course_progress_credits_earned | Unknown |  |
| course_progress_id | Unknown |  |
| course_progress_latest_activity | Unknown |  |
| course_progress_max_score | Unknown |  |
| course_progress_score | Unknown |  |
| course_progress_success_status | Unknown |  |
| course_required_lesson_count | Unknown |  |
| enrolled_at | Unknown |  |

### quiz

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| html | Unknown |  |
| limit_question_count | Unknown |  |
| max_attempts | Unknown |  |
| name | Unknown |  |
| passing_percentage_correct | Unknown |  |
| randomize_answer | Unknown |  |
| randomize_question | Unknown |  |
| require_correct_response | Unknown |  |
| show_question_feedback | Unknown |  |
| show_results_on_failure | Unknown |  |
| time_limit_seconds | Unknown |  |

### lesson

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| course_id | Unknown | PK, FK |
| content_asset_id | Unknown |  |
| content_html | Unknown |  |
| content_quiz_id | Unknown |  |
| content_web_package_id | Unknown |  |
| description_html | Unknown |  |
| display_fullscreen | Unknown |  |
| optional | Unknown |  |
| orders | Unknown |  |
| search_keyword | Unknown |  |
| time_second | Unknown |  |
| title | Unknown |  |
| tooltip_html | Unknown |  |
| type | Unknown |  |

### course_series

| Column | Type | Keys |
| --- | --- | --- |
| domain_name | Unknown | PK |
| id | Unknown | PK |
| offer | Unknown |  |
| published_course_count | Unknown |  |
| series_url | Unknown |  |
| title | Unknown |  |
| visible_on_catalog | Unknown |  |

### groups

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| user_count | Unknown |  |

### quiz_question_answer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| quiz_question_id | Unknown | PK, FK |
| quiz_question_quiz_id | Unknown | PK, FK |
| answer_text | Unknown |  |
| correct | Unknown |  |
| orders | Unknown |  |

### quiz_question

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| quiz_id | Unknown | PK, FK |
| answer_feedback_html | Unknown |  |
| case_sensitive | Unknown |  |
| correct_answer_feedback_html | Unknown |  |
| html | Unknown |  |
| incorrect_answer_feedback_html | Unknown |  |
| is_graded | Unknown |  |
| is_optional | Unknown |  |
| orders | Unknown |  |
| requires_manual_grading | Unknown |  |
| type | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| completion_count | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| latest_activity | Unknown |  |
| registration_count | Unknown |  |
| signed_up_at | Unknown |  |

### domain_access_code

| Column | Type | Keys |
| --- | --- | --- |
| domain_access_code_pool_domain_name | Unknown | PK |
| id | Unknown | PK |
| domain_access_code_pool_id | Unknown | PK, FK |
| active | Unknown |  |
| code | Unknown |  |
| duration | Unknown |  |
| duration_unit | Unknown |  |
| max_uses | Unknown |  |
| use_count | Unknown |  |

### course_series_published_course

| Column | Type | Keys |
| --- | --- | --- |
| domain_name | Unknown | PK |
| course_series_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| course_id | Unknown | FK |
| offer_id | Unknown | FK |
| allow_self_service_reenroll | Unknown |  |
| require_all_prerequisites | Unknown |  |
| restrict_access_start_end_dates | Unknown |  |
| strict_enforce_group_visibility | Unknown |  |
| unique_progress_per_enrollment | Unknown |  |

### published_path

| Column | Type | Keys |
| --- | --- | --- |
| domain_name | Unknown | PK |
| id | Unknown | PK |
| offer_id | Unknown | FK |
| path_id | Unknown |  |
| path_path_item_count | Unknown |  |
| path_title | Unknown |  |
| path_url | Unknown |  |

### domain_access_code_pool

| Column | Type | Keys |
| --- | --- | --- |
| domain_name | Unknown | PK |
| id | Unknown | PK |
| active | Unknown |  |
| channel | Unknown |  |
| end_date | Unknown |  |
| expire_domain_membership | Unknown |  |
| name | Unknown |  |
| start_date | Unknown |  |

### domain

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| access | Unknown |  |
| access_code_message_html | Unknown |  |
| catalog_title | Unknown |  |
| marketing_message | Unknown |  |
| name | Unknown |  |
| private | Unknown |  |

### group_user

| Column | Type | Keys |
| --- | --- | --- |
| group_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| created_at | Unknown |  |

### domain_user_invite

| Column | Type | Keys |
| --- | --- | --- |
| domain_name | Unknown | PK |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| invite_url | Unknown |  |
| sent_at | Unknown |  |
| token | Unknown |  |
| used_at | Unknown |  |

### course_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| lesson_progress_id | Unknown | PK, FK |
| name | Unknown |  |
| slug | Unknown |  |

### quiz_completion

| Column | Type | Keys |
| --- | --- | --- |
| lesson_progress_id | Unknown | PK |
| course_id | Unknown | FK |
| domain_id | Unknown | FK |
| lesson_id | Unknown | FK |
| user_id | Unknown | FK |
| attempted_question_count | Unknown |  |
| completed_at | Unknown |  |
| correct_response_count | Unknown |  |
| course_enrollment_id | Unknown |  |
| course_url | Unknown |  |
| elapsed_time | Unknown |  |
| event_type | Unknown |  |
| finish_time | Unknown |  |
| graded_question_count | Unknown |  |
| passed | Unknown |  |
| published_course_id | Unknown |  |
| question_count | Unknown |  |
| signup_field | Json |  |
| start_time | Unknown |  |
| time_limit | Unknown |  |
| timestamps | Unknown |  |

### path_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| path_id | Unknown | PK, FK |
| path_progress_id | Unknown | PK, FK |
| name | Unknown |  |
| slug | Unknown |  |

### path_completion

| Column | Type | Keys |
| --- | --- | --- |
| path_id | Unknown | PK |
| path_progress_id | Unknown | PK |
| domain_id | Unknown | FK |
| path_published_path_id | Unknown | FK |
| user_id | Unknown | FK |
| event_type | Unknown |  |
| path_progress_completed_at | Unknown |  |
| path_progress_completed_path_object | Unknown |  |
| path_progress_enrolled_at | Unknown |  |
| path_progress_latest_activity | Unknown |  |
| path_progress_total_required_path_object | Unknown |  |
| path_title | Unknown |  |
| path_url | Unknown |  |
| signup_field | Json |  |
| timestamps | Unknown |  |

## Relationships

- published_path_enrollment(user_id) → users(id)
- published_path_enrollment(published_path_id) → published_path(id)
- plan_enrollment(user_id) → users(id)
- plan_enrollment(plan_id) → plan(id)
- signup_field_option(signup_field_id) → signup_field(id)
- offer(course_series_id) → course_series(id)
- offer(domain_name) → domain(name)
- offer(plan_id) → plan(id)
- offer(published_course_id) → published_course(id)
- published_course(offer_id) → offer(id)
- published_course(course_id) → course(id)
- path_item(published_course_id) → published_course(id)
- path_item(course_id) → course(id)
- path_item(published_path_id) → published_path(id)
- published_course_enrollment(user_id) → users(id)
- published_course_enrollment(published_course_id) → published_course(id)
- course_label(course_id) → course(id)
- plan(offer_id) → offer(id)
- users_published_course_all_enrollment(enrollment_id) → published_course_enrollment(id)
- users_published_course_all_enrollment(user_id) → users_published_course(user_id)
- users_published_course_all_enrollment(user_published_course_id) → users_published_course(course_id)
- users_published_course(id) → published_course(id)
- users_published_course(course_id) → course(id)
- users_published_course(domain_name) → domain(name)
- users_published_course(enrollment_id) → published_course_enrollment(id)
- users_published_course(user_id) → users(id)
- lesson(course_id) → course(id)
- quiz_question_answer(quiz_question_id) → quiz_question(id)
- quiz_question_answer(quiz_question_quiz_id) → quiz_question(quiz_id)
- quiz_question(quiz_id) → quiz(id)
- domain_access_code(domain_access_code_pool_id) → domain_access_code_pool(id)
- course_series_published_course(id) → published_course(id)
- course_series_published_course(course_id) → course(id)
- course_series_published_course(offer_id) → offer(id)
- course_series_published_course(course_series_id) → course_series(id)
- published_path(offer_id) → offer(id)
- group_user(user_id) → users(id)
- group_user(group_id) → groups(id)
- domain_user_invite(user_id) → domain_user(user_id)
- course_tag(lesson_progress_id) → quiz_completion(lesson_progress_id)
- quiz_completion(user_id) → users(id)
- quiz_completion(domain_id) → domain(id)
- quiz_completion(lesson_id) → lesson(id)
- quiz_completion(course_id) → course(id)
- path_tag(path_progress_id) → path_completion(path_progress_id)
- path_tag(path_id) → path_completion(path_id)
- path_completion(user_id) → users(id)
- path_completion(domain_id) → domain(id)
- path_completion(path_published_path_id) → published_path(id)