# 360Learning schema ERD

Table and field reference for the Fivetran 360Learning connector.

## Table & Field Reference

### custom_link

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| custom_link_id | Unknown |  |
| url | Unknown |  |

### user_certificate

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| path_id | Unknown | FK |
| path_session_id | Unknown | FK |
| certificate_outline_id | Unknown |  |
| delivery_date | Unknown |  |
| expiration_date | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| validity_period | Unknown |  |

### classroom_slot_registration

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| classroom_slot_id | Unknown | PK, FK |
| path_id | Unknown | FK |
| user_id | Unknown | FK |
| archived_at | Instant |  |
| attendance_duration | Unknown |  |
| created_at | Instant |  |
| has_attended | Unknown |  |
| modified_at | Instant |  |
| rsvp_going | Unknown |  |
| rsvp_last_updated_at | Instant |  |
| status | Unknown |  |

### user_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| type | Unknown |  |
| value | Unknown |  |

### path_step

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| path_id | Unknown | PK, FK |
| attempts_limit | Unknown |  |
| auto_registration | Unknown |  |
| availability_mode | Unknown |  |
| availability_relative_unit | Unknown |  |
| availability_relative_value | Unknown |  |
| is_examination | Unknown |  |
| min_score | Unknown |  |
| optional | Unknown |  |
| recipient_type | Unknown |  |
| relative_date_unit | Unknown |  |
| relative_date_value | Unknown |  |
| scheduling_condition | Unknown |  |
| scheduling_relative_to | Unknown |  |
| scheduling_relativity | Unknown |  |
| show_correction | Unknown |  |
| show_forum | Unknown |  |
| subtype | Unknown |  |
| time_limit_mode | Unknown |  |
| time_limit_value | Unknown |  |
| type | Unknown |  |

### path_translator

| Column | Type | Keys |
| --- | --- | --- |
| translator_id | Unknown | PK |
| path_id | Unknown | PK, FK |
| path_translation_index | Unknown | PK, FK |

### path_translation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| path_id | Unknown | PK, FK |
| lang | Unknown |  |
| published | Unknown |  |
| translated_description | Unknown |  |
| translated_name | Unknown |  |

### path

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| author_id | Unknown | FK |
| group_id | Unknown | FK |
| additional_information | Unknown |  |
| automated_reminders | Unknown |  |
| certificate_id | Unknown |  |
| created_at | Unknown |  |
| default_lang | Unknown |  |
| description | Unknown |  |
| display_classroom_messages | Unknown |  |
| display_forum | Unknown |  |
| estimated_commitment_max | Unknown |  |
| estimated_commitment_min | Unknown |  |
| estimated_duration_unit | Unknown |  |
| estimated_duration_value | Unknown |  |
| linear_progression | Unknown |  |
| mandatory_replay | Unknown |  |
| modified_at | Unknown |  |
| name | Unknown |  |
| notification_on_step_create | Unknown |  |
| source_lang | Unknown |  |
| status | Unknown |  |

### path_tag

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

### attendance_sheet

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| classroom_slot_id | Unknown | PK, FK |
| check_in_code | Unknown |  |
| name | Unknown |  |
| organization_logo_id | Unknown |  |
| personalized_fields | Unknown |  |
| status | Unknown |  |

### classroom_slot_trainer

| Column | Type | Keys |
| --- | --- | --- |
| classroom_slot_id | Unknown | PK, FK |
| trainer_id | Unknown | PK, FK |

### classroom_slot_media

| Column | Type | Keys |
| --- | --- | --- |
| media_id | Unknown | PK |
| classroom_slot_id | Unknown | PK, FK |

### classroom_slot

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| classroom_id | Unknown | PK, FK |
| context_id | Unknown |  |
| context_type | Unknown |  |
| created_at | Instant |  |
| end_date | Instant |  |
| location | Unknown |  |
| max_capacity | Unknown |  |
| modified_at | Instant |  |
| name | Unknown |  |
| reported_duration | Unknown |  |
| self_registration_cutoff_date | Instant |  |
| self_registration_enabled | Unknown |  |
| start_date | Instant |  |
| timezone | Unknown |  |
| virtual | Unknown |  |
| webinar_provider | Unknown |  |

### custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| target_type | Unknown |  |
| type | Unknown |  |

### path_session_stat

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| path_id | Unknown | PK |
| path_session_id | Unknown | PK, FK |
| certificate_id | Unknown | FK |
| user_id | Unknown | FK |
| completed_at | Unknown |  |
| due_date | Unknown |  |
| enrolled_at | Unknown |  |
| progress | Unknown |  |
| score | Unknown |  |
| self_enrolled | Unknown |  |
| started_at | Unknown |  |
| status_type | Unknown |  |
| time_spent | Unknown |  |
| unenrolled_at | Unknown |  |

### path_session_instructor

| Column | Type | Keys |
| --- | --- | --- |
| instructor_id | Unknown | PK |
| path_session_id | Unknown | PK, FK |

### path_session_translator

| Column | Type | Keys |
| --- | --- | --- |
| translator_id | Unknown | PK |
| path_session_id | Unknown | PK, FK |
| path_session_translation_index | Unknown | PK, FK |

### path_session_translation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| path_session_id | Unknown | PK, FK |
| lang | Unknown |  |
| published | Unknown |  |
| translated_name | Unknown |  |

### path_session

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| path_id | Unknown | FK |
| additional_information | Unknown |  |
| auto_reenroll_delay_days | Unknown |  |
| auto_reenroll_type | Unknown |  |
| created_at | Unknown |  |
| end_date | Unknown |  |
| ip_filtering_active | Unknown |  |
| ip_filtering_authorized_addr | Unknown |  |
| is_audience_builder | Unknown |  |
| main_instructor_id | Unknown |  |
| modified_at | Unknown |  |
| name | Unknown |  |
| registration_request_validation | Unknown |  |
| root_session_id | Unknown |  |
| start_date | Unknown |  |
| user_limit | Unknown |  |

### groups

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_group_id | Unknown | FK |
| background_image_id | Unknown |  |
| banner_image_id | Unknown |  |
| custom | Unknown |  |
| favicon_image_id | Unknown |  |
| logo_image_id | Unknown |  |
| moderation_charter_explicit_consent | Unknown |  |
| moderation_charter_url | Unknown |  |
| name | Unknown |  |
| privacy_policy_explicit_consent | Unknown |  |
| privacy_policy_url | Unknown |  |
| public | Unknown |  |
| subdomain | Unknown |  |
| terms_of_use_explicit_consent | Unknown |  |
| terms_of_use_url | Unknown |  |
| url | Unknown |  |

### classroom_media

| Column | Type | Keys |
| --- | --- | --- |
| media_id | Unknown | PK |
| classroom_id | Unknown | PK, FK |

### classroom

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| created_at | Unknown |  |
| message | Unknown |  |
| modified_at | Unknown |  |
| name | Unknown |  |
| training_objective | Unknown |  |

### user_reactivated_at

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

### user_deleted_at

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

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| custom | Unknown |  |
| first_name | Unknown |  |
| job | Unknown |  |
| lang | Unknown |  |
| last_login_date | Unknown |  |
| last_name | Unknown |  |
| mail | Unknown |  |
| organization | Unknown |  |
| phone | Unknown |  |
| status | Unknown |  |
| to_be_deactivated_at | Instant |  |
| username | Unknown |  |

### tags

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| external_id | Unknown |  |
| is_main | Unknown |  |
| name | Unknown |  |
| source | Unknown |  |

### path_statistics

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| certificate_id | Unknown | FK |
| path_id | Unknown | FK |
| user_id | Unknown | FK |
| completed_at | Instant |  |
| due_date | Instant |  |
| enrolled_at | Instant |  |
| progress | Unknown |  |
| score | Unknown |  |
| self_enrolled | Unknown |  |
| session_id | Unknown |  |
| started_at | Instant |  |
| status_reason | Unknown |  |
| status_type | Unknown |  |
| time_spent | Unknown |  |
| unenrolled_at | Instant |  |

### course_stat

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| course_id | Unknown | FK |
| path_id | Unknown | FK |
| path_session_id | Unknown | FK |
| user_id | Unknown | FK |
| completed_at | Unknown |  |
| first_activity_at | Unknown |  |
| lang | Unknown |  |
| last_activity_at | Unknown |  |
| progress | Unknown |  |
| score | Unknown |  |
| time_spent | Unknown |  |
| version_number | Unknown |  |

### group_user

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

### attendance

| Column | Type | Keys |
| --- | --- | --- |
| attendance_sheet_id | Unknown | PK, FK |
| classroom_slot_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| status | Unknown |  |

### skill_parent

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| skill_id | Unknown | PK, FK |
| external_id | Unknown |  |

### skill_translation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| skill_id | Unknown | PK, FK |
| lang | Unknown |  |
| translated_description | Unknown |  |
| translated_name | Unknown |  |

### skill

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| creation_date | Unknown |  |
| description | Unknown |  |
| external_id | Unknown |  |
| library_id | Unknown |  |
| modification_date | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |

### course_co_author

| Column | Type | Keys |
| --- | --- | --- |
| co_author_id | Unknown | PK, FK |
| course_id | Unknown | PK, FK |

### course_translator

| Column | Type | Keys |
| --- | --- | --- |
| translator_id | Unknown | PK |
| course_id | Unknown | PK, FK |
| course_translation_index | Unknown | PK, FK |

### course_translation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| course_id | Unknown | PK, FK |
| description | Unknown |  |
| lang | Unknown |  |
| name | Unknown |  |
| published | Unknown |  |

### course

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| author_id | Unknown | FK |
| group_id | Unknown | FK |
| creation_date | Unknown |  |
| current_version_number | Unknown |  |
| default_lang | Unknown |  |
| description | Unknown |  |
| duration | Unknown |  |
| external_platform | Unknown |  |
| modification_date | Unknown |  |
| name | Unknown |  |
| source_lang | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |

### course_tag

| Column | Type | Keys |
| --- | --- | --- |
| course_id | Unknown | PK, FK |
| tag_id | Unknown | PK, FK |

## Relationships

- custom_link(user_id) → users(id)
- user_certificate(path_session_id) → path_session(id)
- user_certificate(path_id) → path(id)
- user_certificate(user_id) → users(id)
- classroom_slot_registration(user_id) → users(id)
- classroom_slot_registration(path_id) → path(id)
- classroom_slot_registration(classroom_slot_id) → classroom_slot(id)
- user_custom_field(user_id) → users(id)
- path_step(path_id) → path(id)
- path_translator(path_translation_index) → path_translation(index)
- path_translator(path_id) → path_translation(path_id)
- path_translation(path_id) → path(id)
- path(author_id) → users(id)
- path(group_id) → groups(id)
- path_tag(tag_id) → tags(id)
- path_tag(path_id) → path(id)
- attendance_sheet(classroom_slot_id) → classroom_slot(id)
- classroom_slot_trainer(trainer_id) → users(id)
- classroom_slot_trainer(classroom_slot_id) → classroom_slot(id)
- classroom_slot_media(classroom_slot_id) → classroom_slot(id)
- classroom_slot(classroom_id) → classroom(id)
- path_session_stat(user_id) → users(id)
- path_session_stat(certificate_id) → user_certificate(id)
- path_session_stat(path_session_id) → path_session(id)
- path_session_instructor(path_session_id) → path_session(id)
- path_session_translator(path_session_translation_index) → path_session_translation(index)
- path_session_translator(path_session_id) → path_session_translation(path_session_id)
- path_session_translation(path_session_id) → path_session(id)
- path_session(group_id) → groups(id)
- path_session(path_id) → path(id)
- groups(parent_group_id) → groups(id)
- classroom_media(classroom_id) → classroom(id)
- classroom(group_id) → groups(id)
- user_reactivated_at(user_id) → users(id)
- user_deleted_at(user_id) → users(id)
- path_statistics(user_id) → users(id)
- path_statistics(certificate_id) → user_certificate(id)
- path_statistics(path_id) → path(id)
- course_stat(user_id) → users(id)
- course_stat(path_session_id) → path_session(id)
- course_stat(path_id) → path(id)
- course_stat(course_id) → course(id)
- group_user(user_id) → users(id)
- group_user(group_id) → groups(id)
- attendance(user_id) → users(id)
- attendance(classroom_slot_id) → classroom_slot(id)
- attendance(attendance_sheet_id) → attendance_sheet(id)
- skill_parent(id) → skill(id)
- skill_parent(skill_id) → skill(id)
- skill_translation(skill_id) → skill(id)
- course_co_author(co_author_id) → users(id)
- course_co_author(course_id) → course(id)
- course_translator(course_translation_index) → course_translation(index)
- course_translator(course_id) → course_translation(course_id)
- course_translation(course_id) → course(id)
- course(author_id) → users(id)
- course(group_id) → groups(id)
- course_tag(tag_id) → tags(id)
- course_tag(course_id) → course(id)