Fivetran documentation

Search the docs

/

LearnUpon

Explore the interactive ERD

Table & Field Reference

location

Column	Type	Keys
`id`	Unknown	PK
`address_1`	Unknown
`address_2`	Unknown
`address_3`	Unknown
`country_code`	Unknown
`notes`	Unknown
`timezone`	Unknown
`title`	Unknown

groups

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`description`	Unknown
`number_of_members`	Unknown
`title`	Unknown
`updated_at`	Unknown

course_instructor

Column	Type	Keys
`id`	Unknown	PKFK
`course_id`	Unknown	FK
`created_at`	Unknown
`enrollment_count`	Unknown
`updated_at`	Unknown
`version`	Unknown

course_custom_data_field_value

Column	Type	Keys
`index`	Unknown	PK
`course_id`	Unknown	PKFK
`definition_id`	Unknown	PKFK
`value`	Json

course

Column	Type	Keys
`id`	Unknown	PK
`owner_id`	Unknown	FK
`source_id`	Unknown	FK
`allow_users_rate_course`	Unknown
`cataloged`	Unknown
`course_length_unit`	Unknown
`created_at`	Unknown
`credits_to_be_awarded`	Unknown
`date_published`	Unknown
`description_text`	Unknown
`difficulty_level`	Unknown
`due_date_after_enrollment`	Unknown
`due_date_reminder_days`	Unknown
`due_date_reminder_days_2`	Unknown
`due_days_after_enrollment`	Unknown
`keywords`	Unknown
`license_expire`	Unknown
`license_has_unlimited_enrollments`	Unknown
`license_is_open_ended`	Unknown
`license_number_enrollments_purchased`	Unknown
`manager_can_enroll`	Unknown
`minute_length`	Unknown
`name`	Unknown
`num_completed`	Unknown
`num_enrolled`	Unknown
`num_failed`	Unknown
`num_in_progress`	Unknown
`num_not_started`	Unknown
`num_passed`	Unknown
`num_pending_review`	Unknown
`number_of_modules`	Unknown
`number_of_reviews`	Unknown
`number_of_stars`	Unknown
`objectives_text`	Unknown
`price`	Unknown
`published_status_id`	Unknown
`reference_code`	Unknown
`sellable`	Unknown
`send_due_date_reminders`	Unknown
`thumbnail_image_url`	Unknown
`version`	Unknown

group_membership

Column	Type	Keys
`group_id`	Unknown	PKFK
`id`	Unknown	PKFK
`locale`	Unknown

custom_data_field_definition

Column	Type	Keys
`id`	Unknown	PK
`custom_type`	Unknown
`label`	Unknown
`type_id`	Unknown

enrollment

Column	Type	Keys
`id`	Unknown	PK
`course_id`	Unknown	FK
`group_id`	Unknown	FK
`user_id`	Unknown	FK
`cert_expires_at`	Unknown
`certificate_name`	Unknown
`course_access_expires_at`	Unknown
`date_completed`	Unknown
`date_enrolled`	Unknown
`date_lastaccessed`	Unknown
`date_started`	Unknown
`due_date`	Unknown
`from_catalog`	Unknown
`from_store`	Unknown
`has_attempts_remaining`	Unknown
`is_overdue`	Unknown
`percentage`	Unknown
`percentage_complete`	Unknown
`status`	Unknown
`unenrolled`	Unknown
`updated_at`	Unknown
`was_recertified`	Unknown

module

Column	Type	Keys
`id`	Unknown	PK
`course_id`	Unknown	FK
`creator_id`	Unknown	FK
`location_id`	Unknown	FK
`assignment_passing_percentage`	Unknown
`assignment_question_text`	Unknown
`component_type`	Unknown
`created_at`	Unknown
`description_text`	Unknown
`end_at`	Unknown
`exam_id`	Unknown
`location_state_code`	Unknown
`max_capacity`	Unknown
`number_enrolled_on_session`	Unknown
`number_of_linked_courses`	Unknown
`sequence`	Unknown
`session_id`	Unknown
`session_tutor_id`	Unknown
`start_at`	Unknown
`tags`	Unknown
`timezone`	Unknown
`title`	Unknown
`training_id`	Unknown
`tutor_email`	Unknown
`tutor_first_name`	Unknown
`tutor_last_name`	Unknown
`tutor_username`	Unknown
`updated_at`	Unknown

group_manager

Column	Type	Keys
`id`	Unknown	PK
`group_id`	Unknown	FK
`user_id`	Unknown	FK
`can_create_users`	Unknown
`created_at`	Unknown
`number_of_courses`	Unknown
`number_of_members`	Unknown
`updated_at`	Unknown

group_course

Column	Type	Keys
`id`	Unknown	PK
`course_id`	Unknown	FK
`group_id`	Unknown	FK

markcomplete

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	FK
`action_source_type`	Unknown
`created_at`	Unknown
`date_completed`	Unknown
`notes`	Unknown
`percentage`	Unknown
`status`	Unknown

learning_path

Column	Type	Keys
`id`	Unknown	PK
`cataloged`	Unknown
`created_at`	Unknown
`credits_to_be_awarded`	Unknown
`date_published`	Unknown
`description_text`	Unknown
`difficulty_level`	Unknown
`due_date_after_enrollment`	Unknown
`due_date_reminder_days`	Unknown
`due_date_reminder_days_2`	Unknown
`due_days_after_enrollment`	Unknown
`keywords`	Unknown
`minute_length`	Unknown
`name`	Unknown
`path_length_unit`	Unknown
`price`	Unknown
`published_status_id`	Unknown
`sellable`	Unknown
`send_due_date_reminder`	Unknown
`thumbnail_image_url`	Unknown

learning_path_enrollment

Column	Type	Keys
`id`	Unknown	PK
`learning_path_id`	Unknown	FK
`user_id`	Unknown	FK
`cert_expires_at`	Unknown
`certificate_name`	Unknown
`date_completed`	Unknown
`date_enrolled`	Unknown
`date_last_accessed`	Unknown
`date_started`	Unknown
`due_date`	Unknown
`percentage`	Unknown
`status`	Unknown
`unenrolled`	Unknown
`was_recertified`	Unknown

user_custom_data_field_value

Column	Type	Keys
`index`	Unknown	PK
`definition_id`	Unknown	PKFK
`user_id`	Unknown	PKFK
`value`	Json

user_custom_data

Column	Type	Keys
`name`	Unknown	PK
`user_id`	Unknown	PKFK
`value`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`account_expires`	Unknown
`can_act_as_instructor`	Unknown
`can_delete_users`	Unknown
`can_enroll`	Unknown
`can_manage_sessions`	Unknown
`can_manage_trainings`	Unknown
`can_mark_complete`	Unknown
`can_move_groups`	Unknown
`can_unenroll_users`	Unknown
`created_at`	Unknown
`email`	Unknown
`enabled`	Unknown
`first_name`	Unknown
`is_salesforce_contact`	Unknown
`languages`	Unknown
`last_name`	Unknown
`last_sign_in_at`	Unknown
`locale`	Unknown
`membership_type`	Unknown
`number_of_badges`	Unknown
`number_of_enrollments`	Unknown
`number_of_enrollments_accessed`	Unknown
`number_of_points`	Unknown
`sf_contact_id`	Unknown
`sf_user_id`	Unknown
`sign_in_count`	Unknown
`timezone_id`	Unknown
`tutor_can_create_courses`	Unknown
`tutor_can_edit_their_courses`	Unknown
`updated_at`	Unknown
`user_type`	Unknown
`username`	Unknown

group_invitie_custom_data_field_definition

Column	Type	Keys
`id`	Unknown	PKFK
`label`	Unknown
`type_id`	Unknown

group_invitie_custom_data_field_value

Column	Type	Keys
`definition_id`	Unknown	PK
`group_invitie_id`	Unknown	PKFK
`value`	Unknown

group_invitie

Column	Type	Keys
`id`	Unknown	PK
`group_id`	Unknown	FK
`accept_url`	Unknown
`created_at`	Unknown
`expires_at`	Unknown
`first_name`	Unknown
`invite_email_address`	Unknown
`invite_status`	Unknown
`last_name`	Unknown
`last_reminder_sent_at`	Unknown
`num_reminders_sent`	Unknown
`sf_contact_id`	Unknown
`sf_user_id`	Unknown
`user_type`	Unknown
`username`	Unknown

group_invite_course_enrollment

Column	Type	Keys
`id`	Unknown	PK
`course_id`	Unknown	FK
`group_id`	Unknown	FK
`group_invite_id`	Unknown	FK