# Coassemble schema ERD

Table and field reference for the Fivetran Coassemble connector.

## Table & Field Reference

### learner_progress_card

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| learner_id | Unknown | PK, FK |
| category_id | Unknown | FK |
| group_id | Unknown | FK |
| card_image | Unknown |  |
| card_image_alt_text | Unknown |  |
| card_image_mode | Unknown |  |
| card_image_offset | Unknown |  |
| code | Unknown |  |
| commenced | Unknown |  |
| completed | Unknown |  |
| due_date | Unknown |  |
| duration | Unknown |  |
| end_date | Unknown |  |
| enrolled | Unknown |  |
| grading_in_progress | Unknown |  |
| group_type | Unknown |  |
| image | Unknown |  |
| options | Json |  |
| overview | Unknown |  |
| prerequisites | Json |  |
| progress_percent | Unknown |  |
| sequence | Unknown |  |
| starred | Unknown |  |
| start_date | Unknown |  |
| study | Unknown |  |
| title | Unknown |  |
| updated | Unknown |  |

### learner_action

| Column | Type | Keys |
| --- | --- | --- |
| action | Unknown | PK |
| learner_id | Unknown | PK, FK |

### learner

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| active | Unknown |  |
| avatar | Unknown |  |
| courses | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| groups | Unknown |  |
| invitation_sent | Unknown |  |
| last_login | Unknown |  |
| last_name | Unknown |  |
| name | Unknown |  |
| removed | Unknown |  |
| user_name | Unknown |  |

### groups

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| caps_admin | Unknown |  |
| caps_copy | Unknown |  |
| caps_create | Unknown |  |
| caps_delete | Unknown |  |
| caps_disenroll | Unknown |  |
| caps_edit | Unknown |  |
| caps_enrol | Unknown |  |
| caps_finance | Unknown |  |
| caps_invite | Unknown |  |
| caps_manage_enrolment | Unknown |  |
| caps_preview | Unknown |  |
| caps_publish_grades | Unknown |  |
| caps_remove_mirror | Unknown |  |
| caps_report | Unknown |  |
| caps_study | Unknown |  |
| caps_teach | Unknown |  |
| caps_view | Unknown |  |
| created | Unknown |  |
| name | Unknown |  |
| updated | Unknown |  |

### enrolment_permission

| Column | Type | Keys |
| --- | --- | --- |
| permission | Unknown | PK |
| enrolment_id | Unknown | PK, FK |

### enrolment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| course_id | Unknown | FK |
| group_id | Unknown | FK |
| initiator | Unknown | FK |
| user_id | Unknown | FK |
| action | Unknown |  |
| catalog_active | Unknown |  |
| catalog_caps_admin | Unknown |  |
| catalog_caps_copy | Unknown |  |
| catalog_caps_create | Unknown |  |
| catalog_caps_delete | Unknown |  |
| catalog_caps_disenroll | Unknown |  |
| catalog_caps_edit | Unknown |  |
| catalog_caps_enrol | Unknown |  |
| catalog_caps_finance | Unknown |  |
| catalog_caps_invite | Unknown |  |
| catalog_caps_manage_enrolment | Unknown |  |
| catalog_caps_preview | Unknown |  |
| catalog_caps_publish_grades | Unknown |  |
| catalog_caps_remove_mirror | Unknown |  |
| catalog_caps_report | Unknown |  |
| catalog_caps_study | Unknown |  |
| catalog_caps_teach | Unknown |  |
| catalog_caps_view | Unknown |  |
| catalog_created | Unknown |  |
| catalog_draft_only | Unknown |  |
| catalog_id | Unknown |  |
| catalog_invited | Unknown |  |
| catalog_public | Unknown |  |
| catalog_published | Unknown |  |
| catalog_published_copy | Unknown |  |
| catalog_published_diff | Unknown |  |
| catalog_revision | Unknown |  |
| catalog_securable_identity | Json |  |
| catalog_slug | Unknown |  |
| catalog_title | Unknown |  |
| catalog_updated | Unknown |  |
| date | Unknown |  |
| dtype | Unknown |  |
| group_students_count | Unknown |  |
| group_teachers_count | Unknown |  |
| group_type | Unknown |  |
| initiator_timezone | Unknown |  |
| user_timezone | Unknown |  |

### course

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category_id | Unknown | FK |
| trainer_id | Unknown | FK |
| card_image | Unknown |  |
| card_image_mode | Unknown |  |
| card_image_offset_x | Unknown |  |
| card_image_offset_y | Unknown |  |
| code | Unknown |  |
| cover_image | Unknown |  |
| cover_image_alt_text | Unknown |  |
| cover_image_mode | Unknown |  |
| cover_image_offset | Unknown |  |
| default_cover_image | Unknown |  |
| duration | Unknown |  |
| groups_count | Unknown |  |
| overview_content | Unknown |  |
| title | Unknown |  |

### learner_course

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

### category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| title | Unknown |  |

### assignment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| title | Unknown |  |

### user_role

| Column | Type | Keys |
| --- | --- | --- |
| role_id | Unknown | PK |
| users_id | Unknown | PK, FK |
| name | Unknown |  |
| role | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| accreditable_id | Unknown |  |
| active | Unknown |  |
| avatar | Unknown |  |
| created | Unknown |  |
| custom_value | Unknown |  |
| disable_course_enrolment_notification | Unknown |  |
| email | Unknown |  |
| email_verified | Unknown |  |
| first_name | Unknown |  |
| last_login | Unknown |  |
| last_name | Unknown |  |
| last_sent | Unknown |  |
| local | Unknown |  |
| number_of_logins | Unknown |  |
| timezone | Unknown |  |
| user_name | Unknown |  |

### result

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| course_id | Unknown | FK |
| group_id | Unknown | FK |
| user_id | Unknown | FK |
| accreditable_user_custom_value | Unknown |  |
| children | Json |  |
| commenced | Unknown |  |
| completed | Unknown |  |
| passed | Unknown |  |
| progress_percent | Unknown |  |
| score_percent | Unknown |  |
| total_time | Unknown |  |
| updated | Unknown |  |

### module_result

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_id | Unknown | FK |
| user_id | Unknown | FK |
| accreditable_identity_custom_value | Unknown |  |
| accreditable_identity_dtype | Unknown |  |
| commenced | Unknown |  |
| completed | Unknown |  |
| feedback | Unknown |  |
| lms_id | Unknown |  |
| module_access | Unknown |  |
| module_entity_type | Unknown |  |
| module_id | Unknown |  |
| module_launch | Unknown |  |
| module_module_type | Unknown |  |
| module_path | Unknown |  |
| module_required | Unknown |  |
| module_scorm_version | Unknown |  |
| module_title | Unknown |  |
| parent_access | Unknown |  |
| parent_commenced | Unknown |  |
| parent_completed | Unknown |  |
| parent_course_trainer | Unknown |  |
| parent_deleted | Unknown |  |
| parent_fresh | Unknown |  |
| parent_group_dtype | Unknown |  |
| parent_identifier | Unknown |  |
| parent_login_count | Unknown |  |
| parent_only_non_deleted | Unknown |  |
| parent_passed | Unknown |  |
| parent_progress_percent | Unknown |  |
| parent_report_url | Unknown |  |
| parent_score_max | Unknown |  |
| parent_score_percent | Unknown |  |
| parent_score_percentage | Unknown |  |
| parent_score_percentage_string | Unknown |  |
| parent_score_raw | Unknown |  |
| parent_starred | Unknown |  |
| parent_student_name | Unknown |  |
| parent_total_time | Unknown |  |
| parent_user_active | Unknown |  |
| parent_user_created | Unknown |  |
| parent_user_email_verified | Unknown |  |
| passed | Unknown |  |
| progress_percent | Unknown |  |
| score_max | Unknown |  |
| score_percent | Unknown |  |
| score_percentage | Unknown |  |
| score_percentage_string | Unknown |  |
| score_raw | Unknown |  |
| student_name | Unknown |  |
| total_time | Unknown |  |
| trainer | Unknown |  |

## Relationships

- learner_progress_card(category_id) → category(id)
- learner_progress_card(group_id) → groups(id)
- learner_progress_card(learner_id) → learner(id)
- learner_action(learner_id) → learner(id)
- learner(id) → users(id)
- enrolment_permission(enrolment_id) → enrolment(id)
- enrolment(user_id) → users(id)
- enrolment(group_id) → groups(id)
- enrolment(initiator) → users(id)
- enrolment(course_id) → course(id)
- course(trainer_id) → users(id)
- course(category_id) → category(id)
- learner_course(course_id) → course(id)
- learner_course(learner_id) → learner(id)
- user_role(users_id) → users(id)
- result(user_id) → users(id)
- result(group_id) → groups(id)
- result(course_id) → course(id)
- module_result(user_id) → users(id)
- module_result(parent_id) → result(id)