Canvas by Instructure

Explore the interactive ERD

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	PKFK
`group_id`	Unknown	PKFK
`user_id`	Unknown	PKFK

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	PKFK
`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	PKFK
`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	PKFK
`base`	Unknown
`due_at`	Unknown
`lock_at`	Unknown
`unlock_at`	Unknown

quiz_question_type

Column	Type	Keys
`index`	Unknown	PK
`quiz_id`	Unknown	PKFK
`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