Last Quiz And Question
Tables (64)
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_drags
- id — BIGINT(10) — Primary key — NOT NULL
- questionid — BIGINT(10) — Foreign key — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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_qtype_match_subquestions
- id — BIGINT(10) — Primary key — NOT NULL
- questionid — BIGINT(10) — Foreign key — NOT NULL
- questiontext — LONGTEXT — NOT NULL
- questiontextformat — TINYINT(2) — NOT NULL
- answertext — VARCHAR(255) — NOT NULL
- INDEX — `mdl_qtypmatcsubq_que_ix`
mdl_qtype_multichoice_options
- id — BIGINT(10) — Primary key — NOT NULL
- questionid — BIGINT(10) — Foreign key — NOT NULL
- layout — SMALLINT(4) — NOT NULL
- single — SMALLINT(4) — 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
- answernumbering — VARCHAR(10) — NOT NULL
- shownumcorrect — TINYINT(2) — NOT NULL
mdl_qtype_multichoiceset_options
- id — BIGINT(10) — Primary key — NOT NULL
- questionid — BIGINT(10) — Foreign key — NOT NULL
- layout — SMALLINT(4) — NOT NULL
- shuffleanswers — SMALLINT(4) — NOT NULL
- correctfeedback — LONGTEXT — NOT NULL
- correctfeedbackformat — TINYINT(2) — NOT NULL
- incorrectfeedback — LONGTEXT — NOT NULL
- incorrectfeedbackformat — TINYINT(2) — NOT NULL
- answernumbering — VARCHAR(10) — NOT NULL
- shownumcorrect — TINYINT(2) — NOT NULL
mdl_qtype_pmatch
- id — BIGINT(10) — Primary key — NOT NULL
- questionid — BIGINT(10) — Foreign key — NOT NULL
- allowsubscript — TINYINT(2) — NOT NULL
- allowsuperscript — TINYINT(2) — NOT NULL
- forcelength — TINYINT(2) — NOT NULL
- usecase — TINYINT(2) — NOT NULL
- converttospace — LONGTEXT — NOT NULL
- applydictionarycheck — TINYINT(2) — NOT NULL
- extenddictionary — LONGTEXT — NOT NULL
- INDEX — `mdl_qtyppmat_que_ix`
mdl_qtype_pmatch_synonyms
- id — BIGINT(10) — Primary key — NOT NULL
- questionid — BIGINT(10) — Foreign key — NOT NULL
- word — LONGTEXT — NOT NULL
- synonyms — LONGTEXT — NOT NULL
- INDEX — `FK_mdl_qtype_pmatch_synonyms_mdl_question`
mdl_qtype_randomsamatch_options
- id — BIGINT(10) — Primary key — NOT NULL
- questionid — BIGINT(10) — Foreign key — NOT NULL
- choose — BIGINT(10) — NOT NULL
- subcats — TINYINT(2) — 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_qtype_shortanswer_options
- id — BIGINT(10) — Primary key — NOT NULL
- questionid — BIGINT(10) — Foreign key — NOT NULL
- usecase — TINYINT(2) — NOT NULL
mdl_qtype_stack_cas_cache
- id — BIGINT(10) — Primary key — NOT NULL
- hash — VARCHAR(40) — NOT NULL
- command — LONGTEXT — NOT NULL
- result — LONGTEXT — NOT NULL
- INDEX — `mdl_qtypstaccascach_has_ix`
mdl_qtype_stack_deployed_seeds
- id — BIGINT(10) — Primary key — NOT NULL
- questionid — BIGINT(10) — Foreign key — NOT NULL
- seed — BIGINT(10) — NOT NULL
- INDEX — `mdl_qtypstacdeplseed_que_ix`
mdl_qtype_stack_inputs
- id — BIGINT(10) — Primary key — NOT NULL
- questionid — BIGINT(10) — Foreign key — NOT NULL
- name — VARCHAR(32) — NOT NULL
- type — VARCHAR(32) — NOT NULL
- tans — VARCHAR(255) — NOT NULL
- boxsize — BIGINT(10) — NOT NULL
- strictsyntax — SMALLINT(4) — NOT NULL
- insertstars — SMALLINT(4) — NOT NULL
- syntaxhint — VARCHAR(255) — NOT NULL
- syntaxattribute — SMALLINT(4) — NOT NULL
- forbidwords — VARCHAR(255) — NOT NULL
- allowwords — VARCHAR(255) — NOT NULL
- forbidfloat — SMALLINT(4) — NOT NULL
- requirelowestterms — SMALLINT(4) — NOT NULL
- checkanswertype — SMALLINT(4) — NOT NULL
- mustverify — SMALLINT(4) — NOT NULL
- showvalidation — SMALLINT(4) — NOT NULL
- options — LONGTEXT — NOT NULL
- INDEX — `mdl_qtypstacinpu_que_ix`
mdl_qtype_stack_options
- id — BIGINT(10) — Primary key — NOT NULL
- questionid — BIGINT(10) — Foreign key — NOT NULL
- questionvariables — LONGTEXT — NOT NULL
- specificfeedback — LONGTEXT — NOT NULL
- specificfeedbackformat — TINYINT(2) — NOT NULL
- questionnote — VARCHAR(255) — NOT NULL
- questionsimplify — SMALLINT(4) — NOT NULL
- assumepositive — SMALLINT(4) — NOT NULL
- prtcorrect — LONGTEXT — NOT NULL
- prtcorrectformat — TINYINT(2) — NOT NULL
- prtpartiallycorrect — LONGTEXT — NOT NULL
- prtpartiallycorrectformat — TINYINT(2) — NOT NULL
- prtincorrect — LONGTEXT — NOT NULL
- prtincorrectformat — TINYINT(2) — NOT NULL
- multiplicationsign — VARCHAR(8) — NOT NULL
- sqrtsign — SMALLINT(4) — NOT NULL
- complexno — VARCHAR(8) — NOT NULL
- inversetrig — VARCHAR(8) — NOT NULL
- matrixparens — VARCHAR(8) — NOT NULL
- variantsselectionseed — VARCHAR(255)
mdl_qtype_stack_prt_nodes
- id — BIGINT(10) — Primary key — NOT NULL
- questionid — BIGINT(10) — Foreign key — NOT NULL
- prtname — VARCHAR(32) — NOT NULL
- nodename — VARCHAR(8) — NOT NULL
- answertest — VARCHAR(32) — NOT NULL
- sans — VARCHAR(255) — NOT NULL
- tans — VARCHAR(255) — NOT NULL
- testoptions — VARCHAR(255) — NOT NULL
- quiet — SMALLINT(4) — NOT NULL
- truescoremode — VARCHAR(4) — NOT NULL
- truescore — DECIMAL(12,7) — NOT NULL
- truepenalty — DECIMAL(12,7)
- truenextnode — VARCHAR(8)
- trueanswernote — VARCHAR(255) — NOT NULL
- truefeedback — LONGTEXT — NOT NULL
- truefeedbackformat — TINYINT(2) — NOT NULL
- falsescoremode — VARCHAR(4) — NOT NULL
- falsescore — DECIMAL(12,7)
- falsepenalty — DECIMAL(12,7)
- falsenextnode — VARCHAR(8)
- falseanswernote — VARCHAR(255) — NOT NULL
- falsefeedback — LONGTEXT — NOT NULL
- falsefeedbackformat — TINYINT(2) — NOT NULL
- INDEX — `mdl_qtypstacprtnode_queprt_ix`
mdl_qtype_stack_prts
- id — BIGINT(10) — Primary key — NOT NULL
- questionid — BIGINT(10) — Foreign key — NOT NULL
- name — VARCHAR(32) — NOT NULL
- value — DECIMAL(12,7) — NOT NULL
- autosimplify — SMALLINT(4) — NOT NULL
- feedbackvariables — LONGTEXT — NOT NULL
- firstnodename — VARCHAR(8) — NOT NULL
- INDEX — `mdl_qtypstacprts_que_ix`
mdl_qtype_stack_qtest_expected
- id — BIGINT(10) — Primary key — NOT NULL
- questionid — BIGINT(10) — Foreign key — NOT NULL
- testcase — BIGINT(10) — NOT NULL
- prtname — VARCHAR(32) — NOT NULL
- expectedscore — DECIMAL(12,7)
- expectedpenalty — DECIMAL(12,7)
- expectedanswernote — VARCHAR(255) — NOT NULL
- INDEX — `mdl_qtypstacqtesexpe_quetes_ix`
mdl_qtype_stack_qtest_inputs
- id — BIGINT(10) — Primary key — NOT NULL
- questionid — BIGINT(10) — Foreign key — NOT NULL
- testcase — BIGINT(10) — NOT NULL
- inputname — VARCHAR(32) — NOT NULL
- value — VARCHAR(255) — NOT NULL
- INDEX — `mdl_qtypstacqtesinpu_quetes_ix`
mdl_qtype_stack_qtests
- id — BIGINT(10) — Primary key — NOT NULL
- questionid — BIGINT(10) — Foreign key — NOT NULL
- testcase — BIGINT(10) — NOT NULL
- INDEX — `mdl_qtypstacqtes_que_ix`
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 → mdl_user.id — 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 → mdl_user.id — 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 → mdl_user.id
- 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`
mdl_user
- id — BIGINT(10) — Primary key — NOT NULL
- auth — VARCHAR(20) — NOT NULL
- confirmed — TINYINT(1) — NOT NULL
- policyagreed — TINYINT(1) — NOT NULL
- deleted — TINYINT(1) — NOT NULL
- suspended — TINYINT(1) — NOT NULL
- mnethostid — BIGINT(10) — NOT NULL
- username — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- idnumber — VARCHAR(255) — NOT NULL
- firstname — VARCHAR(100) — NOT NULL
- lastname — VARCHAR(100) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- emailstop — TINYINT(1) — NOT NULL
- icq — VARCHAR(15) — NOT NULL
- skype — VARCHAR(50) — NOT NULL
- yahoo — VARCHAR(50) — NOT NULL
- aim — VARCHAR(50) — NOT NULL
- msn — VARCHAR(50) — NOT NULL
- phone1 — VARCHAR(20) — NOT NULL
- phone2 — VARCHAR(20) — NOT NULL
- institution — VARCHAR(255) — NOT NULL
- department — VARCHAR(255) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- city — VARCHAR(120) — NOT NULL
- country — VARCHAR(2) — NOT NULL
- lang — VARCHAR(30) — NOT NULL
- calendartype — VARCHAR(30) — NOT NULL
- theme — VARCHAR(50) — NOT NULL
- timezone — VARCHAR(100) — NOT NULL
- firstaccess — BIGINT(10) — NOT NULL
- lastaccess — BIGINT(10) — NOT NULL
- lastlogin — BIGINT(10) — NOT NULL
- currentlogin — BIGINT(10) — NOT NULL
- lastip — VARCHAR(45) — NOT NULL
- secret — VARCHAR(15) — NOT NULL
- picture — BIGINT(10) — NOT NULL
- url — VARCHAR(255) — NOT NULL
- description — LONGTEXT
- descriptionformat — TINYINT(2) — NOT NULL
- mailformat — TINYINT(1) — NOT NULL
- maildigest — TINYINT(1) — NOT NULL
- maildisplay — TINYINT(2) — NOT NULL
- autosubscribe — TINYINT(1) — NOT NULL
- trackforums — TINYINT(1) — NOT NULL
- timecreated — BIGINT(10) — NOT NULL
- timemodified — BIGINT(10) — NOT NULL
- trustbitmask — BIGINT(10) — NOT NULL
- imagealt — VARCHAR(255)
- lastnamephonetic — VARCHAR(255)
- firstnamephonetic — VARCHAR(255)
- middlename — VARCHAR(255)
- alternatename — VARCHAR(255)
- INDEX — `mdl_user_del_ix`
- INDEX — `mdl_user_con_ix`
- INDEX — `mdl_user_fir_ix`
- INDEX — `mdl_user_las_ix`
- INDEX — `mdl_user_cit_ix`
- INDEX — `mdl_user_cou_ix`
- INDEX — `mdl_user_las2_ix`
- … +7