# WorkRamp schema ERD

Table and field reference for the Fivetran WorkRamp connector.

## 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| api_name | Unknown |  |
| value | Unknown |  |

### path_tag

| Column | Type | Keys |
| --- | --- | --- |
| tags | Unknown | PK |
| path_id | Unknown | PK, FK |

### 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 | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| user_id | Unknown | PK, FK |

### users_certification

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| 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 | PK, FK |
| path_id | Unknown | PK, FK |

### path_assignment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| path_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| session_id | Unknown | PK, FK |
| user_id | Unknown | FK |

### event_session

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| 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 | PK, FK |
| name | Unknown |  |

### guide_assignment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| guide_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| item_folder_id | Unknown | PK, FK |
| display_name | Unknown |  |
| is_active | Unknown |  |
| is_limited | Unknown |  |
| role | Unknown |  |

### item_folder_child

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| item_folder_id | Unknown | PK, FK |
| 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 | PK, FK |
| event_session_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| 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 | PK, FK |

### 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 | PK, FK |

### 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 | PK, FK |
| name | Unknown |  |

### group_user

| Column | Type | Keys |
| --- | --- | --- |
| group_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |

### offered_path

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| academy_id | String |  |
| created_at | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |

## Relationships

- scorm_assignment(assigner) → users(id)
- scorm_assignment(scorm_id) → scorm(id)
- scim_user(id) → users(id)
- path_enrollment(assigner_user_id) → users(id)
- path_enrollment(offered_path_id) → offered_path(id)
- user_custom_attribute(user_id) → users(id)
- path_tag(path_id) → path(id)
- guide_tag(guide_id) → guide(id)
- certification_award(certification_id) → certification(id)
- certification_award(user_id) → users(id)
- scim_group_member(scim_group_id) → scim_group(id)
- academy_user_segment(academy_user_id) → academy_user(id)
- academy_user_custom_registration(academy_user_id) → academy_user(id)
- academy_path_user_custom_registration(academy_path_user_id) → academy_path_user(id)
- academy_path_user(user_id) → academy_user(id)
- academy_path_user(path_id) → path(id)
- users_direct_report(user_direct_report_id) → users(id)
- users_direct_report(user_id) → users(id)
- users_certification(user_id) → users(id)
- guide_assignment_dated(user_id) → users(id)
- guide_assignment_dated(guide_id) → guide(id)
- guide_assignment_dated(path_assignment_id) → path_assignment(id)
- guide_assignment_dated(path_id) → path(id)
- path_assignment_tag(path_assignment_id) → path_assignment(id)
- path_assignment_tag(path_id) → path_assignment(path_id)
- path_assignment(assigner_id) → users(id)
- path_assignment(user_id) → users(id)
- path_assignment(path_id) → path(id)
- award_by_user(user_id) → users(id)
- award_by_user(training_series_user_assignment_id) → training_series_assignment(id)
- award_by_user(course_user_assignment_id) → course_assignment(id)
- award_by_user(assignment_id) → scorm(id)
- award_by_user(challenge_user_assignment_id) → challenge_assignment(id)
- award_by_user(certification_id) → certification(id)
- certification_enrollment(assigner_user_id) → users(id)
- certification_enrollment(academy_certification_id) → academy_certification(id)
- event_session_training_class_instructor(session_id) → event_session(id)
- event_session_training_class_instructor(user_id) → users(id)
- event_session_training_class_instructor(event_id) → event_session(event_id)
- event_session(event_id) → event(id)
- guide_assignment_path(guide_assignment_id) → guide_assignment(id)
- guide_assignment(assigner_id) → users(id)
- guide_assignment(user_id) → users(id)
- guide_assignment(course_id) → course_assignment(course_id)
- guide_assignment(guide_id) → guide(id)
- academy_awarded_certification(user_id) → academy_user(id)
- unique_guide_assignment_change(guide_id) → guide(id)
- unique_guide_assignment_change(user_id) → users(id)
- item_folder_user(id) → users(id)
- item_folder_user(item_folder_id) → item_folder(id)
- item_folder_child(item_folder_id) → item_folder(id)
- event_session_learner(user_id) → users(id)
- event_session_learner(event_session_id) → event_session(id)
- event_session_learner(event_id) → event_session(event_id)
- course_assignment_tag(course_assignment_id) → course_assignment(id)
- course_assignment(assigner_id) → users(id)
- course_assignment(user_id) → users(id)
- course_assignment(training_series_id) → training_series_assignment(id)
- training_series_assignment_tag(training_series_assignment_id) → training_series_assignment(id)
- training_series_assignment(assigner_id) → users(id)
- training_series_assignment(user_id) → users(id)
- training_series_assignment(training_series_id) → path(id)
- challenge_assignment(user_id) → users(id)
- challenge_assignment(training_series_id) → training_series_assignment(id)
- academy_registration(user_id) → academy_user(id)
- academy_registration(content_id) → academy_training(id)
- challenge_user_assignment(user_email) → users(email)
- challenge_user_assignment(challenge_id) → challenge(id)
- challenge(id) → challenge_assignment(challenge_id)
- group_user(user_id) → users(id)
- group_user(group_id) → groups(id)