canvas

Tables and types in canvas namespace.

Tables in canvas namespace

access_tokens

Stores the access tokens for a user and developer tools.

This table in Canvas Data 2 will only share developer tool specific token metadata. All users have an option to create an access token based on their role and level of data access.

Parameters:

• id (int64) – primary key The unique identifier for an access token record.

• developer_key_id (developer_keys) – The unique identifier of a developer key.

• user_id (users | None) – The unique ID of the user the token acts as.

• real_user_id (users | None) – If the token was created while masquerading, this is the real user doing the masquerading. Used for auditing.

• last_used_at (datetime | None) – Timestamp of last access using this access token.

• expires_at (datetime | None) – The expiration date/time for this token. This may be a NULL value.

• purpose (Annotated[str, MaxLength(255)] | None) – For user-generated tokens, purpose can be manually set. For app-generated tokens, this should be generated based on the scope defined in the authentication process.

• created_at (datetime) – Timestamp of when an access_tokens record was created.

• updated_at (datetime) – Timestamp of when an access_tokens record was updated.

• scopes (json | None) – A list of scopes that can be applied to access tokens. i.e.: courses.

• workflow_state (access_tokens__workflow_state) – The current state of the access token record.

account_users

Join table for accounts, users and roles.

Contains users’ roles within an account (this table includes the account admins).

Parameters:

• id (int64) – primary key The unique identifier for the users account association record.

• user_id (users) – The unique ID of a user.

• created_at (datetime) – Timestamp of when an account_users record was created.

• updated_at (datetime) – Timestamp of when an account_users record was updated.

• workflow_state (account_users__workflow_state) – The current state of the account user record.

• account_id (accounts) – The unique ID of an account.

• role_id (roles) – The unique ID of a role.

accounts

Stores data about account objects in the Canvas system.

Accounts are most often used to represent a hierarchy of colleges, schools, departments, campuses.

Parameters:

• name (Annotated[str, MaxLength(255)] | None) – The display name of the account.

• id (int64) – primary key The ID of the Account object.

• deleted_at (datetime | None) – Timestamp of when the account was deleted. Will only ever be NULL for end customers.

• parent_account_id (accounts | None) – The account’s parent ID, or NULL if this is the root account.

• current_sis_batch_id (int64 | None) – The ID of the currently processing SIS (Student Information System) batch (if submitted via UI, not API).

• storage_quota (int64 | None) – The storage quote for the account, in megabytes.

• default_storage_quota (int64 | None) – The storage quota for children accounts in megabytes, if not otherwise specified.

• default_locale (Annotated[str, MaxLength(255)] | None) – Language for the account.

• default_user_storage_quota (int64 | None) – The default storage quota for users in the account in megabytes, if not otherwise specified.

• default_group_storage_quota (int64 | None) – The storage quota for a group in the account in megabytes, if not otherwise specified.

• integration_id (Annotated[str, MaxLength(255)] | None) – The account’s identifier in the Student Information System.

• lti_context_id (Annotated[str, MaxLength(255)] | None) – UUID of the Canvas context in LTI standard. Secondary ID for this context, could be used in API to identify resource as well.

• consortium_parent_account_id (int64 | None) – The root account of the consortium account, if this root account is part of a consortium.

• course_template_id (int64 | None) – The course selected as a template for new courses created in this account. 0 if a template should not be used, nor inherited.

• created_at (datetime) – Timestamp of when the account was created.

• updated_at (datetime) – Timestamp of when the account was updated.

• workflow_state (accounts__workflow_state) – Life-cycle state for account.

• default_time_zone (Annotated[str, MaxLength(255)] | None) – The default time zone of the account. Allowed time zones are IANA time zones or friendlier Ruby on Rails time zones.

• uuid (Annotated[str, MaxLength(255)] | None) – The UUID of the account.

• sis_source_id (Annotated[str, MaxLength(255)] | None) – Correlated id for the record for this course in the SIS system (assuming SIS integration is configured)

assessment_question_banks

Stores data about question banks.

Question Banks are a place to house questions that can be added to quizzes across courses or accounts.

Parameters:

• id (int64) – primary key The unique identifier for the question bank.

• deleted_at (datetime | None) – The time the question bank was deleted. If the question bank has not been deleted the value will be NULL.

• created_at (datetime) – The time the question bank was created.

• updated_at (datetime) – The time the question bank was last updated.

• workflow_state (assessment_question_banks__workflow_state) – Life-cycle state for the question bank.

• context_id (accounts | courses | None) – The unique identifier for the question bank’s context (account or course).

• context_type (assessment_question_banks__context_type) – The type of context the question bank is associated with.

• migration_id (Annotated[str, MaxLength(255)] | None) – The unique identifier of the migration that imported this question bank.

• title (bounded_str | None) – The title for the question bank.

assessment_questions

Stores attributes of a question associated with a quiz.

The column question_data stores a variety of question data related points such as: : * question_type denotes the type of the question. Possible values are: : - calculated_question - essay_question - file_upload_question - fill_in_multiple_blanks_question - matching_question - multiple_answers_question - multiple_choice_question - multiple_dropdowns_question - numerical_question, - short_answer_question - text_only_question - true_false_question

• question_text is the text of the question.

• regrade_option denotes if regrading is available for the question. Possible values are: available and unavailable for question types multiple_answers_question, multiple_choice_question, true_false_question, and NULL for others. Defaults to available for the allowed question types, and NULL for the rest.

• correct_comments are comments to be displayed if the student answers the question correctly.

• incorrect_comments are comments to be displayed if the student answers the question incorrectly.

• neutral_comments are comments to be displayed regardless of how the student answers the question.

• answers is a JSON array of all possible answers.

Parameters:

• name (bounded_str | None) – Name of the question.

• id (int64) – primary key The unique identifier for the Assessment Question.

• deleted_at (datetime | None) – The time the question was deleted. If the question has not been deleted the value will be NULL.

• created_at (datetime | None) – Time when the quiz question was created.

• updated_at (datetime | None) – Time when the quiz question was last updated.

• workflow_state (assessment_questions__workflow_state | None) – Life-cycle state for the quiz question.

• context_id (int64 | None) – The unique identifier for the question bank’s context (account or course). No longer used as Canvas delegates to context_id of the associated AssessmentQuestion.

• context_type (Annotated[str, MaxLength(255)] | None) – The type of context the question bank is associated with. No longer used as Canvas delegates to the context of the associated AssessmentQuestion.

• question_data (json | None) – A variety of question data related points.

• assessment_question_bank_id (assessment_question_banks | None) – The unique identifier for the assessment question bank this question is associated with.

• migration_id (Annotated[str, MaxLength(255)] | None) – The unique identifier of the migration that imported this assessment question.

• position (int32 | None) – The position of the question.

assignment_groups

Stores rules associated with an assignment group.

Parameters:

• name (Annotated[str, MaxLength(255)] | None) – The name of the assignment group.

• id (int64) – primary key The ID of the assignment group.

• created_at (datetime) – The time when the assignment group was created.

• updated_at (datetime) – The time when the assignment group was updated.

• workflow_state (assignment_groups__workflow_state) – Life-cycle state for the assignment group.

• context_id (courses) – The unique identifier for the assignments group context (course).

• context_type (assignment_groups__context_type) – The type of object represented by context_id.

• default_assignment_name (Annotated[str, MaxLength(255)] | None) – The default title for an assignment when it is created in this assignment group.

• group_weight (float64 | None) – The weight of the assignment group.

• migration_id (Annotated[str, MaxLength(255)] | None) – The unique identifier of the migration that imported this assignment group.

• sis_source_id (Annotated[str, MaxLength(255)] | None) – The Student Information System source ID of the assignment group.

• position (int32 | None) – The position of the assignment group.

• rules (Annotated[assignment_groups__rules, YamlStringToJsonObject()] | None) – Assignment group rules.

assignment_override_students

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

Parameters:

• id (int64) – primary key The ID of the Assignment Override Student.

• user_id (users) – Identifies the user.

• created_at (datetime) – Timestamp of when the assignment_override_student record was created.

• updated_at (datetime) – Timestamp of when the assignment_override_student was last updated.

• workflow_state (assignment_override_students__workflow_state) – Life-cycle state for assignment override students record.

• assignment_id (assignments | None) – Identifies the assignment the override is associated with.

• quiz_id (quizzes | None) – Identifies the quiz the override is associated with.

• assignment_override_id (assignment_overrides) – Identifies the assignment override dimension.

assignment_overrides

Stores records for assignment due date overrides.

There may be many records in this table for each assignment. Use the data in this table to calculate actual due, all day, lock and unlock dates/times.

Parameters:

• id (int64) – primary key The ID of the assignment_override.

• created_at (datetime) – Timestamp of when the assignment_override was created.

• updated_at (datetime) – Timestamp of when the assignment_override was last updated.

• workflow_state (assignment_overrides__workflow_state) – Gives the workflow state of this record.

• due_at (datetime | None) – The new due at date-time for this group of users.

• unlock_at (datetime | None) – The new unlock at date-time for this group of users.

• lock_at (datetime | None) – The new lock at date-time for this group of users.

• all_day (bool | None) – Indicates if the all_day field overrides the original all_day field in the table assignment for this group of users.

• assignment_version (int32 | None) – The version of the assignment this override is applied to.

• set_type (assignment_overrides__set_type) – Used in conjunction with set_id, this field tells us what type of foreign relation is used.

• set_id (groups | course_sections | None) – The primary key for the object type described in set_id.

• due_at_overridden (bool) – Indicates if the unlock_at field overrides the original.

• unlock_at_overridden (bool) – Indicates if the unlock_at field overrides the original unlock_at field in the table assignment for this group of users.

• lock_at_overridden (bool) – Indicates if the lock_at field overrides the original lock_at field in the table assignment for this group of users.

• quiz_id (quizzes | None) – Identifies the quiz the override is associated with.

• quiz_version (int32 | None) – The version of the quiz this override is applied to.

• assignment_id (assignments | None) – Identifies the assignment the override is associated with.

• all_day_date (date | None) – The new date version of the due date if the all_day flag is true.

• title (Annotated[str, MaxLength(255)]) – The title for this assignment_override.

assignments

This table stores attributes for assignments.

There is one record in this table for each assignment.

Parameters:

• integration_id (Annotated[str, MaxLength(255)] | None) – Third Party unique identifier for Assignments.

• lti_context_id (bounded_str | None) – UUID of the Canvas context in LTI standard. Secondary ID for this context, could be used in API to identify resource as well.

• created_at (datetime | None) – The time at which this assignment was originally created.

• updated_at (datetime | None) – The time at which this assignment was last modified.

• workflow_state (assignments__workflow_state) – Current workflow state of the assignment.

• due_at (datetime | None) – The due date for the assignment. Returns NULL if not present.

• unlock_at (datetime | None) – The unlock date, meaning that the assignment is unlocked after this date. Returns NULL if not present.

• lock_at (datetime | None) – The lock date, meaning that the assignment is locked after this date. Returns NULL if not present.

• points_possible (float64 | None) – The maximum points possible for the assignment.

• grading_type (assignments__grading_type | None) – The type of grading the assignment receives.

• submission_types (Annotated[List[assignments__submission_types], SpecialConversion()]) – The types of submissions allowed for this assignment.

• assignment_group_id (assignment_groups | None) – Identifies which assignment grouping the particular assignment is part of (assignment groups may have a scoring weight to determine how much of the assignment group contributes to the total grade).

• grading_standard_id (grading_standards | None) – The ID of the grading standard being applied to this assignment. Valid if grading_type is letter_grade or gpa_scale.

• submissions_downloads (int32) – Number of times submissions have been downloaded in a zip bundle.

• peer_review_count (int32) – Represents the amount of reviews each user is assigned. NOTE: This key is NOT present unless you have automatic_peer_reviews set to true.

• peer_reviews_due_at (datetime | None) – Timestamp for when peer reviews should be completed.

• peer_reviews_assigned (bool) – True if all peer reviews have been assigned.

• peer_reviews (bool) – Indicates if peer reviews are required for this assignment.

• context_id (courses) – The ID of the object this assignment belongs to. Typically course.

• context_type (assignments__context_type) – The type of object this assignment belongs to.

• automatic_peer_reviews (bool) – Indicates if peer reviews are assigned automatically. If false, the teacher is expected to manually assign peer reviews.

• all_day (bool) – True if a specific time for when the assignment is due was not given. The effective due time will be 11:59pm.

• all_day_date (date | None) – The date version of the due date if the all_day flag is true.

• could_be_locked (bool) – True if the assignment is under a module that can be locked.

• migration_id (Annotated[str, MaxLength(255)] | None) – The unique identifier of the migration that imported this assignment. For assignments which have been imported via a content migration, an opaque identifier for the assignment in its source. This field is used by Canvas to identify when an assignment is being re-imported, and can also be used to identify multiple assignments that have been copied from the same source.

• grade_group_students_individually (bool) – If this is a group assignment, boolean flag indicating whether or not students will be graded individually.

• anonymous_peer_reviews (bool) – If true, hide the identities of peer-reviewing and peer-reviewed students. Only relevant if peer_reviews is true.

• turnitin_enabled (bool) – Flag indicating whether or not Turnitin has been enabled for the assignment. NOTE: This flag will not appear unless your account has the Turnitin plugin available.

• allowed_extensions (Annotated[str, MaxLength(255)] | None) – Allowed file extensions, which take effect if submission_types includes online_upload.

• group_category_id (group_categories | None) – The ID of the assignment’s group set, if this is a group assignment. For group discussions, set group_category_id on the discussion topic, not the linked assignment.

• freeze_on_copy (bool) – Indicates if assignment will be frozen when it is copied. NOTE: This field will only be present if the AssignmentFreezer plugin is available for your account.

• only_visible_to_overrides (bool) – Indicates whether the assignment is only visible to overrides.

• post_to_sis (bool) – Present if Sync Grades to Student Information System feature is enabled.

• moderated_grading (bool) – Indicates if the assignment is moderated.

• grades_published_at (datetime | None) – For assignments with moderated grading, a timestamp identifying when provisional grades were published.

• omit_from_final_grade (bool) – If true, the assignment will be omitted from the student’s final grade.

• intra_group_peer_reviews (bool) – Indicates whether or not members from within the same group on a group assignment can be assigned to peer review their own group’s work.

• vericite_enabled (bool) – Flag indicating whether or not VeriCite has been enabled for the assignment. NOTE: This flag will not appear unless your account has the VeriCite plugin available.

• anonymous_instructor_annotations (bool) – Flag indicating whether instructor annotations in document submissions for this assignment should be anonymous.

• duplicate_of_id (assignments | None) – If the assignment is a duplicate, the ID of the original assignment.

• anonymous_grading (bool) – Indicates if the assignment is graded anonymously. If true, graders cannot see student identities.

• graders_anonymous_to_graders (bool) – Indicates if provisional graders’ identities are hidden from other provisional graders. Only relevant for moderated assignments with grader_comments_visible_to_graders set to true.

• grader_count (int32) – The maximum number of provisional graders who may issue grades for this assignment. Only relevant for moderated assignments. Must be a positive value, and must be set to 1 if the course has fewer than two active instructors. Otherwise, the maximum value is the number of active instructors in the course minus one, or 10 if the course has more than 11 active instructors.

• grader_comments_visible_to_graders (bool) – Indicates if provisional graders’ comments are visible to other provisional graders. Only relevant for moderated assignments.

• grader_section_id (course_sections | None) – Graders for an assignment with anonymous moderated marking are assigned from this section if provided, or all sections otherwise.

• final_grader_id (users | None) – User ID of the final grader.

• grader_names_visible_to_final_grader (bool) – Indicates if provisional grader identities are visible to the final grader. Only relevant for moderated assignments.

• allowed_attempts (int32 | None) – The number of submission attempts a student can make for this assignment. -1 is considered unlimited.

• sis_source_id (bounded_str | None) – ID for the correlated record for the assignment in the Student Information System. It can be NULL.

• annotatable_attachment_id (attachments | None) – For an Annotated Document type assignment, the ID of the annotatable attachment.

• important_dates (bool) – Indicates if the assignment has important dates.

• description (bounded_str | None) – The assignment description in an HTML fragment.

• position (int32 | None) – The sorting order of the assignment in the group.

• id (int64) – primary key Primary key for this record in the Canvas assignments table.

• title (Annotated[str, MaxLength(255)] | None) – Title of the assignment.

• turnitin_settings (Annotated[assignments__turnitin_settings, YamlStringToJsonObject()] | None) – Miscellaneous settings for Turnitin.

• parent_assignment_id (assignments | None) – Parent of assignment.

• type (assignments__type | None) – Type of assignment.

• has_sub_assignments (bool | None) – Indicates if this assignment has sub assignments.

attachment_associations

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

Parameters:

• id (int64) – primary key The unique identifier of an attachment associations record.

• attachment_id (attachments | None) – The unique identifier of an attachment record.

• context_id (conversation_messages | submissions | courses | groups | None) – The unique identifier of the context of this attachment association.

• context_type (attachment_associations__context_type) – The type of the object represented by context_id.

attachments

Describes files in Canvas.

Parameters:

• deleted_at (datetime | None) – Timestamp showing when this record was deleted. If the record has not been deleted the value will be NULL.

• user_id (users | None) – The unique ID of a user.

• created_at (datetime | None) – Timestamp showing when an attachments record was created.

• updated_at (datetime | None) – Timestamp showing when an attachments record was updated.

• workflow_state (attachments__workflow_state | None) – Current workflow state of the attachment.

• unlock_at (datetime | None) – The date-time to unlock the file at.

• lock_at (datetime | None) – The date-time to lock the file at.

• context_id (accounts | assessment_questions | assignments | attachments | content_exports | content_migrations | courses | eportfolios | epub_exports | gradebook_uploads | groups | group_and_membership_importers | submissions | purgatories | folders | outcome_imports | quizzes | quiz_statistics | quiz_submissions | sis_batches | users | None) – The unique identifier of the attachments’s context.

• context_type (attachments__context_type | None) – The type of the object represented by context_id.

• folder_id (folders | None) – The unique identifier of a folder record.

• filename (bounded_str | None) – The name of the actual file.

• locked (bool) – Flag if file is locked or available.

• file_state (attachments__file_state) – Similar to workflow_state but for the file itself.

• media_entry_id (Annotated[str, MaxLength(255)] | None) – The ID of a Kaltura/Notorious media entry associated with the file.

• md5 (Annotated[str, MaxLength(255)] | None) – A hash of the file. Historically this was MD5 in Canvas Data 1 and API but newer records store a SHA512 in this column.

• replacement_attachment_id (attachments | None) – The unique identifier of the attachment that this record replaced.

• usage_rights_id (usage_rights | None) – The unique identifier for the usage_rights record.

• modified_at (datetime | None) – Timestamp showing when an attachment record was updated.

• viewed_at (datetime | None) – Timestamp showing when an attachment record was last viewed.

• could_be_locked (bool | None) – True if the file is in a lockable module item.

• migration_id (Annotated[str, MaxLength(255)] | None) – Only applicable for files which have been imported via a content migration, an opaque identifier for the file in its source. This field is used by Canvas to identify when a file is being re-imported, and can also be used to identify multiple files that have been copied from the same source.

• namespace (Annotated[str, MaxLength(255)] | None) – The asset string of the root account associated with the file’s storage.

• id (int64) – primary key The unique identifier of an attachment record.

• size (int64 | None) – The size of the file in bytes.

• display_name (bounded_str | None) – The attachment name that is displayed.

• content_type (Annotated[str, MaxLength(255)] | None) – MIME type of the associated file.

• uuid (Annotated[str, MaxLength(255)] | None) – The UUID of the attachment.

• root_attachment_id (attachments | None) – Identifier of the source file from which this file was copied and created. Defaults to NULL when this is the only copy.

calendar_events

The model for calendar events in Canvas.

These can be manually created, or automatically generated from other items like Assignments with a date attached.

Parameters:

• deleted_at (datetime | None) – Timestamp when this record was deleted. If the record has not been deleted the value will be NULL.

• user_id (users | None) – The unique ID of a user.

• created_at (datetime) – Timestamp of when a calendar_events record was created.

• updated_at (datetime) – Timestamp of when a calendar_events record was updated.

• workflow_state (calendar_events__workflow_state) – Current state of the event.

• context_id (appointment_groups | courses | course_sections | groups | users) – The unique identifier for the context of this calendar event (account, course, user).

• context_type (calendar_events__context_type) – The type of the object represented by context_id.

• location_address (bounded_str | None) – The address where the event is taking place.

• start_at (datetime | None) – The start date for the calendar event, if applicable.

• end_at (datetime | None) – The end date for the calendar event, if applicable.

• context_code (Annotated[str, MaxLength(255)] | None) – The context code of the calendar this event belongs to (course, user or group).

• time_zone_edited (Annotated[str, MaxLength(255)] | None) – Time zone of the user editing the event.

• parent_calendar_event_id (calendar_events | None) – Normally NULL. If this is a reservation (see the Appointment Groups API), the ID will indicate the time slot it is for. If this is a section-level event, this will be the course-level parent event.

• effective_context_code (Annotated[str, MaxLength(255)] | None) – If specified, it indicates which calendar this event should be displayed on. For example, a section-level event would have the course’s context code here, while the section’s context code would be returned above.

• participants_per_appointment (int32 | None) – If the event is a time slot, this is the participant limit.

• comments (bounded_str | None) – Comments associate with this reservation.

• web_conference_id (web_conferences | None) – The ID of a web conference associated with the calendar event.

• all_day (bool | None) – Indicates whether this is an all-day event (midnight to midnight).

• all_day_date (date | None) – The date of this event.

• migration_id (Annotated[str, MaxLength(255)] | None) – The unique identifier of the migration that imported this calendar event.

• important_dates (bool) – Indicates if the calendar event has important dates.

• location_name (bounded_str | None) – The location name of the event.

• description (bounded_str | None) – The HTML description of the event.

• id (int64) – primary key The unique identifier for a calendar event record.

• title (Annotated[str, MaxLength(255)] | None) – The title of the calendar event.

canvadocs_annotation_contexts

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

Parameters:

• created_at (datetime) – When this record was created.

• updated_at (datetime) – When this record was last updated.

• attachment_id (attachments) – The attachment that this DocViewer launch is owned by.

• submission_id (submissions) – The submission this DocViewer launch is associated with.

• launch_id (bounded_str) – The ID that differentiates a DocViewer launch from another using the same attachment.

• submission_attempt (int32 | None) – The submission attempt associated with the launch_id.

• id (int64) – primary key The ID of this record.

collaborations

This table contains attributes related to collaborations.

• Parameters:

  • id (int64) – primary key The ID of the collaboration.

  • collaboration_type (Annotated[str, MaxLength(255)] | None) – The type of the collaboration.

  • document_id (Annotated[str, MaxLength(255)] | None) – The ID of the document.

  • user_id (users | None) – The ID of the user.

  • context_id (accounts | groups | courses | None) – The ID of the context.

  • context_type (collaboration__context_type | None) – The type of the context.

  • url (Annotated[str, MaxLength(255)] | None) – The URL of the collaboration.

  • uuid (UUID | None) – The UUID of the collaboration.

  • data (json | None) – The data of the collaboration.

  • created_at (datetime) – The date this collaboration was created.

  • updated_at (datetime) – The date this collaboration was updated.

  • description (bounded_str | None) – The description of the collaboration.

  • title (Annotated[str, MaxLength(255)]) – The title of the collaboration.

  • workflow_state (Annotated[str, MaxLength(255)]) – The workflow state of the collaboration.

  • deleted_at (datetime | None) – The date this collaboration was deleted.

  • context_code (Annotated[str, MaxLength(255)] | None) – The context code of the collaboration.

  • type (Annotated[str, MaxLength(255)] | None) – The type of the collaboration.

  • resource_link_lookup_uuid (UUID | None) – The UUID of the resource

comment_bank_items

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

Parameters:

• user_id (users) – The ID of the user who created the comment bank item.

• created_at (datetime) – Timestamp of when the comment_bank_item record was created.

• updated_at (datetime) – Timestamp of when the comment_bank_item record was updated.

• workflow_state (comment_bank_items__workflow_state) – Workflow status of the comment bank item.

• course_id (courses) – Identifies the course.

• id (int64) – primary key The ID of the comment bank item.

• comment (bounded_str) – The text of the comment bank item.

communication_channels

Channels through which a user receives Canvas notifications.

Examples include an email address, a phone number, a mobile device token for push notifications, etc.

Parameters:

• id (int64) – primary key The unique identifier for a user communication channel record.

• path (Annotated[str, MaxLength(255)]) – The address of the communication channel e.g. an email address or a phone number.

• path_type (Annotated[str, MaxLength(255)]) – The type of communication channel being described. This field determines the type of value seen in address.

• pseudonym_id (pseudonyms | None) – The unique ID of a user’s pseudonym record.

• bounce_count (int32) – The number of times a communication channel has bounced when trying to deliver messages.

• confirmation_code_expires_at (datetime | None) – The date-time when the issued confirmation code will expire.

• confirmation_sent_count (int32) – The number of confirmations sent for the channel.

• user_id (users) – The unique ID of a user.

• created_at (datetime) – Timestamp of when a communication_channels record was created.

• updated_at (datetime) – Timestamp of when a communication_channels record was updated.

• workflow_state (communication_channels__workflow_state) – Current state of the communication channel.

• position (int32 | None) – The position of this communication channel relative to the user’s other channels when they are ordered.

content_migrations

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

Parameters:

• id (int64) – primary key The unique identifier of a content migration record.

• attachment_id (attachments | None) – The unique ID of the package being imported.

• user_id (users | None) – The unique ID of a user.

• created_at (datetime) – Timestamp showing when a content_migrations record was created.

• updated_at (datetime) – Timestamp of when a content_migrations record was updated.

• workflow_state (content_migrations__workflow_state) – Current state of the content migration.

• context_id (courses | accounts | groups | users) – The unique identifier of a content_migrations context.

• context_type (content_migrations__context_type) – The type of the object represented by context_id.

• overview_attachment_id (attachments | None) – The unique ID of the packages overview.json file.

• exported_attachment_id (attachments | None) – The unique ID of the resulting exported package.

• source_course_id (courses | None) – The course to copy from for a course copy migration (required if doing course copy).

• migration_type (Annotated[str, MaxLength(255)] | None) – The type of the migration. Use the Migrator endpoint to see all available migrators. Examples include: academic_benchmark_importer, angel_exporter, blackboard_exporter, canvas_cartridge_importer, common_cartridge_importer, course_copy_importer, d2l_exporter, master_course_import, moodle_converter, qti_converter, webct_scraper,`zip_file_importer`, context_external_tool_1234.

• child_subscription_id (master_courses_child_subscriptions | None) – The unique ID of the master_courses_child_subscription record indicating a blueprint association.

• migration_settings (json | None) – Ruby hash of settings that determine what data will get imported for this migration.

• started_at (datetime | None) – Timestamp showing when a content migration started.

• finished_at (datetime | None) – Timestamp showing when a content migration finished.

• progress (float64 | None) – Current migration progress. 100 indicates done at 100%.

content_participation_counts

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

Parameters:

• id (int64) – primary key The unique identifier of a content participation count record.

• user_id (users | None) – The unique ID of a user.

• created_at (datetime) – Timestamp showing when a content_participation_counts record was created.

• updated_at (datetime) – Timestamp showing when a content_participation_counts record was updated.

• context_id (courses | None) – The unique identifier of a content_participation_counts’s context (course).

• context_type (content_participation_counts__context_type) – The type of the object represented by context_id.

• unread_count (int32) – The number of unread actions for this user on this course.

• content_type (content_participation_counts__content_type) – The type of content.

content_participations

Stores data related to students submission updates or feedback.

Examples include new grade, new excused status, or new score.

Parameters:

• id (int64) – primary key The unique identifier of a content participation record.

• user_id (users) – The unique ID of a user.

• workflow_state (content_participations__workflow_state) – Current state of the record.

• content_id (submissions) – The unique identifier of a content record.

• content_type (content_participations__content_type) – The type of the object represented by content_id.

content_shares

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

The receiver can use this link to import the content export into any of their courses.

Parameters:

• name (Annotated[str, MaxLength(255)]) – Name of the content item being shared.

• id (int64) – primary key The unique identifier of a content share.

• type (content_shares__type) – Type of content share.

• user_id (users) – The ID of the user who owns the content share.

• created_at (datetime) – Timestamp showing when a content_share record was created.

• updated_at (datetime) – Timestamp showing when a content_share record was updated.

• content_export_id (content_exports) – The ID of the ContentExport containing the content of the share.

• sender_id (users | None) – The ID of the user who sent the content share. Only populated for ReceivedContentShare.

• read_state (content_shares__read_state) – State of the content shared.

content_tags

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

Some of the ways to use this table would be to: identify the external tool that is used to submit an assignment, identify the items that are in modules (the IDs in this table are also referred to as module_item_id), identify the learning outcome group that an outcome is part of.

Parameters:

• created_at (datetime) – Timestamp of when a content_tags record was created.

• updated_at (datetime) – Timestamp of when a content_tags record was updated.

• workflow_state (content_tags__workflow_state) – The workflow state of the content tag.

• context_id (courses | learning_outcome_groups | assignments | accounts | quizzes | users) – The unique identifier for the content_tags context (account, course, user). Depends on context_type value: Course: courses.id, Assignment: assignments.id.

• context_type (content_tags__context_type) – The type of the object represented by context_id, typically Course or Account or User.

• context_code (Annotated[str, MaxLength(255)] | None) – An asset string describing the content tag context (for example: assignment_3).

• comments (bounded_str | None) – Comments associated with the tag.

• migration_id (Annotated[str, MaxLength(255)] | None) – The ID of the migration that created the content tag.

• content_id (assessment_question_banks | assignments | attachments | context_external_tools | discussion_topics | learning_outcomes | learning_outcome_groups | live_assessments_assessments | lti_message_handlers | quizzes | rubrics | wiki_pages | None) – Refers to the ID of the object that is linked to another object (context_type).

• tag_type (content_tags__tag_type) – Identifies the type of tag.

• context_module_id (context_modules | None) – The ID of the context module the content tag belongs to (if tag_type is context_module).

• learning_outcome_id (learning_outcomes | None) – Has a value if tag_type is learning_outcome, indicates that the content (content_type, content_id) is aligned with the given LearningOutcome.

• mastery_score (float64 | None) – when tag_type is learning_outcome and content_type is AssessmentQuestionBank, indicates the required score on a set of bank questions to show mastery.

• rubric_association_id (int64 | None) – (deprecated) when tag_type is learning_outcome and content_type is Assignment, indicates the RubricAssociation which aligns the LearningOutcome to the Assignment.

• associated_asset_id (learning_outcome_groups | None) – Associated asset, whose use varies by ContentTag use. When tag_type is learning_outcome_association, then content_type is LearningOutcome and associated_asset_type is learning_outcome_group and indicates the LearningOutcome (content_id) is displayed within the LearningOutcomeGroup (associated_asset_id). When content_type is ContextExternalTool and associated_asset_type is Lti::ResourceLink, indicates the resource link associated with an LTI tool link.

• associated_asset_type (content_tags__associated_asset_type | None) – when tag_type is learning_outcome_association, then content_type is LearningOutcome and associated_asset_type is learning_outcome_group and indicates the LearningOutcome (content_id) is displayed within the LearningOutcomeGroup (associated_asset_id).

• link_settings (Annotated[bounded_str, JsonStringToJsonObject()] | None) – Settings for LTI links associated with the content tag (for example, tool iframe width and height).

• new_tab (bool | None) – Whether or not the content should open in a new tab.

• position (int32 | None) – The position of the content tag relative to other content tags when listed in a UI.

• id (int64) – primary key The unique identifier for a content tag record.

• content_type (content_tags__content_type | None) – The type of the tag’s content. Corresponds to the tables that content_id is a foreign key for, the exceptions being: Announcement (for which content_id references the discussion_topics table) and ContextModuleSubheader and ExternalUrl (which have no tables).

• url (bounded_str | None) – The URL of the content where applicable (for example: the launch URL of a context_external_tool). Applicable when content_type is ExternalUrl, ContextExternalTool or Lti::MessageHandler.

• title (bounded_str | None) – The title of the content tag.

context_external_tools

Stores data about installed LTI 1 and 1.3 tools.

Parameters:

• developer_key_id (developer_keys | None) – The client ID of the tool provider. LTI 1.3 only.

• created_at (datetime) – Timestamp when the activation was created.

• updated_at (datetime) – The time at which the tool was last updated.

• workflow_state (context_external_tools__workflow_state) – Workflow state for activation (active, deleted).

• context_id (accounts | courses | None) – The ID of the context the tool is deployed to. Identifies either a course (courses.`id` if context_type is Course) or an account (accounts.`id` if context_type is Account).

• context_type (context_external_tools__context_type | None) – The type of object the tool was activated in.

• migration_id (Annotated[str, MaxLength(255)] | None) – The unique identifier of the migration that imported the tool.

• consumer_key (bounded_str) – A key used by the tool for validation at launch time. This value is set by the Canvas user who installs the tool.

• cloned_item_id (int64 | None) – The Id of the item in which this context_external_tool was cloned from.

• tool_id (Annotated[str, MaxLength(255)] | None) – The tool ID received from the external tool. May be missing if the tool does not send an ID.

• not_selectable (bool | None) – true - tool is selectable in all scenarios. false - not selectable for assignment or module selection menu.

• app_center_id (Annotated[str, MaxLength(255)] | None) – The tool ID from eduappcenter.com.

• allow_membership_service_access (bool) – Indicates that the tool has access to the legacy membership service. LTI 1 only. This setting is set by the Canvas user who installs the tool.

• description (bounded_str | None) – The description of the tool activation as entered by the user.

• name (Annotated[str, MaxLength(255)]) – The name of tool activation as entered by the user.

• id (int64) – primary key Primary key for this record in the context_external_tools table in the Canvas database.

• domain (Annotated[str, MaxLength(255)] | None) – The domain for the tool launch URL (optional field). Canvas uses this domain to lookup the correct tool to launch when the tool ID is unknown.

• url (Annotated[str, MaxLength(4096)] | None) – The URL to where the tool may launch to (if this value is NULL, use the domain field).

• settings (Annotated[context_external_tools__settings, YamlStringToJsonObject()] | None) – LTI application settings, such as placements, links, etc.

context_module_progressions

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

Parameters:

• id (int64) – primary key The unique identifier of a user module progression record.

• user_id (users | None) – The unique ID of a user.

• created_at (datetime) – Timestamp showing when a context_module_progressions record was created.

• updated_at (datetime) – Timestamp showing when a context_module_progressions record was updated.

• workflow_state (context_module_progressions__workflow_state) – The current state of the record.

• requirements_met (json | None) – Object indicating which requirements have been met.

• collapsed (bool | None) – Flag indicating whether modules items are collapsed for user.

• current_position (int32 | None) – For sequential access, this is the current position of the module item (ContentTag).

• completed_at (datetime | None) – Timestamp showing when this user completed this module progression.

• current (bool | None) – Flag indicating that this progression is current and not outdated.

• evaluated_at (datetime | None) – Timestamp showing when this progression was last evaluated for completion, lock, or unlock.

• incomplete_requirements (json | None) – Object that contains incomplete requirements related to min_score.

• context_module_id (context_modules | None) – The unique identifier of a associated context_module.

• lock_version (int32) – Lock version of the module progression.

context_modules

Modules in Canvas.

A place to link items so that students can proceed through course content in order.

Parameters:

• name (bounded_str | None) – The name of the module that shows up in the UI.

• id (int64) – primary key The unique identifier of a module record.

• deleted_at (datetime | None) – Timestamp showing when this record was deleted. If the record has not been deleted, the value will be NULL.

• created_at (datetime) – Timestamp showing when a context_modules record was created.

• updated_at (datetime) – Timestamp showing when a context_modules record was updated.

• workflow_state (context_modules__workflow_state) – Current state of the record.

• unlock_at (datetime | None) – Module can be locked until this date.

• context_id (courses) – The unique identifier for the context of context_modules (courses.`id` if context_type is Course).

• context_type (context_modules__context_type) – The type of the object represented by context_id.

• migration_id (Annotated[str, MaxLength(255)] | None) – An identifier used by the Blueprint system to match with the blueprint content.

• prerequisites (json | None) – An object indicating which module(s) must be completed before accessing this one. Has value if course module has prerequisites; field contains ids (context_modules.id), type and name of prerequisites.

• completion_requirements (json | None) – An object indicating the requirements to complete this module. Contains ids and types (the action required). Requirements can be “must_mark_done” , “must_view”, or “must_contribute”.

• require_sequential_progress (bool | None) – Indicates whether requirements must be completed in sequential order.

• completion_events (bounded_str | None) – Events that can trigger module completion in CSV format: publish_final_grade.

• requirement_count (int32 | None) – The number of requirements to be completed before marking module as complete: can be 1 or NULL for all.

• position (int32 | None) – Where the module should fall in the list of modules.

conversation_message_participants

The participants in a certain message in a Conversation.

Parameters:

• id (int64) – primary key The unique identifier for a conversation recipients record.

• deleted_at (datetime | None) – Timestamp when this record was deleted. If the record has not been deleted the value will be NULL.

• user_id (users | None) – The unique ID of a user.

• workflow_state (conversation_message_participants__workflow_state | None) – The workflow state of the conversation participants.

• conversation_message_id (conversation_messages | None) – Identifies the messages dataset for the associated message.

• conversation_participant_id (conversation_participants | None) – Identifies the conversations dataset for the associated conversation.

• tags (bounded_str | None) – Tags used to identify multiple contexts such as course, group, etc.

conversation_messages

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

Parameters:

• id (int64) – primary key The unique identifier for a conversation message record.

• created_at (datetime | None) – Timestamp of when a conversation_messages record was created.

• context_id (accounts | None) – The unique identifier for the context of conversation_messages (account, course, user).

• context_type (conversation_messages__context_type | None) – The type of the object represented by context_id, typically Course or Account or User.

• conversation_id (conversations | None) – The unique identifier for the conversation.

• author_id (users | None) – User ID of the author of the message.

• generated (bool | None) – This attribute is true if the system generated this message (e.g. “John was added to this conversation”).

• forwarded_message_ids (bounded_str | None) – The IDs of any messages that were created as a forward of the current message.

• media_comment_id (Annotated[str, MaxLength(255)] | None) – Media comment ID of an audio of video file to be associated with this message.

• media_comment_type (conversation_messages__media_comment_type | None) – Type of the associated media file.

• asset_id (submissions | None) – The ID of an attached asset, such as a submission.

• asset_type (conversation_messages__asset_type | None) – The type of an attached asset.

• attachment_ids (bounded_str | None) – Comma-separated list of attachments ids. These must be files that have been previously uploaded to the sender’s “conversation attachments” folder.

• has_attachments (bool | None) – True if the message has attachments.

• has_media_objects (bool | None) – True if the message has media objects.

• body (bounded_str | None) – The HTML content of the message.

conversation_participants

The participants in a Conversation.

Parameters:

• user_id (users) – The unique ID of a user.

• updated_at (datetime | None) – Timestamp of when a conversation_participants record was updated.

• workflow_state (conversation_participants__workflow_state) – The workflow state of the message.

• has_attachments (bool) – If the conversation has attachments.

• has_media_objects (bool) – If the conversation has media objects associated.

• last_message_at (datetime | None) – The timestamp of the latest message.

• subscribed (bool) – Indicates whether the current user is subscribed to the conversation.

• message_count (int32) – The number of messages in the conversation.

• label (Annotated[str, MaxLength(255)] | None) – Any label applied to the conversation, such as starred.

• id (int64) – primary key The unique identifier for a conversation message participants record.

• tags (bounded_str | None) – Tags used to identify multiple contexts such as course, group, etc.

conversations

Conversation threads from the Canvas Inbox.

Parameters:

• id (int64) – primary key The unique identifier for a conversations record. Links to conversation_messages.conversation_id.

• updated_at (datetime | None) – Timestamp of when a conversations record was updated.

• context_id (accounts | courses | groups | None) – The unique identifier for the conversations’s context (account, course, user). ID associated with the context_type.

• context_type (conversations__context_type | None) – The type of the object represented by context_id.

• has_attachments (bool) – If the conversation has attachments.

• has_media_objects (bool) – If the conversation has media objects associated.

• subject (Annotated[str, MaxLength(255)] | None) – The subject line of the conversation.

• tags (bounded_str | None) – Tags used to identify multiple contexts such as course, group, etc. Contains a comma-delimited list of IDs of the course or group if the conversation is associated with a course or group. The format of the values are course_12345 or group_12345.

course_account_associations

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

Parameters:

• id (int64) – primary key The unique identifier for a course account association record.

• course_id (courses) – Identifies the course.

• created_at (datetime) – Timestamp of when the record was created.

• updated_at (datetime) – Timestamp of when the record was updated.

• account_id (accounts) – Identifies the accounts dataset. Points to the account associated with the course. Could be Canvas root account or sub-account ID.

• course_section_id (course_sections | None) – Identifies the course section.

• depth (int32) – How many steps in the account chain are between the courses’ direct account (course.`account_id`) and the account_id of the association.

course_sections

Stores attributes for a section of a course.

Sections are a group of students that have been organized for administrative purposes. When users are enrolled in a course, they are actually enrolled in one of the sections of that course. It is possible to place more than one section in course, but it is not possible to put sections within sections. All sections of a course share the same content. If a course is taught by one instructor, sections can remain under one course. However, if each section is taught by a different instructor, those sections will need to be housed under separate courses. Each section can have its own varied due dates for assignments, quizzes, and discussions. For example, a course may have sections that meet on different days of the week or in different formats (online vs. face-to-face). Sections are also beneficial when Teacher Assistants are assigned to help manage courses and oversee grading for a portion of a course enrollment. As part of SIS or manual enrollments, you can limit students to only see students in their section. Instructors can also limit students if you allow them to manually enroll users in their own courses.

Parameters:

• name (Annotated[str, MaxLength(255)]) – The name of the section.

• id (int64) – primary key The unique identifier for the section.

• course_id (courses) – The unique Canvas identifier for the course in which the section belongs.

• integration_id (Annotated[str, MaxLength(255)] | None) – The integration ID of the section. This field is only included if there is an integration set up between CanvaS and SIS.

• created_at (datetime) – Timestamp for when this section was entered into the system.

• updated_at (datetime) – Timestamp for when the last time the section was updated.

• workflow_state (course_sections__workflow_state) – Life-cycle state for the section.

• sis_batch_id (sis_batches | None) – The unique identifier for the SIS import if created through SIS.

• start_at (datetime | None) – The start date for the section, if applicable. When a user is allowed to participate in a course, enrollment term dates, course dates, and course section dates flow together in all aspects of Canvas. Various dates allow different users to participate in the course. The hierarchy of dates are: course section dates override course dates, course dates override term dates.

• end_at (datetime | None) – The end date for the section, if applicable. When a user is allowed to participate in a course.

• sis_source_id (Annotated[str, MaxLength(255)] | None) – Id for the correlated record for the section in the SIS (assuming SIS integration has been properly configured).

• default_section (bool | None) – True if this is the default section.

• accepting_enrollments (bool | None) – True if this section is open for enrollment.

• restrict_enrollments_to_section_dates (bool | None) – Restrict user enrollments to the start and end dates of the section. True when “Users can only participate in the course between these dates” is checked.

• nonxlist_course_id (courses | None) – The unique identifier of the original course of a cross-listed section.

• enrollment_term_id (enrollment_terms | None) – Identifies the associated enrollment term.

courses

Stores attributes for a course.

Parameters:

• storage_quota (int64 | None) – The total amount of storage space (in bytes) allowed to be used by files in the course.

• integration_id (Annotated[str, MaxLength(255)] | None) – the integration identifier for the course, if defined.

• lti_context_id (Annotated[str, MaxLength(255)] | None) – UUID of the Canvas context in LTI standard. secondary ID for this context, could be used in API to identify resource as well.

• sis_batch_id (int64 | None) – The unique identifier for the SIS import.

• created_at (datetime) – The date the course was created.

• updated_at (datetime) – The time the course was last updated.

• workflow_state (courses__workflow_state) – Life-cycle state for the course.

• account_id (accounts) – Points to the account associated with the course.

• grading_standard_id (grading_standards | None) – The grading standard associated with the course.

• start_at (datetime | None) – The start date for the course, if applicable. If NULL, then use start_at value from enrollment_terms table. Enrollment term dates, course dates, and course section dates flow together in all aspects of Canvas. Various dates allow different users to participate in the course. The hierarchy of dates are: course section dates override course dates, course dates override term dates.

• sis_source_id (Annotated[str, MaxLength(255)] | None) – The SIS identifier for the course, if defined.

• group_weighting_scheme (Annotated[str, MaxLength(255)] | None) – Whether final grades will be weighted based on the group_weight value of assignment groups percent if weighted equal or NULL otherwise.

• conclude_at (datetime | None) – The end date for the course, if applicable. If NULL, then use start_at value from enrollment_terms table.

• is_public (bool | None) – True if the course is publicly visible.

• allow_student_wiki_edits (bool | None) – Whether Pages in the course can be created and are editable by students.

• syllabus_body (bounded_str | None) – User-generated HTML for the course syllabus.

• default_wiki_editing_roles (Annotated[str, MaxLength(255)] | None) – Comma-separated list used as the default editing_roles value for new wiki_pages in the course.

• wiki_id (wikis | None) – Foreign key to the wikis dataset.

• allow_student_organized_groups (bool) – Whether students are able to organize their own groups.

• course_code (Annotated[str, MaxLength(255)] | None) – The course code.

• default_view (Annotated[str, MaxLength(255)] | None) – the type of page that users will see when they first visit the course - feed: Recent Activity Dashboard - wiki: Wiki Front Page - modules: Course Modules/Sections Page - assignments: Course Assignments List - syllabus: Course Syllabus Page other types may be added in the future.

• abstract_course_id (abstract_courses | None) – Foreign key to the abstract_courses table.

• enrollment_term_id (enrollment_terms) – The enrollment term associated with the course.

• open_enrollment (bool | None) – Whether the course has enabled open enrollment.

• tab_configuration (Annotated[bounded_str, JsonStringToJsonObject(), SpecialConversion()] | None) – A JSON serialized list detailing the order and visibility status of tabs in the left-hand navigation for the course.

• turnitin_comments (bounded_str | None) – Comments to be shown to students when submitting a Turnitin-enabled assignment.

• self_enrollment (bool | None) – Whether the course has enabled self enrollment.

• license (Annotated[str, MaxLength(255)] | None) – The default license for content in the course; private: Private (Copyrighted), public_domain: Public Domain, cc_by: CC Attribution, cc_by_sa: CC Attribution Share Alike, cc_by_nc: CC Attribution Noncommercial, cc_by_nc_sa: CC Attribution Noncommercial Share Alike, cc_by_nd: CC Attribution No Derivatives, cc_by_nc_nd: CC Attribution Noncommercial No Derivatives.

• indexed (bool | None) – Whether the course is included in the public course index.

• restrict_enrollments_to_course_dates (bool | None) – Whether the course’s start and end dates will override dates from the term when determining user access.

• template_course_id (courses | None) – If set, this course was originally created via SIS when a section was marked to be cross listed to a non-existent course, using attributes from the original section’s course and setting that course ID here.

• replacement_course_id (courses | None) – The ID of the course created to replace this one when it had its content reset.

• public_description (bounded_str | None) – The public description of the course.

• self_enrollment_code (Annotated[str, MaxLength(255)] | None) – The alpha-numeric code students can use to enroll in the course through self enrollment.

• self_enrollment_limit (int32 | None) – The number of students that can enroll in the course through self enrollment.

• turnitin_id (int64 | None) – A unique identifier for use with Turnitin.

• show_announcements_on_home_page (bool | None) – Whether announcements will be shown on the course home page.

• home_page_announcement_limit (int32 | None) – The maximum number of announcements to show on the course home page.

• latest_outcome_import_id (int64 | None) – The ID of the most recent Outcome Import for the course.

• grade_passback_setting (Annotated[str, MaxLength(255)] | None) – The grade_passback_setting set on the course.

• template (bool) – Course is marked as a template for accounts to use.

• homeroom_course (bool) – Course is marked as a homeroom course.

• sync_enrollments_from_homeroom (bool) – Enrollments for this course will be synced from the associated homeroom.

• homeroom_course_id (courses | None) – Points to the homeroom course from which this course receives its enrollments.

• locale (Annotated[str, MaxLength(255)] | None) – The course-set locale, if applicable.

• name (Annotated[str, MaxLength(255)] | None) – The full name of the course.

• id (int64) – primary key The unique identifier for the course.

• time_zone (Annotated[str, MaxLength(255)] | None) – The course’s IANA time zone name.

• uuid (Annotated[str, MaxLength(255)] | None) – The UUID of the course.

• settings (Annotated[courses__settings, YamlStringToJsonObject()] | None) – Miscellaneous settings for the course.

custom_gradebook_column_data

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

Parameters:

• id (int64) – primary key The unique identifier for a custom gradebook column data record.

• content (Annotated[str, MaxLength(255)]) – The particular value of the specified column for the user denoted by user_id.

• user_id (users) – The unique ID of the user to whom this data record applies.

• custom_gradebook_column_id (custom_gradebook_columns) – The ID of the associated custom column.

custom_gradebook_columns

Contains configuration information for custom Gradebook columns defined for specific courses.

Parameters:

• created_at (datetime) – Timestamp of when a custom_gradebook_columns record was created.

• updated_at (datetime) – Timestamp of when a custom_gradebook_columns record was updated.

• workflow_state (custom_gradebook_columns__workflow_state) – Life-cycle state for the custom gradebook column.

• course_id (courses) – The ID of the course that defines this column.

• teacher_notes (bool) – True if this column represents the predefined Notes column in Gradebook.

• position (int32) – The ordering of this column among the columns defined for this course.

• id (int64) – primary key The unique identifier for a custom Gradebook column data definition.

• read_only (bool) – If true, the contents of this column cannot be edited from Gradebook.

• title (Annotated[str, MaxLength(255)]) – The title of the column, as displayed in Gradebook.

developer_key_account_bindings

Joins the accounts table to developer_keys.

Describes if the associated developer key is “on” or “off” for the associated account.

Parameters:

• account_id (accounts) – Points to the account associated with the course. Could be Canvas root account or sub-account ID.

• created_at (datetime) – Timestamp of when a developer_key_account_bindings record was created.

• updated_at (datetime) – Timestamp of when a developer_key_account_bindings record was updated.

• workflow_state (developer_key_account_bindings__workflow_state) – The workflow state of the binding.

• developer_key_id (developer_keys) – The ID of the associated developer key.

• id (int64) – primary key The unique identifier for a developer key and account association record.

developer_keys

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

Contains both normal API keys and the LTI keys used in LTI 1.3 apps.

Parameters:

• name (Annotated[str, MaxLength(255)] | None) – The name of the developer key.

• id (int64) – primary key The unique identifier for a developer key record.

• user_id (users | None) – The unique ID of a user.

• created_at (datetime) – Timestamp of when a developer_keys record was created.

• updated_at (datetime) – Timestamp of when a developer_keys record was updated.

• scopes (json | None) – The list of scopes the developer key’s access tokens may use.

• workflow_state (developer_keys__workflow_state) – The workflow state of the developer key.

• account_id (accounts | None) – Points to the account associated with the course. Could be Canvas root account or sub-account ID.

• redirect_uri (Annotated[str, MaxLength(255)] | None) – (legacy) The valid redirect URI for the developer key.

• icon_url (Annotated[str, MaxLength(255)] | None) – A URL pointing to the icon of the developer key.

• redirect_uris (List[Annotated[str, MaxLength(255)]]) – The list of valid redirect URIs for the developer key.

• notes (bounded_str | None) – Any notes added to the developer key.

• access_token_count (int32) – The number of times the developer key has been used.

• require_scopes (bool) – Whether or not access token for the developer key are required to be scoped.

• test_cluster_only (bool) – If true, the developer key’s access tokens are only valid on Canvas test and beta instances.

• public_jwk (bounded_str | None) – The public key (in JWK format) for the developer key. Used if the developer key is associated with an LTI 1.3 tool.

• allow_includes (bool) – If true, requests made with this key’s access token can use “includes” parameters to retrieve additional data in each request.

• is_lti_key (bool) – If true, the developer key is intended to be used with LTI 1.3 tools.

• client_credentials_audience (bounded_str | None) – The intended audience of client credentials issued by the developer key. If internal (default), credentials will be verified by Canvas; if external, credentials will be verified by other parties using Canvas’ public key.

• email (Annotated[str, MaxLength(255)] | None) – The email address of the developer key’s owner.

• user_name (Annotated[str, MaxLength(255)] | None) – the login ID of the user who originated developer key.

discussion_entries

Stores attributes for discussion entries.

Discussion entries are replies in a discussion topic.

Parameters:

• message (bounded_str | None) – The content of the entry. Contains html tags.

• id (int64) – primary key The unique identifier for the entry.

• attachment_id (attachments | None) – Representation of the attachment for the entry, if any. Present only if there is an attachment.

• deleted_at (datetime | None) – Timestamp when the discussion entry was deleted.

• user_id (users | None) – The unique identifier for the author of the entry.

• created_at (datetime) – The creation time of the entry.

• updated_at (datetime) – The updated time of the entry, in ISO8601 format.

• workflow_state (discussion_entries__workflow_state) – Life-cycle state for the discussion message.

• migration_id (Annotated[str, MaxLength(255)] | None) – The unique identifier of the migration that imported the entry.

• discussion_topic_id (discussion_topics | None) – The ID of the discussion topic that this entry is part of.

• parent_id (discussion_entries | None) – The parent discussion entry ID of this discussion entry. Has a value if the entry is a reply to another entry.

• editor_id (users | None) – The unique user ID of the person to last edit the entry, if different than user_id.

• root_entry_id (discussion_entries | None) – The root discussion entry ID that this entry is a part of. Has a value if the entry is a reply to another entry.

• depth (int32 | None) – Reply depth for this entry.

• rating_count (int32 | None) – Rating count is the amount of people who have submitted a rating on a given discussion with the only rating being “like”.

• rating_sum (int32 | None) – The rating sum is the sum of the ratings which occurred.

discussion_entry_participants

Tracks who has read a particular entry.

Parameters:

• id (int64) – primary key The Id of the discussion entry participant.

• user_id (users) – The ID of the user who participated in this discussion entry.

• workflow_state (discussion_entry_participants__workflow_state) – Life-cycle state for the entry record, could be “read” if a participant read a discussion.

• forced_read_state (bool | None) – Allows for users to force a discussion entry to be unread.

• discussion_entry_id (discussion_entries) – The ID of the discussion entry that this participant participated in.

• rating (int32 | None) – It is a number of 0 or 1 that indicates the rating providing to the linked entry.

discussion_topic_participants

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

If a user has posted to a discussion topic, there will be a row in this table.

Parameters:

• id (int64) – primary key The unique identifier of a discussion topic participants record.

• user_id (users) – The unique ID of a user.

• workflow_state (discussion_topic_participants__workflow_state) – Current state of the record.

• subscribed (bool | None) – Flag indicating that user is subscribed to discussion and will receive notifications for new comments.

• unread_entry_count (int32) – The count of discussion entries that this user has not yet read.

• discussion_topic_id (discussion_topics) – The unique identifier of a discussion topic record.

discussion_topics

This table stores attributes for discussion topics in Canvas.

Discussion topics are logical discussion threads. They can have many discussion entries. They also have their own message text for the message that started the topic.

Parameters:

• message (bounded_str | None) – The HTML content of the message body.

• id (int64) – primary key The ID of this topic.

• type (discussion_topics__type | None) – Discussion topic type. Two types are default (blank) and Announcement.

• attachment_id (attachments | None) – Has a value if the discussion topic is associated with an attachment (file).

• deleted_at (datetime | None) – Timestamp when the discussion topic was deleted.

• user_id (users | None) – The username of the topic creator.

• created_at (datetime) – The date the discussion topic was made.

• updated_at (datetime) – The date the discussion topic was updated.

• workflow_state (discussion_topics__workflow_state) – Life-cycle state for the discussion topic.

• lock_at (datetime | None) – The datetime to lock the topic (if ever).

• context_id (courses | groups) – The ID of the context that this discussion is used in, e.g. courses.`id` if context_type is Course.

• context_type (discussion_topics__context_type) – The type of context this discussion is used with.

• locked (bool) – Whether or not the discussion is closed for comments.

• assignment_id (assignments | None) – The unique identifier of the assignment if the topic is for grading, otherwise NULL.

• migration_id (Annotated[str, MaxLength(255)] | None) – The unique identifier of the migration that imported this discussion topic.

• group_category_id (group_categories | None) – The unique identifier of the group category if the topic is a group discussion, otherwise NULL.

• cloned_item_id (cloned_items | None) – The ID of the item in which this discussion topic was cloned from.

• last_reply_at (datetime | None) – The datetime for when the last reply was in the topic.

• delayed_post_at (datetime | None) – The datetime to publish the topic (if not right away).

• posted_at (datetime | None) – The datetime the topic was posted. If it is NULL it hasn’t been posted yet.

• root_topic_id (discussion_topics | None) – If the topic is for grading and a group assignment this will point to the original topic in the course.

• old_assignment_id (assignments | None) – the assignment ID after you change a topic from graded to ungraded, then restores the old one if it goes back to graded.

• subtopics_refreshed_at (datetime | None) – The time at which the subtopics for a group category discussion was refreshed at.

• external_feed_id (external_feeds | None) – The ID of the external feed that this discussion topic was created from.

• podcast_enabled (bool) – Boolean to determine if the podcast is enabled.

• podcast_has_student_posts (bool) – If true, the podcast will include posts from students as well. Implies podcast_enabled.

• require_initial_post (bool) – If true then a user may not respond to other replies until that user has made an initial reply.

• editor_id (users | None) – The ID of the editor of the discussion.

• discussion_type (discussion_topics__discussion_type | None) – The type of discussion.

• pinned (bool) – Whether or not the discussion has been pinned by an instructor.

• allow_rating (bool) – Whether or not users can rate entries in this topic.

• only_graders_can_rate (bool) – Whether or not grade permissions are required to rate entries.

• sort_by_rating (bool) – Whether or not entries should be sorted by rating.

• todo_date (datetime | None) – Date in which discussion topic will show up in the student planner feature.

• is_section_specific (bool) – Boolean distinguishing if the topic is a section specific topic or not.

• position (int32 | None) – The position on the discussions index page under pinned items.

• title (Annotated[str, MaxLength(255)] | None) – The topic title.

enrollment_dates_overrides

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

Parameters:

• id (int64) – primary key The unique identifier for an enrollment date override record.

• created_at (datetime) – Timestamp of when a enrollment_dates_overrides record was created.

• updated_at (datetime) – Timestamp of when an enrollment_dates_overrides record was updated.

• context_id (accounts) – The unique ID of main Canvas account, always a root account ID in this table.

• context_type (enrollment_dates_overrides__context_type) – The type of the object represented by context_id.

• start_at (datetime | None) – The start time of the enrollment.

• end_at (datetime | None) – The end datetime for the enrollment date override, if applicable.

• enrollment_term_id (enrollment_terms | None) – The unique identifier for the enrollment term.

• enrollment_type (enrollment_dates_overrides__enrollment_type | None) – The enrollment type. One of StudentEnrollment, TeacherEnrollment, TaEnrollment, DesignerEnrollment, ObserverEnrollment.

enrollment_states

Stores the state of an enrollment.

Parameters:

• updated_at (datetime | None) – Timestamp of when an enrollment_states record was updated.

• state_is_current (bool) – Indicates if the enrollment state is current or needs recalculation.

• state_started_at (datetime | None) – Indicates the date that the enrollment state should take effect.

• state_valid_until (datetime | None) – Indicates the date that the enrollment state becomes stale.

• restricted_access (bool) – Indicates if the enrollment is allowed to view the course.

• access_is_current (bool) – Indicates if the state is within the start and valid until bounds.

• enrollment_id (int64) – primary key The ID of the enrollment.

• state (enrollment_states__state | None) – State of the user enrollment.

enrollment_terms

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

Use the dates in this table as a proxy for the course start/end dates if the start_at and end_at fields in the courses table are NULL.

Parameters:

• name (Annotated[str, MaxLength(255)] | None) – The name of the term.

• id (int64) – primary key The unique identifier for the enrollment term.

• integration_id (Annotated[str, MaxLength(255)] | None) – The ID of the enrollment term in the external tools or SIS, this ID usually gets populated via API or SIS import.

• created_at (datetime) – Timestamp of when the enrollment term was created.

• updated_at (datetime) – Timestamp of when the enrollment term was last updated.

• workflow_state (enrollment_terms__workflow_state) – Life-cycle state for the term.

• sis_batch_id (sis_batches | None) – The unique identifier for the SIS import. This field is only included if the user has permission to manage SIS information.

• start_at (datetime | None) – The datetime of the start of the term. Set up by the administrator. Enrollment term dates, course dates, and course section dates flow together in all aspects of Canvas; various dates allow different users to participate in the course. The hierarchy of dates are: course section dates override course dates, course dates override term dates.

• end_at (datetime | None) – The datetime of the end of the term. Set up by the administrator.

• sis_source_id (Annotated[str, MaxLength(255)] | None) – The SIS ID of the term. Only included if the user has permission to view SIS information.

• term_code (Annotated[str, MaxLength(255)] | None) – Enrollment term code as viewed in the UI.

• grading_period_group_id (grading_period_groups | None) – Identifies the grading period group.

enrollments

This table stores user enrollments.

An enrollment represents a user’s association with a specific course and section. There may be multiple records associated with a course_id and user_id combination (records are unique on: course_id, user_id, course_section_id, role_id, workflow_state, associated_user_id).

Parameters:

• sis_batch_id (sis_batches | None) – The unique identifier for the SIS import. This field is only included if the user has permission to manage SIS information.

• user_id (users) – The unique ID of the user.

• created_at (datetime) – The created time of the enrollment.

• updated_at (datetime) – The updated time of the enrollment.

• workflow_state (enrollments__workflow_state) – Life-cycle state for the user’s enrollment in the course.

• role_id (roles) – The ID of the enrollment role.

• start_at (datetime | None) – The start time of the enrollment, in ISO8601 format.

• end_at (datetime | None) – The end time of the enrollment, in ISO8601 format.

• course_id (courses) – The unique ID of the course.

• completed_at (datetime | None) – Enrollment completed date.

• course_section_id (course_sections) – The Section Integration ID in which the enrollment is associated. This field is only included if the user has permission to view SIS information.

• grade_publishing_status (Annotated[str, MaxLength(255)]) – Used internally with grade passback functionality.

• associated_user_id (users | None) – The unique ID of the associated user. Will be NULL unless type is ObserverEnrollment.

• self_enrolled (bool | None) – Enrollment was created via self-enrollment.

• limit_privileges_to_course_section (bool) – User can only access his or her own course section.

• last_activity_at (datetime | None) – The last activity time of the user for the enrollment. This time stamp updates when a user navigates through the course using the Course Navigation menu, replies to a discussion or submits an assignment or quiz, and when they access course files and pages (does not include mobile interactions or group participation).

• total_activity_time (int32 | None) – The total activity time of the user for the enrollment, in seconds. If user is viewing a page and is enrolled in that particular course, then the time is incremented. Requires at least 2 minutes, but not more than 10 (e.g. if a student just checks their grade or due date and was on the page for less than 2 min, it doesn’t get counted). May not be incremented for page views through mobile app (will get incremented for page views through mobile browser); does not include group activity or page views for videos that do not include intermediate page requests, such as a half-hour recorded lecture.

• sis_pseudonym_id (pseudonyms | None) – If enrolled via SIS import, which pseudonym was referenced to create this enrollment. It is the user ID that was referenced when an enrollment was created via SIS. it’s used for some LTI calls to try and send consistent IDs. also used for splitting accidentally-merged-users to decide which way the enrollments should go.

• last_attended_at (datetime | None) – The last attended date of the user for the enrollment in a course. The UI facing field that could be set by an end user or API call.

• id (int64) – primary key The ID of the enrollment.

• type (enrollments__type) – The base enrollment type.

favorites

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

This affects how items are displayed in places like the Dashboard.

Parameters:

• id (int64) – primary key The unique identifier for a favorite record.

• user_id (users | None) – The unique ID of a user.

• created_at (datetime) – Timestamp of when a favorites record was created.

• updated_at (datetime) – Timestamp of when a favorites record was updated.

• context_id (courses | groups | None) – The unique identifier for the favorites’s context (account, course, user).

• context_type (favorites__context_type) – The type of the object represented by context_id, typically Course or Account or User.

folders

A collection of files (attachments).

Parameters:

• name (Annotated[str, MaxLength(255)] | None) – Name of the folder.

• id (int64) – primary key The unique identifier for a folder record.

• full_name (bounded_str | None) – Full path of the folder.

• deleted_at (datetime | None) – Timestamp when this record was deleted. If the record has not been deleted the value will be NULL.

• created_at (datetime) – Timestamp of when a folders record was created.

• updated_at (datetime) – Timestamp of when a folders record was updated.

• workflow_state (folders__workflow_state) – In this context the workflow state indicates the visibility of the folder.

• unlock_at (datetime | None) – Indicates the date at which this folder should become accessible.

• lock_at (datetime | None) – Indicates the date at which this folder should no longer be accessible.

• context_id (accounts | courses | groups | users) – The unique identifier for the folders’s context (account, course, user).

• context_type (folders__context_type) – The type of the object represented by context_id.

• locked (bool | None) – Indicates if the folder is currently accessible [NULL=false].

• cloned_item_id (cloned_items | None) – Unique identifier of the folder that this folder was cloned from.

• submission_context_code (Annotated[str, MaxLength(255)] | None) – A value indicating the context to which this folder should be submitted if it is for a submission.

• parent_folder_id (folders | None) – Id of the parent folder.

• unique_type (folders__unique_type | None) – Value indicating what kind of files are stored in this folder. NULL is the most common value, meaning this is a standard folder. media is a special case where media files are stored.

• position (int32 | None) – An integer value used for sorting the order in which the folder is listed.

grading_period_groups

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

Parameters:

• account_id (accounts | None) – Points to the account associated with the group.

• created_at (datetime) – Timestamp when record was created.

• updated_at (datetime) – Timestamp when record was last updated.

• workflow_state (grading_period_groups__workflow_state) – Life-cycle state for the grading period group.

• course_id (courses | None) – Identifies the course.

• weighted (bool | None) – Whether to weight individual grading periods within this grading group.

• display_totals_for_all_grading_periods (bool) – If set, shows the option to display the totals for all grading periods within this group on the student grades page and the gradebook.

• id (int64) – primary key Primary key for the grading period groups.

• title (Annotated[str, MaxLength(255)] | None) – The title for this grading period group.

grading_periods

Stores attributes for grading period.

A Grading period is like a “term”, essentially used for splitting up the grade book into “periods”.

Parameters:

• created_at (datetime) – Timestamp when record was created.

• updated_at (datetime) – Timestamp when record was last updated.

• workflow_state (grading_periods__workflow_state) – Life-cycle state for the grading periods.

• grading_period_group_id (grading_period_groups) – Surrogate ID to the grading period group dataset.

• start_date (datetime) – The start date of the grading period.

• end_date (datetime) – The end date of the grading period.

• close_date (datetime | None) – Grades can only be changed before this close date of the grading period.

• id (int64) – primary key The unique identifier for the grading period.

• title (Annotated[str, MaxLength(255)] | None) – The title for the grading period.

• weight (float64 | None) – A weight value that contributes to the overall weight of a grading period set, used to calculate how much assignments in this period contribute to the total grade.

grading_standards

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

Parameters:

• id (int64) – primary key The unique identifier for a grading standard record.

• version (int32 | None) – Either 1 or 2, as noted in the definition of data.

• context_code (Annotated[str, MaxLength(255)] | None) – A value in string form representing the associated context (e.g., course_5).

• user_id (users | None) – The ID of the user who created this grading standard.

• created_at (datetime) – Timestamp of when a grading_standards record was created.

• updated_at (datetime) – Timestamp of when a grading_standards record was updated.

• workflow_state (grading_standards__workflow_state) – Life-cycle state for the grading standard.

• context_id (accounts | courses) – The ID of the account or course to which this grading standard belongs.

• context_type (grading_standards__context_type) – The type of the object represented by context_id, either Account or Course.

• migration_id (Annotated[str, MaxLength(255)] | None) – The ID of the associated migration, if this grading standard was created via a content migration.

• title (Annotated[str, MaxLength(255)] | None) – The name for this grading standard.

• data (json | None) – A stringified array representing the content of this grading standard. If the version column is 1, each element is a tuple containing a letter grade and the maximum value for that letter grade. If the version column is 2, each element is a tuple containing a letter grade and the minimum value for that letter grade.

group_categories

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

Parameters:

• name (Annotated[str, MaxLength(255)] | None) – The display name of the group category.

• id (int64) – primary key The unique identifier for a group category record.

• deleted_at (datetime | None) – Timestamp when this record was deleted. If the record has not been deleted the value will be NULL.

• created_at (datetime | None) – Timestamp of when a group_categories record was created.

• updated_at (datetime | None) – Timestamp of when a group_categories record was updated.

• sis_batch_id (sis_batches | None) – The unique identifier for the SIS import. This field is only included if the user has permission to manage SIS information.

• context_id (accounts | courses | None) – The unique identifier for the context of group_categories (account, course, user).

• context_type (group_categories__context_type) – The type of the object represented by context_id.

• sis_source_id (bounded_str | None) – The unique identifier for this group in the customer SIS.

• role (group_categories__role | None) – Certain types of group categories have special role designations. Currently, these include: communities, student_organized, and imported. Regular course/account group categories have a role of NULL.

• self_signup (Annotated[str, MaxLength(255)] | None) – If the group category allows users to join a group themselves, thought they may only be a member of one group per group category at a time. Values include restricted, enabled, and NULL. enabled allows students to assign themselves to a group, restricted restricts them to only joining a group in their section, NULL disallows students from joining groups.

• group_limit (int32 | None) – If self-signup is enabled, this field can be set to cap the number of users in each group. If NULL, there is no limit.

• auto_leader (Annotated[str, MaxLength(255)] | None) – Gives instructors the ability to automatically have group leaders assigned. Values include random, first, and NULL; random picks a student from the group at random as the leader, first sets the first student to be assigned to the group as the leader.

group_memberships

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

Parameters:

• id (int64) – primary key The unique identifier for a group membership record.

• user_id (users) – The ID of the user object to which the membership belongs.

• created_at (datetime) – Timestamp of when a group_memberships record was created.

• updated_at (datetime) – Timestamp of when a group_memberships record was updated.

• workflow_state (group_memberships__workflow_state) – The current state of the membership.

• sis_batch_id (sis_batches | None) – The ID of the SIS import if created through SIS. Only included if the user has permission to manage SIS information.

• group_id (groups) – The ID of the group object to which the membership belongs.

• moderator (bool | None) – Whether or not the user is a moderator of the group (the must also be an active member of the group to moderate).

• uuid (Annotated[str, MaxLength(255)]) – UUID for a membership record.

groups

Stores attributes for groups in canvas.

Groups contain two or more students enrolled in a particular course working on an assignment or project together.

Parameters:

• name (Annotated[str, MaxLength(255)] | None) – The display name of the group.

• id (int64) – primary key The ID of the group.

• deleted_at (datetime | None) – Timestamp when the group was deleted.

• storage_quota (int64 | None) – The storage quota for the group.

• lti_context_id (Annotated[str, MaxLength(255)] | None) – UUID of the Canvas context in LTI standard. secondary ID for this context, could be used in API to identify resource as well.

• created_at (datetime) – Timestamp when the group was first saved in the system.

• updated_at (datetime) – Timestamp when the group was last updated in the system.

• workflow_state (groups__workflow_state) – Life-cycle state for the group.

• account_id (accounts) – Identifies the associated account, groups could be owned by sub-accounts.

• sis_batch_id (sis_batches | None) – The ID of the SIS import if created through SIS.

• context_id (courses | accounts) – The ID of the context (account or course) this group belongs too. See also: context_type.

• context_type (groups__context_type) – The course or account that the group belongs to. The pattern here is that whatever the context_type is, there will be an _id field named after that type. So if instead context_type was account, the course_id field would be replaced by an account_id field.

• migration_id (Annotated[str, MaxLength(255)] | None) – The unique identifier of the migration that imported this group.

• group_category_id (group_categories | None) – The ID of the group’s category.

• sis_source_id (Annotated[str, MaxLength(255)] | None) – The SIS ID of the group.

• is_public (bool | None) – Whether or not the group is public. Currently only community groups can be made public. Also, once a group has been set to public, it cannot be changed back to private.

• wiki_id (wikis | None) – The ID of an associated wiki page.

• max_membership (int32 | None) – The maximum number of participating users in the group.

• join_level (Annotated[str, MaxLength(255)] | None) – How people are allowed to join the group. For all groups except for community groups, the user must share the group’s parent course or account. For student organized or community groups, where a user can be a member of as many or few as they want, the applicable levels are parent_context_auto_join, parent_context_request, and invitation_only. For class groups, where students are divided up and should only be part of one group of the category, this value will always be invitation_only, and is not relevant. If parent_context_auto_join, anyone can join and will be automatically accepted. If parent_context_request, anyone can request to join, which must be approved by a group moderator. If invitation_only, only those how have received an invitation my join the group, by accepting that invitation.

• avatar_attachment_id (attachments | None) – Foreign key to the attachments table for the avatar of this group.

• leader_id (users | None) – Foreign key to the users table for the leader of this group.

• description (bounded_str | None) – A description of the group.

• uuid (Annotated[str, MaxLength(255)]) – The UUID of the group.

• default_view (groups__default_view | None) – Default view for groups is the feed.

late_policies

Contains late/missing policy configurations for courses.

Parameters:

• id (int64) – primary key The unique identifier for a late policy record.

• course_id (courses) – The ID of the course this late policy references.

• created_at (datetime) – Timestamp of when a late_policies record was created.

• updated_at (datetime) – Timestamp of when a late_policies record was updated.

• missing_submission_deduction_enabled (bool) – Whether to apply a deduction for submissions that have not been submitted as of their due date.

• missing_submission_deduction (Annotated[Decimal, Precision(5, 2)]) – The amount to award for a missing submission, expressed as a percentage (from 0 to 100) of the assignment’s possible points.

• late_submission_deduction_enabled (bool) – Whether to apply a deduction for submissions submitted late.

• late_submission_deduction (Annotated[Decimal, Precision(5, 2)]) – The amount to deduct from the submission for each interval it is late, expressed as a percentage (from 0 to 100) of the assignment’s possible points.

• late_submission_interval (Annotated[str, MaxLength(16)]) – The interval at which points should be deducted: valid values are day and hour.

• late_submission_minimum_percent_enabled (bool) – True if the points deducted for lateness should be capped.

• late_submission_minimum_percent (Annotated[Decimal, Precision(5, 2)]) – If late_submission_minimum_percent_enabled is true, prevents late deductions from bringing a submission below this percentage of the total points. A value between 0 and 100.

learning_outcome_groups

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

This table contains dimensions for learning outcome groups.

Parameters:

• id (int64) – primary key The unique identifier for a learning outcome group record.

• created_at (datetime) – Timestamp of when a learning_outcome_groups record was created.

• updated_at (datetime) – Timestamp of when a learning_outcome_groups record was updated.

• workflow_state (learning_outcome_groups__workflow_state) – Workflow status of the learning outcome.

• context_id (accounts | courses | None) – The unique identifier for the learning_outcome_groups’s context (account, course).

• context_type (learning_outcome_groups__context_type | None) – The type of the object represented by context_id.

• migration_id (Annotated[str, MaxLength(255)] | None) – A GUID used to resolve outcomes during import and migration.

• learning_outcome_group_id (learning_outcome_groups | None) – ID associated with the parent of this group (NULL if it does not have parent). Refers to a learning_outcome_group record.

• root_learning_outcome_group_id (learning_outcome_groups | None) – ID associated with the root group in the group hierarchy (NULL if it is the root). Refers to a learning_outcome_group record.

• vendor_guid (Annotated[str, MaxLength(255)] | None) – A custom GUID for the learning standard.

• outcome_import_id (outcome_imports | None) – Foreign key to the outcome import associated with this outcome group, if this group was imported.

• source_outcome_group_id (learning_outcome_groups | None) – Foreign key to the learning outcome group that the group was copied from.

• description (bounded_str | None) – Description of the learning outcome group.

• title (Annotated[str, MaxLength(255)]) – Title of the learning outcome group.

learning_outcome_question_results

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

Parameters:

• created_at (datetime) – Timestamp of when a learning_outcome_question_results record was created.

• updated_at (datetime) – Timestamp of when a learning_outcome_question_results record was updated.

• learning_outcome_id (learning_outcomes | None) – Foreign key to the learning outcome this record is associated with.

• associated_asset_id (assessment_questions | None) – Polymorphic foreign key to the associated asset (currently always Assessment Question) used to generate this result.

• associated_asset_type (learning_outcome_question_results__associated_asset_type) – Type of the associated asset (currently always Assessment Question).

• learning_outcome_result_id (learning_outcome_results | None) – Identifies the learning outcome result.

• score (float64 | None) – The student’s score.

• possible (float64 | None) – Total number of points possible.

• mastery (bool | None) – Boolean indicating whether user achieved mastery.

• attempt (int32 | None) – The total number of attempts, or submissions.

• original_score (float64 | None) – Score on the first attempt.

• original_possible (float64 | None) – Possible points on the first attempt.

• original_mastery (bool | None) – Boolean indicating whether user achieved mastery.

• assessed_at (datetime | None) – Time when answer was assessed.

• submitted_at (datetime | None) – Time when answer was submitted.

• id (int64) – primary key The unique identifier for a learning outcome question result record.

• percent (float64 | None) – Score’s percent of maximum points possible for outcome, scaled to reflect any custom mastery levels that differ from the learning outcome.

• title (bounded_str | None) – Title for identifying the question result.

learning_outcome_results

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

This table contains dimensions for learning outcome results.

Parameters:

• user_id (users | None) – The unique ID of a user who made the submission.

• created_at (datetime) – Timestamp of when a learning_outcome_results record was created.

• updated_at (datetime) – Timestamp of when a learning_outcome_results record was updated.

• workflow_state (learning_outcome_results__workflow_state) – The current state of a learning outcome result record.

• context_id (courses | None) – The unique identifier for the learning_outcome_results’s context (account, course, user).

• context_type (learning_outcome_results__context_type | None) – The type of the object represented by context_id, typically Course or Account or User.

• context_code (Annotated[str, MaxLength(255)] | None) – Alternate specification of learning outcome result context as single string.

• learning_outcome_id (learning_outcomes | None) – Identifies the learning outcome this result is associated with.

• associated_asset_id (assessment_questions | live_assessments_assessments | assignments | quizzes | None) – Polymorphic foreign key to the associated asset this result is associated with.

• associated_asset_type (learning_outcome_results__associated_asset_type | None) – Type of the associated asset this result is associated with.

• score (float64 | None) – The student’s score.

• possible (float64 | None) – Total number of points possible.

• mastery (bool | None) – Boolean indicating whether user achieved mastery.

• attempt (int32 | None) – The total number of attempts, or submissions.

• original_score (float64 | None) – Score on the first attempt.

• original_possible (float64 | None) – Possible points on the first attempt.

• original_mastery (bool | None) – Boolean indicating whether user achieved mastery.

• assessed_at (datetime | None) – Time when the result was assessed.

• submitted_at (datetime | None) – Time when the submission was submitted.

• association_id (assignments | quizzes | rubric_associations | None) – Polymorphic foreign key to the aligned learning object this result is associated with.

• association_type (learning_outcome_results__association_type | None) – Type of the aligned learning object this result is associated with.

• content_tag_id (content_tags | None) – Foreign key to the content tag representing the learning outcome alignment this result is associated with.

• user_uuid (Annotated[str, MaxLength(255)] | None) – The uuid of the user who made the submission.

• artifact_id (live_assessments_submissions | quiz_submissions | rubric_assessments | submissions | None) – Polymorphic foreign key to the assessed artifact this result is associated with.

• artifact_type (learning_outcome_results__artifact_type | None) – Type of the assessed artifact this result is associated with.

• hide_points (bool) – Boolean indicating if outcome result points should be hidden in the Learning Mastery Gradebook and reports. If enabled, replace points with the description of the highest scoring outcome criterion rating.

• hidden (bool) – Boolean indicating if outcome result should be hidden from the Learning Mastery Gradebook and reports.

• id (int64) – primary key The unique identifier for a learning outcome result record.

• percent (float64 | None) – Percent of maximum points possible for an outcome, scaled to reflect any custom mastery levels that differ from the learning outcome.

• title (Annotated[str, MaxLength(255)] | None) – Title for identifying the result.

learning_outcomes

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

This table contains dimensions for learning outcomes.

Parameters:

• id (int64) – primary key The unique identifier for a learning outcome record.

• display_name (Annotated[str, MaxLength(255)] | None) – Optional friendly name for reporting.

• context_code (Annotated[str, MaxLength(255)] | None) – Alternate specification of learning outcome context as single string. Combination of context_type and context_id (e.g. course_34416).

• created_at (datetime) – Timestamp of when a learning_outcomes record was created.

• updated_at (datetime) – Timestamp of when a learning_outcomes record was updated.

• workflow_state (learning_outcomes__workflow_state) – Workflow status of the learning outcome.

• context_id (accounts | courses | None) – The unique identifier for the context of learning_outcomes (account, course, user), may be NULL for global outcomes.

• context_type (learning_outcomes__context_type | None) – The type of the object represented by context_id.

• migration_id (Annotated[str, MaxLength(255)] | None) – A GUID used to resolve outcomes during import and migration.

• vendor_guid (Annotated[str, MaxLength(255)] | None) – A custom GUID for the learning standard.

• outcome_import_id (outcome_imports | None) – Foreign key to the outcome import associated with this outcome, if this outcome was imported.

• calculation_method (learning_outcomes__calculation_method | None) – The method used to calculate student score.

• calculation_int (int16 | None) – Defines the variable value used by the calculation_method. included only if calculation_method uses it.

• short_description (Annotated[str, MaxLength(255)]) – Title of the outcome.

• description (bounded_str | None) – Description of the outcome.

• data (json | None) – YAML data specifying the scoring method and rubric criteria for this outcome.

lti_line_items

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

LTI 1.3 tools that have been authorized by an admin may manage this table.

See Learning Tools Interoperability (LTI) Assignment and Grade Services Specification.

Parameters:

• created_at (datetime) – Timestamp of when a lti_line_items record was created.

• updated_at (datetime) – Timestamp of when a lti_line_items record was updated.

• workflow_state (lti_line_items__workflow_state) – The workflow state of the line item.

• assignment_id (assignments) – The ID of the assignment associated with the line item.

• client_id (int64) – The client ID used to create the line item (developer key global id).

• coupled (bool) – True if the line item is the default one created when a user created an assignment; false if the line item was created via the API (regardless if it is the default line item or not).

• score_maximum (float64) – The maximum score for the line item.

• resource_id (bounded_str | None) – A Tool Provider specified ID for the Line Item. Multiple line items may share the same resourceId within a given context.

• lti_resource_link_id (lti_resource_links | None) – The resource link ID associated with the line item. This ID matches the associated assignments “lti_context_id”.

• label (bounded_str) – The label of the line item.

• id (int64) – primary key The unique identifier for an lti line item record.

• extensions (Annotated[bounded_str, JsonStringToJsonObject()]) – Contains canvas-specific line item extensions. For example: submission_type.

• tag (bounded_str | None) – A value used to qualify a line Item beyond its ids. Line Items may be queried by this value in the List endpoint. Multiple line items can share the same tag within a given context.

lti_resource_links

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

Only used with LTI 1.3 context_external_tools.

Parameters:

• id (int64) – primary key The unique identifier for an lti resource link record.

• created_at (datetime) – Timestamp of when a lti_resource_links record was created.

• updated_at (datetime) – Timestamp of when a lti_resource_links record was updated.

• workflow_state (lti_resource_links__workflow_state) – The workflow state of the line item.

• context_id (accounts | assignments | courses) – The context the LTI resource link belongs to.

• context_type (lti_resource_links__context_type) – The type of the context the LTI resource link belongs to.

• context_external_tool_id (context_external_tools) – The ID of the context_external_tool associated to the resource.

• custom (bounded_str | None) – Custom parameters that will be added to the LTI launch. These are custom parameters returned from a Deep Linking response. These are merged with tool/placement-level custom parameters, if any.

• resource_link_uuid (UUID) – A UUID identifying the resource link.

• lookup_uuid (UUID) – Used to identify the resource link to use in order to lookup custom parameters in some scenarios, such as a link added from Deep Linking into a Rich Content Editor.

lti_results

Represents a result from the IMS Assignment and Grade service

See IMS Global. LTI 1.3 tools that have been authorized by an admin may read records from this table via API.

Parameters:

• id (int64) – primary key The unique identifier for an lti result record.

• extensions (bounded_str) – Platform-specific extensions for the result.

• comment (bounded_str | None) – Comment visible to the student about the result (LTI AGS).

• submission_id (submissions | None) – the ID of the associated submission.

• user_id (users) – The unique ID of a user.

• created_at (datetime) – Timestamp of when a lti_results record was created.

• updated_at (datetime) – Timestamp of when a lti_results record was updated.

• workflow_state (lti_results__workflow_state) – The workflow state of the result.

• result_score (float64 | None) – The score given for the the student (LTI AGS).

• result_maximum (float64 | None) – The maximum score for the student (LTI AGS).

• activity_progress (bounded_str | None) – Indication to Canvas of the status of the user towards the activity’s completion. Must be one of Initialized, Started, InProgress, Submitted, Completed (LTI AGS).

• grading_progress (bounded_str | None) – Indication to Canvas of the status of the grading process. A value of PendingManual will require intervention by a grader. Values of NotReady, Failed, and Pending will cause the scoreGiven to be ignored. FullyGraded values will require no action. Possible values are NotReady, Failed, Pending, PendingManual, FullyGraded (LTI AGS).

• lti_line_item_id (lti_line_items) – The ID of the associated line item.

master_courses_child_content_tags

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

Parameters:

• id (int64) – primary key The unique identifier of a master courses child content tag record.

• child_subscription_id (master_courses_child_subscriptions) – The ID of a subscription belonging to the associated course.

• content_id (assessment_question_banks | assignments | assignment_groups | attachments | calendar_events | context_external_tools | context_modules | content_tags | discussion_topics | learning_outcomes | learning_outcome_groups | rubrics | wikis | wiki_pages | quizzes) – The ID of an associated content object.

• migration_id (bounded_str | None) – An identifier used by the Blueprint system to match with the blueprint content.

• downstream_changes (json | None) – The columns changed on the associated content.

• content_type (master_courses_child_content_tags__content_type) – The class of the associated content object.

master_courses_child_subscriptions

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

Parameters:

• id (int64) – primary key The unique identifier of a master courses child subscription record.

• created_at (datetime) – Timestamp showing when a master_courses_child_subscriptions record was created.

• updated_at (datetime) – Timestamp showing when a master_courses_child_subscriptions record was updated.

• workflow_state (master_courses_child_subscriptions__workflow_state) – Whether the subscription is active or has been deleted.

• use_selective_copy (bool) – Whether the associated course can receive partial exports from the blueprint course for subsequent sync events.

• master_template_id (master_courses_master_templates) – The ID of a template that belongs to the blueprint course.

• child_course_id (courses) – The ID of an associated course.

master_courses_master_content_tags

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

Parameters:

• id (int64) – primary key The unique identifier of a master courses master content tag record.

• content_id (assessment_question_banks | assignments | assignment_groups | attachments | calendar_events | context_external_tools | context_modules | content_tags | discussion_topics | learning_outcomes | rubrics | wikis | wiki_pages | quizzes) – The ID of an associated content object.

• migration_id (bounded_str | None) – An identifier used by the Blueprint system to match with associated content.

• restrictions (json | None) – The locked status of the associated content object.

• use_default_restrictions (bool) – Whether the content is using defaults set by the course or has been individually configured.

• master_template_id (master_courses_master_templates) – The ID of a template belonging to the blueprint course.

• content_type (master_courses_master_content_tags__content_type) – The class of the associated content object.

master_courses_master_migrations

Represents a blueprint course sync event.

Parameters:

• id (int64) – primary key The unique identifier of a master courses master migrations record.

• comment (bounded_str | None) – An optional message to be displayed with the sync event.

• user_id (users | None) – The unique ID of a user.

• created_at (datetime) – Timestamp showing when a master_courses_master_migrations record was created.

• updated_at (datetime) – Timestamp showing when a master_courses_master_migrations record was updated.

• workflow_state (master_courses_master_migrations__workflow_state) – Current state of the sync event.

• migration_settings (json | None) – Optional settings for the sync event (such as whether to include course settings).

• export_results (json | None) – Record of which associated courses received full exports and which ones received partial (selective) ones.

• exports_started_at (datetime | None) – Timestamp showing when exports started being generated from the blueprint course.

• imports_queued_at (datetime | None) – Timestamp showing when imports started being queued into the associated courses.

• imports_completed_at (datetime | None) – Timestamp showing when all imports into associated courses completed.

• send_notification (bool) – Whether to generate notifications around the sync event.

• master_template_id (master_courses_master_templates) – The ID of a template that belongs to the blueprint course.

master_courses_master_templates

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

Parameters:

• id (int64) – primary key The unique identifier of a master courses template record.

• course_id (courses) – The ID of a blueprint course record.

• created_at (datetime) – Timestamp showing when a master_courses_templates record was created.

• updated_at (datetime) – Timestamp showing when a master_courses_templates record was updated.

• workflow_state (master_courses_master_templates__workflow_state | None) – Whether the template is active or if it has been deleted (i.e. the course has been unset as a blueprint).

• full_course (bool) – Whether all blueprint content in the course should be synced (always true for the time being).

• active_migration_id (master_courses_master_migrations | None) – The ID of a last migration to be run (used to ensure only one is running at a time).

• default_restrictions (json | None) – The default locked status for all blueprint course content (unless using restrictions by type).

• use_default_restrictions_by_type (bool) – Whether to use default_restrictions_by_type to determine content locked status.

• default_restrictions_by_type (json | None) – The default locked status for all blueprint course content depending on the type of content (unless not using restrictions by type).

master_courses_migration_results

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

Parameters:

• id (int64) – primary key The unique identifier of a master courses migration result record.

• state (master_courses_migration_results__state) – The state of the import into the associated course (failed, completed or queued).

• child_subscription_id (master_courses_child_subscriptions) – The ID of a relevant associated course subscription record.

• master_migration_id (master_courses_master_migrations) – The ID of a relevant blueprint migration record (sync event).

• content_migration_id (content_migrations) – The ID of a relevant import record on the associated course.

• import_type (master_courses_migration_results__import_type) – Whether the blueprint export was for the entire course (full) or a partial (selective).

• results (json | None) – Relevant results of the import (e.g. items that were not synced because they were modified by the associated course).

originality_reports

Represents an “originality score” for a submission.

Rows in this table are managed solely by LTI 2 tool providers that leverage the Canvas plagiarism detection platform.

Parameters:

• id (int64) – primary key The unique identifier for an originality report record.

• error_message (bounded_str | None) – The error message provided by the tool provider. Only set if there was an error processing the submission.

• attachment_id (attachments | None) – The is of the attachment associated with the originality report.

• submission_id (submissions) – ID of the submission associated with the originality report.

• created_at (datetime) – Timestamp of when an originality_reports record was created.

• updated_at (datetime) – Timestamp of when an originality_reports record was updated.

• workflow_state (originality_reports__workflow_state) – Workflow state of the originality report.

• originality_score (float64 | None) – A number ranging from 0-100 indicating the level of potential plagiarism.

• originality_report_url (bounded_str | None) – The url pointing to the originality report from the tool provider.

• originality_report_lti_url (bounded_str | None) – The LTI launch URL that allows a user to view the originality report in the tool.

• link_id (bounded_str | None) – Resource link ID of the assignment associated with the submission.

• submission_time (datetime | None) – Time the submission was submitted.

outcome_proficiencies

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

Parameters:

• created_at (datetime) – Timestamp of when an outcome_proficiencies record was created.

• updated_at (datetime) – Timestamp of when an outcome_proficiencies record was updated.

• workflow_state (outcome_proficiencies__workflow_state) – Workflow status of the outcome_proficiency. Defaults to active.

• context_id (accounts | courses) – The unique identifier for the context (account or course) of the outcome proficiency.

• context_type (outcome_proficiencies__context_type) – The type of the object represented by context_id.

• id (int64) – primary key The unique identifier for an outcome proficiency record.

outcome_proficiency_ratings

Outcome proficiency ratings define the individual tiers of outcome proficiencies.

Parameters:

• created_at (datetime) – Timestamp of when an outcome_proficiency_ratings record was created.

• updated_at (datetime) – Timestamp of when an outcome_proficiency_ratings record was updated.

• workflow_state (outcome_proficiency_ratings__workflow_state) – Workflow status of the outcome_proficiency_rating. Defaults to active.

• mastery (bool) – Indicates the rating where mastery is first achieved.

• points (float64) – A non-negative number of points for the rating.

• outcome_proficiency_id (outcome_proficiencies) – Unique ID of proficiency collection to which this rating belongs.

• color (bounded_str) – The hex color code of the rating.

• description (Annotated[str, MaxLength(255)]) – The description of the rating.

• id (int64) – primary key The unique identifier for an outcome proficiency ratings record.

post_policies

Contains post policy configurations for courses and individual assignments.

Parameters:

• id (int64) – primary key The unique identifier for a post policy record.

• course_id (courses | None) – The ID of the course referenced by this policy. Note that this is always set even if the policy refers to a specific assignment within a course.

• created_at (datetime) – Timestamp of when a post_policies record was created.

• updated_at (datetime) – Timestamp of when a post_policies record was updated.

• assignment_id (assignments | None) – The ID of the assignment referenced by this policy, or NULL if the policy refers to a course at large.

• post_manually (bool) – For post policies associated with an assignment, whether submissions receiving grades or comments should be posted to the student automatically. For post policies associated with a course, this value will be applied by default to assignments created in the course.

pseudonyms

This table stores user pseudonyms.

Pseudonyms are login profiles associated with users. Contains user / account relationship (may contain multiple records per user_id if that user_id is associated with multiple accounts); note: not all users can be found in the pseudonyms table.

Parameters:

• id (int64) – primary key Primary key for this pseudonym in the the Canvas database.

• deleted_at (datetime | None) – Timestamp when the pseudonym was deleted (NULL if the pseudonym is still active).

• integration_id (Annotated[str, MaxLength(255)] | None) – The integration_id associated with the user.

• user_id (users) – Id for the user associated with this pseudonym.

• created_at (datetime) – Timestamp when this pseudonym was created in Canvas.

• updated_at (datetime) – Timestamp when this pseudonym was last updated in Canvas.

• workflow_state (pseudonyms__workflow_state) – Life-cycle state for the pseudonym.

• account_id (accounts) – Identifies the account associated with this pseudonym. Typically root account ID unless account user belongs to trust/consortium based Canvas accounts.

• sis_batch_id (sis_batches | None) – The ID of the SIS import.

• unique_id (Annotated[str, MaxLength(255)]) – The unique login ID for the user. This is what the user uses to log in to Canvas.

• login_count (int32) – The count of all user logins.

• failed_login_count (int32) – Only applies to accounts that use Canvas authentication settings.

• last_request_at (datetime | None) – Timestamp of when the user last logged in with this pseudonym.

• last_login_at (datetime | None) – Timestamp of last time a user logged in with this pseudonym.

• current_login_at (datetime | None) – Timestamp of when the user logged in.

• last_login_ip (Annotated[str, MaxLength(255)] | None) – IP address recorded the last time a user logged in with this pseudonym.

• current_login_ip (Annotated[str, MaxLength(255)] | None) – IP address of user’s previous login id, this value could be the same as last_login_ip.

• sis_user_id (Annotated[str, MaxLength(255)] | None) – The SIS ID associated with the user.

• authentication_provider_id (authentication_providers | None) – The authentication provider this login is associated with. This can be the integer ID of the provider, or the type of the provider (in which case, it will find the first matching provider).

• position (int32 | None) – Position of user’s login credentials.

quiz_groups

This table stores attributes for quiz group.

Parameters:

• name (Annotated[str, MaxLength(255)] | None) – The name of the question group.

• id (int64) – primary key The ID of the question group.

• created_at (datetime) – Time when the quiz question was created.

• updated_at (datetime) – Time when the quiz question was last updated.

• assessment_question_bank_id (assessment_question_banks | None) – The ID of the Assessment question bank to pull questions from.

• quiz_id (quizzes) – The ID of the Quiz the question group belongs to.

• migration_id (Annotated[str, MaxLength(255)] | None) – The unique identifier of the migration that imported the quiz group.

• pick_count (int32 | None) – The number of questions to pick from the group to display to the student.

• question_points (float64 | None) – The amount of points allotted to each question in the group.

• position (int32 | None) – The order in which the question group will be retrieved and displayed.

quiz_questions

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

Parameters:

• id (int64) – primary key The ID of the quiz question.

• created_at (datetime | None) – Time when the quiz question was created.

• updated_at (datetime | None) – Time when the quiz question was last updated.

• workflow_state (quiz_questions__workflow_state | None) – Life-cycle state for the quiz question.

• quiz_id (quizzes | None) – The ID of the Quiz the question belongs to.

• migration_id (Annotated[str, MaxLength(255)] | None) – The unique identifier of the migration that imported the quiz question.

• quiz_group_id (quiz_groups | None) – Identifies the quiz group.

• assessment_question_id (assessment_questions | None) – Identifies the assessment question.

• assessment_question_version (int32 | None) – Version of the assessment question associated with the quiz question.

• position (int32 | None) – The order in which the question will be retrieved and displayed.

• question_data (Annotated[quiz_questions__question_data, YamlStringToJsonObject()] | None) – Question data.

quiz_submissions

Stores attributes for the last submitted quiz.

This tables persists one record per user_id and quiz_id.

Parameters:

• id (int64) – primary key The ID of the quiz submission.

• submission_id (submissions | None) – The ID of the Submission the quiz submission represents.

• user_id (users | None) – The ID of the Student that made the quiz submission.

• created_at (datetime) – Time when the quiz submission was created.

• updated_at (datetime) – Time when the quiz submission was last updated.

• workflow_state (quiz_submissions__workflow_state) – Life-cycle state for the quiz submission.

• quiz_id (quizzes) – The ID of the Quiz the quiz submission belongs to.

• quiz_version (int32 | None) – The version of the quiz this submission is related to.

• started_at (datetime | None) – The time at which the student started the quiz submission.

• finished_at (datetime | None) – The time at which the student submitted the quiz submission.

• end_at (datetime | None) – The time at which the quiz submission will be overdue, and be flagged as a late submission.

• score (float64 | None) – The score of the quiz submission, if graded.

• attempt (int32 | None) – For quizzes that allow multiple attempts, this field specifies the quiz submission attempt number.

• submission_data (Annotated[bounded_str, JsonStringToJsonObject(), SpecialConversion()] | None) – Student answers to quiz, it shares JSON array of answers for only graded quiz submissions, it has NULL if quiz hasn’t been graded yet. Contains the question_id, whether the question was answered correctly, the answer_id and answer text.

• kept_score (float64 | None) – For quizzes that allow multiple attempts, this is the score that will be used, which might be the score of the latest, or the highest, quiz submission.

• fudge_points (float64) – Number of points the quiz submissions score was fudged by.

• quiz_points_possible (float64 | None) – The amount of points possible for the quiz.

• extra_attempts (int32 | None) – Number of times the student was allowed to retake the quiz over the multiple-attempt limit.

• temporary_user_code (Annotated[str, MaxLength(255)] | None) – Construct for previewing a quiz.

• extra_time (int32 | None) – Amount of extra time allowed for the quiz submission, in minutes.

• manually_scored (bool | None) – Indicates if this submission was graded by the teacher.

• manually_unlocked (bool | None) – The student can take the quiz even if it’s locked for everyone else.

• was_preview (bool | None) – Indicates if this submission was created from a teacher preview.

• score_before_regrade (float64 | None) – The original score of the quiz submission prior to any re-grading.

• has_seen_results (bool | None) – Whether the student has viewed their results to the quiz.

quizzes

Stores attributes for quizzes.

Quizzes can also be assignments (assignment_id field will have a value).

Parameters:

• deleted_at (datetime | None) – Timestamp when the quiz was deleted.

• created_at (datetime) – Time when the quiz was created.

• updated_at (datetime) – Time when the quiz was last updated.

• workflow_state (quizzes__workflow_state) – Denotes where the quiz is in the workflow. Possible values are unpublished, published and deleted. Defaults to unpublished.

• due_at (datetime | None) – when the quiz is due.

• unlock_at (datetime | None) – when to unlock the quiz.

• lock_at (datetime | None) – when to lock the quiz.

• points_possible (float64 | None) – The total point value given to the quiz.

• assignment_group_id (assignment_groups | None) – the ID of the quizzes assignment group.

• context_id (courses) – The ID of the context (account or course) this group belongs too. See also: context_type.

• context_type (quizzes__context_type) – The type of the context object (typically Course).

• assignment_id (assignments | None) – Identifies the assignment the quiz belongs to (NULL if not an assignment).

• could_be_locked (bool) – Dictates if the quiz can be locked or not. Possible values are allow_locking and disallow_locking. Defaults to disallow_locking.

• migration_id (Annotated[str, MaxLength(255)] | None) – The unique identifier of the migration that imported the quiz.

• only_visible_to_overrides (bool) – This indicates the quiz is not visible to everyone in the course, but only to those with an override.

• allowed_attempts (int32 | None) – how many times a student can take the quiz -1 = unlimited attempts.

• published_at (datetime | None) – whether the quiz has a published or unpublished draft state.

• shuffle_answers (bool) – shuffle answers for students.

• show_correct_answers (bool) – show which answers were correct when results are shown? only valid if hide_results is NULL.

• time_limit (int32 | None) – quiz time limit in minutes.

• scoring_policy (Annotated[str, MaxLength(255)] | None) – which quiz score to keep (only if allowed_attempts != 1) possible values: keep_highest, keep_latest.

• quiz_type (quizzes__quiz_type | None) – type of quiz.

• access_code (Annotated[str, MaxLength(255)] | None) – access code to restrict quiz access.

• question_count (int32 | None) – the number of questions in the quiz.

• anonymous_submissions (bool) – Dictates whether students are allowed to submit the quiz anonymously.

• hide_results (Annotated[str, MaxLength(255)] | None) – let students see their quiz responses? possible values: NULL, always, until_after_last_attempt.

• ip_filter (Annotated[str, MaxLength(255)] | None) – IP address or range that quiz access is limited to.

• require_lockdown_browser (bool) – Dictates whether the browser has locked-down when the quiz is being taken. Possible values are required and not_required. Defaults to not_required.

• require_lockdown_browser_for_results (bool) – Dictates whether the browser has to be locked-down to display the results. Is valid only if hide_results is set to never or until_after_last_attempt (for the results to be displayed after the last attempt). Possible values are required and not_required. Defaults to not_required.

• one_question_at_a_time (bool) – show one question at a time?

• cant_go_back (bool) – lock questions after answering? only valid if one_question_at_a_time is true.

• show_correct_answers_at (datetime | None) – when should the correct answers be visible by students? only valid if show_correct_answers is true.

• hide_correct_answers_at (datetime | None) – prevent the students from seeing correct answers after the specified date has passed. only valid if show_correct_answers is true.

• require_lockdown_browser_monitor (bool) – Dictates whether a browser lockdown monitor is required. Possible values are required and not_required. Defaults to not_required.

• one_time_results (bool) – prevent the students from seeing their results more than once (right after they submit the quiz).

• show_correct_answers_last_attempt (bool) – restrict the show_correct_answers option above to apply only to the last submitted attempt of a quiz that allows multiple attempts. only valid if show_correct_answers is true and allowed_attempts > 1.

• unpublished_question_count (int32) – The number of questions that have not been published.

• description (bounded_str | None) – the description of the quiz.

• id (int64) – primary key the ID of the quiz.

• title (Annotated[str, MaxLength(255)] | None) – the title of the quiz.

role_overrides

A customization to the default permissions granted by a role.

Parameters:

• id (int64) – primary key unique identifier of a role permission.

• permission (Annotated[str, MaxLength(255)] | None) – Permission assigned to a role, see the dictionary of permissions keyed by name in Canvas Roles API documentation.

• created_at (datetime | None) – Timestamp of when this record was created.

• updated_at (datetime | None) – Timestamp of last update to this record.

• role_id (roles) – Unique ID of a role.

• context_id (accounts) – The unique identifier for the folders’s context (account, course, user).

• context_type (role_overrides__context_type) – The type of the object represented by context_id.

• locked (bool) – Whether the permission is locked by this role.

• enabled (bool) – Whether the role has the permission.

• applies_to_self (bool) – Whether the permission applies to the account this role is in. Only present if enabled is true.

• applies_to_descendants (bool) – Whether the permission cascades down to sub accounts of the account this role is in. Only present if enabled is true.

roles

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

Roles have a few implicit permissions and a large set of default permissions, which can be customized with RoleOverrides.

Parameters:

• name (Annotated[str, MaxLength(255)]) – The name of the role.

• id (int64) – primary key The unique identifier for a user role record.

• deleted_at (datetime | None) – Timestamp when this record was deleted. If the record has not been deleted the value will be NULL.

• created_at (datetime) – Timestamp of when a roles record was created.

• updated_at (datetime) – Timestamp of when a roles record was updated.

• workflow_state (roles__workflow_state) – The state of the role.

• account_id (accounts | None) – Points to the account associated with the course. Could be Canvas root account or sub-account ID.

• base_role_type (roles__base_role_type) – The role type that is being used as a base for this role. For account-level roles, this is AccountMembership. For course-level roles, it is an enrollment type.

rubric_assessments

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

Parameters:

• id (int64) – primary key The unique identifier of a rubric assessment record.

• user_id (users | None) – The unique ID of a user.

• created_at (datetime) – Timestamp showing when a rubric_assessment record was created.

• updated_at (datetime) – Timestamp showing when a rubric_assessment record was updated.

• rubric_association_id (rubric_associations | None) – The ID of a rubric association (which links the rubric to an assignment that uses the rubric).

• artifact_id (submissions | assignments | moderated_grading_provisional_grades) – The submission or assignment identifier.

• artifact_type (rubric_assessments__artifact_type) – The artifact type.

• hide_points (bool) – Flag indicating a non-scoring rubric assessment.

• score (float64 | None) – Score of the assessment.

• rubric_id (rubrics) – The unique ID of a rubric.

• assessment_type (rubric_assessments__assessment_type) – Type of assessment.

• assessor_id (users | None) – The unique ID of a user who assessed the submission.

• artifact_attempt (int32 | None) – The current number of attempts made on the object of the assessment.

• data (json | None) – Object containing all data related to assessment including score-break down and comments for each criterion.

rubric_associations

Links a rubric to an assignment.

Parameters:

• id (int64) – primary key The unique identifier of a rubric association record.

• purpose (Annotated[str, MaxLength(255)]) – Whether or not the association is for grading (and thus linked to an assignment) or if it’s to indicate the rubric should appear in its context. Values will be grading or bookmark.

• created_at (datetime) – Timestamp showing when a rubric_associations record was created.

• updated_at (datetime) – Timestamp showing when a rubric_associations record was updated.

• workflow_state (rubric_associations__workflow_state) – The current state of a rubric association record.

• context_id (courses | accounts) – The unique identifier for the context of rubric_associations (account, course).

• context_type (rubric_associations__context_type) – The type of the object represented by context_id.

• association_id (accounts | courses | assignments) – The unique identifier of an associated object.

• association_type (rubric_associations__association_type) – The type of object associated.

• hide_points (bool) – Flag indication whether to hide points from rubric.

• rubric_id (rubrics) – The unique identifier of a rubric tied to this association.

• use_for_grading (bool | None) – Whether or not the associated rubric is used for grade calculation.

• summary_data (json | None) – Object that stores reusable comments made during assessments.

• hide_score_total (bool | None) – Flag indicating whether to hide the score total for assessment results.

• bookmarked (bool) – Flag indication whether rubric is bookmarked.

• hide_outcome_results (bool) – Flag indicating to not post Outcomes results to Learning Mastery Gradebook.

• title (Annotated[str, MaxLength(255)] | None) – The name of the object this rubric is associated with.

rubrics

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

Parameters:

• id (int64) – primary key The unique identifier of a rubric record.

• user_id (users | None) – The unique ID of a user.

• created_at (datetime) – Timestamp showing when a rubrics record was created.

• updated_at (datetime) – Timestamp showing when a rubrics record was updated.

• workflow_state (rubrics__workflow_state) – Current state of row.

• points_possible (float64 | None) – Total points possible for the rubric.

• context_id (accounts | courses) – The unique identifier of a rubric’s context (account, course).

• context_type (rubrics__context_type) – The type of the object represented by context_id.

• migration_id (Annotated[str, MaxLength(255)] | None) – An identifier used by the Blueprint system to match with the blueprint content.

• hide_score_total (bool | None) – Whether or not the score total is displayed within the rubric. This option is only available if the rubric is not used for grading.

• association_count (int32) – The number of associated objects (accounts, courses, assignments).

• free_form_criterion_comments (bool | None) – Whether or not you can write custom comments in the ratings field for a rubric.

• title (Annotated[str, MaxLength(255)] | None) – The Rubric name or title.

• data (json | None) – The data containing all the information for the rubric including each criterion.

score_statistics

This table stores aggregate statistics for scores on individual assignments.

Parameters:

• created_at (datetime) – The date this statistics object was created.

• updated_at (datetime) – The date this statistics object was updated.

• assignment_id (assignments) – The ID of the assignment referred to by this object.

• mean (float64) – The mean score for all graded submissions on this assignment.

• count (int32) – The number of submissions that have been graded for this assignment, excluding excused submissions.

• minimum (float64) – The lowest score for any graded submission on this assignment.

• id (int64) – primary key The ID of the statistics object.

• maximum (float64) – The highest score for any graded submission on this assignment.

scores

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

Parameters:

• id (int64) – primary key The ID of the score.

• created_at (datetime | None) – Time when the score was created.

• updated_at (datetime | None) – Time when the score was updated.

• workflow_state (scores__workflow_state) – Life-cycle state for the score.

• assignment_group_id (assignment_groups | None) – The ID of the assignment group this score refers to, or NULL if it does not refer to a particular assignment group.

• enrollment_id (enrollments) – The ID of the enrollment object this score refers to.

• grading_period_id (grading_periods | None) – The ID of the grading period covered by this score, or NULL if it does not apply to a specific grading period. If this is NULL, this is the overall score for the course.

• current_score (float64 | None) – The current score for the assignments represented by this Score object.

• final_score (float64 | None) – The final score for the assignments represented by this Score object, calculated by treating ungraded assignments as though they received zero points.

• course_score (bool) – True if this score does not refer to a particular grading period or assignment group (in other words, if it represents the overall score for the course referred to in the enrollment).

• unposted_current_score (float64 | None) – The current score, with muted/unposted assignments included.

• unposted_final_score (float64 | None) – The final score, with muted/unposted assignments included.

• current_points (float64 | None) – The number of points earned over all assignments covered by this score, with dropped assignments excluded.

• unposted_current_points (float64 | None) – The total number of points earned over all assignments covered by this score, including muted/unposted assignments.

• final_points (float64 | None) – The number of points earned over all assignments covered by this score, with dropped assignments excluded and unposted submissions treated as 0.

• unposted_final_points (float64 | None) – The number of points earned over all assignments covered by this score, with dropped assignments excluded and unposted submissions treated as 0, including muted/unposted assignments.

• override_score (float64 | None) – The override score, if one has been set.

submission_comments

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

Parameters:

• id (int64) – primary key The ID of this submission comment.

• comment (bounded_str | None) – The text of the submission comment.

• submission_id (submissions | None) – The ID of the associated submission.

• created_at (datetime) – The date this comment was created.

• updated_at (datetime) – The date this comment was updated.

• context_id (courses | None) – The ID of the course this comment is associated with.

• context_type (submission_comments__context_type) – The type of the object represented by context_id, typically Course.

• author_id (users | None) – The ID of the commenting user.

• media_comment_id (Annotated[str, MaxLength(255)] | None) – For media comments, the ID of the associated media object.

• media_comment_type (submission_comments__media_comment_type | None) – For media comments, the type of the associated media object.

• attachment_ids (bounded_str | None) – A comma-separated list of attachment IDs associated with this comment.

• attempt (int32 | None) – The particular attempt (on the associated submission) that this comment pertains to.

• hidden (bool) – True if this comment is not visible to the owner of the submission.

• author_name (Annotated[str, MaxLength(255)] | None) – The name of the commenting user.

• group_comment_id (Annotated[str, MaxLength(255)] | None) – For group assignments, a value that is unique for all copies of this comment on submissions in the same group.

• assessment_request_id (assessment_requests | None) – For peer-reviewed assignments, the ID of the Assessment Request this comment is associated with.

• anonymous (bool | None) – True if this is a peer-reviewed comment for an assignment with anonymous peer reviews enabled. Does not apply to instructor comments for anonymously-graded assignments.

• teacher_only_comment (bool) – Indicates whether the comment was provided by a teacher.

• provisional_grade_id (moderated_grading_provisional_grades | None) – For moderated assignments, the provisional grade this comment is tied to.

• draft (bool) – True if this comment was saved as a draft.

• edited_at (datetime | None) – The date this comment was last edited.

submission_versions

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

Parameters:

• id (int64) – primary key The ID of this version object.

• user_id (users | None) – The ID of the submitter.

• context_id (courses | None) – The ID of the course this submission belongs to.

• context_type (submission_versions__context_type) – The type of the context object (typically Course).

• assignment_id (assignments | None) – The ID of the associated assignment.

• version_id (versions | None) – The ID of the corresponding object in the versions table.

submissions

This table stores submission records for an assignment.

Parameters:

• id (int64) – primary key Primary key of this record in the Canvas submissions dataset.

• attachment_id (attachments | None) – The ID of an attachment belonging to this submission if submission_type is online_url. Generally superseded by attachment_ids.

• course_id (courses) – The ID of the associated assignment’s course.

• user_id (users) – The ID of the user who created the submission.

• created_at (datetime | None) – Timestamp of when the submission was created.

• updated_at (datetime | None) – Timestamp of when the submission was last updated.

• workflow_state (submissions__workflow_state) – Life-cycle state for the submission.

• assignment_id (assignments) – The ID of the associated assignment.

• media_comment_id (Annotated[str, MaxLength(255)] | None) – For media comments, the ID of the media object associated with this comment, as a string.

• media_comment_type (submissions__media_comment_type | None) – For media comments, the type of the media object associated with this comment.

• attachment_ids (bounded_str | None) – A comma-delimited string representing the IDs of attachments belonging to this submission.

• posted_at (datetime | None) – The date this submission was posted to the student, or NULL if it has not been posted.

• group_id (groups | None) – Foreign key to the groups table.

• score (float64 | None) – The raw score.

• attempt (int32 | None) – The number of attempts made including this one.

• submitted_at (datetime | None) – The timestamp when the assignment was submitted. Note: this date may be missing even though the assignment was submitted and graded (example scenarios: paper assignments, submissions through external tools, no submission required, etc.); additionally, if the student failed to submit an assignment by the due date, the assignment can be graded by the instructor (and will be missing a submitted_at date).

• quiz_submission_id (quiz_submissions | None) – Foreign key to the quiz_submissions dataset (if submission_type is online_quiz). If this field contains a value it means that the assignment is a quiz.

• extra_attempts (int32 | None) – Extra submission attempts allowed for the given user and assignment.

• grading_period_id (grading_periods | None) – The ID of the grading period that this submission’s assignment belongs to.

• grade (Annotated[str, MaxLength(255)] | None) – Letter grade mapped from the score by the grading scheme.

• submission_type (submissions__submission_type | None) – The type of submission.

• processed (bool | None) – Valid only when there is a file/attachment associated with the submission. By default, this attribute is set to false when making the assignment submission. When a submission has a file/attachment associated with it, upon submitting the assignment a snapshot is saved and its value is set to true. Defaults to NULL.

• grade_matches_current_submission (bool | None) – A boolean flag which is false if the student has re-submitted since the submission was last graded. Valid only when a score has been assigned to a submission. This is set to false if a student makes a new submission to an already graded assignment. This is done to indicate that the current grade given by the teacher is not for the most recent submission by the student. It is set to true if a score has been given and there is no new submission. Defaults to NULL.

• published_score (float64 | None) – The raw score (identical to score).

• published_grade (Annotated[str, MaxLength(255)] | None) – Valid only for a graded submission. The values are strings that reflect the grading type used. For example, a scoring method of points will show 4 if given a 4 out of 5, and a scoring method of letter grade will show B for the same score (assuming a grading scale where 80-90% is a B). Defaults to NULL.

• graded_at (datetime | None) – Timestamp of when the submission was graded.

• student_entered_score (float64 | None) – A “what-if” score that the student has entered for this submission.

• grader_id (users | None) – The ID of the user who graded the submission. This will be NULL for submissions that haven’t been graded yet. It will be a positive number if a real user has graded the submission and a negative number if the submission was graded by a process (e.g. Quiz auto-grader and auto-grading LTI tools). Specifically auto-graded quizzes set grader_id to the negative of the quiz ID. Submissions auto-graded by LTI tools set grader_id to the negative of the tool ID.

• submission_comments_count (int32 | None) – A count of the number of comments made on this submission.

• media_object_id (media_objects | None) – The ID of the associated MediaObject.

• turnitin_data (json | None) – A YAML string representing plagiarism data associated with this submission.

• cached_due_date (datetime | None) – The de-normalized cached due date for this submission.

• excused (bool | None) – Whether the assignment is excused. Excused assignments have no impact on a user’s grade.

• graded_anonymously (bool | None) – Denotes how the grading has been performed. Possible values are graded_anonymously and not_graded_anonymously.

• late_policy_status (Annotated[str, MaxLength(16)] | None) – The status of the submission in relation to the late policy. Only reflects statuses manually applied by a grader. Can be late, missing, none, or NULL.

• points_deducted (Annotated[Decimal, Precision(6, 2)] | None) – The amount of points automatically deducted from the score by the missing/late policy for a late or missing assignment.

• seconds_late_override (int64 | None) – For late submissions, the amount of time (in seconds) the submission is late by.

• lti_user_id (bounded_str | None) – The LTI context ID of the submitter.

• anonymous_id (Annotated[str, MaxLength(5)] | None) – A unique short ID identifying this submission without reference to the owning user.

• last_comment_at (datetime | None) – The date of the last non-draft comment on this submission by a user other than the submitter.

• cached_quiz_lti (bool) – True if the associated assignment is a Quizzes.Next assignment.

• cached_tardiness (Annotated[str, MaxLength(16)] | None) – The status of the submission in relation to the late policy, including automatically-applied statuses. Can be late, missing or NULL.

• resource_link_lookup_uuid (UUID | None) – When the submission is from an LTI tool, the resource link lookup ID is assigned to the submission in order to recover the custom parameters.

• redo_request (bool) – True if the assignment has been reassigned to the student for resubmission.

• body (bounded_str | None) – The content of the submission, if it was submitted directly in a text field.

• url (Annotated[str, MaxLength(255)] | None) – URL content for the submission.

user_account_associations

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

Parameters:

• id (int64) – primary key The ID of a record.

• user_id (users) – The foreign key for the users dataset.

• created_at (datetime) – Timestamp of when the user association with an account was created.

• updated_at (datetime) – Timestamp that shows the last time the record was updated.

• account_id (accounts) – Identifies the account associated with this user.

• depth (int32 | None) – How “close” a user is related to an account. 1 if you have a pseudonym or enrollment in a course in that account. 2 if it’s the parent account of a course you’re enrolled in, etc.

users

This table stores attributes for users.

Some users are from other Canvas instances (id column being > 10000000000000). Not all users are displayed in users list on UI.

Parameters:

• deleted_at (datetime | None) – Timestamp that shows when a user was deleted at.

• storage_quota (int64 | None) – The storage quota for the users.

• lti_context_id (Annotated[str, MaxLength(255)] | None) – UUID of the Canvas context in LTI standard. secondary ID for this context, could be used in API to identify resource as well.

• created_at (datetime) – Timestamp when the user was created in the Canvas system.

• updated_at (datetime) – Timestamp that shows the last time the record was updated.

• workflow_state (users__workflow_state) – Workflow status indicating the status of the user.

• sortable_name (Annotated[str, MaxLength(255)] | None) – The name of the user that is should be used for sorting groups of users, such as in the gradebook. Format: “lastname, firstname”.

• avatar_image_url (Annotated[str, MaxLength(255)] | None) – If avatars are enabled, this field will be included and contain a url to retrieve the user’s avatar.

• avatar_image_source (Annotated[str, MaxLength(255)] | None) – The source of a user avatar image.

• avatar_image_updated_at (datetime | None) – Timestamp that shows the last time the avatar image was updated.

• short_name (Annotated[str, MaxLength(255)] | None) – A short name the user has selected, for use in conversations or other less formal places through the site.

• last_logged_out (datetime | None) – The last time the user explicitly logged out of Canvas.

• pronouns (bounded_str | None) – stores a list of preferred gender pronouns i.e.: she/her; he/him; they/them.

• merged_into_user_id (users | None) – If this user was merged into another one, this is the foreign key to that other user.

• locale (Annotated[str, MaxLength(255)] | None) – The user’s locale. This is an optional field and may not be entered by the user.

• name (Annotated[str, MaxLength(255)] | None) – The name of the user (“firstname lastname” format).

• id (int64) – primary key The ID of the user.

• time_zone (Annotated[str, MaxLength(255)] | None) – This field is only returned in certain API calls, and will return the IANA time zone name of the user’s preferred timezone.

• uuid (Annotated[str, MaxLength(255)] | None) – UUID of the user.

• school_name (Annotated[str, MaxLength(255)] | None) – Used in Trial Versions of Canvas, the school the user is associated with.

• school_position (Annotated[str, MaxLength(255)] | None) – Used in Trial Versions of Canvas, the position the user has at the school. E.g. Admin

• public (bool | None) – Used in Trial Versions of Canvas, the type of school the user is associated with.

web_conference_participants

Links users to conferences they are invited to join.

Parameters:

• id (int64) – primary key The ID of the web conference participant.

• web_conference_id (web_conferences | None) – Foreign key to the web_conferences page.

• user_id (users | None) – Identifies the user who is the conference participant.

• created_at (datetime) – Timestamp when record was created.

• updated_at (datetime) – Timestamp when record was updated.

• participation_type (web_conference_participants__participation_type | None) – Type of participation e.g.: invitee or attendee.

web_conferences

Data model for Conferences in Canvas.

Integrates with external conferencing solutions like BigBlueButton.

Parameters:

• user_id (users | None) – The ID of the user that created the conference.

• created_at (datetime) – Timestamp when record was created.

• updated_at (datetime) – Timestamp when record was updated.

• context_id (courses | groups | accounts) – The ID of this conference’s context.

• context_type (web_conferences__context_type) – The type of this conference’s context.

• start_at (datetime | None) – The date the conference started at, NULL if it hasn’t started.

• end_at (datetime | None) – The date that the conference ended at, NULL if it hasn’t ended.

• context_code (Annotated[str, MaxLength(255)] | None) – A string identifying the context.

• started_at (datetime | None) – The time at which this conference actually started at, NULL if it hasn’t started.

• user_ids (Annotated[str, MaxLength(255)] | None) – Array of user ids that are participants in the conference.

• ended_at (datetime | None) – The time at which this conference actually ended, NULL if it hasn’t ended.

• recording_ready (bool | None) – Whether the conference’s recording has been processed.

• conference_type (web_conferences__conference_type) – The type of conference.

• conference_key (Annotated[str, MaxLength(255)] | None) – The 3rd party’s ID for the conference.

• description (bounded_str | None) – The description for the conference.

• duration (float64 | None) – The expected duration the conference is supposed to last.

• settings (json | None) – Settings for the given conference.

• id (int64) – primary key The ID of the conference.

• title (Annotated[str, MaxLength(255)]) – The title of the conference.

• uuid (Annotated[str, MaxLength(255)] | None) – A unique ID used for integrations.

wiki_pages

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

Also known as Pages. Pages store content and educational resources that are part of a course or group but don’t necessarily belong in an assignment. Pages can include text, video, and links to files and other course or group content. Pages can also be linked to other pages. They can also be used as a collaboration tool for course or group wikis where only specific users can have access. Canvas keeps the entire history of the page to account for changes over time.

Parameters:

• id (int64) – primary key The unique identifier of a wiki page record.

• user_id (users | None) – The unique ID of a user.

• created_at (datetime) – Timestamp showing when a wiki_pages record was created.

• updated_at (datetime) – Timestamp showing when a wiki_pages record was updated.

• workflow_state (wiki_pages__workflow_state) – The state of a wiki page.

• context_id (courses | groups) – The unique identifier for the context of wiki_pages (account, course, user).

• context_type (wiki_pages__context_type) – The type of the object represented by context_id.

• assignment_id (assignments | None) – Assignment identifier when using wiki_page assignment type for an assignment.

• migration_id (Annotated[str, MaxLength(255)] | None) – An identifier used by the Blueprint system to match with the blueprint content.

• wiki_id (wikis) – The unique identifier of an associated wiki record.

• old_assignment_id (assignments | None) – An old assignment identifier.

• todo_date (datetime | None) – Date to set when setting this page as student to-do.

• editing_roles (Annotated[str, MaxLength(255)] | None) – CSV list of the roles that are allowed to edit this page. Possible values are teachers, students, public.

• revised_at (datetime | None) – Timestamp showing when page was last revised.

• body (bounded_str | None) – The body of the wiki page record (includes html tags).

• url (bounded_str | None) – The HTML body of the page.

• title (Annotated[str, MaxLength(255)] | None) – The name of the wiki page record.

• protected_editing (bool) – Editing protection for the wiki page. It is false by default.

• could_be_locked (bool | None) – True if the wiki page can be locked. This prevents it from being visible to others until ready.

wikis

Links a course to its wiki pages.

There’s only ever one per course, it is not highly used any longer, Wiki pages object is linked directly to a course now.

Parameters:

• id (int64) – primary key The unique identifier of a wiki record.

• created_at (datetime) – Timestamp showing when a wikis record was created.

• updated_at (datetime) – Timestamp showing when a wikis record was updated.

• front_page_url (bounded_str | None) – Captures the URL of the front page (wiki page) record if one exists.

• has_no_front_page (bool | None) – Flag to determine if a course’s wiki has a front page or not. No front page == true.

• title (Annotated[str, MaxLength(255)] | None) – The title of the wiki.

Types in canvas namespace

access_tokens__workflow_state

Bases: Enum

Type for column access_tokens.workflow_state.

active = 'active'

deleted = 'deleted'

pending = 'pending'

unspecified = '_dap_unspecified_'

account_users__workflow_state

Bases: Enum

Type for column account_users.workflow_state.

active = 'active'

deleted = 'deleted'

unspecified = '_dap_unspecified_'

accounts__workflow_state

Bases: Enum

Type for column accounts.workflow_state.

active = 'active'

The only state an end customer will ever see.

deleted = 'deleted'

suspended = 'suspended'

A state only site admins can see.

unspecified = '_dap_unspecified_'

assessment_question_banks__context_type

Bases: Enum

Discriminator for column assessment_question_banks.context_type.

account = 'Account'

course = 'Course'

unspecified = '_dap_unspecified_'

assessment_question_banks__workflow_state

Bases: Enum

Type for column assessment_question_banks.workflow_state.

active = 'active'

deleted = 'deleted'

unspecified = '_dap_unspecified_'

assessment_questions__workflow_state

Bases: Enum

Type for column assessment_questions.workflow_state.

active = 'active'

independently_edited = 'independently_edited'

deleted = 'deleted'

unspecified = '_dap_unspecified_'

asset_user_accesses__context_type

Bases: Enum

Discriminator for column asset_user_accesses.context_type.

account = 'Account'

assessment_question = 'AssessmentQuestion'

course = 'Course'

group = 'Group'

user = 'User'

unspecified = '_dap_unspecified_'

asset_user_accesses__action_level

Bases: Enum

Type for column asset_user_accesses.action_level.

view = 'view'

participate = 'participate'

unspecified = '_dap_unspecified_'

asset_user_accesses__asset_category

Bases: Enum

Type for column asset_user_accesses.asset_category.

announcements = 'announcements'

assignments = 'assignments'

calendar_feed = 'calendar_feed'

collaborations = 'collaborations'

conferences = 'conferences'

files = 'files'

grades = 'grades'

home = 'home'

modules = 'modules'

outcomes = 'outcomes'

pages = 'pages'

quizzes = 'quizzes'

roster = 'roster'

speed_grader = 'speed_grader'

syllabus = 'syllabus'

topics = 'topics'

calendar = 'calendar'

external_tools = 'external_tools'

wiki = 'wiki'

external_urls = 'external_urls'

unspecified = '_dap_unspecified_'

asset_user_accesses__membership_type

Bases: Enum

Type for column asset_user_accesses.membership_type.

TeacherEnrollment = 'TeacherEnrollment'

AccountUser = 'AccountUser'

Other = 'Other'

User = 'User'

NilClass = 'NilClass'

TaEnrollment = 'TaEnrollment'

DesignerEnrollment = 'DesignerEnrollment'

ObserverEnrollment = 'ObserverEnrollment'

GroupMembership = 'GroupMembership'

StudentEnrollment = 'StudentEnrollment'

StudentViewEnrollment = 'StudentViewEnrollment'

unspecified = '_dap_unspecified_'

assignment_groups__context_type

Bases: Enum

Discriminator for column assignment_groups.context_type.

course = 'Course'

unspecified = '_dap_unspecified_'

assignment_groups__rules

Type extracted from column assignment_groups.rules.

Parameters:

• drop_highest (int32 | None) – Number of highest scores to be dropped for each user.

• drop_lowest (int32 | None) – Number of lowest scores to be dropped for each user.

• never_drop (List[int32]) – Assignment IDs that should never be dropped. E.g.: [33, 17, 24].

assignment_groups__workflow_state

Bases: Enum

Type for column assignment_groups.workflow_state.

available = 'available'

Equivalent to active state in other tables.

deleted = 'deleted'

active = 'active'

unspecified = '_dap_unspecified_'

assignment_override_students__workflow_state

Bases: Enum

Type for column assignment_override_students.workflow_state.

active = 'active'

deleted = 'deleted'

unspecified = '_dap_unspecified_'

assignment_overrides__set_type

Bases: Enum

Discriminator for column assignment_overrides.set_type.

Group = 'Group'

CourseSection = 'CourseSection'

ADHOC = 'ADHOC'

Noop = 'Noop'

Course = 'Course'

unspecified = '_dap_unspecified_'

assignment_overrides__workflow_state

Bases: Enum

Type for column assignment_overrides.workflow_state.

active = 'active'

deleted = 'deleted'

unspecified = '_dap_unspecified_'

assignments__workflow_state

Bases: Enum

Type for column assignments.workflow_state.

unpublished = 'unpublished'

published = 'published'

deleted = 'deleted'

duplicating = 'duplicating'

fail_to_import = 'fail_to_import'

failed_to_duplicate = 'failed_to_duplicate'

failed_to_import = 'failed_to_import'

failed_to_migrate = 'failed_to_migrate'

importing = 'importing'

migrating = 'migrating'

outcome_alignment_cloning = 'outcome_alignment_cloning'

failed_to_clone_outcome_alignment = 'failed_to_clone_outcome_alignment'

unspecified = '_dap_unspecified_'

assignments__context_type

Bases: Enum

Type for column assignments.context_type.

Course = 'Course'

unspecified = '_dap_unspecified_'

assignments__turnitin_settings__exclude_small_matches_type

Bases: Enum

Type for column assignments__turnitin_settings.exclude_small_matches_type.

off = 'off'

words = 'words'

percent = 'percent'

unspecified = '_dap_unspecified_'

assignments__turnitin_settings__originality_report_visibility

Bases: Enum

Type for column assignments__turnitin_settings.originality_report_visibility.

immediate = 'immediate'

after_grading = 'after_grading'

after_due_date = 'after_due_date'

never = 'never'

unspecified = '_dap_unspecified_'

assignments__turnitin_settings

Type extracted from column assignments.turnitin_settings.

Parameters:

• originality_report_visibility (assignments__turnitin_settings__originality_report_visibility | None) – Allows to set the timeframe when the report will become visible.

• exclude_small_matches_type (assignments__turnitin_settings__exclude_small_matches_type | None) – Exclude small sources from the Similarity Report by a set number of words or percentage.

• exclude_small_matches_value (int32 | None) – If exclude_small_matches_type is set to percent or number then the value will be will be a number (of words or a percent).

• s_paper_check (bool | None) – If set to TRUE, will allow to compare submission against other students’ papers.

• s_view_report (bool | None) – If set to TRUE students will be able to access their originality report.

• internet_check (bool | None) – Select the content you’d like to compare papers against: current and archived website content.

• journal_check (bool | None) – Select the content you’d like to compare papers against: periodicals, journals and publications.

• exclude_biblio (bool | None) – Selecting this option will exclude text appearing in the bibliography, works cited, or references sections of student papers from being checked for matches when generating Similarity Reports.

• exclude_quoted (bool | None) – Selecting this option will exclude text in student papers that is enclosed in quotation marks or is part of a block quotation (an indented block of text) from being checked for matches when generating Similarity Reports.

• submit_papers_to (bool | None) – If set to FALSE, a similarity report will still be generated for paper submissions but students’ papers will not be stored in the Turnitin standard paper repository or the institution’s paper repository for future comparison.

assignments__grading_type

Bases: Enum

Type for column assignments.grading_type.

gpa_scale = 'gpa_scale'

letter_grade = 'letter_grade'

not_graded = 'not_graded'

pass_fail = 'pass_fail'

percent = 'percent'

points = 'points'

default = 'default'

unspecified = '_dap_unspecified_'

assignments__submission_types

Bases: Enum

Type for column assignments.submission_types.

discussion_topic = 'discussion_topic'

online_quiz = 'online_quiz'

on_paper = 'on_paper'

none = 'none'

external_tool = 'external_tool'

online = 'online'

online_text_entry = 'online_text_entry'

online_url = 'online_url'

online_upload = 'online_upload'

media_recording = 'media_recording'

not_graded = 'not_graded'

wiki_page = 'wiki_page'

student_annotation = 'student_annotation'

default_external_tool = 'default_external_tool'

unspecified = '_dap_unspecified_'

assignments__type

Bases: Enum

Type for column assignments.type.

assignment = 'Assignment'

subassignment = 'SubAssignment'

unspecified = '_dap_unspecified_'

attachment_associations__context_type

Bases: Enum

Discriminator for column attachment_associations.context_type.

ConversationMessage = 'ConversationMessage'

Submission = 'Submission'

Course = 'Course'

Group = 'Group'

unspecified = '_dap_unspecified_'

attachments__workflow_state

Bases: Enum

Type for column attachments.workflow_state.

deleted = 'deleted'

errored = 'errored'

pending_upload = 'pending_upload'

processed = 'processed'

processing = 'processing'

to_be_zipped = 'to_be_zipped'

unattached = 'unattached'

unattached_temporary = 'unattached_temporary'

zipped = 'zipped'

zipping = 'zipping'

unspecified = '_dap_unspecified_'

attachments__context_type

Bases: Enum

Type for column attachments.context_type.

Account = 'Account'

AssessmentQuestion = 'AssessmentQuestion'

Assignment = 'Assignment'

Attachment = 'Attachment'

ContentExport = 'ContentExport'

ContentMigration = 'ContentMigration'

Course = 'Course'

Eportfolio = 'Eportfolio'

EpubExport = 'EpubExport'

Folder = 'Folder'

GradebookUpload = 'GradebookUpload'

Group = 'Group'

GroupAndMembershipImporter = 'GroupAndMembershipImporter'

OutcomeImport = 'OutcomeImport'

Purgatory = 'Purgatory'

Quizzes__Quiz = 'Quizzes::Quiz'

Quizzes__QuizStatistics = 'Quizzes::QuizStatistics'

Quizzes__QuizSubmission = 'Quizzes::QuizSubmission'

SisBatch = 'SisBatch'

Submission = 'Submission'

User = 'User'

unspecified = '_dap_unspecified_'

attachments__file_state

Bases: Enum

Type for column attachments.file_state.

unpublished = 'unpublished'

published = 'published'

deleted = 'deleted'

available = 'available'

hidden = 'hidden'

errored = 'errored'

broken = 'broken'

public = 'public'

unspecified = '_dap_unspecified_'

calendar_events__context_type

Bases: Enum

Discriminator for column calendar_events.context_type.

AppointmentGroup = 'AppointmentGroup'

Course = 'Course'

CourseSection = 'CourseSection'

Group = 'Group'

User = 'User'

Account = 'Account'

unspecified = '_dap_unspecified_'

calendar_events__workflow_state

Bases: Enum

Type for column calendar_events.workflow_state.

active = 'active'

locked = 'locked'

Indicates that start_at/end_at cannot be changed (though the event could be deleted). Normally only reservations or time slots with reservations are locked (see the Appointment Groups API).

deleted = 'deleted'

unspecified = '_dap_unspecified_'

comment_bank_items__workflow_state

Bases: Enum

Type for column comment_bank_items.workflow_state.

active = 'active'

Default value.

deleted = 'deleted'

unspecified = '_dap_unspecified_'

communication_channels__workflow_state

Bases: Enum

Type for column communication_channels.workflow_state.

unconfirmed = 'unconfirmed'

active = 'active'

retired = 'retired'

unspecified = '_dap_unspecified_'

communication_channels__path_type

Bases: Enum

Type for column communication_channels.path_type.

email = 'email'

push = 'push'

slack = 'slack'

sms = 'sms'

twitter = 'twitter'

unspecified = '_dap_unspecified_'

content_migrations__workflow_state

Bases: Enum

Type for column content_migrations.workflow_state.

created = 'created'

exported = 'exported'

exporting = 'exporting'

failed = 'failed'

imported = 'imported'

importing = 'importing'

pre_process_error = 'pre_process_error'

pre_processed = 'pre_processed'

pre_processing = 'pre_processing'

queued = 'queued'

unspecified = '_dap_unspecified_'

content_migrations__context_type

Bases: Enum

Discriminator for column content_migrations.context_type.

Course = 'Course'

Account = 'Account'

Group = 'Group'

User = 'User'

unspecified = '_dap_unspecified_'

content_participation_counts__context_type

Bases: Enum

Discriminator for column content_participation_counts.context_type.

Course = 'Course'

unspecified = '_dap_unspecified_'

content_participation_counts__content_type

Bases: Enum

Discriminator for column content_participation_counts.content_type.

Submission = 'Submission'

unspecified = '_dap_unspecified_'

content_participations__content_type

Bases: Enum

Discriminator for column content_participations.content_type.

Submission = 'Submission'

unspecified = '_dap_unspecified_'

content_participations__workflow_state

Bases: Enum

Type for column content_participations.workflow_state.

read = 'read'

unread = 'unread'

unspecified = '_dap_unspecified_'

content_shares__type

Bases: Enum

Type for column content_shares.type.

SentContentShare = 'SentContentShare'

ReceivedContentShare = 'ReceivedContentShare'

unspecified = '_dap_unspecified_'

content_shares__read_state

Bases: Enum

Type for column content_shares.read_state.

read = 'read'

unread = 'unread'

unspecified = '_dap_unspecified_'

content_tags__workflow_state

Bases: Enum

Type for column content_tags.workflow_state.

active = 'active'

unpublished = 'unpublished'

deleted = 'deleted'

unspecified = '_dap_unspecified_'

content_tags__context_type

Bases: Enum

Type for column content_tags.context_type.

Account = 'Account'

Assignment = 'Assignment'

Course = 'Course'

LearningOutcomeGroup = 'LearningOutcomeGroup'

Quizzes__Quiz = 'Quizzes::Quiz'

User = 'User'

unspecified = '_dap_unspecified_'

content_tags__tag_type

Bases: Enum

Type for column content_tags.tag_type.

context_module = 'context_module'

indicates that the content object is a module item in a course (context_type will have a value of Course); the id value in the content_tags table may also be referred to as item_id; there will be a value in the context_module_id which indicates which module this content object appears under

default = 'default'

learning_outcome = 'learning_outcome'

indicates that the content object is aligned with a learning outcome (there will be a value in the learning_outcome_id field)

learning_outcome_association = 'learning_outcome_association'

with this value, the record will also have a value in the associated_asset_id and associated_asset_type fields; means that the content object is under a learning outcome folder (i.e. Learning Outcome Group)

unspecified = '_dap_unspecified_'

content_tags__associated_asset_type

Bases: Enum

Type for column content_tags.associated_asset_type.

LearningOutcomeGroup = 'LearningOutcomeGroup'

Lti__ResourceLink = 'Lti::ResourceLink'

unspecified = '_dap_unspecified_'

content_tags__content_type

Bases: Enum

Type for column content_tags.content_type.

Announcement = 'Announcement'

AssessmentQuestionBank = 'AssessmentQuestionBank'

Assignment = 'Assignment'

Attachment = 'Attachment'

ContextExternalTool = 'ContextExternalTool'

ContextModuleSubHeader = 'ContextModuleSubHeader'

DiscussionTopic = 'DiscussionTopic'

ExternalUrl = 'ExternalUrl'

LearningOutcome = 'LearningOutcome'

LearningOutcomeGroup = 'LearningOutcomeGroup'

LiveAssessments__Assessment = 'LiveAssessments::Assessment'

Lti__MessageHandler = 'Lti::MessageHandler'

Quizzes__Quiz = 'Quizzes::Quiz'

Rubric = 'Rubric'

WikiPage = 'WikiPage'

unspecified = '_dap_unspecified_'

context_external_tools__workflow_state

Bases: Enum

Type for column context_external_tools.workflow_state.

anonymous = 'anonymous'

no identifying information about the user will be sent to the vendor

deleted = 'deleted'

disabled = 'disabled'

email_only = 'email_only'

the user’s email is the only identifying information sent to the vendor

name_only = 'name_only'

the user’s name is the only identifying information sent to the vendor

public = 'public'

various identifying information (name, email, Canvas ID, SIS ID of the course, SIS ID of the user, etc.) is sent to the vendor

unspecified = '_dap_unspecified_'

context_external_tools__context_type

Bases: Enum

Type for column context_external_tools.context_type.

Account = 'Account'

Course = 'Course'

unspecified = '_dap_unspecified_'

context_external_tools__settings

Type extracted from column context_external_tools.settings.

Parameters:

• course_home_sub_navigation (str | None) – Course home sub navigation placement type.

• course_settings_sub_navigation (str | None) – Course settings sub navigation placement type.

• custom_fields (str | None) – Custom parameters provider request to share on every single LTI launch, each placement column might have its own set of custom_fields.

• discussion_menu (str | None) – Discussion menu placement type.

• discussion_topic_index_menu (str | None) – Discussion topic index menu placement type.

• discussion_topic_menu (str | None) – Discussion topic menu placement type.

• editor_button (str | None) – RCE placement type.

• enabled (str | None) – Controls if the tool is disabled for user to click on, typically tool gets removed altogether but sometimes provider uses this setting to just disable it in the UI.

• file_index_menu (str | None) – File index menu placement type.

• file_menu (str | None) – File menu placement type.

• global_navigation (str | None) – Global navigation placement type.

• grade_passback (str | None) – Grade pass-back placement type.

• homework_selection (str | None) – Homework selection placement type.

• homework_submission (str | None) – Homework submission placement type.

• launch_presentation_document_target (str | None) – Tells us if it should be opened in another window.

• link_selection (str | None) – Link selection placement type.

• migration_selection (str | None) – Migration selection placement type.

• module_group_menu (str | None) – Module group menu placement type.

• module_index_menu (str | None) – Module index menu placement type.

• account_navigation (str | None) – account navigation placement type.

• assignment_group_menu (str | None) – Assignment group menu placement type.

• assignment_index_menu (str | None) – Assignment index menu placement type.

• assignment_menu (str | None) – Assignment menu placement type.

• assignment_selection (str | None) – Assignment selection placement type.

• canvas_caliper_url (str | None) – URL to caliper endpoint if supported by the tool.

• collaboration (str | None) – Collaboration placement type.

• content_migration (str | None) – Content migration placement type.

• course_assignments_menu (str | None) – Course assignments menu placement type.

• course_navigation (str | None) – Course navigation placement type.

• module_menu (str | None) – Module menu placement type.

• post_grades (str | None) – Post grades placement type.

• quiz_index_menu (str | None) – Quiz index menu placement type.

• quiz_menu (str | None) – Quiz menu placement type.

• similarity_detection (str | None) – Plagiarism platform placement.

• student_context_card (str | None) – Student context card placement type.

• text (str | None) – Identifies the name of the tool, default what the user can see if no label is set.

• tool_configuration (str | None) – Identifies the LTI tool configuration dataset.

• use_1_3 (str | None) – LTI 1.3 compliant tool.

• user_navigation (str | None) – User navigation placement type.

• visibility (str | None) – Controls if it is an admin only tool, takes values of admin and members.

• wiki_index_menu (str | None) – Wiki index menu placement type.

• wiki_page_menu (str | None) – Wiki page menu placement type.

context_module_progressions__workflow_state

Bases: Enum

Type for column context_module_progressions.workflow_state.

completed = 'completed'

locked = 'locked'

started = 'started'

unlocked = 'unlocked'

unspecified = '_dap_unspecified_'

context_modules__workflow_state

Bases: Enum

Type for column context_modules.workflow_state.

active = 'active'

deleted = 'deleted'

unpublished = 'unpublished'

unspecified = '_dap_unspecified_'

context_modules__context_type

Bases: Enum

Type for column context_modules.context_type.

Course = 'Course'

unspecified = '_dap_unspecified_'

conversation_message_participants__workflow_state

Bases: Enum

Type for column conversation_message_participants.workflow_state.

active = 'active'

deleted = 'deleted'

unspecified = '_dap_unspecified_'

conversation_messages__context_type

Bases: Enum

Type for column conversation_messages.context_type.

Account = 'Account'

unspecified = '_dap_unspecified_'

conversation_messages__asset_type

Bases: Enum

Type for column conversation_messages.asset_type.

Submission = 'Submission'

unspecified = '_dap_unspecified_'

conversation_messages__media_comment_type

Bases: Enum

Type for column conversation_messages.media_comment_type.

audio = 'audio'

audio2 = 'audio/*'

video = 'video'

video2 = 'video/*'

audio_aac = 'audio/aac'

audio_amr = 'audio/amr'

audio_flac = 'audio/flac'

audio_mp4 = 'audio/mp4'

audio_mpeg = 'audio/mpeg'

audio_ogg = 'audio/ogg'

audio_vnd_dlna_adts = 'audio/vnd.dlna.adts'

audio_wav = 'audio/wav'

audio_webm = 'audio/webm'

audio_xm4a = 'audio/x-m4a'

audio_xmswma = 'audio/x-ms-wma'

audio_xwav = 'audio/x-wav'

video_3gpp = 'video/3gpp'

video_avi = 'video/avi'

video_mp4 = 'video/mp4'

video_mpeg = 'video/mpeg'

video_ogg = 'video/ogg'

video_quicktime = 'video/quicktime'

video_webm = 'video/webm'

video_xm4v = 'video/x-m4v'

video_xmatroska = 'video/x-matroska'

video_xmsasf = 'video/x-ms-asf'

video_xmswmv = 'video/x-ms-wmv'

video_xmsvideo = 'video/x-msvideo'

unspecified = '_dap_unspecified_'

conversation_participants__workflow_state

Bases: Enum

Type for column conversation_participants.workflow_state.

read = 'read'

unread = 'unread'

archived = 'archived'

deleted = 'deleted'

unspecified = '_dap_unspecified_'

conversations__context_type

Bases: Enum

Type for column conversations.context_type.

Course = 'Course'

the sender selected a course when composing the message

Group = 'Group'

the sender selected a group when composing the message

Account = 'Account'

the sender did not select a course or group when composing the message

unspecified = '_dap_unspecified_'

course_sections__workflow_state

Bases: Enum

Type for column course_sections.workflow_state.

active = 'active'

deleted = 'deleted'

unspecified = '_dap_unspecified_'

courses__workflow_state

Bases: Enum

Type for column courses.workflow_state.

created = 'created'

course created by admin, no teacher assigned yet

claimed = 'claimed'

teacher has been assigned to course or course created by teacher (not published)

available = 'available'

published

completed = 'completed'

course manually marked as completed

deleted = 'deleted'

course manually deleted (possibly created in error; sometimes admin and instructors delete courses to clear from their list); note: if a course is deleted it won’t necessarily delete the wiki pages, but does cascade to enrollments

unspecified = '_dap_unspecified_'

courses__settings

Type extracted from column courses.settings.

Parameters:

• allow_student_discussion_editing (str | None) – Let students edit or delete their own discussion posts.

• allow_student_discussion_topics (str | None) – Let students create discussion topics.

• course_format (str | None) – Format of a course, values include blended, on_campus, online.

• filter_speed_grader_by_student_group (str | None) – Filter SpeedGrader by student group.

• hide_distribution_graphs (str | None) – Hide grade distribution graphs from students.

• hide_final_grade (str | None) – Hide totals in student grades summary.

• is_public_to_auth_users (str | None) – Set to true if course is public only to authenticated users.

• lock_all_announcements (str | None) – Disable comments on announcements.

• public_syllabus (str | None) – Set to true to make the course syllabus public. Values include true, false.

• public_syllabus_to_auth (str | None) – Set to true to make the course syllabus public for authenticated users.

• restrict_student_future_view (str | None) – Restrict students from viewing courses before start date.

• restrict_student_past_view (str | None) – Restrict students from viewing courses after end date.

• syllabus_updated_at (str | None) – Timestamp when syllabus was updated in a course.

• usage_rights_required (str | None) – Copyright and license information must be provided for files before they are published.

• allow_student_forum_attachments (str | None) – Whether students can attach files to discussions.

custom_gradebook_columns__workflow_state

Bases: Enum

Type for column custom_gradebook_columns.workflow_state.

active = 'active'

hidden = 'hidden'

deleted = 'deleted'

unspecified = '_dap_unspecified_'

developer_key_account_bindings__workflow_state

Bases: Enum

Type for column developer_key_account_bindings.workflow_state.

on = 'on'

allow = 'allow'

off = 'off'

deleted = 'deleted'

unspecified = '_dap_unspecified_'

developer_keys__workflow_state

Bases: Enum

Type for column developer_keys.workflow_state.

active = 'active'

deleted = 'deleted'

inactive = 'inactive'

unspecified = '_dap_unspecified_'

discussion_entries__workflow_state

Bases: Enum

Type for column discussion_entries.workflow_state.

active = 'active'

deleted = 'deleted'

unspecified = '_dap_unspecified_'

discussion_entry_participants__workflow_state

Bases: Enum

Type for column discussion_entry_participants.workflow_state.

read = 'read'

unread = 'unread'

unspecified = '_dap_unspecified_'

discussion_topic_participants__workflow_state

Bases: Enum

Type for column discussion_topic_participants.workflow_state.

read = 'read'

unread = 'unread'

unspecified = '_dap_unspecified_'

discussion_topics__type

Bases: Enum

Type for column discussion_topics.type.

Announcement = 'Announcement'

unspecified = '_dap_unspecified_'

discussion_topics__workflow_state

Bases: Enum

Type for column discussion_topics.workflow_state.

active = 'active'

displayed to any user in the course

deleted = 'deleted'

locked = 'locked'

post_delayed = 'post_delayed'

discussion created, but set to go live at a certain date

unpublished = 'unpublished'

created but not yet published (draft state)

unspecified = '_dap_unspecified_'

discussion_topics__context_type

Bases: Enum

Type for column discussion_topics.context_type.

Course = 'Course'

entire class can participate

Group = 'Group'

only people in the group can participate

unspecified = '_dap_unspecified_'

discussion_topics__discussion_type

Bases: Enum

Type for column discussion_topics.discussion_type.

side_comment = 'side_comment'

The same as not_threaded. This value is obsolete.

threaded = 'threaded'

Allows replies within replies. Maximum depth of replies is 3.

not_threaded = 'not_threaded'

Prevent users from replying to replies, only to the original topic.

unspecified = '_dap_unspecified_'

enrollment_dates_overrides__context_type

Bases: Enum

Discriminator for column enrollment_dates_overrides.context_type.

Account = 'Account'

unspecified = '_dap_unspecified_'

enrollment_dates_overrides__enrollment_type

Bases: Enum

Type for column enrollment_dates_overrides.enrollment_type.

DesignerEnrollment = 'DesignerEnrollment'

StudentEnrollment = 'StudentEnrollment'

TaEnrollment = 'TaEnrollment'

TeacherEnrollment = 'TeacherEnrollment'

unspecified = '_dap_unspecified_'

enrollment_states__state

Bases: Enum

Type for column enrollment_states.state.

active = 'active'

invited = 'invited'

creation_pending = 'creation_pending'

deleted = 'deleted'

rejected = 'rejected'

completed = 'completed'

inactive = 'inactive'

current_and_invited = 'current_and_invited'

current_and_future = 'current_and_future'

current_and_concluded = 'current_and_concluded'

pending_active = 'pending_active'

pending_invited = 'pending_invited'

unspecified = '_dap_unspecified_'

enrollment_terms__workflow_state

Bases: Enum

Type for column enrollment_terms.workflow_state.

active = 'active'

deleted = 'deleted'

unspecified = '_dap_unspecified_'

enrollments__workflow_state

Bases: Enum

Type for column enrollments.workflow_state.

creation_pending = 'creation_pending'

created but user hasn’t logged in yet

invited = 'invited'

admin added student through sis

rejected = 'rejected'

student rejected invite

active = 'active'

user can fully participate in course

inactive = 'inactive'

hard state (i.e., tuition not paid or user drops course); user can no longer access course content

completed = 'completed'

manually marked as completed (conclude this enrollment button); user can only view course in read-only format

deleted = 'deleted'

enrollment removed from course (soft-deleted, so users with admin permissions can include in reports)

unspecified = '_dap_unspecified_'

enrollments__type

Bases: Enum

Type for column enrollments.type.

StudentEnrollment = 'StudentEnrollment'

TeacherEnrollment = 'TeacherEnrollment'

TaEnrollment = 'TaEnrollment'

DesignerEnrollment = 'DesignerEnrollment'

ObserverEnrollment = 'ObserverEnrollment'

StudentViewEnrollment = 'StudentViewEnrollment'

this role is typically used by course designers or instructors to view the course as a student would see it

unspecified = '_dap_unspecified_'

favorites__context_type

Bases: Enum

Discriminator for column favorites.context_type.

Course = 'Course'

Group = 'Group'

unspecified = '_dap_unspecified_'

folders__context_type

Bases: Enum

Discriminator for column folders.context_type.

Account = 'Account'

Course = 'Course'

Group = 'Group'

User = 'User'

unspecified = '_dap_unspecified_'

folders__workflow_state

Bases: Enum

Type for column folders.workflow_state.

active = 'active'

deleted = 'deleted'

hidden = 'hidden'

private = 'private'

visible = 'visible'

unspecified = '_dap_unspecified_'

folders__unique_type

Bases: Enum

Type for column folders.unique_type.

media = 'media'

sadocs = 'student annotation documents'

imicons = 'icon maker icons'

baicons = 'buttons and icons'

unspecified = '_dap_unspecified_'

grading_period_groups__workflow_state

Bases: Enum

Type for column grading_period_groups.workflow_state.

active = 'active'

deleted = 'deleted'

unspecified = '_dap_unspecified_'

grading_periods__workflow_state

Bases: Enum

Type for column grading_periods.workflow_state.

active = 'active'

deleted = 'deleted'

unspecified = '_dap_unspecified_'

grading_standards__context_type

Bases: Enum

Discriminator for column grading_standards.context_type.

Account = 'Account'

Course = 'Course'

unspecified = '_dap_unspecified_'

grading_standards__workflow_state

Bases: Enum

Type for column grading_standards.workflow_state.

active = 'active'

deleted = 'deleted'

archived = 'archived'

unspecified = '_dap_unspecified_'

group_categories__context_type

Bases: Enum

Discriminator for column group_categories.context_type.

Account = 'Account'

Course = 'Course'

unspecified = '_dap_unspecified_'

group_categories__role

Bases: Enum

Type for column group_categories.role.

communities = 'communities'

student_organized = 'student_organized'

imported = 'imported'

unspecified = '_dap_unspecified_'

group_memberships__workflow_state

Bases: Enum

Type for column group_memberships.workflow_state.

accepted = 'accepted'

deleted = 'deleted'

invited = 'invited'

rejected = 'rejected'

requested = 'requested'

unspecified = '_dap_unspecified_'

groups__workflow_state

Bases: Enum

Type for column groups.workflow_state.

available = 'available'

deleted = 'deleted'

active = 'active'

unspecified = '_dap_unspecified_'

groups__context_type

Bases: Enum

Type for column groups.context_type.

Account = 'Account'

Course = 'Course'

unspecified = '_dap_unspecified_'

groups__default_view

Bases: Enum

Type for column groups.default_view.

feed = 'feed'

unspecified = '_dap_unspecified_'

learning_outcome_groups__workflow_state

Bases: Enum

Type for column learning_outcome_groups.workflow_state.

active = 'active'

deleted = 'deleted'

unspecified = '_dap_unspecified_'

learning_outcome_groups__context_type

Bases: Enum

Type for column learning_outcome_groups.context_type.

Account = 'Account'

Course = 'Course'

College = 'College'

Department = 'Department'

unspecified = '_dap_unspecified_'

learning_outcome_question_results__associated_asset_type

Bases: Enum

Discriminator for column learning_outcome_question_results.associated_asset_type.

AssessmentQuestion = 'AssessmentQuestion'

unspecified = '_dap_unspecified_'

learning_outcome_results__context_type

Bases: Enum

Type for column learning_outcome_results.context_type.

Course = 'Course'

unspecified = '_dap_unspecified_'

learning_outcome_results__associated_asset_type

Bases: Enum

Discriminator for column learning_outcome_results.associated_asset_type.

AssessmentQuestion = 'AssessmentQuestion'

LiveAssessments__Assessment = 'LiveAssessments::Assessment'

Assignment = 'Assignment'

Quizzes__Quiz = 'Quizzes::Quiz'

unspecified = '_dap_unspecified_'

learning_outcome_results__association_type

Bases: Enum

Discriminator for column learning_outcome_results.association_type.

Assignment = 'Assignment'

Quizzes__Quiz = 'Quizzes::Quiz'

RubricAssociation = 'RubricAssociation'

unspecified = '_dap_unspecified_'

learning_outcome_results__artifact_type

Bases: Enum

Discriminator for column learning_outcome_results.artifact_type.

LiveAssessments__Submission = 'LiveAssessments::Submission'

Quizzes__QuizSubmission = 'Quizzes::QuizSubmission'

RubricAssessment = 'RubricAssessment'

Submission = 'Submission'

unspecified = '_dap_unspecified_'

learning_outcome_results__workflow_state

Bases: Enum

Type for column learning_outcome_results.workflow_state.

active = 'active'

deleted = 'deleted'

unspecified = '_dap_unspecified_'

learning_outcomes__workflow_state

Bases: Enum

Type for column learning_outcomes.workflow_state.

active = 'active'

deleted = 'deleted'

retired = 'retired'

unspecified = '_dap_unspecified_'

learning_outcomes__context_type

Bases: Enum

Type for column learning_outcomes.context_type.

Account = 'Account'

Course = 'Course'

unspecified = '_dap_unspecified_'

learning_outcomes__calculation_method

Bases: Enum

Type for column learning_outcomes.calculation_method.

decaying_average = 'decaying_average'

average = 'average'

highest = 'highest'

latest = 'latest'

n_mastery = 'n_mastery'

weighted_average = 'weighted_average'

standard_decaying_average = 'standard_decaying_average'

unspecified = '_dap_unspecified_'

lti_line_items__workflow_state

Bases: Enum

Type for column lti_line_items.workflow_state.

active = 'active'

deleted = 'deleted'

unspecified = '_dap_unspecified_'

lti_resource_links__context_type

Bases: Enum

Discriminator for column lti_resource_links.context_type.

Account = 'Account'

Assignment = 'Assignment'

Course = 'Course'

Group = 'Group'

unspecified = '_dap_unspecified_'

lti_resource_links__workflow_state

Bases: Enum

Type for column lti_resource_links.workflow_state.

active = 'active'

deleted = 'deleted'

unspecified = '_dap_unspecified_'

lti_results__workflow_state

Bases: Enum

Type for column lti_results.workflow_state.

active = 'active'

deleted = 'deleted'

unspecified = '_dap_unspecified_'

master_courses_child_content_tags__content_type

Bases: Enum

Discriminator for column master_courses_child_content_tags.content_type.

AssessmentQuestionBank = 'AssessmentQuestionBank'

Assignment = 'Assignment'

AssignmentGroup = 'AssignmentGroup'

Attachment = 'Attachment'

CalendarEvent = 'CalendarEvent'

ContextExternalTool = 'ContextExternalTool'

ContextModule = 'ContextModule'

ContentTag = 'ContentTag'

CoursePace = 'CoursePace'

DiscussionTopic = 'DiscussionTopic'

LearningOutcome = 'LearningOutcome'

LearningOutcomeGroup = 'LearningOutcomeGroup'

Rubric = 'Rubric'

Wiki = 'Wiki'

WikiPage = 'WikiPage'

Quizzes__Quiz = 'Quizzes::Quiz'

unspecified = '_dap_unspecified_'

master_courses_child_subscriptions__workflow_state

Bases: Enum

Type for column master_courses_child_subscriptions.workflow_state.

active = 'active'

deleted = 'deleted'

unspecified = '_dap_unspecified_'

master_courses_master_content_tags__content_type

Bases: Enum

Discriminator for column master_courses_master_content_tags.content_type.

AssessmentQuestionBank = 'AssessmentQuestionBank'

Assignment = 'Assignment'

AssignmentGroup = 'AssignmentGroup'

Attachment = 'Attachment'

CalendarEvent = 'CalendarEvent'

ContextExternalTool = 'ContextExternalTool'

ContextModule = 'ContextModule'

ContentTag = 'ContentTag'

CoursePace = 'CoursePace'

DiscussionTopic = 'DiscussionTopic'

LearningOutcome = 'LearningOutcome'

Rubric = 'Rubric'

Wiki = 'Wiki'

WikiPage = 'WikiPage'

Quizzes__Quiz = 'Quizzes::Quiz'

MediaTrack = 'MediaTrack'

unspecified = '_dap_unspecified_'

master_courses_master_migrations__workflow_state

Bases: Enum

Type for column master_courses_master_migrations.workflow_state.

completed = 'completed'

created = 'created'

exporting = 'exporting'

exports_failed = 'exports_failed'

imports_failed = 'imports_failed'

imports_queued = 'imports_queued'

queued = 'queued'

unspecified = '_dap_unspecified_'

master_courses_master_templates__workflow_state

Bases: Enum

Type for column master_courses_master_templates.workflow_state.

active = 'active'

deleted = 'deleted'

unspecified = '_dap_unspecified_'

master_courses_migration_results__import_type

Bases: Enum

Type for column master_courses_migration_results.import_type.

full = 'full'

selective = 'selective'

unspecified = '_dap_unspecified_'

master_courses_migration_results__state

Bases: Enum

Type for column master_courses_migration_results.state.

failed = 'failed'

completed = 'completed'

queued = 'queued'

unspecified = '_dap_unspecified_'

originality_reports__workflow_state

Bases: Enum

Type for column originality_reports.workflow_state.

error = 'error'

pending = 'pending'

scored = 'scored'

unspecified = '_dap_unspecified_'

outcome_proficiencies__context_type

Bases: Enum

Discriminator for column outcome_proficiencies.context_type.

Account = 'Account'

Course = 'Course'

unspecified = '_dap_unspecified_'

outcome_proficiencies__workflow_state

Bases: Enum

Type for column outcome_proficiencies.workflow_state.

active = 'active'

deleted = 'deleted'

unspecified = '_dap_unspecified_'

outcome_proficiency_ratings__workflow_state

Bases: Enum

Type for column outcome_proficiency_ratings.workflow_state.

active = 'active'

deleted = 'deleted'

unspecified = '_dap_unspecified_'

pseudonyms__workflow_state

Bases: Enum

Type for column pseudonyms.workflow_state.

active = 'active'

deleted = 'deleted'

suspended = 'suspended'

unspecified = '_dap_unspecified_'

quiz_questions__question_data__regrade_option

Bases: Enum

Type for regrade_option extracted from column quiz_questions.question_data.

available = 'available'

unavailable = 'unavailable'

multiple_answers_question = 'multiple_answers_question'

multiple_choice_question = 'multiple_choice_question'

true_false_question = 'true_false_question'

current_and_previous_correct = 'current_and_previous_correct'

no_regrade = 'no_regrade'

current_correct_only = 'current_correct_only'

full_credit = 'full_credit'

disabled = 'disabled'

unspecified = '_dap_unspecified_'

quiz_questions__question_data

Type extracted from column quiz_questions.question_data.

Parameters:

• neutral_comments (str | None) – Comments to be displayed regardless of how the student answers the question.

• answers (str | None) – Collection of possible answers.

• name (str | None) – Name of the question.

• question_type (str | None) – Denotes the type of the question.

• question_text (str | None) – Text of the question.

• regrade_option (quiz_questions__question_data__regrade_option | None) – Denotes if regrading is available for the question. Possible values are available and unavailable for question types. Defaults to available for the allowed question types and NULL for the rest.

• correct_comments (str | None) – Comments to be displayed if the student answers the question correctly.

• incorrect_comments (str | None) – Comments to be displayed if the student answers the question incorrectly.

• text_after_answers (str | None) – (Used in short_answer_question, also known as fill_in_the_blank. Omitted for other question types.) Text following the missing word.

• matching_answer_incorrect_matches (str | None) – (Used in matching_question. Omitted for other question types.) List of distractors (incorrect answers), delimited by new lines, that will be seeded with all the answer_match_right values.

• points_possible (float64 | None) – Maximum number of points that can be awarded for answering the question correctly.

quiz_questions__workflow_state

Bases: Enum

Type for column quiz_questions.workflow_state.

active = 'active'

deleted = 'deleted'

generated = 'generated'

unspecified = '_dap_unspecified_'

quiz_submissions__workflow_state

Bases: Enum

Type for column quiz_submissions.workflow_state.

complete = 'complete'

pending_review = 'pending_review'

denotes that a manual submission has been made by the student which has not been completely graded yet. This usually happens when one or more questions in the quiz cannot be autograded (e.g. essay_question type questions)

preview = 'preview'

when a Teacher or Admin previews a quiz (even a partial one)

settings_only = 'settings_only'

pertains only to quiz moderation events (stores the settings to create and store moderation events before the student has begun an attempt)

untaken = 'untaken'

default value; a quiz submission is recorded as soon as a student starts the quiz-taking process (before even answering the first question)

unspecified = '_dap_unspecified_'

quizzes__workflow_state

Bases: Enum

Type for column quizzes.workflow_state.

created = 'created'

quiz created, but no further actions have been taken

edited = 'edited'

after the teacher makes edits to quiz

unpublished = 'unpublished'

teacher unpublished a published quiz

deleted = 'deleted'

available = 'available'

published and available

unspecified = '_dap_unspecified_'

quizzes__context_type

Bases: Enum

Type for column quizzes.context_type.

Course = 'Course'

unspecified = '_dap_unspecified_'

quizzes__quiz_type

Bases: Enum

Type for column quizzes.quiz_type.

assignment = 'assignment'

appears as Graded Quiz in the UI (a column is created in the grade book for any graded quizzes)

practice_quiz = 'practice_quiz'

appears as Practice Quiz in the UI (students do not receive a grade for practice quizzes)

graded_survey = 'graded_survey'

appears as Graded Survey in the UI (allows instructor to give students points for completing the survey, but it does not allow the survey to be graded for right or wrong answers)

survey = 'survey'

appears as Ungraded Survey in the UI (students do not receive a grade for their responses)

unspecified = '_dap_unspecified_'

role_overrides__context_type

Bases: Enum

Discriminator for column role_overrides.context_type.

Account = 'Account'

unspecified = '_dap_unspecified_'

roles__workflow_state

Bases: Enum

Type for column roles.workflow_state.

active = 'active'

built_in = 'built_in'

default roles that are included in each Canvas shard

deleted = 'deleted'

inactive = 'inactive'

unspecified = '_dap_unspecified_'

roles__base_role_type

Bases: Enum

Type for column roles.base_role_type.

AccountAdmin = 'AccountAdmin'

AccountMembership = 'AccountMembership'

DesignerEnrollment = 'DesignerEnrollment'

NoPermissions = 'NoPermissions'

ObserverEnrollment = 'ObserverEnrollment'

StudentEnrollment = 'StudentEnrollment'

TaEnrollment = 'TaEnrollment'

TeacherEnrollment = 'TeacherEnrollment'

unspecified = '_dap_unspecified_'

rubric_assessments__artifact_type

Bases: Enum

Discriminator for column rubric_assessments.artifact_type.

Submission = 'Submission'

Assignment = 'Assignment'

ModeratedGrading__ProvisionalGrade = 'ModeratedGrading::ProvisionalGrade'

unspecified = '_dap_unspecified_'

rubric_assessments__assessment_type

Bases: Enum

Type for column rubric_assessments.assessment_type.

grading = 'grading'

invited_assessment = 'invited_assessment'

peer_review = 'peer_review'

unspecified = '_dap_unspecified_'

rubric_associations__context_type

Bases: Enum

Discriminator for column rubric_associations.context_type.

Course = 'Course'

Account = 'Account'

unspecified = '_dap_unspecified_'

rubric_associations__association_type

Bases: Enum

Discriminator for column rubric_associations.association_type.

Account = 'Account'

Course = 'Course'

Assignment = 'Assignment'

unspecified = '_dap_unspecified_'

rubric_associations__workflow_state

Bases: Enum

Type for column rubric_associations.workflow_state.

active = 'active'

deleted = 'deleted'

unspecified = '_dap_unspecified_'

rubrics__context_type

Bases: Enum

Discriminator for column rubrics.context_type.

Account = 'Account'

Course = 'Course'

unspecified = '_dap_unspecified_'

rubrics__workflow_state

Bases: Enum

Type for column rubrics.workflow_state.

active = 'active'

deleted = 'deleted'

archived = 'archived'

draft = 'draft'

unspecified = '_dap_unspecified_'

scores__workflow_state

Bases: Enum

Type for column scores.workflow_state.

active = 'active'

deleted = 'deleted'

unspecified = '_dap_unspecified_'

submission_comments__context_type

Bases: Enum

Discriminator for column submission_comments.context_type.

Course = 'Course'

unspecified = '_dap_unspecified_'

submission_comments__media_comment_type

Bases: Enum

Type for column submission_comments.media_comment_type.

audio = 'audio'

video = 'video'

audio_aac = 'audio/aac'

audio_amr = 'audio/amr'

audio_flac = 'audio/flac'

audio_mp4 = 'audio/mp4'

audio_mpeg = 'audio/mpeg'

audio_ogg = 'audio/ogg'

audio_vnd_dlna_adts = 'audio/vnd.dlna.adts'

audio_wav = 'audio/wav'

audio_webm = 'audio/webm'

audio_xm4a = 'audio/x-m4a'

audio_xmswma = 'audio/x-ms-wma'

audio_xwav = 'audio/x-wav'

video_3gpp = 'video/3gpp'

video_avi = 'video/avi'

video_mp4 = 'video/mp4'

video_mpeg = 'video/mpeg'

video_ogg = 'video/ogg'

video_quicktime = 'video/quicktime'

video_webm = 'video/webm'

video_xm4v = 'video/x-m4v'

video_xmatroska = 'video/x-matroska'

video_xmsasf = 'video/x-ms-asf'

video_xmswmv = 'video/x-ms-wmv'

video_xmsvideo = 'video/x-msvideo'

unspecified = '_dap_unspecified_'

submission_versions__context_type

Bases: Enum

Discriminator for column submission_versions.context_type.

Course = 'Course'

unspecified = '_dap_unspecified_'

submissions__workflow_state

Bases: Enum

Type for column submissions.workflow_state.

graded = 'graded'

pending_review = 'pending_review'

submitted = 'submitted'

unsubmitted = 'unsubmitted'

deleted = 'deleted'

unspecified = '_dap_unspecified_'

submissions__submission_type

Bases: Enum

Type for column submissions.submission_type.

basic_lti_launch = 'basic_lti_launch'

discussion_topic = 'discussion_topic'

external_tool = 'external_tool'

media_recording = 'media_recording'

online_file_upload = 'online_file_upload'

online_quiz = 'online_quiz'

online_text_entry = 'online_text_entry'

online_upload = 'online_upload'

online_url = 'online_url'

student_annotation = 'student_annotation'

unspecified = '_dap_unspecified_'

submissions__media_comment_type

Bases: Enum

Type for column submissions.media_comment_type.

audio = 'audio'

audio2 = 'audio/*'

video = 'video'

video2 = 'video/*'

audio_aac = 'audio/aac'

audio_amr = 'audio/amr'

audio_flac = 'audio/flac'

audio_mp4 = 'audio/mp4'

audio_mpeg = 'audio/mpeg'

audio_ogg = 'audio/ogg'

audio_vnd_dlna_adts = 'audio/vnd.dlna.adts'

audio_wav = 'audio/wav'

audio_webm = 'audio/webm'

audio_xm4a = 'audio/x-m4a'

audio_xmswma = 'audio/x-ms-wma'

audio_xwav = 'audio/x-wav'

video_3gpp = 'video/3gpp'

video_avi = 'video/avi'

video_mp4 = 'video/mp4'

video_mpeg = 'video/mpeg'

video_ogg = 'video/ogg'

video_quicktime = 'video/quicktime'

video_webm = 'video/webm'

video_xm4v = 'video/x-m4v'

video_xmatroska = 'video/x-matroska'

video_xmsasf = 'video/x-ms-asf'

video_xmswmv = 'video/x-ms-wmv'

video_xmsvideo = 'video/x-msvideo'

unspecified = '_dap_unspecified_'

users__workflow_state

Bases: Enum

Type for column users.workflow_state.

creation_pending = 'creation_pending'

deleted = 'deleted'

pending_approval = 'pending_approval'

pre_registered = 'pre_registered'

registered = 'registered'

unspecified = '_dap_unspecified_'

web_conference_participants__participation_type

Bases: Enum

Type for column web_conference_participants.participation_type.

attendee = 'attendee'

initiator = 'initiator'

invitee = 'invitee'

unspecified = '_dap_unspecified_'

web_conferences__context_type

Bases: Enum

Discriminator for column web_conferences.context_type.

Account = 'Account'

Course = 'Course'

Group = 'Group'

unspecified = '_dap_unspecified_'

web_conferences__conference_type

Bases: Enum

Type for column web_conferences.conference_type.

AdobeConnect = 'AdobeConnect'

BigBlueButton = 'BigBlueButton'

CiscoWebex = 'CiscoWebex'

DimDim = 'DimDim'

Wimba = 'Wimba'

Wiziq = 'Wiziq'

unspecified = '_dap_unspecified_'

wiki_pages__workflow_state

Bases: Enum

Type for column wiki_pages.workflow_state.

active = 'active'

deleted = 'deleted'

post_delayed = 'post_delayed'

unpublished = 'unpublished'

unspecified = '_dap_unspecified_'

wiki_pages__context_type

Bases: Enum

Type for column wiki_pages.context_type.

Course = 'Course'

Group = 'Group'

unspecified = '_dap_unspecified_'

collaboration__context_type

Bases: Enum

Type for column collaboration_comments.context_type.

Account = 'Account'

Group = 'Group'

Course = 'Course'

unspecified = '_dap_unspecified_'