# Canvas by Instructure schema ERD

Table and field reference for the Fivetran Canvas by Instructure connector.

## Table & Field Reference

### logins

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| user_id | Unknown | FK |
| authentication_provider_id | Unknown |  |
| authentication_provider_type | Unknown |  |
| created_at | Unknown |  |
| declared_user_type | Unknown |  |
| integration_id | Unknown |  |
| sis_user_id | Unknown |  |
| unique_id | Unknown |  |
| workflow_state | Unknown |  |

### groups

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| group_category_id | Unknown | FK |
| avatar_url | Unknown |  |
| concluded | Unknown |  |
| context_type | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| has_submission | Unknown |  |
| is_public | Unknown |  |
| join_level | Unknown |  |
| leader | Unknown |  |
| max_membership | Unknown |  |
| members_count | Unknown |  |
| name | Unknown |  |
| role | Unknown |  |
| sis_group_id | Unknown |  |
| sis_import_id | Unknown |  |
| storage_quota_mb | Unknown |  |

### group_discussion_topic

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

### discussion_topic

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assignment_id | Unknown | FK |
| course_id | Unknown | FK |
| allow_rating | Unknown |  |
| anonymous_state | Unknown |  |
| attachments | Unknown |  |
| author_anonymous_id | Unknown |  |
| author_avatar_image_url | Unknown |  |
| author_display_name | Unknown |  |
| author_html_url | Unknown |  |
| author_id | Unknown |  |
| author_pronouns | Unknown |  |
| can_group | Unknown |  |
| can_lock | Unknown |  |
| can_unpublish | Unknown |  |
| comments_disabled | Unknown |  |
| created_at | Unknown |  |
| delayed_post_at | Unknown |  |
| discussion_subentry_count | Unknown |  |
| discussion_type | Unknown |  |
| group_category_id | Unknown |  |
| html_url | Unknown |  |
| is_announcement | Unknown |  |
| is_section_specific | Unknown |  |
| last_reply_at | Unknown |  |
| lock_at | Unknown |  |
| locked | Unknown |  |
| locked_for_user | Unknown |  |
| message | Unknown |  |
| only_graders_can_rate | Unknown |  |
| permissions_attach | Unknown |  |
| permissions_delete | Unknown |  |
| permissions_reply | Unknown |  |
| permissions_update | Unknown |  |
| pinned | Unknown |  |
| podcast_has_student_posts | Unknown |  |
| podcast_url | Unknown |  |
| position | Unknown |  |
| posted_at | Unknown |  |
| published | Unknown |  |
| read_state | Unknown |  |
| require_initial_post | Unknown |  |
| root_topic_id | Unknown |  |
| sort_by_rating | Unknown |  |
| subscribed | Unknown |  |
| title | Unknown |  |
| todo_date | Unknown |  |
| unread_count | Unknown |  |
| url | Unknown |  |
| user_can_see_posts | Unknown |  |
| user_name | Unknown |  |

### course

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| apply_assignment_group_weight | Unknown |  |
| blueprint | Unknown |  |
| blueprint_restrictions_availability_dates | Unknown |  |
| blueprint_restrictions_content | Unknown |  |
| blueprint_restrictions_due_dates | Unknown |  |
| blueprint_restrictions_points | Unknown |  |
| calendar_ics | Unknown |  |
| course_code | Unknown |  |
| course_color | Unknown |  |
| course_format | Unknown |  |
| created_at | Unknown |  |
| default_view | Unknown |  |
| end_at | Unknown |  |
| enrollment_term_id | Unknown |  |
| friendly_name | Unknown |  |
| grade_passback_setting | Unknown |  |
| grading_standard_id | Unknown |  |
| hide_final_grade | Unknown |  |
| home_room_course | Unknown |  |
| integration_id | Unknown |  |
| is_public | Unknown |  |
| is_public_to_auth_user | Unknown |  |
| license | Unknown |  |
| name | Unknown |  |
| public_syllabus | Unknown |  |
| public_syllabus_to_auth | Unknown |  |
| restrict_enrollment_to_course_date | Unknown |  |
| sis_course_id | Unknown |  |
| sis_import_id | Unknown |  |
| start_at | Unknown |  |
| storage_quota_mb | Unknown |  |
| template | Unknown |  |
| time_zone | Unknown |  |
| uuid | Unknown |  |
| workflow_state | Unknown |  |

### enrollment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| course_id | Unknown | FK |
| course_section_id | Unknown | FK |
| root_account_id | Unknown | FK |
| user_id | Unknown | FK |
| associated_user_id | Unknown |  |
| course_integration_id | Unknown |  |
| created_at | Unknown |  |
| current_grade | Unknown |  |
| current_score | Unknown |  |
| end_at | Unknown |  |
| enrollment_state | Unknown |  |
| final_grade | Unknown |  |
| final_score | Unknown |  |
| grade_html_url | Unknown |  |
| html_url | Unknown |  |
| last_activity_at | Unknown |  |
| last_attended_at | Unknown |  |
| limit_privilege_to_course_section | Unknown |  |
| role | Unknown |  |
| role_id | Unknown |  |
| section_integration_id | Unknown |  |
| sis_account_id | Unknown |  |
| sis_course_id | Unknown |  |
| sis_import_id | Unknown |  |
| sis_section_id | Unknown |  |
| sis_user_id | Unknown |  |
| start_at | Unknown |  |
| total_activity_time | Unknown |  |
| type | Unknown |  |
| unposted_current_grade | Unknown |  |
| unposted_current_score | Unknown |  |
| unposted_final_grade | Unknown |  |
| unposted_final_score | Unknown |  |
| updated_at | Unknown |  |

### assignment_submission

| Column | Type | Keys |
| --- | --- | --- |
| assignment_course_id | Unknown | PK |
| id | Unknown | PK |
| assignment_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| anonymous_id | Unknown |  |
| assignment | Unknown |  |
| assignment_visible | Unknown |  |
| attempt | Unknown |  |
| body | Unknown |  |
| course | Unknown |  |
| excused | Unknown |  |
| extra_attempt | Unknown |  |
| grade | Unknown |  |
| grade_match_current_submission | Unknown |  |
| graded_at | Unknown |  |
| grader_id | Unknown |  |
| html_url | Unknown |  |
| late | Unknown |  |
| late_policy_status | Unknown |  |
| missing | Unknown |  |
| point_deducted | Unknown |  |
| posted_at | Unknown |  |
| preview_url | Unknown |  |
| read_status | Unknown |  |
| redo_request | Unknown |  |
| score | Unknown |  |
| second_late | Unknown |  |
| submission_comment | Unknown |  |
| submission_type | Unknown |  |
| submitted_at | Unknown |  |
| url | Unknown |  |
| users | Unknown |  |
| workflow_state | Unknown |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| course_template_id | Unknown |  |
| default_group_storage_quota_mb | Unknown |  |
| default_storage_quota_mb | Unknown |  |
| default_time_zone | Unknown |  |
| default_user_storage_quota_mb | Unknown |  |
| integration_id | Unknown |  |
| lti_guid | Unknown |  |
| name | Unknown |  |
| parent_account_id | Unknown |  |
| root_account_id | Unknown |  |
| sis_account_id | Unknown |  |
| sis_import_id | Unknown |  |
| uuid | Unknown |  |
| workflow_state | Unknown |  |

### quiz_submission

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| quiz_id | Unknown | FK |
| user_id | Unknown | FK |
| attempt | Unknown |  |
| end_at | Unknown |  |
| extra_attempt | Unknown |  |
| extra_time | Unknown |  |
| finished_at | Unknown |  |
| fudge_point | Unknown |  |
| has_seen_result | Unknown |  |
| kept_score | Unknown |  |
| manually_unlocked | Unknown |  |
| overdue_and_needs_submission | Unknown |  |
| score | Unknown |  |
| score_before_regrade | Unknown |  |
| started_at | Unknown |  |
| time_spent | Unknown |  |
| workflow_state | Unknown |  |

### quiz_question_answer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| quiz_question_id | Unknown | PK, FK |
| migration_id | Unknown |  |
| text | Unknown |  |
| weight | Unknown |  |

### quiz_question

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| course_id | Unknown | FK |
| quiz_id | Unknown | FK |
| answer_tolerance | Unknown |  |
| assessment_question_id | Unknown |  |
| correct_comment | Unknown |  |
| correct_comment_html | Unknown |  |
| formula | Unknown |  |
| formula_decimal_place | Unknown |  |
| incorrect_comment | Unknown |  |
| incorrect_comment_html | Unknown |  |
| match | Unknown |  |
| matching_answer_incorrect_matches | Unknown |  |
| neutral_comment | Unknown |  |
| neutral_comment_html | Unknown |  |
| points_possible | Unknown |  |
| position | Unknown |  |
| question_name | Unknown |  |
| question_text | Unknown |  |
| question_type | Unknown |  |
| quiz_group_id | Unknown |  |
| variable | Unknown |  |

### poll_session

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| course_id | Unknown | FK |
| course_section_id | Unknown | FK |
| poll_id | Unknown | FK |
| created_at | Unknown |  |
| has_public_results | Unknown |  |
| is_published | Unknown |  |
| poll_submissions | Unknown |  |
| results | Json |  |

### assignment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assignment_group_id | Unknown | FK |
| course_id | Unknown | FK |
| group_category_id | Unknown | FK |
| quiz_id | Unknown | FK |
| allowed_attempt | Unknown |  |
| annotatable_attachment_id | Unknown |  |
| anonymize_student | Unknown |  |
| anonymous_grading | Unknown |  |
| anonymous_instructor_annotation | Unknown |  |
| anonymous_peer_review | Unknown |  |
| anonymous_submission | Unknown |  |
| automatic_peer_review | Unknown |  |
| can_duplicate | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| due_at | Unknown |  |
| due_date_required | Unknown |  |
| final_grader_id | Unknown |  |
| grade_group_student_individually | Unknown |  |
| graded_submission_exist | Unknown |  |
| grader_anonymous_to_grader | Unknown |  |
| grader_comment_visible_to_grader | Unknown |  |
| grader_count | Unknown |  |
| grader_name_visible_to_final_grader | Unknown |  |
| grading_standard_id | Unknown |  |
| grading_type | Unknown |  |
| has_override | Unknown |  |
| has_submitted_submission | Unknown |  |
| hide_in_gradebook | Unknown |  |
| html_url | Unknown |  |
| important_date | Unknown |  |
| in_closed_grading_period | Unknown |  |
| integration_id | Unknown |  |
| intra_group_peer_review | Unknown |  |
| is_master_course_master_content | Unknown |  |
| is_quiz_assignment | Unknown |  |
| lock_at | Unknown |  |
| locked_for_user | Unknown |  |
| lti_context_id | Unknown |  |
| master_course_restrictions_availability_date | Unknown |  |
| master_course_restrictions_content | Unknown |  |
| master_course_restrictions_due_date | Unknown |  |
| master_course_restrictions_point | Unknown |  |
| max_name_length | Unknown |  |
| moderated_grading | Unknown |  |
| muted | Unknown |  |
| name | Unknown |  |
| need_grading_count | Unknown |  |
| omit_from_final_grade | Unknown |  |
| only_visible_to_override | Unknown |  |
| original_assignment_id | Unknown |  |
| original_assignment_name | Unknown |  |
| original_course_id | Unknown |  |
| original_lti_resource_link_id | Unknown |  |
| original_quiz_id | Unknown |  |
| peer_review | Unknown |  |
| point_possible | Unknown |  |
| position | Unknown |  |
| post_manually | Unknown |  |
| post_to_sis | Unknown |  |
| published | Unknown |  |
| require_lockdown_browser | Unknown |  |
| restrict_quantitative_data | Unknown |  |
| restricted_by_master_course | Unknown |  |
| secure_param | Unknown |  |
| sis_assignment_id | Unknown |  |
| submission_download_url | Unknown |  |
| unlock_at | Unknown |  |
| unpublishable | Unknown |  |
| updated_at | Unknown |  |
| workflow_state | Unknown |  |

### poll

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| created_at | Unknown |  |
| description | Unknown |  |
| question | Unknown |  |
| total_result | Json |  |

### module_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| module_id | Unknown | FK |
| completion_requirement | Unknown |  |
| content_details | Unknown |  |
| content_id | Unknown |  |
| external_url | Unknown |  |
| html_url | Unknown |  |
| indent | Unknown |  |
| new_tab | Unknown |  |
| page_url | Unknown |  |
| position | Unknown |  |
| publish_at | Unknown |  |
| published | Unknown |  |
| quiz_lti | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| url | Unknown |  |

### enrollment_term

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| created_at | Unknown |  |
| end_at | Unknown |  |
| grading_period_group_id | Unknown |  |
| name | Unknown |  |
| sis_term_id | Unknown |  |
| start_at | Unknown |  |
| student_enrollment | Unknown |  |
| student_enrollment_end_at | Unknown |  |
| student_enrollment_start_at | Unknown |  |
| teacher_enrollment | Unknown |  |
| teacher_enrollment_end_at | Unknown |  |
| teacher_enrollment_start_at | Unknown |  |
| workflow_state | Unknown |  |

### assignment_override

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assignment_id | Unknown | FK |
| course_section_id | Unknown | FK |
| quiz_id | Unknown | FK |
| all_day | Unknown |  |
| all_day_date | Unknown |  |
| context_module_id | Unknown |  |
| due_at | Unknown |  |
| group_id | Unknown |  |
| lock_at | Unknown |  |
| title | Unknown |  |
| unlock_at | Unknown |  |

### group_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| auto_leader | Unknown |  |
| context_type | Unknown |  |
| group_limit | Unknown |  |
| name | Unknown |  |
| progress | Unknown |  |
| role | Unknown |  |
| self_signup | Unknown |  |
| sis_group_category_id | Unknown |  |
| sis_import_id | Unknown |  |

### communication_channel

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| address | Unknown |  |
| bounce_count | Unknown |  |
| last_bounce_at | Unknown |  |
| position | Unknown |  |
| type | Unknown |  |
| workflow_state | Unknown |  |

### course_section

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| course_id | Unknown | FK |
| created_at | Unknown |  |
| end_at | Unknown |  |
| integration_id | Unknown |  |
| name | Unknown |  |
| nonxlist_course_id | Unknown |  |
| restrict_enrollment_to_section_date | Unknown |  |
| sis_course_id | Unknown |  |
| sis_import_id | Unknown |  |
| sis_section_id | Unknown |  |
| start_at | Unknown |  |

### assignment_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| course_id | Unknown | FK |
| group_weight | Unknown |  |
| name | Unknown |  |
| position | Unknown |  |
| sis_source_id | Unknown |  |

### quiz_question_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| quiz_id | Unknown | FK |
| assessment_question_bank_id | Unknown |  |
| name | Unknown |  |
| pick_count | Unknown |  |
| position | Unknown |  |
| question_point | Unknown |  |

### group_membership

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| user_id | Unknown | FK |
| just_created | Unknown |  |
| moderator | Unknown |  |
| sis_import_id | Unknown |  |
| workflow_state | Unknown |  |

### module

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| course_id | Unknown | FK |
| completed_at | Unknown |  |
| items_count | Unknown |  |
| items_url | Unknown |  |
| name | Unknown |  |
| position | Unknown |  |
| pre_requisite_module_id | Unknown |  |
| publish_final_grade | Unknown |  |
| published | Unknown |  |
| require_sequential_progress | Unknown |  |
| state | Unknown |  |
| unlock_at | Unknown |  |
| workflow_state | Unknown |  |

### quiz_all_date

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| quiz_id | Unknown | PK, FK |
| base | Unknown |  |
| due_at | Unknown |  |
| lock_at | Unknown |  |
| unlock_at | Unknown |  |

### quiz_question_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| quiz_id | Unknown | PK, FK |
| question_type | Unknown |  |

### quiz

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assignment_group_id | Unknown | FK |
| assignment_id | Unknown | FK |
| course_id | Unknown | FK |
| access_code | Unknown |  |
| allowed_attempt | Unknown |  |
| can_unpublish | Unknown |  |
| can_update | Unknown |  |
| cant_go_back | Unknown |  |
| description | Unknown |  |
| due_at | Unknown |  |
| has_access_code | Unknown |  |
| hide_correct_answers_at | Unknown |  |
| hide_result | Unknown |  |
| html_url | Unknown |  |
| important_date | Unknown |  |
| in_paced_course | Unknown |  |
| ip_filter | Unknown |  |
| is_master_course_master_content | Unknown |  |
| lock_at | Unknown |  |
| lock_explanation | Unknown |  |
| lock_info_asset_string | Unknown |  |
| lock_info_missing_permission | Unknown |  |
| lockdown_browser_monitor_data | Unknown |  |
| locked_for_user | Unknown |  |
| master_course_restrictions_availability_date | Unknown |  |
| master_course_restrictions_content | Unknown |  |
| master_course_restrictions_due_date | Unknown |  |
| master_course_restrictions_point | Unknown |  |
| message_student_url | Unknown |  |
| migration_id | Unknown |  |
| mobile_url | Unknown |  |
| one_question_at_a_time | Unknown |  |
| one_time_result | Unknown |  |
| only_visible_to_override | Unknown |  |
| permissions_create | Unknown |  |
| permissions_delete | Unknown |  |
| permissions_grade | Unknown |  |
| permissions_manage | Unknown |  |
| permissions_preview | Unknown |  |
| permissions_read | Unknown |  |
| permissions_read_statistic | Unknown |  |
| permissions_review_grade | Unknown |  |
| permissions_submit | Unknown |  |
| permissions_update | Unknown |  |
| permissions_view_answer_audit | Unknown |  |
| point_possible | Unknown |  |
| post_to_sis | Unknown |  |
| published | Unknown |  |
| quiz_report_url | Unknown |  |
| quiz_statistic_url | Unknown |  |
| quiz_submission_versions_html_url | Unknown |  |
| quiz_type | Unknown |  |
| require_lockdown_browser | Unknown |  |
| require_lockdown_browser_for_result | Unknown |  |
| require_lockdown_browser_monitor | Unknown |  |
| restricted_by_master_course | Unknown |  |
| scoring_policy | Unknown |  |
| section_count | Unknown |  |
| show_correct_answer | Unknown |  |
| show_correct_answers_at | Unknown |  |
| show_correct_answers_last_attempt | Unknown |  |
| shuffle_answer | Unknown |  |
| speed_grader_url | Unknown |  |
| time_limit | Unknown |  |
| timer_autosubmit_disabled | Unknown |  |
| title | Unknown |  |
| unlock_at | Unknown |  |
| unpublishable | Unknown |  |

### new_quiz

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assignment_group_id | Unknown | FK |
| course_id | Unknown | FK |
| quiz_id | Unknown | FK |
| due_at | Unknown |  |
| grading_type | Unknown |  |
| instructions | Unknown |  |
| lock_at | Unknown |  |
| points_possible | Unknown |  |
| published | Unknown |  |
| quiz_settings | Unknown |  |
| title | Unknown |  |
| unlock_at | Unknown |  |

### roles

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| base_role_type | Unknown |  |
| created_at | Unknown |  |
| is_account_role | Unknown |  |
| label | Unknown |  |
| last_updated_at | Unknown |  |
| role | Unknown |  |
| workflow_state | Unknown |  |
| permission_** |  |  |

### calender_event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| all_context_codes | Unknown |  |
| all_day | Unknown |  |
| all_day_date | Unknown |  |
| appointment_group_id | Unknown |  |
| appointment_group_url | Unknown |  |
| available_slots | Unknown |  |
| blackout_date | Unknown |  |
| child_event | Unknown |  |
| child_event_count | Unknown |  |
| context_code | Unknown |  |
| context_name | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| effective_context_code | Unknown |  |
| end_at | Unknown |  |
| groups | Unknown |  |
| hidden | Unknown |  |
| html_url | Unknown |  |
| important_date | Unknown |  |
| location_address | Unknown |  |
| location_name | Unknown |  |
| own_reservation | Unknown |  |
| parent_event_id | Unknown |  |
| participant_per_appointment | Unknown |  |
| participant_type | Unknown |  |
| reserve_url | Unknown |  |
| reserved | Unknown |  |
| rrule | Unknown |  |
| series_head | Unknown |  |
| series_natural_language | Unknown |  |
| series_uuid | Unknown |  |
| start_at | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |
| users | Unknown |  |
| workflow_state | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| created_at | Unknown |  |
| integration_id | Unknown |  |
| login_id | Unknown |  |
| name | Unknown |  |
| short_name | Unknown |  |
| sis_import_id | Unknown |  |
| sis_user_id | Unknown |  |
| sortable_name | Unknown |  |

## Relationships

- logins(user_id) → users(id)
- logins(account_id) → account(id)
- groups(group_category_id) → group_category(id)
- groups(account_id) → account(id)
- group_discussion_topic(user_id) → users(id)
- group_discussion_topic(group_id) → groups(id)
- group_discussion_topic(discussion_topic_id) → discussion_topic(id)
- discussion_topic(assignment_id) → assignment(id)
- discussion_topic(course_id) → course(id)
- course(account_id) → account(id)
- enrollment(user_id) → users(id)
- enrollment(root_account_id) → account(id)
- enrollment(course_section_id) → course_section(id)
- enrollment(course_id) → course(id)
- assignment_submission(user_id) → users(id)
- assignment_submission(assignment_id) → assignment(id)
- quiz_submission(user_id) → users(id)
- quiz_submission(quiz_id) → quiz(id)
- quiz_question_answer(quiz_question_id) → quiz_question(id)
- quiz_question(quiz_id) → quiz(id)
- quiz_question(course_id) → quiz(course_id)
- poll_session(poll_id) → poll(id)
- poll_session(course_section_id) → course_section(id)
- poll_session(course_id) → course(id)
- assignment(assignment_group_id) → assignment_group(id)
- assignment(quiz_id) → quiz(id)
- assignment(group_category_id) → group_category(id)
- assignment(course_id) → course(id)
- poll(user_id) → users(id)
- module_item(module_id) → module(id)
- enrollment_term(account_id) → account(id)
- assignment_override(course_section_id) → course_section(id)
- assignment_override(assignment_id) → assignment(id)
- assignment_override(quiz_id) → quiz(id)
- group_category(account_id) → account(id)
- communication_channel(user_id) → users(id)
- course_section(course_id) → course(id)
- assignment_group(course_id) → course(id)
- quiz_question_group(quiz_id) → quiz(id)
- group_membership(group_id) → groups(id)
- group_membership(user_id) → users(id)
- module(course_id) → course(id)
- quiz_all_date(quiz_id) → quiz(id)
- quiz_question_type(quiz_id) → quiz(id)
- quiz(assignment_group_id) → assignment_group(id)
- quiz(assignment_id) → assignment(id)
- quiz(course_id) → course(id)
- new_quiz(assignment_group_id) → assignment_group(id)
- new_quiz(course_id) → course(id)
- new_quiz(quiz_id) → quiz(id)
- roles(account_id) → account(id)
- users(account_id) → account(id)