Quiz Table Schema (quiz)

Standard Moodle primary key.

Foreign key reference to the course this quiz is part of.

Quiz name.

Quiz introduction text.

Quiz intro text format.

The time when this quiz opens. (0 = no restriction.)

The time when this quiz closes. (0 = no restriction.)

The time limit for quiz attempts, in seconds.

The method used to handle overdue attempts. 'autosubmit', 'graceperiod' or 'autoabandon'.

The amount of time (in seconds) after the time limit runs out during which attempts can still be submitted, if overduehandling is set to allow it.

The behaviour to ask questions to use.

Allows students to redo any completed question within a quiz attempt.

The maximum number of attempts a student is allowed.

Whether subsequent attempts start from teh answer to the previous attempt (1) or start blank (0).

One of the values QUIZ_GRADEHIGHEST, QUIZ_GRADEAVERAGE, QUIZ_ATTEMPTFIRST or QUIZ_ATTEMPTLAST.

Number of decimal points to use when displaying grades.

Number of decimal points to use when displaying question grades. (-1 means use decimalpoints.)

Whether users are allowed to review their quiz attempts at various times. This is a bit field, decoded by the mod_quiz_display_options class. It is formed by ORing together the constants defined there.

Whether users are allowed to review their quiz attempts at various times. A bit field, like reviewattempt.

Whether users are allowed to review their quiz attempts at various times. A bit field, like reviewattempt.

Whether users are allowed to review their quiz attempts at various times. A bit field, like reviewattempt.

Whether users are allowed to review their quiz attempts at various times. A bit field, like reviewattempt.

Whether users are allowed to review their quiz attempts at various times. A bit field, like reviewattempt.

Whether users are allowed to review their quiz attempts at various times. A bit field, like reviewattempt.

How often to insert a page break when editing the quiz, or when shuffling the question order.

Any constraints on how the user is allowed to navigate around the quiz. Currently recognised values are 'free' and 'seq'.

Whether the parts of the question should be shuffled, in those question types that support it.

The total of all the question instance maxmarks.

The total that the quiz overall grade is scaled to be out of.

The time when the quiz was added to the course.

Last modified time.

A password that the student must enter before starting or continuing a quiz attempt.

Used to restrict the IP addresses from which this quiz can be attempted. The format is as requried by the address_in_subnet function.

Restriciton on the browser the student must use. E.g. 'securewindow'.

Delay that must be left between the first and second attempt, in seconds.

Delay that must be left between the second and subsequent attempt, in seconds.

Option to show the user's picture during the attempt and on the review page.

Whether blocks should be shown on the attempt.php and review.php pages.

Whether to allow the quiz to be attempted offline in the mobile app