Coassemble

Explore the interactive ERD

Column	Type	Keys
`action`	Unknown	PK
`learner_id`	Unknown	PKFK

Column	Type	Keys
`permission`	Unknown	PK
`enrolment_id`	Unknown	PKFK

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

Column	Type	Keys
`course_id`	Unknown	PKFK
`learner_id`	Unknown	PKFK

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

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

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