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`