# Udemy Business schema ERD

Table and field reference for the Fivetran Udemy Business connector.

## Table & Field Reference

### user_assessment_activity

| Column | Type | Keys |
| --- | --- | --- |
| assessment_id | Unknown | PK |
| user_id | Unknown | PK |
| user_email | Unknown | FK |
| assessment_title | Unknown |  |
| assigned_by | Unknown |  |
| assigned_due_date | Unknown |  |
| assigned_on | Unknown |  |
| highest_proficiency_level | Unknown |  |
| interacted_with_guidance | Unknown |  |
| last_activity_date | Unknown |  |
| number_of_attempt | Unknown |  |
| number_of_completed_assessment | Unknown |  |
| total_time_spent | Unknown |  |

### learning_activity_attempt

| Column | Type | Keys |
| --- | --- | --- |
| user_email | Unknown | PK, FK |
| course_id | Unknown | FK |
| item_id | Unknown | FK |
| course_category | Unknown |  |
| item_completion_ratio | Unknown |  |
| item_completion_time | Unknown |  |
| item_final_result | Unknown |  |
| item_marked_complete | Unknown |  |
| item_start_time | Unknown |  |
| item_title | Unknown |  |
| item_type | Unknown |  |
| item_views | Unknown |  |

### course_category

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

### course_topic

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| course_id | Unknown | PK, FK |
| id | Unknown |  |
| title | Unknown |  |
| url | Unknown |  |

### course_promo_video

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

### course_instructor

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

### course_requirement_list

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

### course_learn_list

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

### course_caption_language

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

### course_caption_locale

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| course_id | Unknown | PK, FK |
| english_title | Unknown |  |
| locale | Unknown |  |
| title | Unknown |  |

### course

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| accreditation | Json |  |
| description | Unknown |  |
| estimated_content_length | Unknown |  |
| estimated_content_length_video | Unknown |  |
| has_closed_caption | Unknown |  |
| headline | Unknown |  |
| images_size_100_x_100 | Unknown |  |
| images_size_125_h | Unknown |  |
| images_size_200_h | Unknown |  |
| images_size_240_x_135 | Unknown |  |
| images_size_304_x_171 | Unknown |  |
| images_size_480_x_270 | Unknown |  |
| images_size_48_x_27 | Unknown |  |
| images_size_50_x_50 | Unknown |  |
| images_size_750_x_422 | Unknown |  |
| images_size_75_x_75 | Unknown |  |
| images_size_96_x_54 | Unknown |  |
| is_custom | Unknown |  |
| is_imported | Unknown |  |
| is_practice_test_course | Unknown |  |
| last_update_date | Unknown |  |
| level | Unknown |  |
| locale_locale | Unknown |  |
| mobile_native_deeplink | Unknown |  |
| num_lectures | Unknown |  |
| num_practice_tests | Unknown |  |
| num_quizzes | Unknown |  |
| num_videos | Unknown |  |
| primary_category_id | Unknown |  |
| primary_category_title | Unknown |  |
| primary_category_url | Unknown |  |
| primary_subcategory_id | Unknown |  |
| primary_subcategory_title | Unknown |  |
| primary_subcategory_url | Unknown |  |
| title | Unknown |  |
| url | Unknown |  |
| xapi_activity_id | Unknown |  |

### user_path_activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_email | Unknown | FK |
| completion_ratio | Unknown |  |
| is_path_assigned | Unknown |  |
| is_private_path | Unknown |  |
| is_pro_path | Unknown |  |
| lms_user_id | Unknown |  |
| path_assigned_by | Unknown |  |
| path_assigned_due_date | Unknown |  |
| path_assigned_on | Unknown |  |
| path_completion_date | Unknown |  |
| path_consumed_minutes | Unknown |  |
| path_enrolled_date | Unknown |  |
| path_first_activity_date | Unknown |  |
| path_last_activity_date | Unknown |  |

### user_activity

| Column | Type | Keys |
| --- | --- | --- |
| user_email | Unknown | PK |
| last_date_visit | Unknown |  |
| num_completed_courses | Unknown |  |
| num_completed_lectures | Unknown |  |
| num_completed_quizzes | Unknown |  |
| num_new_assigned_courses | Unknown |  |
| num_new_enrolled_courses | Unknown |  |
| num_new_started_courses | Unknown |  |
| num_video_consumed_minutes | Unknown |  |
| num_web_visited_days | Unknown |  |
| user_external_id | Unknown |  |
| user_is_deactivated | Unknown |  |
| user_joined_date | Unknown |  |
| user_name | Unknown |  |
| user_role | Unknown |  |
| user_surname | Unknown |  |

### learning_path_editor

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| learning_path_id | Unknown | PK, FK |
| display_name | Unknown |  |
| email | Unknown |  |
| lms_user_id | Unknown |  |

### learning_path_section_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| section_id | Unknown | PK, FK |
| duration | Unknown |  |
| number_of_items | Unknown |  |
| orders | Unknown |  |
| resource_url | Unknown |  |
| thumbnail_size_100_x_100 | Unknown |  |
| thumbnail_size_125_h | Unknown |  |
| thumbnail_size_200_h | Unknown |  |
| thumbnail_size_240_x_135 | Unknown |  |
| thumbnail_size_304_x_171 | Unknown |  |
| thumbnail_size_480_x_270 | Unknown |  |
| thumbnail_size_48_x_27 | Unknown |  |
| thumbnail_size_50_x_50 | Unknown |  |
| thumbnail_size_750_x_422 | Unknown |  |
| thumbnail_size_75_x_75 | Unknown |  |
| thumbnail_size_96_x_54 | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| url | Unknown |  |

### learning_path_section

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| learning_path_id | Unknown | PK, FK |
| description | Unknown |  |
| orders | Unknown |  |
| title | Unknown |  |

### learning_path_locale

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| learning_path_id | Unknown | PK, FK |
| locale | Unknown |  |

### learning_path_category

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| learning_path_id | Unknown | PK, FK |
| category | Unknown |  |

### learning_path_folder

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| learning_path_id | Unknown | PK, FK |
| description | Unknown |  |
| title | Unknown |  |

### learning_path

| Column | Type | Keys |
| --- | --- | --- |
| title | Unknown | PK |
| id | Unknown | PK, FK |
| created | Unknown |  |
| description | Unknown |  |
| estimated_content_length | Unknown |  |
| is_pro_path | Unknown |  |
| last_modified | Unknown |  |
| number_of_content_item | Unknown |  |
| url | Unknown |  |

### user_course_activity

| Column | Type | Keys |
| --- | --- | --- |
| user_id | Unknown | PK |
| course_id | Unknown | PK, FK |
| user_email | Unknown | FK |
| assigned_by | Unknown |  |
| completion_ratio | Unknown |  |
| course_category | Unknown |  |
| course_completion_date | Unknown |  |
| course_duration | Unknown |  |
| course_enroll_date | Unknown |  |
| course_first_completion_date | Unknown |  |
| course_last_accessed_date | Unknown |  |
| course_start_date | Unknown |  |
| course_title | Unknown |  |
| is_assigned | Unknown |  |
| is_user_deactivated | Unknown |  |
| lms_user_id | Unknown |  |
| num_video_consumed_minutes | Unknown |  |
| user_external_id | Unknown |  |
| user_name | Unknown |  |
| user_role | Unknown |  |
| user_surname | Unknown |  |

### user_lab_activtiy

| Column | Type | Keys |
| --- | --- | --- |
| lab_id | Unknown | PK |
| user_email | Unknown | PK, FK |
| lab_assigned_by | Unknown |  |
| lab_assigned_due_date | Unknown |  |
| lab_assigned_on | Unknown |  |
| lab_completed | Unknown |  |
| lab_started | Unknown |  |
| lab_title | Unknown |  |
| last_activity_date | Unknown |  |
| total_time_spent | Unknown |  |

## Relationships

- user_assessment_activity(user_email) → user_activity(user_email)
- learning_activity_attempt(user_email) → user_activity(user_email)
- learning_activity_attempt(item_id) → learning_path_section_item(id)
- learning_activity_attempt(course_id) → course(id)
- course_category(course_id) → course(id)
- course_topic(course_id) → course(id)
- course_promo_video(course_id) → course(id)
- course_instructor(course_id) → course(id)
- course_requirement_list(course_id) → course(id)
- course_learn_list(course_id) → course(id)
- course_caption_language(course_id) → course(id)
- course_caption_locale(course_id) → course(id)
- user_path_activity(user_email) → user_activity(user_email)
- learning_path_editor(learning_path_id) → learning_path(id)
- learning_path_section_item(section_id) → learning_path_section(id)
- learning_path_section(learning_path_id) → learning_path(id)
- learning_path_locale(learning_path_id) → learning_path(id)
- learning_path_category(learning_path_id) → learning_path(id)
- learning_path_folder(learning_path_id) → learning_path(id)
- learning_path(id) → user_path_activity(id)
- user_course_activity(user_email) → user_activity(user_email)
- user_course_activity(course_id) → course(id)
- user_lab_activtiy(user_email) → user_activity(user_email)