new_quizzes

Tables in new_quizzes namespace.

Tables in new_quizzes namespace

assessment_question_banks

Stores New Quizzes assessment question banks.

Properties:

• id (int64) - primary key Unique identifier for the assessment question bank.

• deleted_at (datetime | None) - Timestamp when the record was deleted.

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

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

• workflow_state (assessment_question_banks__workflow_state) - Current state of the workflow.

• migration_id (str | None) - Unique identifier for the migration.

• title (str | None) - Title of the record.

assessment_questions

Stores New Quizzes assessment questions.

Properties:

• id (int64) - primary key Unique identifier for the assessment question.

• name (str | None) - Name of the assessment question.

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

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

• deleted_at (datetime | None) - Timestamp when the record was deleted.

• workflow_state (assessment_questions__workflow_state | None) - Current state of the workflow.

• context_id (int64 | None) - Unique identifier for the context.

• context_type (context_type | None) - Type of the context.

• migration_id (str | None) - Unique identifier for the migration.

• assessment_question_bank_id (assessment_question_banks | None) - Unique identifier for the assessment question bank.

• question_data (str | None) - Data related to the question.

• position (int32 | None) - Position of the question.

• item_id (int64 | None) - Unique identifier for the item.

assignment_override_students

Stores New Quizzes assignment override students.

Properties:

• id (int64) - primary key Unique identifier for the assignment override student.

• user_id (int64 | None) - Identifier of the user who created the assignment override.

• created_at (datetime) - Timestamp when the assignment override was created.

• updated_at (datetime) - Timestamp when the assignment override was last updated.

• workflow_state (assignment_override_students__workflow_state) - Current state of the assignment override in the workflow.

• assignment_id (assignments | None) - Identifier of the assignment.

• assignment_override_id (assignment_overrides) - Unique identifier for the assignment override.

assignment_overrides

Stores New Quizzes assignment overrides.

Properties:

• id (int64) - primary key Unique identifier for the assignment override.

• all_day (bool | None) - Whether the assignment is all-day.

• all_day_date (date | None) - Date of the all-day assignment.

• assignment_id (assignments | None) - Unique identifier of the assignment.

• assignment_version (int32 | None) - Version of the assignment.

• created_at (datetime) - Timestamp when the assignment was created.

• due_at (datetime | None) - Due date of the assignment.

• due_at_overridden (bool) - Whether the due date has been overridden.

• lock_at (datetime | None) - Timestamp when the assignment is locked.

• lock_at_overridden (bool) - Whether the lock time has been overridden.

• quiz_id (quizzes | None) - Unique identifier of the quiz.

• quiz_version (int32 | None) - Version of the quiz.

• set_id (int64 | None) - Unique identifier of the assignment set.

• set_type (str | None) - Type of the assignment set.

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

• unlock_at (datetime | None) - Timestamp when the assignment is unlocked.

• unlock_at_overridden (bool) - Whether the unlock time has been overridden.

• updated_at (datetime) - Timestamp when the assignment was last updated.

• workflow_state (assignment_overrides__workflow_state) - Current state of the workflow.

assignments

Stores New Quizzes assignments.

Properties:

• id (int64) - primary key Unique identifier for the assignment.

• integration_id (str | None) - Unique identifier for the integration.

• lti_context_id (str | None) - Unique identifier for the LTI context.

• created_at (datetime | None) - Date and time when the assignment was created.

• updated_at (datetime | None) - Date and time when the assignment was last updated.

• workflow_state (canvas.assignments__workflow_state) - Current state of the workflow.

• due_at (datetime | None) - Date and time when the assignment is due.

• unlock_at (datetime | None) - Date and time when the assignment is unlocked.

• lock_at (datetime | None) - Date and time when the assignment is locked.

• points_possible (float | None) - Maximum points possible.

• grading_type (canvas.assignments__grading_type | None) - Type of grading.

• submission_types (Annotated[List[canvas.assignments__submission_types], SpecialConversion()]) - Types of submissions allowed.

• assignment_group_id (int64 | None) - Unique identifier for the assignment group.

• grading_standard_id (int64 | None) - Unique identifier for the grading standard.

• submissions_downloads (int32 | None) - Number of submissions downloads.

• peer_review_count (int32 | None) - Number of peer reviews.

• peer_reviews_due_at (datetime | None) - Date and time when peer reviews are due.

• peer_reviews_assigned (bool) - Whether peer reviews are assigned.

• peer_reviews (bool) - Whether peer reviews are allowed.

• context_id (int64 | None) - Unique identifier for the context.

• context_type (canvas.assignments__context_type) - Type of context.

• automatic_peer_reviews (bool) - Whether automatic peer reviews are allowed.

• all_day (bool) - Whether the assignment is all-day.

• all_day_date (date | None) - Date when the assignment is all-day.

• could_be_locked (bool) - Whether the assignment could be locked.

• migration_id (Annotated[str, MaxLength(255)] | None) - Unique identifier for the migration.

• grade_group_students_individually (bool) - Whether grades are grouped by students individually.

• anonymous_peer_reviews (bool) - Whether anonymous peer reviews are allowed.

• turnitin_enabled (bool) - Whether Turnitin is enabled.

• allowed_extensions (Annotated[str, MaxLength(255)] | None) - File extensions allowed for submission.

• group_category_id (int64 | None) - Unique identifier for the group category.

• freeze_on_copy (bool) - Whether to freeze on copy.

• only_visible_to_overrides (bool) - Whether the assignment is only visible to overrides.

• post_to_sis (bool) - Whether to post to SIS.

• moderated_grading (bool) - Whether grading is moderated.

• grades_published_at (datetime | None) - Date and time when grades were published.

• omit_from_final_grade (bool) - Whether to omit from final grade.

• intra_group_peer_reviews (bool) - Whether intra-group peer reviews are allowed.

• vericite_enabled (bool) - Whether Vericite is enabled.

• anonymous_instructor_annotations (bool) - Whether anonymous instructor annotations are allowed.

• duplicate_of_id (int64 | None) - Unique identifier for the duplicate of.

• anonymous_grading (bool | None) - Whether anonymous grading is allowed.

• graders_anonymous_to_graders (bool | None) - Whether graders are anonymous to graders.

• grader_count (int32 | None) - Number of graders.

• grader_comments_visible_to_graders (bool | None) - Whether grader comments are visible to graders.

• grader_section_id (int64 | None) - Unique identifier for the grader section.

• final_grader_id (int64 | None) - Unique identifier for the final grader.

• grader_names_visible_to_final_grader (bool | None) - Whether grader names are visible to the final grader.

• allowed_attempts (int32 | None) - Number of allowed attempts.

• sis_source_id (str | None) - Unique identifier for the SIS source.

• annotatable_attachment_id (int64 | None) - Unique identifier for the annotatable attachment.

• important_dates (bool) - Whether the assignment has important dates.

• description (str | None) - Description of the assignment.

• position (int32 | None) - Position of the assignment.

• title (str | None) - Title of the assignment.

• turnitin_settings (Annotated[canvas.assignments__turnitin_settings, YamlStringToJsonObject()] | None) - Turnitin settings as JSON.

• parent_assignment_id (int64 | None) - Unique identifier for the parent assignment.

• type (canvas.assignments__type | None) - Type of the assignment.

• has_sub_assignments (bool | None) - Whether the assignment has sub-assignments.

quiz_questions

Stores New Quizzes quiz questions.

Properties:

• id (int64) - primary key Unique identifier for the quiz question.

• created_at (datetime) - Timestamp when the quiz question was created.

• updated_at (datetime) - Timestamp when the quiz question was last updated.

• archived_at (datetime | None) - Timestamp when the quiz question was archived.

• workflow_state (quiz_questions__workflow_state | None) - Current state of the quiz question in the workflow.

• quiz_id (quizzes) - Unique identifier for the quiz.

• migration_id (str | None) - Unique identifier for the quiz question migration.

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

• question_data (str | None) - Data related to the quiz question.

• item_id (int64 | None) - Unique identifier for the item.

quiz_submissions

Stores attributes for the last submitted quiz.

This tables persists one record per user_id and quiz_id.

Properties:

• id (int64) - primary key The ID of the quiz submission.

• user_id (int64) - 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 | None) - Life-cycle state for the quiz submission.

• quiz_id (quizzes) - The ID of the Quiz the quiz submission belongs 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.

• 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.

• 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.

• was_preview (bool | None) - Indicates if this submission was created from a teacher preview.

• has_seen_results (bool | None) - Whether the student has viewed their results to the quiz.

quizzes

Stores New Quizzes quizzes.

Properties:

• id (int64) - primary key The ID of the quiz.

• created_at (datetime) - The timestamp when the quiz is created.

• updated_at (datetime) - The timestamp when the quiz is last updated.

• due_at (datetime | None) - The due date for the quiz.

• unlock_at (datetime | None) - The timestamp when the quiz is unlocked for the user.

• lock_at (datetime | None) - The timestamp when the quiz is locked.

• shuffle_answers (bool | None) - Whether to shuffle the answers.

• title (str | None) - The title of the quiz.

• archived_at (datetime | None) - The timestamp when the quiz is archived.

• workflow_state (quizzes__workflow_state | None) - The workflow state of the quiz.

• description (str | None) - The description of the quiz.

• time_limit (int32 | None) - The time limit for the quiz.

• access_code (str | None) - The access code for the quiz.

• ip_filter (str | None) - The IP filter for the quiz.

• one_question_at_a_time (bool | None) - Whether to display one question at a time.

• cant_go_back (bool) - Whether the user cannot go back to previous questions.

• show_correct_answers (bool | None) - Whether to show correct answers.

• hide_results (bool | None) - Whether to hide the results.

• practice_quiz (bool | None) - Whether the quiz is a practice quiz.

• context_id (int64 | None) - The ID of the context associated with the quiz.

• context_type (context_type) - The type of the context.

• migration_id (str | None) - The ID of the migration associated with the quiz.

• quiz_type (str) - The type of the quiz.

• points_possible (float | None) - The maximum number of points possible for the quiz.

• assignment_group_id (int64 | None) - The ID of the assignment group associated with the quiz.

• could_be_locked (bool | None) - Whether the quiz could be locked.

• only_visible_to_overrides (bool | None) - Whether the quiz is only visible to overrides.

• allowed_attempts (int32 | None) - The number of allowed attempts for the quiz.

• scoring_policy (str | None) - The scoring policy for the quiz.

• anonymous_submissions (bool | None) - Whether to allow anonymous submissions.

• show_correct_answers_at (str | None) - The timestamp when the correct answers are shown to the user.

• hide_correct_answers_at (str | None) - The timestamp when correct answers are hidden.

• show_correct_answers_last_attempt (bool | None) - Whether to show correct answers on the last attempt.

• assignment_id (int64 | None) - Unique identifier for the Canvas assignment.

Types in new_quizzes namespace

assessment_question_banks__workflow_state

Members:

• unspecified = '__dap_unspecified__'

• waiting = 'waiting' - The initial/default state when a Bank is created

• importing = 'importing' - Indicates the bank is currently importing content

• exporting = 'exporting' - Indicates the bank is currently exporting content

• copying = 'copying' - Indicates the bank is being copied

assessment_questions__workflow_state

Members:

• unspecified = '__dap_unspecified__'

• mutable = 'mutable'

• immutable = 'immutable'

assignment_override_students__workflow_state

Type for column assignment_override_students.workflow_state.

Members:

• unspecified = '__dap_unspecified__'

• active = 'active'

• deleted = 'deleted'

assignment_overrides__workflow_state

Type for column assignment_overrides.workflow_state.

Members:

• unspecified = '__dap_unspecified__'

• active = 'active'

• deleted = 'deleted'

context_type

Members:

• unspecified = '__dap_unspecified__'

• course = 'Course'

• account = 'Account'

quiz_questions__workflow_state

Members:

• unspecified = '__dap_unspecified__'

• mutable = 'mutable'

• immutable = 'immutable'

quiz_submissions__workflow_state

Type for column quiz_submissions.workflow_state.

Members:

• unspecified = '__dap_unspecified__'

• created_without_quiz_session = 'created_without_quiz_session'

• pending = 'pending'

• in_progress = 'in_progress'

• creating_responses = 'creating_responses'

• failure = 'failure'

• autograding = 'autograding'

• needs_grading = 'needs_grading'

• graded = 'graded'

• autograding_failed = 'autograding_failed'

quizzes__workflow_state

Members:

• unspecified = '__dap_unspecified__'

• uninitialized = 'uninitialized'

• unpublished = 'unpublished'

• published = 'published'

• importing = 'importing'

• exporting = 'exporting'

• exporting_failed = 'exporting_failed'