Last
Tables (48)
mdl_course
- id — BIGINT(10) — Primary key — NOT NULL
- category — BIGINT(10) — NOT NULL
- sortorder — BIGINT(10) — NOT NULL
- fullname — VARCHAR(254) — NOT NULL
- shortname — VARCHAR(255) — NOT NULL
- idnumber — VARCHAR(100) — NOT NULL
- summary — LONGTEXT
- summaryformat — TINYINT(2) — NOT NULL
- format — VARCHAR(21) — NOT NULL
- showgrades — TINYINT(2) — NOT NULL
- newsitems — MEDIUMINT(5) — NOT NULL
- startdate — BIGINT(10) — NOT NULL
- enddate — BIGINT(10) — NOT NULL
- marker — BIGINT(10) — NOT NULL
- maxbytes — BIGINT(10) — NOT NULL
- legacyfiles — SMALLINT(4) — NOT NULL
- showreports — SMALLINT(4) — NOT NULL
- visible — TINYINT(1) — NOT NULL
- visibleold — TINYINT(1) — NOT NULL
- groupmode — SMALLINT(4) — NOT NULL
- groupmodeforce — SMALLINT(4) — NOT NULL
- defaultgroupingid — BIGINT(10) — NOT NULL
- lang — VARCHAR(30) — NOT NULL
- calendartype — VARCHAR(30) — NOT NULL
- theme — VARCHAR(50) — NOT NULL
- timecreated — BIGINT(10) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- requested — TINYINT(1) — NOT NULL
- enablecompletion — TINYINT(1) — NOT NULL
- completionnotify — TINYINT(1) — NOT NULL
- cacherev — BIGINT(10) — NOT NULL
- INDEX — `mdl_cour_cat_ix`
- INDEX — `mdl_cour_idn_ix`
- INDEX — `mdl_cour_sho_ix`
- INDEX — `mdl_cour_sor_ix`
- INDEX — `mdl_cour_lan_ix`
mdl_groups
- id — BIGINT(10) — Primary key — NOT NULL
- courseid — BIGINT(10) — NOT NULL
- idnumber — VARCHAR(100) — NOT NULL
- name — VARCHAR(254) — NOT NULL
- description — LONGTEXT
- descriptionformat — TINYINT(2) — NOT NULL
- enrolmentkey — VARCHAR(50)
- picture — BIGINT(10) — NOT NULL
- hidepicture — TINYINT(1) — NOT NULL
- timecreated — BIGINT(10) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- INDEX — `mdl_grou_idn_ix`
- INDEX — `mdl_grou_cou_ix`
mdl_qtype_ddimageortext
- id — BIGINT(10) — Primary key — NOT NULL
- questionid — BIGINT(10) — Foreign key → mdl_question.id — NOT NULL
- shuffleanswers — SMALLINT(4) — NOT NULL
- correctfeedback — LONGTEXT — NOT NULL
- correctfeedbackformat — TINYINT(2) — NOT NULL
- partiallycorrectfeedback — LONGTEXT — NOT NULL
- partiallycorrectfeedbackformat — TINYINT(2) — NOT NULL
- incorrectfeedback — LONGTEXT — NOT NULL
- incorrectfeedbackformat — TINYINT(2) — NOT NULL
- shownumcorrect — TINYINT(2) — NOT NULL
- INDEX — `mdl_qtypddim_que_ix`
mdl_qtype_ddimageortext_drags
- id — BIGINT(10) — Primary key — NOT NULL
- questionid — BIGINT(10) — Foreign key → mdl_question.id — NOT NULL
- no — BIGINT(10) — NOT NULL
- draggroup — BIGINT(10) — NOT NULL
- infinite — SMALLINT(4) — NOT NULL
- label — LONGTEXT — NOT NULL
- INDEX — `mdl_qtypddimdrag_que_ix`
mdl_qtype_ddimageortext_drops
- id — BIGINT(10) — Primary key — NOT NULL
- questionid — BIGINT(10) — Foreign key → mdl_question.id — NOT NULL
- no — BIGINT(10) — NOT NULL
- xleft — BIGINT(10) — NOT NULL
- ytop — BIGINT(10) — NOT NULL
- choice — BIGINT(10) — NOT NULL
- label — LONGTEXT — NOT NULL
- INDEX — `mdl_qtypddimdrop_que_ix`
mdl_qtype_ddmarker
- id — BIGINT(10) — Primary key — NOT NULL
- questionid — BIGINT(10) — Foreign key → mdl_question.id — NOT NULL
- shuffleanswers — SMALLINT(4) — NOT NULL
- correctfeedback — LONGTEXT — NOT NULL
- correctfeedbackformat — TINYINT(2) — NOT NULL
- partiallycorrectfeedback — LONGTEXT — NOT NULL
- partiallycorrectfeedbackformat — TINYINT(2) — NOT NULL
- incorrectfeedback — LONGTEXT — NOT NULL
- incorrectfeedbackformat — TINYINT(2) — NOT NULL
- shownumcorrect — TINYINT(2) — NOT NULL
- showmisplaced — SMALLINT(4) — NOT NULL
- INDEX — `mdl_qtypddma_que_ix`
mdl_qtype_ddmarker_drags
- id — BIGINT(10) — Primary key — NOT NULL
- questionid — BIGINT(10) — Foreign key → mdl_question.id — NOT NULL
- no — BIGINT(10) — NOT NULL
- label — LONGTEXT — NOT NULL
- infinite — SMALLINT(4) — NOT NULL
- noofdrags — BIGINT(10) — NOT NULL
- INDEX — `mdl_qtypddmadrag_que_ix`
mdl_qtype_ddmarker_drops
- id — BIGINT(10) — Foreign key → mdl_question.id — NOT NULL
- questionid — BIGINT(10) — NOT NULL
- no — BIGINT(10) — NOT NULL
- shape — VARCHAR(255)
- coords — LONGTEXT — NOT NULL
- choice — BIGINT(10) — NOT NULL
- INDEX — `mdl_qtypddmadrop_que_ix`
mdl_qtype_essay_options
- id — BIGINT(10) — Primary key — NOT NULL
- questionid — BIGINT(10) — Foreign key → mdl_question.id — NOT NULL
- responseformat — VARCHAR(16) — NOT NULL
- responserequired — TINYINT(2) — NOT NULL
- responsefieldlines — SMALLINT(4) — NOT NULL
- attachments — SMALLINT(4) — NOT NULL
- attachmentsrequired — SMALLINT(4) — NOT NULL
- graderinfo — LONGTEXT
- graderinfoformat — SMALLINT(4) — NOT NULL
- responsetemplate — LONGTEXT
- responsetemplateformat — SMALLINT(4) — NOT NULL
mdl_qtype_geogebra_options
- id — BIGINT(10) — Primary key — NOT NULL
- questionid — BIGINT(10) — Foreign key → mdl_question.id — NOT NULL
- ggbturl — LONGTEXT
- ggbparameters — LONGTEXT
- ggbviews — LONGTEXT
- ggbcodebaseversion — LONGTEXT
- ggbxml — LONGTEXT
- israndomized — TINYINT(1) — NOT NULL
- randomizedvar — LONGTEXT
- constraints — LONGTEXT
- isexercise — TINYINT(1)
mdl_qtype_match_options
- id — BIGINT(10) — Primary key — NOT NULL
- questionid — BIGINT(10) — Foreign key → mdl_question.id — NOT NULL
- shuffleanswers — SMALLINT(4) — NOT NULL
- correctfeedback — LONGTEXT — NOT NULL
- correctfeedbackformat — TINYINT(2) — NOT NULL
- partiallycorrectfeedback — LONGTEXT — NOT NULL
- partiallycorrectfeedbackformat — TINYINT(2) — NOT NULL
- incorrectfeedback — LONGTEXT — NOT NULL
- incorrectfeedbackformat — TINYINT(2) — NOT NULL
- shownumcorrect — TINYINT(2) — NOT NULL
mdl_question
- id — BIGINT(10) — Primary key — NOT NULL
- category — BIGINT(10) — Foreign key → mdl_question_categories.id — NOT NULL
- parent — BIGINT(10) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- questiontext — LONGTEXT — NOT NULL
- questiontextformat — TINYINT(2) — NOT NULL
- generalfeedback — LONGTEXT — NOT NULL
- generalfeedbackformat — TINYINT(2) — NOT NULL
- defaultmark — DECIMAL(12,7) — NOT NULL
- penalty — DECIMAL(12,7) — NOT NULL
- qtype — VARCHAR(20) — NOT NULL
- length — BIGINT(10) — NOT NULL
- stamp — VARCHAR(255) — NOT NULL
- version — VARCHAR(255) — NOT NULL
- hidden — TINYINT(1) — NOT NULL
- timecreated — BIGINT(10) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- createdby — BIGINT(10)
- modifiedby — BIGINT(10)
- INDEX — `mdl_ques_qty_ix`
- INDEX — `mdl_ques_cat_ix`
- INDEX — `mdl_ques_par_ix`
- INDEX — `mdl_ques_cre_ix`
- INDEX — `mdl_ques_mod_ix`
mdl_question_answers
- id — BIGINT(10) — Primary key — NOT NULL
- question — BIGINT(10) — NOT NULL
- answer — LONGTEXT — NOT NULL
- answerformat — TINYINT(2) — NOT NULL
- fraction — DECIMAL(12,7) — NOT NULL
- feedback — LONGTEXT — NOT NULL
- feedbackformat — TINYINT(2) — NOT NULL
- INDEX — `mdl_quesansw_que_ix`
mdl_question_attempt_step_data
- id — BIGINT(10) — Primary key — NOT NULL
- attemptstepid — BIGINT(10) — Foreign key → mdl_question_attempt_steps.id — NOT NULL
- name — VARCHAR(32) — NOT NULL
- value — LONGTEXT
- INDEX — `mdl_quesattestepdata_att_ix`
mdl_question_attempt_steps
- id — BIGINT(10) — Primary key — NOT NULL
- questionattemptid — BIGINT(10) — Foreign key → mdl_question.id — NOT NULL
- sequencenumber — BIGINT(10) — NOT NULL
- state — VARCHAR(13) — NOT NULL
- fraction — DECIMAL(12,7)
- timecreated — BIGINT(10) — NOT NULL
- userid — BIGINT(10)
- INDEX — `mdl_quesattestep_que_ix`
- INDEX — `mdl_quesattestep_use_ix`
mdl_question_attempts
- id — BIGINT(10) — Primary key — NOT NULL
- questionusageid — BIGINT(10) — Foreign key → mdl_question_usages.id — NOT NULL
- slot — BIGINT(10) — NOT NULL
- behaviour — VARCHAR(32) — NOT NULL
- questionid — BIGINT(10) — Foreign key → mdl_question.id — NOT NULL
- variant — BIGINT(10) — NOT NULL
- maxmark — DECIMAL(12,7) — NOT NULL
- minfraction — DECIMAL(12,7) — NOT NULL
- maxfraction — DECIMAL(12,7) — NOT NULL
- flagged — TINYINT(1) — NOT NULL
- questionsummary — LONGTEXT
- rightanswer — LONGTEXT
- responsesummary — LONGTEXT
- timemodified — BIGINT(10) — NOT NULL
- INDEX — `mdl_quesatte_beh_ix`
- INDEX — `mdl_quesatte_que_ix`
- INDEX — `mdl_quesatte_que2_ix`
mdl_question_calculated
- id — BIGINT(10) — Primary key — NOT NULL
- question — BIGINT(10) — Foreign key → mdl_question.id — NOT NULL
- answer — BIGINT(10) — Foreign key → mdl_question_answers.id — NOT NULL
- tolerance — VARCHAR(20) — NOT NULL
- tolerancetype — BIGINT(10) — NOT NULL
- correctanswerlength — BIGINT(10) — NOT NULL
- correctanswerformat — BIGINT(10) — NOT NULL
- INDEX — `mdl_quescalc_ans_ix`
- INDEX — `mdl_quescalc_que_ix`
mdl_question_calculated_options
- id — BIGINT(10) — Primary key — NOT NULL
- question — BIGINT(10) — Foreign key → mdl_question.id — NOT NULL
- synchronize — TINYINT(2) — NOT NULL
- single — SMALLINT(4) — NOT NULL
- shuffleanswers — SMALLINT(4) — NOT NULL
- correctfeedback — LONGTEXT
- correctfeedbackformat — TINYINT(2) — NOT NULL
- partiallycorrectfeedback — LONGTEXT
- partiallycorrectfeedbackformat — TINYINT(2) — NOT NULL
- incorrectfeedback — LONGTEXT
- incorrectfeedbackformat — TINYINT(2) — NOT NULL
- answernumbering — VARCHAR(10) — NOT NULL
- shownumcorrect — TINYINT(2) — NOT NULL
- INDEX — `mdl_quescalcopti_que_ix`
mdl_question_categories
- id — BIGINT(10) — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- contextid — BIGINT(10) — NOT NULL
- info — LONGTEXT — NOT NULL
- infoformat — TINYINT(2) — NOT NULL
- stamp — VARCHAR(255) — NOT NULL
- parent — BIGINT(10) — NOT NULL
- sortorder — BIGINT(10) — NOT NULL
- INDEX — `mdl_quescate_con_ix`
- INDEX — `mdl_quescate_par_ix`
mdl_question_coderunner_options
- id — BIGINT(10) — Primary key — NOT NULL
- questionid — BIGINT(10) — Foreign key → mdl_question.id — NOT NULL
- coderunnertype — VARCHAR(255) — NOT NULL
- prototypetype — TINYINT(1) — NOT NULL
- allornothing — TINYINT(1) — NOT NULL
- showsource — TINYINT(1) — NOT NULL
- precheck — INT(8)
- answerboxlines — MEDIUMINT(5) — NOT NULL
- answerboxcolumns — MEDIUMINT(5) — NOT NULL
- answerpreload — LONGTEXT
- useace — TINYINT(1) — NOT NULL
- penaltyregime — VARCHAR(255) — NOT NULL
- answer — LONGTEXT
- validateonsave — TINYINT(1) — NOT NULL
- enablecombinator — TINYINT(1)
- resultcolumns — VARCHAR(255)
- template — LONGTEXT
- iscombinatortemplate — TINYINT(1)
- combinatortemplate — LONGTEXT
- testsplitterre — VARCHAR(255)
- pertesttemplate — LONGTEXT
- templateparams — VARCHAR(255)
- language — VARCHAR(255)
- acelang — VARCHAR(255)
- sandbox — VARCHAR(255)
- sandboxparams — VARCHAR(255)
- grader — VARCHAR(255)
- cputimelimitsecs — BIGINT(10)
- memlimitmb — BIGINT(10)
- INDEX — `mdl_quescodeopti_cod_ix`
- INDEX — `mdl_quescodeopti_pro_ix`
- INDEX — `mdl_quescodeopti_que_ix`
mdl_question_coderunner_tests
- id — BIGINT(10) — Primary key — NOT NULL
- questionid — BIGINT(10) — NOT NULL
- testtype — INT(8)
- testcode — LONGTEXT
- stdin — LONGTEXT
- expected — LONGTEXT
- extra — LONGTEXT
- useasexample — TINYINT(1) — NOT NULL
- display — VARCHAR(30) — NOT NULL
- hiderestiffail — TINYINT(1) — NOT NULL
- mark — DECIMAL(8,3) — NOT NULL
- INDEX — `mdl_quescodetest_que_ix`
mdl_question_dataset_definitions
- id — BIGINT(10) — Primary key — NOT NULL
- category — BIGINT(10) — Foreign key → mdl_question_categories.id — NOT NULL
- name — VARCHAR(255) — NOT NULL
- type — BIGINT(10) — NOT NULL
- options — VARCHAR(255) — NOT NULL
- itemcount — BIGINT(10) — NOT NULL
- INDEX — `mdl_quesdatadefi_cat_ix`
mdl_question_dataset_items
- id — BIGINT(10) — Primary key — NOT NULL
- definition — BIGINT(10) — Foreign key → mdl_question_dataset_definitions.id — NOT NULL
- itemnumber — BIGINT(10) — NOT NULL
- value — VARCHAR(255) — NOT NULL
- INDEX — `mdl_quesdataitem_def_ix`
mdl_question_datasets
- id — BIGINT(10) — Primary key — NOT NULL
- question — BIGINT(10) — Foreign key → mdl_question.id — NOT NULL
- datasetdefinition — BIGINT(10) — Foreign key → mdl_question_dataset_definitions.id — NOT NULL
- INDEX — `mdl_quesdata_quedat_ix`
- INDEX — `mdl_quesdata_que_ix`
- INDEX — `mdl_quesdata_dat_ix`
mdl_question_ddwtos
- id — BIGINT(10) — Primary key — NOT NULL
- questionid — BIGINT(10) — NOT NULL
- shuffleanswers — SMALLINT(4) — NOT NULL
- correctfeedback — LONGTEXT — NOT NULL
- correctfeedbackformat — TINYINT(2) — NOT NULL
- partiallycorrectfeedback — LONGTEXT — NOT NULL
- partiallycorrectfeedbackformat — TINYINT(2) — NOT NULL
- incorrectfeedback — LONGTEXT — NOT NULL
- incorrectfeedbackformat — TINYINT(2) — NOT NULL
- shownumcorrect — TINYINT(2) — NOT NULL
- INDEX — `mdl_quesddwt_que_ix`
mdl_question_gapselect
- id — BIGINT(10) — Primary key — NOT NULL
- questionid — BIGINT(10) — Foreign key → mdl_question.id — NOT NULL
- shuffleanswers — SMALLINT(4) — NOT NULL
- correctfeedback — LONGTEXT — NOT NULL
- correctfeedbackformat — TINYINT(2) — NOT NULL
- partiallycorrectfeedback — LONGTEXT — NOT NULL
- partiallycorrectfeedbackformat — TINYINT(2) — NOT NULL
- incorrectfeedback — LONGTEXT — NOT NULL
- incorrectfeedbackformat — TINYINT(2) — NOT NULL
- shownumcorrect — TINYINT(2) — NOT NULL
- INDEX — `mdl_quesgaps_que_ix`
mdl_question_hints
- id — BIGINT(10) — Primary key — NOT NULL
- questionid — BIGINT(10) — Foreign key → mdl_question.id — NOT NULL
- hint — LONGTEXT — NOT NULL
- hintformat — SMALLINT(4) — NOT NULL
- shownumcorrect — TINYINT(1)
- clearwrong — TINYINT(1)
- options — VARCHAR(255)
- INDEX — `mdl_queshint_que_ix`
mdl_question_multianswer
- id — BIGINT(10) — Primary key — NOT NULL
- question — BIGINT(10) — Foreign key → mdl_question.id — NOT NULL
- sequence — LONGTEXT — NOT NULL
- INDEX — `mdl_quesmult_que_ix`
mdl_question_numerical
- id — BIGINT(10) — Primary key — NOT NULL
- question — BIGINT(10) — Foreign key → mdl_question.id — NOT NULL
- answer — BIGINT(10) — Foreign key → mdl_question_answers.id — NOT NULL
- tolerance — VARCHAR(255) — NOT NULL
- INDEX — `mdl_quesnume_ans_ix`
- INDEX — `mdl_quesnume_que_ix`
mdl_question_numerical_options
- id — BIGINT(10) — Primary key — NOT NULL
- question — BIGINT(10) — Foreign key → mdl_question.id — NOT NULL
- showunits — SMALLINT(4) — NOT NULL
- unitsleft — SMALLINT(4) — NOT NULL
- unitgradingtype — SMALLINT(4) — NOT NULL
- unitpenalty — DECIMAL(12,7) — NOT NULL
- INDEX — `mdl_quesnumeopti_que_ix`
mdl_question_numerical_units
- id — BIGINT(10) — Primary key — NOT NULL
- question — BIGINT(10) — Foreign key → mdl_question.id — NOT NULL
- multiplier — DECIMAL(40,20) — NOT NULL
- unit — VARCHAR(50) — NOT NULL
- INDEX — `mdl_quesnumeunit_que_ix`
mdl_question_response_analysis
- id — BIGINT(10) — Primary key — NOT NULL
- hashcode — VARCHAR(40) — NOT NULL
- whichtries — VARCHAR(255) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- questionid — BIGINT(10) — NOT NULL
- variant — BIGINT(10)
- subqid — VARCHAR(100) — NOT NULL
- aid — VARCHAR(100)
- response — LONGTEXT
- credit — DECIMAL(15,5) — NOT NULL
mdl_question_response_count
- id — BIGINT(10) — Primary key — NOT NULL
- analysisid — BIGINT(10) — Foreign key → mdl_question_response_analysis.id — NOT NULL
- try — BIGINT(10) — NOT NULL
- rcount — BIGINT(10) — NOT NULL
- INDEX — `mdl_quesrespcoun_ana_ix`
mdl_question_statistics
- id — BIGINT(10) — Primary key — NOT NULL
- hashcode — VARCHAR(40) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- questionid — BIGINT(10) — Foreign key → mdl_question.id — NOT NULL
- slot — BIGINT(10)
- subquestion — SMALLINT(4) — NOT NULL
- variant — BIGINT(10)
- s — BIGINT(10) — NOT NULL
- effectiveweight — DECIMAL(15,5)
- negcovar — TINYINT(2) — NOT NULL
- discriminationindex — DECIMAL(15,5)
- discriminativeefficiency — DECIMAL(15,5)
- sd — DECIMAL(15,10)
- facility — DECIMAL(15,10)
- subquestions — LONGTEXT
- maxmark — DECIMAL(12,7)
- positions — LONGTEXT
- randomguessscore — DECIMAL(12,7)
- INDEX — `FK_mdl_question_statistics_mdl_question`
mdl_question_truefalse
- id — BIGINT(10) — Primary key — NOT NULL
- question — BIGINT(10) — Foreign key → mdl_question.id — NOT NULL
- trueanswer — BIGINT(10) — NOT NULL
- falseanswer — BIGINT(10) — NOT NULL
- INDEX — `mdl_questrue_que_ix`
mdl_question_usages
- id — BIGINT(10) — Primary key — NOT NULL
- contextid — BIGINT(10) — NOT NULL
- component — VARCHAR(255) — NOT NULL
- preferredbehaviour — VARCHAR(32) — NOT NULL
- INDEX — `mdl_quesusag_con_ix`
mdl_quiz
- id — BIGINT(10) — Primary key — NOT NULL
- course — BIGINT(10) — Foreign key → mdl_course.id — NOT NULL
- name — VARCHAR(255) — NOT NULL
- intro — LONGTEXT — NOT NULL
- introformat — SMALLINT(4) — NOT NULL
- timeopen — BIGINT(10) — NOT NULL
- timeclose — BIGINT(10) — NOT NULL
- timelimit — BIGINT(10) — NOT NULL
- overduehandling — VARCHAR(16) — NOT NULL
- graceperiod — BIGINT(10) — NOT NULL
- preferredbehaviour — VARCHAR(32) — NOT NULL
- canredoquestions — SMALLINT(4) — NOT NULL
- attempts — MEDIUMINT(6) — NOT NULL
- attemptonlast — SMALLINT(4) — NOT NULL
- grademethod — SMALLINT(4) — NOT NULL
- decimalpoints — SMALLINT(4) — NOT NULL
- questiondecimalpoints — SMALLINT(4) — NOT NULL
- reviewattempt — MEDIUMINT(6) — NOT NULL
- reviewcorrectness — MEDIUMINT(6) — NOT NULL
- reviewmarks — MEDIUMINT(6) — NOT NULL
- reviewspecificfeedback — MEDIUMINT(6) — NOT NULL
- reviewgeneralfeedback — MEDIUMINT(6) — NOT NULL
- reviewrightanswer — MEDIUMINT(6) — NOT NULL
- reviewoverallfeedback — MEDIUMINT(6) — NOT NULL
- questionsperpage — BIGINT(10) — NOT NULL
- navmethod — VARCHAR(16) — NOT NULL
- shuffleanswers — SMALLINT(4) — NOT NULL
- sumgrades — DECIMAL(10,5) — NOT NULL
- grade — DECIMAL(10,5) — NOT NULL
- timecreated — BIGINT(10) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- subnet — VARCHAR(255) — NOT NULL
- browsersecurity — VARCHAR(32) — NOT NULL
- delay1 — BIGINT(10) — NOT NULL
- delay2 — BIGINT(10) — NOT NULL
- showuserpicture — SMALLINT(4) — NOT NULL
- showblocks — SMALLINT(4) — NOT NULL
- completionattemptsexhausted — TINYINT(1)
- completionpass — TINYINT(1)
- allowofflineattempts — TINYINT(1)
- INDEX — `mdl_quiz_cou_ix`
mdl_quiz_attempts
- id — BIGINT(10) — Primary key — NOT NULL
- quiz — BIGINT(10) — Foreign key → mdl_quiz.id — NOT NULL
- userid — BIGINT(10) — Foreign key — NOT NULL
- attempt — MEDIUMINT(6) — NOT NULL
- uniqueid — BIGINT(10) — NOT NULL
- layout — LONGTEXT — NOT NULL
- currentpage — BIGINT(10) — NOT NULL
- preview — SMALLINT(3) — NOT NULL
- state — VARCHAR(16) — NOT NULL
- timestart — BIGINT(10) — NOT NULL
- timefinish — BIGINT(10) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- timemodifiedoffline — BIGINT(10) — NOT NULL
- timecheckstate — BIGINT(10)
- sumgrades — DECIMAL(10,5)
- INDEX — `mdl_quizatte_statim_ix`
- INDEX — `mdl_quizatte_qui_ix`
- INDEX — `mdl_quizatte_use_ix`
mdl_quiz_feedback
- id — BIGINT(10) — Primary key — NOT NULL
- quizid — BIGINT(10) — Foreign key → mdl_quiz.id — NOT NULL
- feedbacktext — LONGTEXT — NOT NULL
- feedbacktextformat — TINYINT(2) — NOT NULL
- mingrade — DECIMAL(10,5) — NOT NULL
- maxgrade — DECIMAL(10,5) — NOT NULL
- INDEX — `mdl_quizfeed_qui_ix`
mdl_quiz_grades
- id — BIGINT(10) — Primary key — NOT NULL
- quiz — BIGINT(10) — Foreign key → mdl_quiz.id — NOT NULL
- userid — BIGINT(10) — Foreign key — NOT NULL
- grade — DECIMAL(10,5) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- INDEX — `mdl_quizgrad_use_ix`
- INDEX — `mdl_quizgrad_qui_ix`
mdl_quiz_overrides
- id — BIGINT(10) — Primary key — NOT NULL
- quiz — BIGINT(10) — Foreign key → mdl_quiz.id — NOT NULL
- groupid — BIGINT(10) — Foreign key → mdl_groups.id
- userid — BIGINT(10) — Foreign key
- timeopen — BIGINT(10)
- timeclose — BIGINT(10)
- timelimit — BIGINT(10)
- attempts — MEDIUMINT(6)
- password — VARCHAR(255)
- INDEX — `mdl_quizover_qui_ix`
- INDEX — `mdl_quizover_gro_ix`
- INDEX — `mdl_quizover_use_ix`
mdl_quiz_overview_regrades
- id — BIGINT(10) — Primary key — NOT NULL
- questionusageid — BIGINT(10) — Foreign key → mdl_question_usages.id — NOT NULL
- slot — BIGINT(10) — NOT NULL
- newfraction — DECIMAL(12,7)
- oldfraction — DECIMAL(12,7)
- regraded — SMALLINT(4) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- INDEX — `FK_mdl_quiz_overview_regrades_mdl_question_usages`
mdl_quiz_reports
- id — BIGINT(10) — Primary key — NOT NULL
- name — VARCHAR(255)
- displayorder — BIGINT(10) — NOT NULL
- capability — VARCHAR(255)
mdl_quiz_sections
- id — BIGINT(10) — Primary key — NOT NULL
- quizid — BIGINT(10) — NOT NULL
- firstslot — BIGINT(10) — NOT NULL
- heading — VARCHAR(1333)
- shufflequestions — SMALLINT(4) — NOT NULL
- INDEX — `mdl_quizsect_qui_ix`
mdl_quiz_slots
- id — BIGINT(10) — Primary key — NOT NULL
- slot — BIGINT(10) — NOT NULL
- quizid — BIGINT(10) — Foreign key → mdl_quiz.id — NOT NULL
- page — BIGINT(10) — NOT NULL
- requireprevious — SMALLINT(4) — NOT NULL
- questionid — BIGINT(10) — Foreign key → mdl_question.id — NOT NULL
- maxmark — DECIMAL(12,7) — NOT NULL
- INDEX — `mdl_quizslot_qui_ix`
- INDEX — `mdl_quizslot_que_ix`
mdl_quiz_statistics
- id — BIGINT(10) — Primary key — NOT NULL
- hashcode — VARCHAR(40) — NOT NULL
- whichattempts — SMALLINT(4) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- firstattemptscount — BIGINT(10) — NOT NULL
- highestattemptscount — BIGINT(10) — NOT NULL
- lastattemptscount — BIGINT(10) — NOT NULL
- allattemptscount — BIGINT(10) — NOT NULL
- firstattemptsavg — DECIMAL(15,5)
- highestattemptsavg — DECIMAL(15,5)
- lastattemptsavg — DECIMAL(15,5)
- allattemptsavg — DECIMAL(15,5)
- median — DECIMAL(15,5)
- standarddeviation — DECIMAL(15,5)
- skewness — DECIMAL(15,10)
- kurtosis — DECIMAL(15,5)
- cic — DECIMAL(15,10)
- errorratio — DECIMAL(15,10)
- standarderror — DECIMAL(15,10)
mdl_quizaccess_onesession
- id — BIGINT(10) — Primary key — NOT NULL
- quizid — BIGINT(10) — Foreign key → mdl_quiz.id — NOT NULL
- enabled — TINYINT(1) — NOT NULL
mdl_quizaccess_onesession_sess
- id — BIGINT(10) — Primary key — NOT NULL
- quizid — BIGINT(10) — Foreign key → mdl_quiz.id — NOT NULL
- attemptid — BIGINT(10) — Foreign key → mdl_quiz_attempts.id — NOT NULL
- sessionhash — VARCHAR(32) — NOT NULL
- INDEX — `mdl_quizonessess_qui_ix`