WorkRamp

Explore the interactive ERD

Table & Field Reference

scorm_assignment

Column	Type	Keys
`_fivetran_id`	String	PK
`assigner`	Unknown	FK
`scorm_id`	Unknown	FK
`completed_at`	Unknown
`completion_percentage`	Unknown
`date_assigned`	Unknown
`due_date`	Unknown
`time_spent_in_minutes`	Unknown
`user_email`	Unknown
`user_name`	Unknown

scim_user

Column	Type	Keys
`id`	Unknown	PKFK
`active`	Unknown
`external_id`	Unknown
`family_name`	Unknown
`formatted`	Unknown
`given_name`	Unknown
`location`	Unknown
`resource_type`	Unknown
`user_name`	Unknown

path_enrollment

Column	Type	Keys
`id`	Unknown	PK
`offered_path_id`	Unknown	PKFK
`assigner_user_id`	Unknown	FK
`academy_id`	String
`completed_at`	Unknown
`enrollment_method`	Unknown
`progress_percentage`	Unknown

user_custom_attribute

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	PKFK
`api_name`	Unknown
`value`	Unknown

path_tag

Column	Type	Keys
`tags`	Unknown	PK
`path_id`	Unknown	PKFK

path

Column	Type	Keys
`id`	Unknown	PK
`card_banner`	Unknown
`created_at`	Unknown
`description`	Unknown
`name`	Unknown
`num_challenge`	Unknown
`num_guide`	Unknown
`num_resource`	Unknown
`passing_score_requiredfor_unlock`	Unknown
`sequential_unlock`	Unknown
`time_estimate_seconds`	Unknown
`updated_at`	Unknown

content_catalog

Column	Type	Keys
`_fivetran_id`	String	PK
`created_date`	Unknown
`folder_name`	Unknown
`item_description`	Unknown
`item_link`	Unknown
`item_name`	Unknown
`item_type`	Unknown
`last_assigned_date`	Unknown
`last_edited_date`	Unknown
`last_editor`	Unknown
`num_assignments`	Unknown
`original_author`	Unknown
`path_description`	Unknown
`path_name`	Unknown
`university_description`	Unknown
`university_folder`	Unknown
`university_name`	Unknown

scorm

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`time_estimate`	Unknown
`title`	Unknown

guide_tag

Column	Type	Keys
`tags`	Unknown	PK
`guide_id`	Unknown	PKFK

guide

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`num_total_task`	Unknown
`num_total_test_question`	Unknown
`title`	Unknown
`updated_at`	Unknown

certification_award

Column	Type	Keys
`id`	Unknown	PK
`certification_id`	Unknown	PKFK
`user_id`	Unknown	FK
`course_user_assignment_id`	Unknown
`created_at`	Unknown
`file_url`	Unknown
`updated_at`	Unknown

scim_group_member

Column	Type	Keys
`value`	Unknown	PK
`scim_group_id`	Unknown	PKFK
`display`	Unknown
`link`	Unknown

scim_group

Column	Type	Keys
`id`	Unknown	PK
`display_name`	Unknown

resource

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`description`	Unknown
`name`	Unknown
`updated_at`	Unknown

academy_user_segment

Column	Type	Keys
`_fivetran_id`	String	PK
`academy_user_id`	Unknown	FK
`name`	Unknown

academy_user_custom_registration

Column	Type	Keys
`_fivetran_id`	String	PK
`academy_user_id`	Unknown	FK
`academy_registration_id`	Unknown
`name`	Unknown
`value`	Unknown

academy_user

Column	Type	Keys
`id`	Unknown	PK
`academy_id`	String
`created_at`	Unknown
`display_name`	Unknown
`email`	Unknown
`first_name`	Unknown
`last_name`	Unknown
`status`	Unknown

academy_path_user_custom_registration

Column	Type	Keys
`_fivetran_id`	String	PK
`academy_path_user_id`	Unknown	FK
`name`	Unknown
`value`	Unknown

academy_path_user

Column	Type	Keys
`id`	Unknown	PK
`path_id`	Unknown	FK
`user_id`	Unknown	FK
`academy_id`	String
`completed_at`	Unknown
`path_description`	Unknown
`path_name`	Unknown
`segments`	Json
`user_email`	Unknown
`user_name`	Unknown

users_direct_report

Column	Type	Keys
`user_direct_report_id`	Unknown	PKFK
`user_id`	Unknown	PKFK

users_certification

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	PKFK
`title`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`email`	Unknown
`is_admin`	Unknown
`is_deleted`	Unknown
`is_permanently_deleted`	Unknown
`name`	Unknown
`updated_at`	Unknown

certification

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`is_deleted`	Unknown
`title`	Unknown
`updated_at`	Unknown

white_label_customer

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`disable_all_emails`	Unknown
`enterprise_base_url`	Unknown
`enterprise_id`	Unknown
`enterprise_name`	Unknown
`updated_at`	Unknown

guide_assignment_dated

Column	Type	Keys
`id`	Unknown	PK
`guide_id`	Unknown	FK
`path_assignment_id`	Unknown	FK
`path_id`	Unknown	FK
`user_id`	Unknown	FK
`completed_at`	Unknown
`completion_percentage`	Unknown
`created_at`	Unknown
`display_title`	Unknown
`due_date`	Unknown
`esignatures`	Json
`is_completed`	Unknown
`is_completed_and_passed`	Unknown
`is_deleted`	Unknown
`is_mandatory`	Unknown
`last_viewed_at`	Unknown
`num_completed_tasks`	Unknown
`num_completed_test_questions`	Unknown
`num_correct_test_questions`	Unknown
`num_graded_test_questions`	Unknown
`num_viewed_tasks`	Unknown
`override_score`	Unknown
`rating`	Unknown
`score`	Unknown
`status`	Unknown
`time_estimate_seconds`	Unknown
`time_spent`	Unknown
`updated_at`	Unknown

academy_training

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`name`	Unknown
`type`	Unknown

path_assignment_tag

Column	Type	Keys
`tags`	Unknown	PK
`path_assignment_id`	Unknown	PKFK
`path_id`	Unknown	PKFK

path_assignment

Column	Type	Keys
`id`	Unknown	PK
`path_id`	Unknown	PKFK
`assigner_id`	Unknown	FK
`user_id`	Unknown	FK
`completed_at`	Unknown
`completion_percentage`	Unknown
`created_at`	Unknown
`created_through`	Unknown
`due_date`	Unknown
`first_accessed_at`	Unknown
`is_completed`	Unknown
`is_completed_on_time`	Unknown
`is_overdue`	Unknown
`last_accessed_at`	Unknown
`modules_completed`	Unknown
`num_days_overdue`	Unknown
`num_modules`	Unknown
`overall_grade`	Unknown
`passed`	Unknown
`passing_grade_required`	Unknown
`status`	Unknown
`time_spent`	Unknown
`title`	Unknown
`training_series_id`	Unknown
`updated_at`	Unknown

award_by_user

Column	Type	Keys
`id`	Unknown	PK
`assignment_id`	Unknown	FK
`certification_id`	Unknown	FK
`challenge_user_assignment_id`	Unknown	FK
`course_user_assignment_id`	Unknown	FK
`training_series_user_assignment_id`	Unknown	FK
`user_id`	Unknown	FK
`created_at`	Unknown
`file_name`	Unknown
`file_url`	Unknown
`training_class_session_attendee_id`	Unknown
`updated_at`	Unknown

certification_enrollment

Column	Type	Keys
`id`	Unknown	PK
`academy_certification_id`	Unknown	PKFK
`assigner_user_id`	Unknown	FK
`academy_id`	String
`awarded_at`	Unknown
`enrollment_method`	Unknown
`progress_percentage`	Unknown

event_session_training_class_instructor

Column	Type	Keys
`id`	Unknown	PK
`event_id`	Unknown	PKFK
`session_id`	Unknown	PKFK
`user_id`	Unknown	FK

event_session

Column	Type	Keys
`id`	Unknown	PK
`event_id`	Unknown	PKFK
`ends`	Unknown
`start`	Unknown
`title`	Unknown
`training_class_id`	Unknown
`zoom_meeting_id`	Unknown
`zoom_meeting_join_url`	Unknown
`zoom_meeting_start_url`	Unknown

guide_assignment_path

Column	Type	Keys
`id`	Unknown	PK
`guide_assignment_id`	Unknown	PKFK
`name`	Unknown

guide_assignment

Column	Type	Keys
`id`	Unknown	PK
`guide_id`	Unknown	PKFK
`assigner_id`	Unknown	FK
`course_id`	Unknown	FK
`user_id`	Unknown	FK
`completed_at`	Unknown
`completion_percentage`	Unknown
`created_at`	Unknown
`due_date`	Unknown
`is_archived`	Unknown
`is_completed`	Unknown
`num_completed_task`	Unknown
`num_completed_test_question`	Unknown
`num_correct_test_question`	Unknown
`num_graded_test_question`	Unknown
`num_viewed_task`	Unknown
`score`	Unknown
`tags`	Json
`title`	Unknown
`training_series_user_assignment_id`	Unknown
`updated_at`	Unknown

academy_awarded_certification

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	PKFK
`academy_id`	String
`awarded_at`	Unknown
`description`	Unknown
`name`	Unknown
`user_email`	Unknown
`user_name`	Unknown

unique_guide_assignment_change

Column	Type	Keys
`id`	Unknown	PK
`guide_id`	Unknown	FK
`user_id`	Unknown	FK
`guide_name`	Unknown
`occurred_at`	Unknown
`status`	Unknown
`training_series_id`	Unknown
`user_email`	Unknown

item_folder_user

Column	Type	Keys
`id`	Unknown	PKFK
`item_folder_id`	Unknown	PKFK
`display_name`	Unknown
`is_active`	Unknown
`is_limited`	Unknown
`role`	Unknown

item_folder_child

Column	Type	Keys
`id`	Unknown	PK
`item_folder_id`	Unknown	PKFK
`children`	Json
`created_at`	Unknown
`groups`	Json
`is_hidden`	Unknown
`is_locked`	Unknown
`name`	Unknown
`orders`	Unknown
`updated_at`	Unknown
`users`	Json

item_folder

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`is_hidden`	Unknown
`is_locked`	Unknown
`name`	Unknown
`orders`	Unknown
`updated_at`	Unknown

event_session_learner

Column	Type	Keys
`event_id`	Unknown	PKFK
`event_session_id`	Unknown	PKFK
`user_id`	Unknown	PKFK
`email`	Unknown
`groups`	Json
`name`	Unknown
`registration_date`	Unknown
`registration_status`	Unknown

event

Column	Type	Keys
`id`	Unknown	PK
`name`	Unknown

course_assignment_tag

Column	Type	Keys
`tags`	Unknown	PK
`course_assignment_id`	Unknown	PKFK

course_assignment

Column	Type	Keys
`id`	Unknown	PK
`assigner_id`	Unknown	FK
`training_series_id`	Unknown	FK
`user_id`	Unknown	FK
`completed_at`	Unknown
`completion_percentage`	Unknown
`course_id`	Unknown
`created_at`	Unknown
`due_date`	Unknown
`is_archived`	Unknown
`is_completed`	Unknown
`num_completed_tasks`	Unknown
`num_completed_test_questions`	Unknown
`num_correct_test_questions`	Unknown
`num_graded_test_questions`	Unknown
`num_viewed_tasks`	Unknown
`score`	Unknown
`title`	Unknown
`updated_at`	Unknown

training_series_assignment_tag

Column	Type	Keys
`tags`	Unknown	PK
`training_series_assignment_id`	Unknown	PKFK

training_series_assignment

Column	Type	Keys
`id`	Unknown	PK
`assigner_id`	Unknown	FK
`training_series_id`	Unknown	FK
`user_id`	Unknown	FK
`completed_at`	Unknown
`completion_percentage`	Unknown
`created_at`	Unknown
`created_through`	Unknown
`due_date`	Unknown
`is_completed`	Unknown
`modules_completed`	Unknown
`num_modules`	Unknown
`overall_grade`	Unknown
`time_spent`	Unknown
`title`	Unknown
`updated_at`	Unknown

challenge_assignment

Column	Type	Keys
`id`	Unknown	PK
`training_series_id`	Unknown	FK
`user_id`	Unknown	FK
`calculated_grade`	Unknown
`challenge_id`	Unknown
`completed_at`	Unknown
`completion_percentage`	Unknown
`created_at`	Unknown
`due_date`	Unknown
`is_fully_graded`	Unknown
`is_partially_graded`	Unknown
`is_submitted`	Unknown
`passed`	Unknown
`reviewer_due_date`	Unknown
`tags`	Json
`title`	Unknown
`updated_at`	Unknown

academy_certification

Column	Type	Keys
`id`	Unknown	PK
`academy_id`	String
`awarded_by_name`	Unknown
`awarded_by_title`	Unknown
`created_at`	Unknown
`description`	Unknown
`name`	Unknown

groups

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`description`	Unknown
`enterprise_id`	Unknown
`from_sso`	Unknown
`has_manager`	Unknown
`name`	Unknown
`original_name`	Unknown
`user_updated_at`	Unknown

academy_registration

Column	Type	Keys
`id`	Unknown	PK
`content_id`	Unknown	FK
`user_id`	Unknown	FK
`academy_overview_description`	Unknown
`card_banner`	Unknown
`completed_at`	Unknown
`completion_percentage`	Unknown
`content_type`	Unknown
`created_at`	Unknown
`description`	Unknown
`due_at`	Unknown
`due_date`	Unknown
`is_completed`	Unknown
`pass_status`	Unknown
`score`	Unknown
`title`	Unknown

collection_offered

Column	Type	Keys
`id`	Unknown	PK
`academy_id`	String
`created_at`	Unknown
`description`	Unknown
`name`	Unknown

challenge_user_assignment

Column	Type	Keys
`_fivetran_id`	String	PK
`challenge_id`	Unknown	FK
`user_email`	Unknown	FK
`completion_date`	Unknown
`grade_earned_points`	Unknown
`grade_incomplete`	Unknown
`grade_total_points`	Unknown
`is_fully_graded`	Unknown
`passed`	Unknown
`time_spent`	Unknown

challenge

Column	Type	Keys
`id`	Unknown	PKFK
`name`	Unknown

group_user

Column	Type	Keys
`group_id`	Unknown	PKFK
`user_id`	Unknown	PKFK

offered_path

Column	Type	Keys
`id`	Unknown	PK
`academy_id`	String
`created_at`	Unknown
`description`	Unknown
`name`	Unknown