Canvas Data Lake Access Request

Classification

Table name

Table Description

admin

access_tokens

Stores the access tokens for a user and developer tools.

admin

account_users

Join table for accounts, users and roles.

registration

accounts

Stores data about account objects in the Canvas system.

course content

assessment_question_banks

Stores data about question banks.

course content

assessment_questions

Stores attributes of a question associated with a quiz.

course content

assignment_groups

Stores rules associated with an assignment group.

course content

assignment_override_students

Stores measures related to ad hoc users for whom an assignment override exists.

course content

assignment_overrides

Stores records for assignment due date overrides.

course content

assignments

This table stores attributes for assignments

course content

attachment_associations

Links user files to an assignment to allow grader to see the student's submission.

course content

attachments

Describes files in Canvas.

course content

calendar_events

The model for calendar events in Canvas

course content

canvadocs_annotation_contexts

Launch context associated with DocViewer when assignment is of type Annotated_Document.

course content

comment_bank_items

Stores user comments that have been added to the comment bank.

admin

communication_channels

Channels through which a user receives Canvas notifications.

course content

content_migrations

Saves data about what and when was added to a course through a course copy or import.

course content

content_participation_counts

Shows students a count of the number of submissions they have that have something unread.

course content

content_participations

Stores data related to students submission updates or feedback.

course content

content_shares

Provides a link to a content export from a sender to a receiver.

course content

content_tags

In the context of LTI, joins context_external_tools to either assignments or to context_modules.

course content

context_external_tools

Stores data about installed LTI 1 and 1.3 tools

course content

context_module_progressions

Shows which items a student has completed, started and not started in a module.

course content

context_modules

Modules in Canvas.

course content/student submission

conversation_message_participants

The participants in a certain message in a Conversation.

course content/student submission

conversation_messages

The messages that belong to a certain Conversation, these are in the Inbox.

course content/student submission

conversation_participants

The participants in a Conversation.

course content/student submission

conversations

Conversation threads from the Canvas Inbox.

registration

course_account_associations

An explicit place to keep track of all the the accounts in the account hierarchy that a course belongs to.

registration

course_sections

Stores attributes for a section of a course.

registration

courses

Stores attributes for a course.

course content

custom_gradebook_column_data

Contains per-user data for the custom columns defined in custom_gradebook_columns.

course content

custom_gradebook_columns

Contains configuration information for custom Gradebook columns defined for specific courses

admin

developer_key_account_bindings

Joins the accounts table to developer_keys.

admin

developer_keys

A table representing a set of credentials used for API access.

student submissions

discussion_entries

Stores attributes for discussion entries.

course content

discussion_entry_participants

Tracks who has read a particular entry.

course content

discussion_topic_participants

Links discussion topics to the users who have posted in them.

course content

discussion_topics

This table stores attributes for discussion topics in Canvas.

registration

enrollment_dates_overrides

Supports allowing certain roles to have access to a term outside of term date boundaries.

registration

enrollment_states

Stores the state of an enrollment.

registration

enrollment_terms

Stores enrollment term records that describe the term or semester associated with courses (e.g. Fall 2013).

registration

enrollments

This table stores user enrollments.

admin

favorites

A record of items that a user has favorited, such as a Course

course content

folders

A collection of files (attachments).

course content

grading_period_groups

Stores attributes for grading period groups, which are a group of grading periods.

course content

grading_periods

Stores attributes for grading period.

course content

grading_standards

Contains data for grading schemes defined for a course or account.

course content

group_categories

A container for a set of groups, since often you want everyone to be in exactly one group in a set.

course content

group_memberships

A join table of users and groups. Like enrollments, but for groups instead of courses

course content

groups

Stores attributes for groups in canvas

course content

late_policies

Contains late/missing policy configurations for courses

course content

learning_outcome_groups

Learning outcome groups organize outcomes hierarchically within a context, such as an account, course or the global context.

course content

learning_outcome_question_results

Attributes for the results of answered questions which have been associated with a learning outcome

course content

learning_outcome_results

Learning outcome results are a student's mastery score on a given outcome.

course content

learning_outcomes

Learning outcomes are measurable statements that express student knowledge or a student skill.

course content

lti_line_items

Represents a line item from the IMS Assignment and Grade service.

course content

lti_resource_links

Joins context_external_tools to other resources in Canvas (assignments for example).

course content

lti_results

Represents a result from the IMS Assignment and Grade service

admin

master_courses_child_content_tags

Links imported course content to the child subscription and keeps track of changes made to content.

admin

master_courses_child_subscriptions

Saves data about which child courses are linked to which master blueprint courses.

admin

master_courses_master_content_tags

Links blueprint course content to the template and keeps track of their locked status.

admin

master_courses_master_migrations

Represents a blueprint course sync event.

admin

master_courses_master_templates

Stores blueprint course specific data and links a course with all other blueprint models.

admin

master_courses_migration_results

Stores results for individual associated courses for a blueprint sync event.

course content

originality_reports

Represents an "originality score" for a submission.

course content

outcome_proficiencies

Outcome proficiencies, or learning mastery proficiency ratings, define a set of ratings, which together create a point scale and a mastery level.

course content

outcome_proficiency_ratings

Outcome proficiency ratings define the individual tiers of outcome proficiencies.

course content

post_policies

Contains post policy configurations for courses and individual assignments.

admin

pseudonyms

This table stores user pseudonyms

course content

quiz_groups

This table stores attributes for quiz group.

course content

quiz_questions

This table stores attributes of a question associated with a quiz.

student submissions

quiz_submissions

Stores attributes for the last submitted quiz

course content

quizzes

Stores attributes for quizzes.

admin

role_overrides

A customization to the default permissions granted by a role.

registration

roles

A user is assigned a role which grants all the permissions associated with that role.

course content

rubric_assessments

Shows the data that a teacher has entered in to a rubric while grading a student

course content

rubric_associations

Links a rubric to an assignment.

course content

rubrics

List of criteria that describe how an assignment should be graded.

course content

score_statistics

This table stores aggregate statistics for scores on individual assignments.

course content

scores

This table stores assignment group and course grades for students enrolled in a course.

course content

submission_comments

This table contains attributes related to the submission comments feature in Canvas.

student submissions

submission_versions

This table stores information describing previous versions of individual submission objects.

student submissions

submissions

This table stores submission records for an assignment.

admin

user_account_associations

Stores data about user and account relationship, how "close" a user is related to an account.

course content

user_notes

Stores the data for the Faculty Journal feature.

registration

users

This table stores attributes for users.

course content

web_conference_participants

Links users to conferences they are invited to join.

course content

web_conferences

Data model for Conferences in Canvas.

course content

wiki_pages

Stores text data that is linked to a wiki and a course.

course content

wikis

Links a course to its wiki pages.