# new\_quizzes

## Tables in new\_quizzes namespace

### assessment\_question\_banks <a href="#dap_schemas.new_quizzes.assessment_question_banks" id="dap_schemas.new_quizzes.assessment_question_banks"></a>

Stores New Quizzes assessment question banks.

**Properties:**

* **id** (int64) - <mark style="color:purple;">**`primary key`**</mark> 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](#dap_schemas.new_quizzes.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 <a href="#dap_schemas.new_quizzes.assessment_questions" id="dap_schemas.new_quizzes.assessment_questions"></a>

Stores New Quizzes assessment questions.

**Properties:**

* **id** (int64) - <mark style="color:purple;">**`primary key`**</mark> 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](#dap_schemas.new_quizzes.assessment_questions__workflow_state) | None) - Current state of the workflow.
* **context\_id** (int64 | None) - Unique identifier for the context.
* **context\_type** ([context\_type](#dap_schemas.new_quizzes.context_type) | None) - Type of the context.
* **migration\_id** (str | None) - Unique identifier for the migration.
* **assessment\_question\_bank\_id** ([assessment\_question\_banks](#dap_schemas.new_quizzes.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 <a href="#dap_schemas.new_quizzes.assignment_override_students" id="dap_schemas.new_quizzes.assignment_override_students"></a>

Stores New Quizzes assignment override students.

**Properties:**

* **id** (int64) - <mark style="color:purple;">**`primary key`**</mark> 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](#dap_schemas.new_quizzes.assignment_override_students__workflow_state)) - Current state of the assignment override in the workflow.
* **assignment\_id** ([assignments](#dap_schemas.new_quizzes.assignments) | None) - Identifier of the assignment.
* **assignment\_override\_id** ([assignment\_overrides](#dap_schemas.new_quizzes.assignment_overrides)) - Unique identifier for the assignment override.

### assignment\_overrides <a href="#dap_schemas.new_quizzes.assignment_overrides" id="dap_schemas.new_quizzes.assignment_overrides"></a>

Stores New Quizzes assignment overrides.

**Properties:**

* **id** (int64) - <mark style="color:purple;">**`primary key`**</mark> 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](#dap_schemas.new_quizzes.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](#dap_schemas.new_quizzes.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](#dap_schemas.new_quizzes.assignment_overrides__workflow_state)) - Current state of the workflow.

### assignments <a href="#dap_schemas.new_quizzes.assignments" id="dap_schemas.new_quizzes.assignments"></a>

Stores New Quizzes assignments.

**Properties:**

* **id** (int64) - <mark style="color:purple;">**`primary key`**</mark> 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](https://developerdocs.instructure.com/services/dap/dataset/dataset-canvas/dataset-canvas-types#dap_schemas.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](https://developerdocs.instructure.com/services/dap/dataset/dataset-canvas/dataset-canvas-types#dap_schemas.canvas.assignments__grading_type) | None) - Type of grading.
* **submission\_types** (Annotated\[List\[[canvas.assignments\_\_submission\_types](https://developerdocs.instructure.com/services/dap/dataset/dataset-canvas/dataset-canvas-types#dap_schemas.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](https://developerdocs.instructure.com/services/dap/dataset/dataset-canvas/dataset-canvas-types#dap_schemas.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](https://developerdocs.instructure.com/services/dap/dataset/dataset-canvas/dataset-canvas-types#dap_schemas.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](https://developerdocs.instructure.com/services/dap/dataset/dataset-canvas/dataset-canvas-types#dap_schemas.canvas.assignments__type) | None) - Type of the assignment.
* **has\_sub\_assignments** (bool | None) - Whether the assignment has sub-assignments.

### quiz\_questions <a href="#dap_schemas.new_quizzes.quiz_questions" id="dap_schemas.new_quizzes.quiz_questions"></a>

Stores New Quizzes quiz questions.

**Properties:**

* **id** (int64) - <mark style="color:purple;">**`primary key`**</mark> 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](#dap_schemas.new_quizzes.quiz_questions__workflow_state) | None) - Current state of the quiz question in the workflow.
* **quiz\_id** ([quizzes](#dap_schemas.new_quizzes.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 <a href="#dap_schemas.new_quizzes.quiz_submissions" id="dap_schemas.new_quizzes.quiz_submissions"></a>

Stores attributes for the last submitted quiz.

This tables persists one record per `user_id` and `quiz_id`.

**Properties:**

* **id** (int64) - <mark style="color:purple;">**`primary key`**</mark> 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](#dap_schemas.new_quizzes.quiz_submissions__workflow_state) | None) - Life-cycle state for the quiz submission.
* **quiz\_id** ([quizzes](#dap_schemas.new_quizzes.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 <a href="#dap_schemas.new_quizzes.quizzes" id="dap_schemas.new_quizzes.quizzes"></a>

Stores New Quizzes quizzes.

**Properties:**

* **id** (int64) - <mark style="color:purple;">**`primary key`**</mark> 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](#dap_schemas.new_quizzes.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](#dap_schemas.new_quizzes.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 <a href="#dap_schemas.new_quizzes.assessment_question_banks__workflow_state" id="dap_schemas.new_quizzes.assessment_question_banks__workflow_state"></a>

**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 <a href="#dap_schemas.new_quizzes.assessment_questions__workflow_state" id="dap_schemas.new_quizzes.assessment_questions__workflow_state"></a>

**Members:**

* **unspecified** = `'__dap_unspecified__'`
* **mutable** = `'mutable'`
* **immutable** = `'immutable'`

### assignment\_override\_students\_\_workflow\_state <a href="#dap_schemas.new_quizzes.assignment_override_students__workflow_state" id="dap_schemas.new_quizzes.assignment_override_students__workflow_state"></a>

Type for column `assignment_override_students.workflow_state`.

**Members:**

* **unspecified** = `'__dap_unspecified__'`
* **active** = `'active'`
* **deleted** = `'deleted'`

### assignment\_overrides\_\_workflow\_state <a href="#dap_schemas.new_quizzes.assignment_overrides__workflow_state" id="dap_schemas.new_quizzes.assignment_overrides__workflow_state"></a>

Type for column `assignment_overrides.workflow_state`.

**Members:**

* **unspecified** = `'__dap_unspecified__'`
* **active** = `'active'`
* **deleted** = `'deleted'`

### context\_type <a href="#dap_schemas.new_quizzes.context_type" id="dap_schemas.new_quizzes.context_type"></a>

**Members:**

* **unspecified** = `'__dap_unspecified__'`
* **course** = `'Course'`
* **account** = `'Account'`

### quiz\_questions\_\_workflow\_state <a href="#dap_schemas.new_quizzes.quiz_questions__workflow_state" id="dap_schemas.new_quizzes.quiz_questions__workflow_state"></a>

**Members:**

* **unspecified** = `'__dap_unspecified__'`
* **mutable** = `'mutable'`
* **immutable** = `'immutable'`

### quiz\_submissions\_\_workflow\_state <a href="#dap_schemas.new_quizzes.quiz_submissions__workflow_state" id="dap_schemas.new_quizzes.quiz_submissions__workflow_state"></a>

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 <a href="#dap_schemas.new_quizzes.quizzes__workflow_state" id="dap_schemas.new_quizzes.quizzes__workflow_state"></a>

**Members:**

* **unspecified** = `'__dap_unspecified__'`
* **uninitialized** = `'uninitialized'`
* **unpublished** = `'unpublished'`
* **published** = `'published'`
* **importing** = `'importing'`
* **exporting** = `'exporting'`
* **exporting\_failed** = `'exporting_failed'`