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 |