# LearnUpon schema ERD

Table and field reference for the Fivetran LearnUpon connector.

## 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 | PK, FK |
| 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 | PK, FK |
| definition_id | Unknown | PK, FK |
| 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 | PK, FK |
| id | Unknown | PK, FK |
| 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 | PK, FK |
| user_id | Unknown | PK, FK |
| value | Json |  |

### user_custom_data

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| user_id | Unknown | PK, FK |
| 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 | PK, FK |
| label | Unknown |  |
| type_id | Unknown |  |

### group_invitie_custom_data_field_value

| Column | Type | Keys |
| --- | --- | --- |
| definition_id | Unknown | PK |
| group_invitie_id | Unknown | PK, FK |
| 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 |

## Relationships

- course_instructor(id) → users(id)
- course_instructor(course_id) → course(id)
- course_custom_data_field_value(definition_id) → custom_data_field_definition(id)
- course_custom_data_field_value(course_id) → course(id)
- course(owner_id) → users(id)
- course(source_id) → course(id)
- group_membership(id) → users(id)
- group_membership(group_id) → groups(id)
- enrollment(user_id) → users(id)
- enrollment(group_id) → groups(id)
- enrollment(course_id) → course(id)
- module(location_id) → location(id)
- module(creator_id) → users(id)
- module(course_id) → course(id)
- group_manager(group_id) → groups(id)
- group_manager(user_id) → users(id)
- group_course(group_id) → groups(id)
- group_course(course_id) → course(id)
- markcomplete(user_id) → users(id)
- learning_path_enrollment(user_id) → users(id)
- learning_path_enrollment(learning_path_id) → learning_path(id)
- user_custom_data_field_value(definition_id) → custom_data_field_definition(id)
- user_custom_data_field_value(user_id) → users(id)
- user_custom_data(user_id) → users(id)
- group_invitie_custom_data_field_definition(id) → group_invitie_custom_data_field_value(definition_id)
- group_invitie_custom_data_field_value(group_invitie_id) → group_invitie(id)
- group_invitie(group_id) → groups(id)
- group_invite_course_enrollment(course_id) → course(id)
- group_invite_course_enrollment(group_id) → groups(id)
- group_invite_course_enrollment(group_invite_id) → group_invitie(id)