Fivetran documentation

Search the docs

/

Udemy Business

Explore the interactive ERD

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	PKFK
`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	PKFK

course_topic

Column	Type	Keys
`index`	Unknown	PK
`course_id`	Unknown	PKFK
`id`	Unknown
`title`	Unknown
`url`	Unknown

course_promo_video

Column	Type	Keys
`index`	Unknown	PK
`course_id`	Unknown	PKFK
`file`	Unknown
`label`	Unknown
`type`	Unknown

course_instructor

Column	Type	Keys
`index`	Unknown	PK
`instructor`	Unknown	PK
`course_id`	Unknown	PKFK

course_requirement_list

Column	Type	Keys
`index`	Unknown	PK
`requirement_list`	Unknown	PK
`course_id`	Unknown	PKFK

course_learn_list

Column	Type	Keys
`learning_list`	Unknown	PK
`course_id`	Unknown	PKFK

course_caption_language

Column	Type	Keys
`caption_language`	Unknown	PK
`course_id`	Unknown	PKFK

course_caption_locale

Column	Type	Keys
`index`	Unknown	PK
`course_id`	Unknown	PKFK
`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	PKFK
`display_name`	Unknown
`email`	Unknown
`lms_user_id`	Unknown

learning_path_section_item

Column	Type	Keys
`id`	Unknown	PK
`section_id`	Unknown	PKFK
`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	PKFK
`description`	Unknown
`orders`	Unknown
`title`	Unknown

learning_path_locale

Column	Type	Keys
`index`	Unknown	PK
`learning_path_id`	Unknown	PKFK
`locale`	Unknown

learning_path_category

Column	Type	Keys
`index`	Unknown	PK
`learning_path_id`	Unknown	PKFK
`category`	Unknown

learning_path_folder

Column	Type	Keys
`id`	Unknown	PK
`learning_path_id`	Unknown	PKFK
`description`	Unknown
`title`	Unknown

learning_path

Column	Type	Keys
`title`	Unknown	PK
`id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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