Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
id | BIGINT | 19 | √ | null |
|
|
Standard Moodle primary key. |
|||||||||
course | BIGINT | 19 | 0 |
|
|
Foreign key reference to the course this quiz is part of. |
||||||||||
name | VARCHAR | 255 |
|
|
Quiz name. |
|||||||||||
intro | LONGTEXT | 2147483647 | null |
|
|
Quiz introduction text. |
||||||||||
introformat | SMALLINT | 5 | 0 |
|
|
Quiz intro text format. |
||||||||||
timeopen | BIGINT | 19 | 0 |
|
|
The time when this quiz opens. (0 = no restriction.) |
||||||||||
timeclose | BIGINT | 19 | 0 |
|
|
The time when this quiz closes. (0 = no restriction.) |
||||||||||
timelimit | BIGINT | 19 | 0 |
|
|
The time limit for quiz attempts, in seconds. |
||||||||||
overduehandling | VARCHAR | 16 | autoabandon |
|
|
The method used to handle overdue attempts. ‘autosubmit’, ‘graceperiod’ or ‘autoabandon’. |
||||||||||
graceperiod | BIGINT | 19 | 0 |
|
|
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. |
||||||||||
preferredbehaviour | VARCHAR | 32 |
|
|
The behaviour to ask questions to use. |
|||||||||||
canredoquestions | SMALLINT | 5 | 0 |
|
|
Allows students to redo any completed question within a quiz attempt. |
||||||||||
attempts | MEDIUMINT | 7 | 0 |
|
|
The maximum number of attempts a student is allowed. |
||||||||||
attemptonlast | SMALLINT | 5 | 0 |
|
|
Whether subsequent attempts start from teh answer to the previous attempt (1) or start blank (0). |
||||||||||
grademethod | SMALLINT | 5 | 1 |
|
|
One of the values QUIZ_GRADEHIGHEST, QUIZ_GRADEAVERAGE, QUIZ_ATTEMPTFIRST or QUIZ_ATTEMPTLAST. |
||||||||||
decimalpoints | SMALLINT | 5 | 2 |
|
|
Number of decimal points to use when displaying grades. |
||||||||||
questiondecimalpoints | SMALLINT | 5 | -1 |
|
|
Number of decimal points to use when displaying question grades. (-1 means use decimalpoints.) |
||||||||||
reviewattempt | MEDIUMINT | 7 | 0 |
|
|
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. |
||||||||||
reviewcorrectness | MEDIUMINT | 7 | 0 |
|
|
Whether users are allowed to review their quiz attempts at various times. A bit field, like reviewattempt. |
||||||||||
reviewmarks | MEDIUMINT | 7 | 0 |
|
|
Whether users are allowed to review their quiz attempts at various times. A bit field, like reviewattempt. |
||||||||||
reviewspecificfeedback | MEDIUMINT | 7 | 0 |
|
|
Whether users are allowed to review their quiz attempts at various times. A bit field, like reviewattempt. |
||||||||||
reviewgeneralfeedback | MEDIUMINT | 7 | 0 |
|
|
Whether users are allowed to review their quiz attempts at various times. A bit field, like reviewattempt. |
||||||||||
reviewrightanswer | MEDIUMINT | 7 | 0 |
|
|
Whether users are allowed to review their quiz attempts at various times. A bit field, like reviewattempt. |
||||||||||
reviewoverallfeedback | MEDIUMINT | 7 | 0 |
|
|
Whether users are allowed to review their quiz attempts at various times. A bit field, like reviewattempt. |
||||||||||
questionsperpage | BIGINT | 19 | 0 |
|
|
How often to insert a page break when editing the quiz, or when shuffling the question order. |
||||||||||
VARCHAR | 16 | free |
|
|
Any constraints on how the user is allowed to navigate around the quiz. Currently recognised values are ‘free’ and ‘seq’. |
|||||||||||
shuffleanswers | SMALLINT | 5 | 0 |
|
|
Whether the parts of the question should be shuffled, in those question types that support it. |
||||||||||
sumgrades | DECIMAL | 10,5 | 0.00000 |
|
|
The total of all the question instance maxmarks. |
||||||||||
grade | DECIMAL | 10,5 | 0.00000 |
|
|
The total that the quiz overall grade is scaled to be out of. |
||||||||||
timecreated | BIGINT | 19 | 0 |
|
|
The time when the quiz was added to the course. |
||||||||||
timemodified | BIGINT | 19 | 0 |
|
|
Last modified time. |
||||||||||
password | VARCHAR | 255 |
|
|
A password that the student must enter before starting or continuing a quiz attempt. |
|||||||||||
subnet | VARCHAR | 255 |
|
|
Used to restrict the IP addresses from which this quiz can be attempted. The format is as requried by the address_in_subnet function. |
|||||||||||
browsersecurity | VARCHAR | 32 |
|
|
Restriciton on the browser the student must use. E.g. ‘securewindow’. |
|||||||||||
delay1 | BIGINT | 19 | 0 |
|
|
Delay that must be left between the first and second attempt, in seconds. |
||||||||||
delay2 | BIGINT | 19 | 0 |
|
|
Delay that must be left between the second and subsequent attempt, in seconds. |
||||||||||
showuserpicture | SMALLINT | 5 | 0 |
|
|
Option to show the user’s picture during the attempt and on the review page. |
||||||||||
showblocks | SMALLINT | 5 | 0 |
|
|
Whether blocks should be shown on the attempt.php and review.php pages. |
||||||||||
completionattemptsexhausted | BIT | 1 | √ | 0 |
|
|
||||||||||
completionpass | BIT | 1 | √ | 0 |
|
|
||||||||||
allowofflineattempts | BIT | 1 | √ | 0 |
|
|
Whether to allow the quiz to be attempted offline in the mobile app |
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | id |
quiz_cou2_ix | Performance | Asc | course |