Skilljar
Explore the interactive ERD
Table & Field Reference
published_path_enrollment
| Column | Type | Keys |
|---|---|---|
domain_name | Unknown | PK |
id | Unknown | PK |
published_path_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
user_id | Unknown | PKFK |
user_published_course_id | Unknown | PKFK |
active | Unknown | |
course_progress_id | Unknown | |
expires_at | Unknown |
users_published_course
| Column | Type | Keys |
|---|---|---|
course_id | Unknown | PKFK |
id | Unknown | PKFK |
user_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
quiz_question_quiz_id | Unknown | PKFK |
answer_text | Unknown | |
correct | Unknown | |
orders | Unknown |
quiz_question
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
quiz_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
id | Unknown | PKFK |
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 | PKFK |
user_id | Unknown | PKFK |
created_at | Unknown |
domain_user_invite
| Column | Type | Keys |
|---|---|---|
domain_name | Unknown | PK |
id | Unknown | PK |
user_id | Unknown | PKFK |
invite_url | Unknown | |
sent_at | Unknown | |
token | Unknown | |
used_at | Unknown |
course_tag
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
course_enrollment_id | Unknown | PKFK |
lesson_progress_id | Unknown | PKFK |
name | Unknown | |
slug | Unknown |
quiz_completion
| Column | Type | Keys |
|---|---|---|
course_enrollment_id | Unknown | PK |
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_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 | PKFK |
path_progress_id | Unknown | PKFK |
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 |