Canvas Data 2 by Instructure

Explore the interactive ERD

Table & Field Reference

master_courses_migration_result

Column	Type	Keys
`id`	Unknown	PK
`child_subscription_id`	Unknown	FK
`master_migration_id`	Unknown	FK
`content_migration_id`	Unknown
`import_type`	Unknown
`results`	Json
`state`	Unknown
`meta_`

user_account_association

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`user_id`	Unknown	FK
`created_at`	Unknown
`depth`	Unknown
`updated_at`	Unknown
`meta_`

content_tag

Column	Type	Keys
`id`	Unknown	PK
`context_module_id`	Unknown	FK
`learning_outcome_id`	Unknown	FK
`rubric_association_id`	Unknown	FK
`associated_asset_id`	Unknown
`associated_asset_type`	Unknown
`comments`	Unknown
`content_id`	Unknown
`content_type`	Unknown
`context_code`	Unknown
`context_id`	Unknown
`context_type`	Unknown
`created_at`	Unknown
`link_settings`	Json
`mastery_score`	Unknown
`migration_id`	Unknown
`new_tab`	Unknown
`position`	Unknown
`tag_type`	Unknown
`title`	Unknown
`updated_at`	Unknown
`url`	Unknown
`workflow_state`	Unknown
`meta_`

rubric

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	FK
`context_id`	Unknown
`context_type`	Unknown
`created_at`	Unknown
`data`	Json
`free_form_criterion_comments`	Unknown
`hide_score_total`	Unknown
`migration_id`	Unknown
`points_possible`	Unknown
`title`	Unknown
`updated_at`	Unknown
`workflow_state`	Unknown
`meta_`

learning_outcome_group

Column	Type	Keys
`id`	Unknown	PK
`learning_outcome_group_id`	Unknown	FK
`root_learning_outcome_group_id`	Unknown	FK
`context_id`	Unknown
`context_type`	Unknown
`created_at`	Unknown
`description`	Unknown
`migration_id`	Unknown
`outcome_import_id`	Unknown
`source_outcome_group_id`	Unknown
`title`	Unknown
`updated_at`	Unknown
`vendor_guid`	Unknown
`workflow_state`	Unknown
`meta_`

learning_outcome_result

Column	Type	Keys
`id`	Unknown	PK
`content_tag_id`	Unknown	FK
`learning_outcome_id`	Unknown	FK
`user_id`	Unknown	FK
`artifact_id`	Unknown
`artifact_type`	Unknown
`assessed_at`	Unknown
`associated_asset_id`	Unknown
`associated_asset_type`	Unknown
`association_id`	Unknown
`association_type`	Unknown
`attempt`	Unknown
`context_code`	Unknown
`context_id`	Unknown
`context_type`	Unknown
`created_at`	Unknown
`hidden`	Unknown
`hide_points`	Unknown
`mastery`	Unknown
`original_mastery`	Unknown
`original_possible`	Unknown
`original_score`	Unknown
`percentage`	Unknown
`possible`	Unknown
`score`	Unknown
`submitted_at`	Unknown
`title`	Unknown
`updated_at`	Unknown
`user_uuid`	Unknown
`workflow_state`	Unknown
`meta_`

outcome_proficiency_rating

Column	Type	Keys
`id`	Unknown	PK
`outcome_proficiency_id`	Unknown	FK
`color`	Unknown
`created_at`	Unknown
`description`	Unknown
`mastery`	Unknown
`points`	Unknown
`updated_at`	Unknown
`workflow_state`	Unknown
`meta_`

discussion_entry_participant

Column	Type	Keys
`id`	Unknown	PK
`discussion_entry_id`	Unknown	FK
`user_id`	Unknown	FK
`forced_read_state`	Unknown
`rating`	Unknown
`workflow_state`	Unknown
`meta_`

canvadocs_annotation_context

Column	Type	Keys
`id`	Unknown	PK
`attachment_id`	Unknown	FK
`submission_id`	Unknown	FK
`created_at`	Unknown
`launch_id`	Unknown
`submission_attempt`	Unknown
`updated_at`	Unknown
`meta_`

master_courses_master_content_tag

Column	Type	Keys
`id`	Unknown	PK
`master_template_id`	Unknown	FK
`content_id`	Unknown
`content_type`	Unknown
`migration_id`	Unknown
`restrictions`	Json
`use_default_restrictions`	Unknown
`meta_`

score

Column	Type	Keys
`id`	Unknown	PK
`assignment_group_id`	Unknown	FK
`enrollment_id`	Unknown	FK
`grading_period_id`	Unknown	FK
`course_score`	Unknown
`created_at`	Unknown
`current_points`	Unknown
`current_score`	Unknown
`final_points`	Unknown
`final_score`	Unknown
`override_score`	Unknown
`unposted_current_points`	Unknown
`unposted_current_score`	Unknown
`unposted_final_points`	Unknown
`unposted_final_score`	Unknown
`updated_at`	Unknown
`workflow_state`	Unknown
`meta_`

rubric_association

Column	Type	Keys
`id`	Unknown	PK
`rubric_id`	Unknown	FK
`association_id`	Unknown
`association_type`	Unknown
`bookmarked`	Unknown
`context_id`	Unknown
`context_type`	Unknown
`created_at`	Unknown
`hide_outcome_results`	Unknown
`hide_points`	Unknown
`hide_score_total`	Unknown
`purpose`	Unknown
`summary_data`	Json
`title`	Unknown
`updated_at`	Unknown
`use_for_grading`	Unknown
`workflow_state`	Unknown
`meta_`

account_user

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`role_id`	Unknown	FK
`user_id`	Unknown	FK
`created_at`	Unknown
`updated_at`	Unknown
`workflow_state`	Unknown
`meta_`

group_category

Column	Type	Keys
`id`	Unknown	PK
`auto_leader`	Unknown
`context_id`	Unknown
`context_type`	Unknown
`created_at`	Unknown
`deleted_at`	Unknown
`group_limit`	Unknown
`name`	Unknown
`non_collaborative`	Unknown
`role`	Unknown
`self_signup`	Unknown
`sis_batch_id`	Unknown
`sis_source_id`	Unknown
`updated_at`	Unknown
`meta_`

conversation_participant

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	FK
`has_attachments`	Unknown
`has_media_objects`	Unknown
`label`	Unknown
`last_message_at`	Unknown
`subscribed`	Unknown
`tags`	Unknown
`updated_at`	Unknown
`workflow_state`	Unknown
`meta_`

course_account_association

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`course_id`	Unknown	FK
`course_section_id`	Unknown	FK
`created_at`	Unknown
`depth`	Unknown
`updated_at`	Unknown
`meta_`

conversation

Column	Type	Keys
`id`	Unknown	PK
`context_id`	Unknown
`context_type`	Unknown
`has_attachments`	Unknown
`has_media_objects`	Unknown
`subject`	Unknown
`tags`	Unknown
`updated_at`	Unknown
`meta_`

master_courses_master_template

Column	Type	Keys
`id`	Unknown	PK
`active_migration_id`	Unknown	FK
`course_id`	Unknown	FK
`created_at`	Unknown
`default_restrictions`	Json
`default_restrictions_by_type`	Json
`full_course`	Unknown
`updated_at`	Unknown
`use_default_restrictions_by_type`	Unknown
`workflow_state`	Unknown
`meta_`

context_module

Column	Type	Keys
`id`	Unknown	PK
`completion_events`	Unknown
`completion_requirements`	Json
`context_id`	Unknown
`context_type`	Unknown
`created_at`	Unknown
`deleted_at`	Unknown
`migration_id`	Unknown
`name`	Unknown
`position`	Unknown
`prerequisites`	Json
`require_sequential_progress`	Unknown
`requirement_count`	Unknown
`unlock_at`	Unknown
`updated_at`	Unknown
`workflow_state`	Unknown
`meta_`

grading_period

Column	Type	Keys
`id`	Unknown	PK
`grading_period_group_id`	Unknown	FK
`close_date`	Unknown
`created_at`	Unknown
`end_date`	Unknown
`start_date`	Unknown
`title`	Unknown
`updated_at`	Unknown
`weight`	Unknown
`workflow_state`	Unknown
`meta_`

role_override

Column	Type	Keys
`id`	Unknown	PK
`role_id`	Unknown	FK
`applies_to_descendants`	Unknown
`applies_to_self`	Unknown
`context_id`	Unknown
`context_type`	Unknown
`created_at`	Unknown
`enabled`	Unknown
`locked`	Unknown
`permission`	Unknown
`updated_at`	Unknown
`meta_`

grading_standard

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	FK
`context_code`	Unknown
`context_id`	Unknown
`context_type`	Unknown
`created_at`	Unknown
`data`	Unknown
`migration_id`	Unknown
`title`	Unknown
`updated_at`	Unknown
`version`	Unknown
`workflow_state`	Unknown
`meta_`

assessment_question_bank

Column	Type	Keys
`id`	Unknown	PK
`context_id`	Unknown
`context_type`	Unknown
`created_at`	Unknown
`deleted_at`	Unknown
`migration_id`	Unknown
`title`	Unknown
`updated_at`	Unknown
`workflow_state`	Unknown
`meta_`

rubric_assessment

Column	Type	Keys
`id`	Unknown	PK
`assessor_id`	Unknown	FK
`rubric_association_id`	Unknown	FK
`rubric_id`	Unknown	FK
`user_id`	Unknown	FK
`artifact_attempt`	Unknown
`artifact_id`	Unknown
`artifact_type`	Unknown
`assessment_type`	Unknown
`created_at`	Unknown
`data`	Json
`hide_points`	Unknown
`score`	Unknown
`updated_at`	Unknown
`meta_`

conversation_message_participant

Column	Type	Keys
`id`	Unknown	PK
`conversation_message_id`	Unknown	FK
`conversation_participant_id`	Unknown	FK
`user_id`	Unknown	FK
`deleted_at`	Unknown
`tags`	Unknown
`workflow_state`	Unknown
`meta_`

outcome_proficiencies

Column	Type	Keys
`id`	Unknown	PK
`context_id`	Unknown
`context_type`	Unknown
`created_at`	Unknown
`updated_at`	Unknown
`workflow_state`	Unknown
`meta_`

discussion_entry

Column	Type	Keys
`id`	Unknown	PK
`attachment_id`	Unknown	FK
`discussion_topic_id`	Unknown	FK
`editor_id`	Unknown	FK
`parent_id`	Unknown	FK
`root_entry_id`	Unknown	FK
`user_id`	Unknown	FK
`created_at`	Unknown
`deleted_at`	Unknown
`depth`	Unknown
`message`	Unknown
`migration_id`	Unknown
`rating_count`	Unknown
`rating_sum`	Unknown
`updated_at`	Unknown
`workflow_state`	Unknown
`meta_`

quiz_question

Column	Type	Keys
`id`	Unknown	PK
`assessment_question_id`	Unknown	FK
`quiz_group_id`	Unknown	FK
`quiz_id`	Unknown	FK
`assessment_question_version`	Unknown
`created_at`	Unknown
`migration_id`	Unknown
`position`	Unknown
`question_data_answers`	Unknown
`question_data_correct_comment`	Unknown
`question_data_incorrect_comment`	Unknown
`question_data_matching_answer_incorrect_matches`	Unknown
`question_data_name`	Unknown
`question_data_neutral_comments`	Unknown
`question_data_points_possible`	Unknown
`question_data_question_text`	Unknown
`question_data_question_type`	Unknown
`question_data_regrade_option`	Unknown
`question_data_text_after_answers`	Unknown
`updated_at`	Unknown
`workflow_state`	Unknown
`meta_`

originality_report

Column	Type	Keys
`id`	Unknown	PK
`attachment_id`	Unknown	FK
`submission_id`	Unknown	FK
`created_at`	Unknown
`error_message`	Unknown
`link_id`	Unknown
`originality_report_lti_url`	Unknown
`originality_report_url`	Unknown
`originality_score`	Unknown
`submission_time`	Unknown
`updated_at`	Unknown
`workflow_state`	Unknown
`meta_`

lti_result

Column	Type	Keys
`id`	Unknown	PK
`lti_line_item_id`	Unknown	FK
`submission_id`	Unknown	FK
`user_id`	Unknown	FK
`activity_progress`	Unknown
`comment`	Unknown
`created_at`	Unknown
`extensions`	Unknown
`grading_progress`	Unknown
`result_maximum`	Unknown
`result_score`	Unknown
`updated_at`	Unknown
`workflow_state`	Unknown
`meta_`

custom_gradebook_column

Column	Type	Keys
`id`	Unknown	PK
`course_id`	Unknown	FK
`created_at`	Unknown
`position`	Unknown
`read_only`	Unknown
`teacher_notes`	Unknown
`title`	Unknown
`updated_at`	Unknown
`workflow_state`	Unknown
`meta_`

users

Column	Type	Keys
`id`	Unknown	PK
`merged_into_user_id`	Unknown	FK
`avatar_image_source`	Unknown
`avatar_image_updated_at`	Unknown
`avatar_image_url`	Unknown
`created_at`	Unknown
`deleted_at`	Unknown
`last_logged_out`	Unknown
`locale`	Unknown
`lti_context_id`	Unknown
`name`	Unknown
`pronouns`	Unknown
`public`	Unknown
`school_name`	Unknown
`school_position`	Unknown
`short_name`	Unknown
`sortable_name`	Unknown
`storage_quota`	Unknown
`time_zone`	Unknown
`updated_at`	Unknown
`uuid`	Unknown
`workflow_state`	Unknown
`meta_`

custom_gradebook_column_data

Column	Type	Keys
`id`	Unknown	PK
`custom_gradebook_column_id`	Unknown	FK
`user_id`	Unknown	FK
`content`	Unknown
`meta_`

group_membership

Column	Type	Keys
`id`	Unknown	PK
`group_id`	Unknown	FK
`user_id`	Unknown	FK
`created_at`	Unknown
`moderator`	Unknown
`sis_batch_id`	Unknown
`updated_at`	Unknown
`uuid`	Unknown
`workflow_state`	Unknown
`meta_`

folder

Column	Type	Keys
`id`	Unknown	PK
`parent_folder_id`	Unknown	FK
`cloned_item_id`	Unknown
`context_id`	Unknown
`context_type`	Unknown
`created_at`	Unknown
`deleted_at`	Unknown
`full_name`	Unknown
`lock_at`	Unknown
`locked`	Unknown
`name`	Unknown
`position`	Unknown
`submission_context_code`	Unknown
`unique_type`	Unknown
`unlock_at`	Unknown
`updated_at`	Unknown
`workflow_state`	Unknown
`meta_`

assignment_override_student

Column	Type	Keys
`id`	Unknown	PK
`assignment_id`	Unknown	FK
`assignment_override_id`	Unknown	FK
`quiz_id`	Unknown	FK
`user_id`	Unknown	FK
`created_at`	Unknown
`updated_at`	Unknown
`workflow_state`	Unknown
`meta_`

context_module_progression

Column	Type	Keys
`id`	Unknown	PK
`context_module_id`	Unknown	FK
`user_id`	Unknown	FK
`collapsed`	Unknown
`completed_at`	Unknown
`created_at`	Unknown
`current`	Unknown
`current_position`	Unknown
`evaluated_at`	Unknown
`incomplete_requirements`	Json
`lock_version`	Unknown
`requirements_met`	Json
`updated_at`	Unknown
`workflow_state`	Unknown
`meta_`

master_courses_child_content_tag

Column	Type	Keys
`id`	Unknown	PK
`child_subscription_id`	Unknown	FK
`content_id`	Unknown
`content_type`	Unknown
`downstream_changes`	Json
`migration_id`	Unknown
`meta_`

enrollment_term

Column	Type	Keys
`id`	Unknown	PK
`grading_period_group_id`	Unknown	FK
`created_at`	Unknown
`end_at`	Unknown
`integration_id`	Unknown
`name`	Unknown
`sis_batch_id`	Unknown
`sis_source_id`	Unknown
`start_at`	Unknown
`term_code`	Unknown
`updated_at`	Unknown
`workflow_state`	Unknown
`meta_`

assessment_question

Column	Type	Keys
`id`	Unknown	PK
`assessment_question_bank_id`	Unknown	FK
`context_id`	Unknown
`context_type`	Unknown
`created_at`	Unknown
`deleted_at`	Unknown
`migration_id`	Unknown
`name`	Unknown
`position`	Unknown
`question_data`	Unknown
`updated_at`	Unknown
`workflow_state`	Unknown
`meta_`

post_policy

Column	Type	Keys
`id`	Unknown	PK
`assignment_id`	Unknown	FK
`course_id`	Unknown	FK
`created_at`	Unknown
`post_manually`	Unknown
`updated_at`	Unknown
`meta_`

attachment_association

Column	Type	Keys
`id`	Unknown	PK
`attachment_id`	Unknown	FK
`context_id`	Unknown
`context_type`	Unknown
`meta_`

submission_comment

Column	Type	Keys
`id`	Unknown	PK
`author_id`	Unknown	FK
`submission_id`	Unknown	FK
`anonymous`	Unknown
`assessment_request_id`	Unknown
`attachment_ids`	Json
`attempt`	Unknown
`author_name`	Unknown
`comment`	Unknown
`context_id`	Unknown
`context_type`	Unknown
`created_at`	Unknown
`draft`	Unknown
`edited_at`	Unknown
`group_comment_id`	Unknown
`hidden`	Unknown
`media_comment_id`	Unknown
`media_comment_type`	Unknown
`provisional_grade_id`	Unknown
`teacher_only_comment`	Unknown
`updated_at`	Unknown
`meta_`

favorite

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	FK
`context_id`	Unknown
`context_type`	Unknown
`created_at`	Unknown
`updated_at`	Unknown
`meta_`

wiki_pages

Column	Type	Keys
`id`	Unknown	PK
`assignment_id`	Unknown	FK
`old_assignment_id`	Unknown	FK
`user_id`	Unknown	FK
`body`	Unknown
`context_id`	Unknown
`context_type`	Unknown
`could_be_locked`	Unknown
`created_at`	Unknown
`editing_roles`	Unknown
`migration_id`	Unknown
`protected_editing`	Unknown
`revised_at`	Unknown
`title`	Unknown
`todo_date`	Unknown
`updated_at`	Unknown
`url`	Unknown
`wiki_id`	Unknown
`workflow_state`	Unknown
`meta_`

communication_channel

Column	Type	Keys
`id`	Unknown	PK
`pseudonym_id`	Unknown	FK
`user_id`	Unknown	FK
`bounce_count`	Unknown
`confirmation_code_expires_at`	Unknown
`confirmation_sent_count`	Unknown
`created_at`	Unknown
`path`	Unknown
`path_type`	Unknown
`position`	Unknown
`updated_at`	Unknown
`workflow_state`	Unknown
`meta_`

calendar_event

Column	Type	Keys
`id`	Unknown	PK
`parent_calendar_event_id`	Unknown	FK
`user_id`	Unknown	FK
`web_conference_id`	Unknown	FK
`all_day`	Unknown
`all_day_date`	Unknown
`comments`	Unknown
`context_code`	Unknown
`context_id`	Unknown
`context_type`	Unknown
`created_at`	Unknown
`deleted_at`	Unknown
`description`	Unknown
`effective_context_code`	Unknown
`end_at`	Unknown
`important_dates`	Unknown
`location_address`	Unknown
`location_name`	Unknown
`migration_id`	Unknown
`participants_per_appointment`	Unknown
`start_at`	Unknown
`time_zone_edited`	Unknown
`title`	Unknown
`updated_at`	Unknown
`workflow_state`	Unknown
`meta_`

lti_resource_link

Column	Type	Keys
`id`	Unknown	PK
`context_external_tool_id`	Unknown	FK
`context_id`	Unknown
`context_type`	Unknown
`created_at`	Unknown
`custom`	Unknown
`lookup_uuid`	Unknown
`resource_link_uuid`	Unknown
`updated_at`	Unknown
`workflow_state`	Unknown
`meta_`

enrollment_state

Column	Type	Keys
`enrollment_id`	Unknown	PKFK
`access_is_current`	Unknown
`restricted_access`	Unknown
`state`	Unknown
`state_is_current`	Unknown
`state_started_at`	Unknown
`state_valid_until`	Unknown
`updated_at`	Unknown
`meta_`

quiz_submission

Column	Type	Keys
`id`	Unknown	PK
`quiz_id`	Unknown	FK
`submission_id`	Unknown	FK
`user_id`	Unknown	FK
`attempt`	Unknown
`created_at`	Unknown
`end_at`	Unknown
`extra_time`	Unknown
`finished_at`	Unknown
`fudge_points`	Unknown
`has_seen_results`	Unknown
`kept_score`	Unknown
`manually_scored`	Unknown
`manually_unlocked`	Unknown
`migration_id`	Unknown
`quiz_points_possible`	Unknown
`quiz_version`	Unknown
`score`	Unknown
`score_before_regrade`	Unknown
`started_at`	Unknown
`submission_data`	Json
`temporary_user_code`	Unknown
`updated_at`	Unknown
`was_preview`	Unknown
`workflow_state`	Unknown
`meta_`

assignment_group

Column	Type	Keys
`id`	Unknown	PK
`context_id`	Unknown
`context_type`	Unknown
`created_at`	Unknown
`default_assignment_name`	Unknown
`group_weight`	Unknown
`migration_id`	Unknown
`name`	Unknown
`position`	Unknown
`rules`	Unknown
`sis_source_id`	Unknown
`updated_at`	Unknown
`workflow_state`	Unknown
`meta_`

score_statistics

Column	Type	Keys
`id`	Unknown	PK
`assignment_id`	Unknown	FK
`count`	Unknown
`created_at`	Unknown
`maximum`	Unknown
`mean`	Unknown
`minimum`	Unknown
`updated_at`	Unknown
`meta_`

submission_version

Column	Type	Keys
`id`	Unknown	PK
`assignment_id`	Unknown	FK
`user_id`	Unknown	FK
`context_id`	Unknown
`context_type`	Unknown
`version_id`	Unknown
`meta_`

discussion_topic_participant

Column	Type	Keys
`id`	Unknown	PK
`discussion_topic_id`	Unknown	FK
`user_id`	Unknown	FK
`subscribed`	Unknown
`unread_entry_count`	Unknown
`workflow_state`	Unknown
`meta_`

content_participation_count

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	FK
`content_type`	Unknown
`context_id`	Unknown
`context_type`	Unknown
`created_at`	Unknown
`unread_count`	Unknown
`updated_at`	Unknown
`meta_`

roles

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`base_role_type`	Unknown
`created_at`	Unknown
`deleted_at`	Unknown
`name`	Unknown
`updated_at`	Unknown
`workflow_state`	Unknown
`meta_`

assignment_override

Column	Type	Keys
`id`	Unknown	PK
`assignment_id`	Unknown	FK
`quiz_id`	Unknown	FK
`set_id`	Unknown	FK
`all_day`	Unknown
`all_day_date`	Unknown
`assignment_version`	Unknown
`created_at`	Unknown
`due_at`	Unknown
`due_at_overridden`	Unknown
`lock_at`	Unknown
`lock_at_overridden`	Unknown
`quiz_version`	Unknown
`set_type`	Unknown
`title`	Unknown
`unlock_at`	Unknown
`unlock_at_overridden`	Unknown
`updated_at`	Unknown
`workflow_state`	Unknown
`meta_`

conversation_message

Column	Type	Keys
`id`	Unknown	PK
`asset_id`	Unknown	FK
`author_id`	Unknown	FK
`conversation_id`	Unknown	FK
`asset_type`	Unknown
`attachment_ids`	Unknown
`body`	Unknown
`context_id`	Unknown
`context_type`	Unknown
`created_at`	Unknown
`forwarded_message_ids`	Unknown
`generated`	Unknown
`has_attachments`	Unknown
`has_media_objects`	Unknown
`media_comment_id`	Unknown
`media_comment_type`	Unknown
`meta_`

pseudonym

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`user_id`	Unknown	FK
`authentication_provider_id`	Unknown
`created_at`	Unknown
`current_login_at`	Unknown
`current_login_ip`	Unknown
`deleted_at`	Unknown
`failed_login_count`	Unknown
`integration_id`	Unknown
`last_login_at`	Unknown
`last_login_ip`	Unknown
`last_request_at`	Unknown
`login_count`	Unknown
`position`	Unknown
`sis_batch_id`	Unknown
`sis_user_id`	Unknown
`unique_id`	Unknown
`updated_at`	Unknown
`workflow_state`	Unknown
`meta_`

enrollment_dates_override

Column	Type	Keys
`id`	Unknown	PK
`enrollment_term_id`	Unknown	FK
`context_id`	Unknown
`context_type`	Unknown
`created_at`	Unknown
`end_at`	Unknown
`enrollment_type`	Unknown
`start_at`	Unknown
`updated_at`	Unknown
`meta_`

grading_period_group

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`course_id`	Unknown	FK
`created_at`	Unknown
`display_totals_for_all_grading_periods`	Unknown
`title`	Unknown
`updated_at`	Unknown
`weighted`	Unknown
`workflow_state`	Unknown
`meta_`

attachment

Column	Type	Keys
`id`	Unknown	PK
`folder_id`	Unknown	FK
`replacement_attachment_id`	Unknown	FK
`root_attachment_id`	Unknown	FK
`user_id`	Unknown	FK
`content_type`	Unknown
`context_id`	Unknown
`context_type`	Unknown
`could_be_locked`	Unknown
`created_at`	Unknown
`deleted_at`	Unknown
`display_name`	Unknown
`file_state`	Unknown
`filename`	Unknown
`lock_at`	Unknown
`locked`	Unknown
`md_5`	Unknown
`media_entry_id`	Unknown
`migration_id`	Unknown
`modified_at`	Unknown
`namespace`	Unknown
`size`	Unknown
`unlock_at`	Unknown
`updated_at`	Unknown
`usage_rights_id`	Unknown
`uuid`	Unknown
`viewed_at`	Unknown
`workflow_state`	Unknown
`meta_`

quiz_group

Column	Type	Keys
`id`	Unknown	PK
`assessment_question_bank_id`	Unknown	FK
`quiz_id`	Unknown	FK
`created_at`	Unknown
`migration_id`	Unknown
`name`	Unknown
`pick_count`	Unknown
`position`	Unknown
`question_points`	Unknown
`updated_at`	Unknown
`meta_`

master_courses_master_migration

Column	Type	Keys
`id`	Unknown	PK
`master_template_id`	Unknown	FK
`user_id`	Unknown	FK
`comment`	Unknown
`created_at`	Unknown
`export_results`	Json
`exports_started_at`	Unknown
`imports_completed_at`	Unknown
`imports_queued_at`	Unknown
`migration_settings`	Json
`send_notification`	Unknown
`updated_at`	Unknown
`workflow_state`	Unknown
`meta_`

course_section

Column	Type	Keys
`id`	Unknown	PK
`course_id`	Unknown	FK
`enrollment_term_id`	Unknown	FK
`nonxlist_course_id`	Unknown	FK
`accepting_enrollments`	Unknown
`created_at`	Unknown
`default_section`	Unknown
`end_at`	Unknown
`integration_id`	Unknown
`name`	Unknown
`restrict_enrollments_to_section_dates`	Unknown
`sis_batch_id`	Unknown
`sis_source_id`	Unknown
`start_at`	Unknown
`updated_at`	Unknown
`workflow_state`	Unknown
`meta_`

course

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`enrollment_term_id`	Unknown	FK
`grading_standard_id`	Unknown	FK
`homeroom_course_id`	Unknown	FK
`replacement_course_id`	Unknown	FK
`template_course_id`	Unknown	FK
`abstract_course_id`	Unknown
`allow_student_organized_groups`	Unknown
`allow_student_wiki_edits`	Unknown
`conclude_at`	Unknown
`course_code`	Unknown
`created_at`	Unknown
`default_view`	Unknown
`default_wiki_editing_roles`	Unknown
`grade_passback_setting`	Unknown
`group_weighting_scheme`	Unknown
`home_page_announcement_limit`	Unknown
`homeroom_course`	Unknown
`indexed`	Unknown
`integration_id`	Unknown
`is_public`	Unknown
`latest_outcome_import_id`	Unknown
`license`	Unknown
`locale`	Unknown
`lti_context_id`	Unknown
`name`	Unknown
`open_enrollment`	Unknown
`public_description`	Unknown
`restrict_enrollments_to_course_dates`	Unknown
`self_enrollment`	Unknown
`self_enrollment_code`	Unknown
`self_enrollment_limit`	Unknown
`settings_allow_student_discussion_editing`	Unknown
`settings_allow_student_discussion_topics`	Unknown
`settings_allow_student_forum_attachments`	Unknown
`settings_filter_speed_grader_by_student_group`	Unknown
`settings_hide_distribution_graphs`	Unknown
`settings_hide_final_grade`	Unknown
`settings_is_public_to_auth_users`	Unknown
`settings_lock_all_announcements`	Unknown
`settings_restrict_student_future_view`	Unknown
`settings_restrict_student_past_view`	Unknown
`settings_usage_rights_required`	Unknown
`show_announcements_on_home_page`	Unknown
`sis_batch_id`	Unknown
`sis_source_id`	Unknown
`start_at`	Unknown
`storage_quota`	Unknown
`syllabus_body`	Unknown
`sync_enrollments_from_homeroom`	Unknown
`tab_configuration`	Unknown
`template`	Unknown
`time_zone`	Unknown
`turnitin_comments`	Unknown
`turnitin_id`	Unknown
`updated_at`	Unknown
`uuid`	Unknown
`wiki_id`	Unknown
`workflow_state`	Unknown
`meta_`

content_migration

Column	Type	Keys
`id`	Unknown	PK
`attachment_id`	Unknown	FK
`child_subscription_id`	Unknown	FK
`exported_attachment_id`	Unknown	FK
`overview_attachment_id`	Unknown	FK
`source_course_id`	Unknown	FK
`user_id`	Unknown	FK
`context_id`	Unknown
`context_type`	Unknown
`created_at`	Unknown
`finished_at`	Unknown
`migration_settings`	Unknown
`migration_type`	Unknown
`progress`	Unknown
`started_at`	Unknown
`updated_at`	Unknown
`workflow_state`	Unknown
`meta_`

discussion_topic

Column	Type	Keys
`id`	Unknown	PK
`assignment_id`	Unknown	FK
`attachment_id`	Unknown	FK
`editor_id`	Unknown	FK
`group_category_id`	Unknown	FK
`old_assignment_id`	Unknown	FK
`root_topic_id`	Unknown	FK
`user_id`	Unknown	FK
`allow_rating`	Unknown
`cloned_item_id`	Unknown
`context_id`	Unknown
`context_type`	Unknown
`created_at`	Unknown
`delayed_post_at`	Unknown
`deleted_at`	Unknown
`discussion_type`	Unknown
`external_feed_id`	Unknown
`is_section_specific`	Unknown
`last_reply_at`	Unknown
`lock_at`	Unknown
`locked`	Unknown
`message`	Unknown
`migration_id`	Unknown
`only_graders_can_rate`	Unknown
`pinned`	Unknown
`podcast_enabled`	Unknown
`podcast_has_student_posts`	Unknown
`position`	Unknown
`posted_at`	Unknown
`require_initial_post`	Unknown
`sort_by_rating`	Unknown
`subtopics_refreshed_at`	Unknown
`title`	Unknown
`todo_date`	Unknown
`type`	Unknown
`updated_at`	Unknown
`workflow_state`	Unknown
`meta_`

quiz

Column	Type	Keys
`id`	Unknown	PK
`assignment_group_id`	Unknown	FK
`assignment_id`	Unknown	FK
`access_code`	Unknown
`allowed_attempts`	Unknown
`anonymous_submissions`	Unknown
`cant_go_back`	Unknown
`context_id`	Unknown
`context_type`	Unknown
`could_be_locked`	Unknown
`created_at`	Unknown
`deleted_at`	Unknown
`description`	Unknown
`due_at`	Unknown
`hide_correct_answers_at`	Unknown
`hide_results`	Unknown
`ip_filter`	Unknown
`lock_at`	Unknown
`migration_id`	Unknown
`one_question_at_a_time`	Unknown
`one_time_results`	Unknown
`only_visible_to_overrides`	Unknown
`points_possible`	Unknown
`published_at`	Unknown
`question_count`	Unknown
`quiz_type`	Unknown
`require_lockdown_browser`	Unknown
`require_lockdown_browser_for_results`	Unknown
`require_lockdown_browser_monitor`	Unknown
`scoring_policy`	Unknown
`show_correct_answers`	Unknown
`show_correct_answers_at`	Unknown
`show_correct_answers_last_attempt`	Unknown
`shuffle_answers`	Unknown
`time_limit`	Unknown
`title`	Unknown
`unlock_at`	Unknown
`unpublished_question_count`	Unknown
`updated_at`	Unknown
`workflow_state`	Unknown
`meta_`

lti_line_item

Column	Type	Keys
`id`	Unknown	PK
`assignment_id`	Unknown	FK
`lti_resource_link_id`	Unknown	FK
`client_id`	Unknown
`coupled`	Unknown
`created_at`	Unknown
`extensions`	Unknown
`label`	Unknown
`resource_id`	Unknown
`score_maximum`	Unknown
`tags`	Unknown
`updated_at`	Unknown
`workflow_state`	Unknown
`meta_`

learning_outcome

Column	Type	Keys
`id`	Unknown	PK
`calculation_int`	Unknown
`calculation_method`	Unknown
`context_code`	Unknown
`context_id`	Unknown
`context_type`	Unknown
`created_at`	Unknown
`data`	Unknown
`description`	Unknown
`display_name`	Unknown
`migration_id`	Unknown
`outcome_import_id`	Unknown
`short_description`	Unknown
`updated_at`	Unknown
`vendor_guid`	Unknown
`workflow_state`	Unknown
`meta_`

assignment_submission

Column	Type	Keys
`index`	Unknown	PK
`assignment_id`	Unknown	PKFK
`submission_type`	Unknown

assignment

Column	Type	Keys
`id`	Unknown	PK
`assignment_group_id`	Unknown	FK
`duplicate_of_id`	Unknown	FK
`final_grader_id`	Unknown	FK
`grader_section_id`	Unknown	FK
`grading_standard_id`	Unknown	FK
`group_category_id`	Unknown	FK
`all_day`	Unknown
`all_day_date`	Unknown
`allowed_attempts`	Unknown
`allowed_extensions`	Unknown
`annotatable_attachment_id`	Unknown
`anonymous_grading`	Unknown
`anonymous_instructor_annotations`	Unknown
`anonymous_peer_reviews`	Unknown
`automatic_peer_reviews`	Unknown
`context_id`	Unknown
`context_type`	Unknown
`could_be_locked`	Unknown
`created_at`	Unknown
`description`	Unknown
`due_at`	Unknown
`freeze_on_copy`	Unknown
`grade_group_students_individually`	Unknown
`grader_comments_visible_to_graders`	Unknown
`grader_count`	Unknown
`grader_names_visible_to_final_grader`	Unknown
`graders_anonymous_to_graders`	Unknown
`grades_published_at`	Unknown
`grading_type`	Unknown
`important_dates`	Unknown
`intra_group_peer_reviews`	Unknown
`lock_at`	Unknown
`lti_context_id`	Unknown
`migration_id`	Unknown
`moderated_grading`	Unknown
`omit_from_final_grade`	Unknown
`only_visible_to_overrides`	Unknown
`peer_review_count`	Unknown
`peer_reviews`	Unknown
`peer_reviews_assigned`	Unknown
`peer_reviews_due_at`	Unknown
`points_possible`	Unknown
`position`	Unknown
`post_to_sis`	Unknown
`sis_source_id`	Unknown
`submission_downloads`	Unknown
`title`	Unknown
`turnitin_enabled`	Unknown
`turnitin_settings`	Unknown
`unlock_at`	Unknown
`updated_at`	Unknown
`vericite_enabled`	Unknown
`workflow_state`	Unknown
`meta_`

web_conference_participant

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	FK
`web_conference_id`	Unknown	FK
`created_at`	Unknown
`participation_type`	Unknown
`updated_at`	Unknown
`meta_`

groups

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`group_category_id`	Unknown	FK
`leader_id`	Unknown	FK
`avatar_attachment_id`	Unknown
`context_id`	Unknown
`context_type`	Unknown
`created_at`	Unknown
`default_view`	Unknown
`deleted_at`	Unknown
`description`	Unknown
`is_public`	Unknown
`join_level`	Unknown
`lti_context_id`	Unknown
`max_membership`	Unknown
`migration_id`	Unknown
`name`	Unknown
`sis_batch_id`	Unknown
`sis_source_id`	Unknown
`storage_quota`	Unknown
`updated_at`	Unknown
`uuid`	Unknown
`wiki_id`	Unknown
`workflow_state`	Unknown
`meta_`

master_courses_child_subscription

Column	Type	Keys
`id`	Unknown	PK
`child_course_id`	Unknown	FK
`master_template_id`	Unknown	FK
`created_at`	Unknown
`updated_at`	Unknown
`use_selective_copy`	Unknown
`workflow_state`	Unknown
`meta_`

content_participation

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	FK
`content_id`	Unknown
`content_type`	Unknown
`workflow_state`	Unknown
`meta_`

late_policy

Column	Type	Keys
`id`	Unknown	PK
`course_id`	Unknown	FK
`created_at`	Unknown
`late_submission_deduction`	Unknown
`late_submission_deduction_enabled`	Unknown
`late_submission_interval`	Unknown
`late_submission_minimum_percent`	Unknown
`late_submission_minimum_percent_enabled`	Unknown
`missing_submission_deduction`	Unknown
`missing_submission_deduction_enabled`	Unknown
`updated_at`	Unknown
`meta_`

web_conference

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	FK
`conference_key`	Unknown
`conference_type`	Unknown
`context_code`	Unknown
`context_id`	Unknown
`context_type`	Unknown
`created_at`	Unknown
`description`	Unknown
`duration`	Unknown
`end_at`	Unknown
`ended_at`	Unknown
`recording_ready`	Unknown
`settings`	Json
`start_at`	Unknown
`started_at`	Unknown
`title`	Unknown
`updated_at`	Unknown
`user_ids`	Json
`uuid`	Unknown
`meta_`

enrollment

Column	Type	Keys
`id`	Unknown	PK
`course_id`	Unknown	FK
`course_section_id`	Unknown	FK
`user_id`	Unknown	FK
`associated_user_id`	Unknown
`completed_at`	Unknown
`created_at`	Unknown
`end_at`	Unknown
`grade_publishing_status`	Unknown
`last_activity_at`	Unknown
`last_attended_at`	Unknown
`limit_privileges_to_course_section`	Unknown
`role_id`	Unknown
`self_enrolled`	Unknown
`sis_batch_id`	Unknown
`sis_pseudonym_id`	Unknown
`start_at`	Unknown
`total_activity_time`	Unknown
`type`	Unknown
`updated_at`	Unknown
`workflow_state`	Unknown
`meta_`

content_shares

Column	Type	Keys
`id`	Unknown	PK
`sender_id`	Unknown	FK
`user_id`	Unknown	FK
`content_export_id`	Unknown
`created_at`	Unknown
`name`	Unknown
`read_state`	Unknown
`type`	Unknown
`updated_at`	Unknown
`meta_`

collaboration

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	FK
`collaboration_type`	Unknown
`context_code`	Unknown
`context_id`	Unknown
`context_type`	Unknown
`created_at`	Unknown
`data`	Unknown
`deleted_at`	Unknown
`description`	Unknown
`document_id`	Unknown
`resource_link_lookup_uuid`	Unknown
`title`	Unknown
`type`	Unknown
`updated_at`	Unknown
`url`	Unknown
`uuid`	Unknown
`workflow_state`	Unknown
`meta_`

learning_outcome_question_result

Column	Type	Keys
`id`	Unknown	PK
`learning_outcome_id`	Unknown	FK
`learning_outcome_result_id`	Unknown	FK
`assessed_at`	Unknown
`associated_asset_id`	Unknown
`associated_asset_type`	Unknown
`attempt`	Unknown
`created_at`	Unknown
`mastery`	Unknown
`original_mastery`	Unknown
`original_possible`	Unknown
`original_score`	Unknown
`possible`	Unknown
`result_percent`	Unknown
`score`	Unknown
`submitted_at`	Unknown
`title`	Unknown
`updated_at`	Unknown
`meta_`

submission

Column	Type	Keys
`id`	Unknown	PK
`assignment_id`	Unknown	FK
`course_id`	Unknown	FK
`grader_id`	Unknown	FK
`grading_period_id`	Unknown	FK
`group_id`	Unknown	FK
`quiz_submission_id`	Unknown	FK
`user_id`	Unknown	FK
`anonymous_id`	Unknown
`attachment_ids`	Json
`attempt`	Unknown
`body`	Unknown
`cached_due_date`	Unknown
`cached_quiz_lti`	Unknown
`cached_tardiness`	Unknown
`created_at`	Unknown
`excused`	Unknown
`extra_attempts`	Unknown
`grade`	Unknown
`grade_matches_current_submission`	Unknown
`graded_anonymously`	Unknown
`graded_at`	Unknown
`last_comment_at`	Unknown
`late_policy_status`	Unknown
`lti_user_id`	Unknown
`media_comment_id`	Unknown
`media_comment_type`	Unknown
`media_object_id`	Unknown
`points_deducted`	Unknown
`posted_at`	Unknown
`processed`	Unknown
`published_grade`	Unknown
`published_score`	Unknown
`redo_request`	Unknown
`resource_link_lookup_uuid`	Unknown
`score`	Unknown
`seconds_late_override`	Unknown
`student_entered_score`	Unknown
`submission_comments_count`	Unknown
`submission_type`	Unknown
`submitted_at`	Unknown
`turnitin_data`	Unknown
`updated_at`	Unknown
`url`	Unknown
`workflow_state`	Unknown
`meta_`

context_external_tool

Column	Type	Keys
`id`	Unknown	PK
`allow_membership_service_access`	Unknown
`app_center_id`	Unknown
`cloned_item_id`	Unknown
`consumer_key`	Unknown
`context_id`	Unknown
`context_type`	Unknown
`created_at`	Unknown
`description`	Unknown
`developer_key_id`	Unknown
`domain`	Unknown
`migration_id`	Unknown
`name`	Unknown
`not_selectable`	Unknown
`settings`	Unknown
`tool_id`	Unknown
`unified_tool_id`	Unknown
`updated_at`	Unknown
`url`	Unknown
`workflow_state`	Unknown
`meta_`

comment_bank_item

Column	Type	Keys
`id`	Unknown	PK
`course_id`	Unknown	FK
`user_id`	Unknown	FK
`comment`	Unknown
`created_at`	Unknown
`updated_at`	Unknown
`workflow_state`	Unknown
`meta_`

account

Column	Type	Keys
`id`	Unknown	PK
`parent_account_id`	Unknown	FK
`consortium_parent_account_id`	Unknown
`course_template_id`	Unknown
`created_at`	Unknown
`current_sis_batch_id`	Unknown
`default_group_storage_quota`	Unknown
`default_locale`	Unknown
`default_storage_quota`	Unknown
`default_time_zone`	Unknown
`default_user_storage_quota`	Unknown
`deleted_at`	Unknown
`integration_id`	Unknown
`lti_context_id`	Unknown
`name`	Unknown
`sis_source_id`	Unknown
`storage_quota`	Unknown
`updated_at`	Unknown
`uuid`	Unknown
`workflow_state`	Unknown
`meta_`