# Canvas Data 2 by Instructure schema ERD

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

## 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 | PK, FK |
| 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 | PK, FK |
| 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_** |  |  |

## Relationships

- master_courses_migration_result(child_subscription_id) → master_courses_child_subscription(id)
- master_courses_migration_result(master_migration_id) → master_courses_master_migration(id)
- user_account_association(user_id) → users(id)
- user_account_association(account_id) → account(id)
- content_tag(learning_outcome_id) → learning_outcome(id)
- content_tag(rubric_association_id) → rubric_association(id)
- content_tag(context_module_id) → context_module(id)
- rubric(user_id) → users(id)
- learning_outcome_group(root_learning_outcome_group_id) → learning_outcome_group(id)
- learning_outcome_group(learning_outcome_group_id) → learning_outcome_group(id)
- learning_outcome_result(user_id) → users(id)
- learning_outcome_result(learning_outcome_id) → learning_outcome(id)
- learning_outcome_result(content_tag_id) → assessment_question(id)
- outcome_proficiency_rating(outcome_proficiency_id) → outcome_proficiencies(id)
- discussion_entry_participant(user_id) → users(id)
- discussion_entry_participant(discussion_entry_id) → discussion_entry(id)
- canvadocs_annotation_context(attachment_id) → attachment(id)
- canvadocs_annotation_context(submission_id) → submission(id)
- master_courses_master_content_tag(master_template_id) → master_courses_master_template(id)
- score(grading_period_id) → grading_period(id)
- score(assignment_group_id) → assignment_group(id)
- score(enrollment_id) → enrollment(id)
- rubric_association(rubric_id) → rubric(id)
- account_user(user_id) → users(id)
- account_user(account_id) → account(id)
- account_user(role_id) → roles(id)
- conversation_participant(user_id) → users(id)
- course_account_association(course_id) → course(id)
- course_account_association(account_id) → account(id)
- course_account_association(course_section_id) → course_section(id)
- master_courses_master_template(active_migration_id) → master_courses_master_migration(id)
- master_courses_master_template(course_id) → course(id)
- grading_period(grading_period_group_id) → grading_period_group(id)
- role_override(role_id) → roles(id)
- grading_standard(user_id) → users(id)
- rubric_assessment(user_id) → users(id)
- rubric_assessment(rubric_association_id) → rubric_association(id)
- rubric_assessment(assessor_id) → users(id)
- rubric_assessment(rubric_id) → rubric(id)
- conversation_message_participant(user_id) → users(id)
- conversation_message_participant(conversation_message_id) → conversation_message(id)
- conversation_message_participant(conversation_participant_id) → conversation_participant(id)
- discussion_entry(user_id) → users(id)
- discussion_entry(root_entry_id) → discussion_entry(id)
- discussion_entry(discussion_topic_id) → discussion_topic(id)
- discussion_entry(attachment_id) → attachment(id)
- discussion_entry(parent_id) → discussion_entry(id)
- discussion_entry(editor_id) → users(id)
- quiz_question(quiz_group_id) → quiz_group(id)
- quiz_question(quiz_id) → quiz(id)
- quiz_question(assessment_question_id) → assessment_question(id)
- originality_report(submission_id) → submission(id)
- originality_report(attachment_id) → attachment(id)
- lti_result(user_id) → users(id)
- lti_result(submission_id) → submission(id)
- lti_result(lti_line_item_id) → lti_line_item(id)
- custom_gradebook_column(course_id) → course(id)
- users(merged_into_user_id) → users(id)
- custom_gradebook_column_data(user_id) → users(id)
- custom_gradebook_column_data(custom_gradebook_column_id) → custom_gradebook_column(id)
- group_membership(user_id) → users(id)
- group_membership(group_id) → groups(id)
- folder(parent_folder_id) → folder(id)
- assignment_override_student(user_id) → users(id)
- assignment_override_student(assignment_id) → assignment(id)
- assignment_override_student(quiz_id) → quiz(id)
- assignment_override_student(assignment_override_id) → assignment_override(id)
- context_module_progression(user_id) → users(id)
- context_module_progression(context_module_id) → context_module(id)
- master_courses_child_content_tag(child_subscription_id) → master_courses_child_subscription(id)
- enrollment_term(grading_period_group_id) → grading_period_group(id)
- assessment_question(assessment_question_bank_id) → assessment_question_bank(id)
- post_policy(course_id) → course(id)
- post_policy(assignment_id) → assignment(id)
- attachment_association(attachment_id) → attachment(id)
- submission_comment(author_id) → users(id)
- submission_comment(submission_id) → submission(id)
- favorite(user_id) → users(id)
- wiki_pages(user_id) → users(id)
- wiki_pages(assignment_id) → assignment(id)
- wiki_pages(old_assignment_id) → assignment(id)
- communication_channel(user_id) → users(id)
- communication_channel(pseudonym_id) → pseudonym(id)
- calendar_event(user_id) → users(id)
- calendar_event(web_conference_id) → web_conference(id)
- calendar_event(parent_calendar_event_id) → calendar_event(id)
- lti_resource_link(context_external_tool_id) → context_external_tool(id)
- enrollment_state(enrollment_id) → enrollment(id)
- quiz_submission(user_id) → users(id)
- quiz_submission(quiz_id) → quiz(id)
- quiz_submission(submission_id) → submission(id)
- score_statistics(assignment_id) → assignment(id)
- submission_version(user_id) → users(id)
- submission_version(assignment_id) → assignment(id)
- discussion_topic_participant(user_id) → users(id)
- discussion_topic_participant(discussion_topic_id) → discussion_topic(id)
- content_participation_count(user_id) → users(id)
- roles(account_id) → account(id)
- assignment_override(set_id) → groups(id)
- assignment_override(assignment_id) → assignment(id)
- assignment_override(quiz_id) → quiz(id)
- conversation_message(author_id) → users(id)
- conversation_message(asset_id) → submission(id)
- conversation_message(conversation_id) → conversation(id)
- pseudonym(user_id) → users(id)
- pseudonym(account_id) → account(id)
- enrollment_dates_override(enrollment_term_id) → enrollment_term(id)
- grading_period_group(account_id) → account(id)
- grading_period_group(course_id) → course(id)
- attachment(user_id) → users(id)
- attachment(folder_id) → folder(id)
- attachment(replacement_attachment_id) → attachment(id)
- attachment(root_attachment_id) → attachment(id)
- quiz_group(assessment_question_bank_id) → assessment_question_bank(id)
- quiz_group(quiz_id) → quiz(id)
- master_courses_master_migration(user_id) → users(id)
- master_courses_master_migration(master_template_id) → master_courses_master_template(id)
- course_section(nonxlist_course_id) → course(id)
- course_section(enrollment_term_id) → enrollment_term(id)
- course_section(course_id) → course(id)
- course(homeroom_course_id) → course(id)
- course(grading_standard_id) → grading_standard(id)
- course(enrollment_term_id) → enrollment_term(id)
- course(replacement_course_id) → course(id)
- course(template_course_id) → course(id)
- course(account_id) → account(id)
- content_migration(user_id) → users(id)
- content_migration(source_course_id) → course(id)
- content_migration(exported_attachment_id) → attachment(id)
- content_migration(child_subscription_id) → master_courses_child_subscription(id)
- content_migration(overview_attachment_id) → attachment(id)
- content_migration(attachment_id) → attachment(id)
- discussion_topic(root_topic_id) → discussion_topic(id)
- discussion_topic(user_id) → users(id)
- discussion_topic(assignment_id) → assignment(id)
- discussion_topic(group_category_id) → group_category(id)
- discussion_topic(attachment_id) → attachment(id)
- discussion_topic(editor_id) → users(id)
- discussion_topic(old_assignment_id) → assignment(id)
- quiz(assignment_group_id) → assignment_group(id)
- quiz(assignment_id) → assignment(id)
- lti_line_item(assignment_id) → assignment(id)
- lti_line_item(lti_resource_link_id) → lti_resource_link(id)
- assignment_submission(assignment_id) → assignment(id)
- assignment(final_grader_id) → users(id)
- assignment(assignment_group_id) → assignment_group(id)
- assignment(duplicate_of_id) → assignment(id)
- assignment(grading_standard_id) → grading_standard(id)
- assignment(group_category_id) → group_category(id)
- assignment(grader_section_id) → course_section(id)
- web_conference_participant(web_conference_id) → web_conference(id)
- web_conference_participant(user_id) → users(id)
- groups(group_category_id) → group_category(id)
- groups(leader_id) → users(id)
- groups(account_id) → account(id)
- master_courses_child_subscription(master_template_id) → master_courses_master_template(id)
- master_courses_child_subscription(child_course_id) → course(id)
- content_participation(user_id) → users(id)
- late_policy(course_id) → course(id)
- web_conference(user_id) → users(id)
- enrollment(user_id) → users(id)
- enrollment(course_section_id) → course_section(id)
- enrollment(course_id) → course(id)
- content_shares(user_id) → users(id)
- content_shares(sender_id) → users(id)
- collaboration(user_id) → users(id)
- learning_outcome_question_result(learning_outcome_result_id) → learning_outcome_result(id)
- learning_outcome_question_result(learning_outcome_id) → learning_outcome(id)
- submission(grading_period_id) → grading_period(id)
- submission(grader_id) → users(id)
- submission(user_id) → users(id)
- submission(quiz_submission_id) → quiz_submission(id)
- submission(group_id) → groups(id)
- submission(assignment_id) → assignment(id)
- submission(course_id) → course(id)
- comment_bank_item(user_id) → users(id)
- comment_bank_item(course_id) → course(id)
- account(parent_account_id) → account(id)