Quiz database structure - Revision history

Tim Hunt: /* Quiz settings and runtime overview */

2020-04-25T10:54:03Z

Quiz settings and runtime overview

← Older revision		Revision as of 10:54, 25 April 2020
Line 9:		Line 9:
	Note that information about the attempter's interaction with each question is [[Overview_of_the_Moodle_question_engine#Database_tables\|stored by the question engine]].		Note that information about the attempter's interaction with each question is [[Overview_of_the_Moodle_question_engine#Database_tables\|stored by the question engine]].

	Note: the diagram below is a bit out of date. The significant change is that quiz_question_instances has been renamed ~~quiz_slot~~.		Note: the diagram below is a bit out of date. The significant change is that quiz_question_instances has been renamed quiz_slots.
	[[Image:Quiz_database.png\|560px]]		[[Image:Quiz_database.png\|560px]]

2020-04-25T10:53:52Z

Quiz settings and runtime overview

← Older revision		Revision as of 10:53, 25 April 2020
Line 9:		Line 9:
	Note that information about the attempter's interaction with each question is [[Overview_of_the_Moodle_question_engine#Database_tables\|stored by the question engine]].		Note that information about the attempter's interaction with each question is [[Overview_of_the_Moodle_question_engine#Database_tables\|stored by the question engine]].

			Note: the diagram below is a bit out of date. The significant change is that quiz_question_instances has been renamed quiz_slot.
	[[Image:Quiz_database.png\|560px]]		[[Image:Quiz_database.png\|560px]]

2014-07-10T22:58:25Z

Quiz settings and runtime overview

← Older revision		Revision as of 22:58, 10 July 2014
Line 7:		Line 7:
	It is helpful to distinguish between quiz settings, which is where we store information about how the teacher has set up the quiz, and 'runtime' (not a great name) where we store information about people's attempts at the quiz.		It is helpful to distinguish between quiz settings, which is where we store information about how the teacher has set up the quiz, and 'runtime' (not a great name) where we store information about people's attempts at the quiz.

	Note that information about the attempter's interaction with each question is stored by the question engine~~. See [[Question_database_structure~~]] ~~for details~~.		Note that information about the attempter's interaction with each question is [[Overview_of_the_Moodle_question_engine#Database_tables\|stored by the question engine]].

	[[Image:Quiz_database.png\|560px]]		[[Image:Quiz_database.png\|560px]]

2013-04-23T04:32:59Z

Verb 'use' should be in past tense

← Older revision		Revision as of 04:32, 23 April 2013
Line 1:		Line 1:
	{{Quiz developer docs}}		{{Quiz developer docs}}

	This page documents the database tables ~~use~~ by the quiz module.		This page documents the database tables used by the quiz module.

	==Quiz settings and runtime overview==		==Quiz settings and runtime overview==

2012-04-24T16:26:52Z

Rough change-log

← Older revision		Revision as of 16:26, 24 April 2012
Line 31:		Line 31:
	* New column quiz.navmethod for MDL-11047.		* New column quiz.navmethod for MDL-11047.
	* New columns quiz.gradeperiod, quiz.overduehandling and quiz_attempts.state for MDL-3030.		* New columns quiz.gradeperiod, quiz.overduehandling and quiz_attempts.state for MDL-3030.
			* Old columns quiz_reports.cron and quiz_reports.lastcron dropped (MDL-30635). (config_plugins is now used, as for other plugin types.)

	===Moodle 2.2===		===Moodle 2.2===
Line 41:		Line 42:
	* New quiz.showblocks column.		* New quiz.showblocks column.
	* Old quiz.review column split into seven new quiz.review* columns.		* Old quiz.review column split into seven new quiz.review* columns.
	*

	===Moodle 2.0===		===Moodle 2.0===
Line 51:		Line 51:
	* All fields that store grades were reviewed and set to the recommended types mentioned above.		* All fields that store grades were reviewed and set to the recommended types mentioned above.
	* Never used quiz_question_versions table was removed.		* Never used quiz_question_versions table was removed.
			* New table quiz_overrides for MDL-16478.

	===Moodle 1.9===		===Moodle 1.9===

2012-04-24T16:21:39Z

Rough change-log

← Older revision		Revision as of 16:21, 24 April 2012
Line 25:		Line 25:

	==Rough change-log==		==Rough change-log==

			===Moodle 2.3===

			* New column quiz_attempts.currentpage for MDL-3054.
			* New column quiz.navmethod for MDL-11047.
			* New columns quiz.gradeperiod, quiz.overduehandling and quiz_attempts.state for MDL-3030.

	===Moodle 2.2===		===Moodle 2.2===

2012-04-24T16:09:45Z

← Older revision		Revision as of 16:09, 24 April 2012
Line 12:		Line 12:

	[[Image:Quiz_database.dia]] [http://projects.gnome.org/dia/ Dia ] file, should you wish to have a copy of this diagram in an editable format.		[[Image:Quiz_database.dia]] [http://projects.gnome.org/dia/ Dia ] file, should you wish to have a copy of this diagram in an editable format.

	~~==Quiz report tables overview==~~

	~~[[Image:Quiz_reports_database.png\|614px]]~~

	~~[[Image:Quiz_reports_database.dia]] [http://projects.gnome.org/dia/ Dia ] file, should you wish to have a copy of this diagram in an editable format.~~

	==Common field types==		==Common field types==

2011-10-13T14:02:30Z

Moodle 2.2

← Older revision		Revision as of 14:02, 13 October 2011
Line 36:		Line 36:
	* Old quiz.popup column replaced by quiz.browsersecurity		* Old quiz.popup column replaced by quiz.browsersecurity

	===Moodle 2.1 (new question engine)		===Moodle 2.1 (new question engine)===

	* Old quiz.optionflags and quiz.penaltyscheme columns replaced by quiz.preferredbehaviour.		* Old quiz.optionflags and quiz.penaltyscheme columns replaced by quiz.preferredbehaviour.
	* New quiz.showblocks column.		* New quiz.showblocks column.
	* Old quiz.review column split into seven new quiz.review* columns.		* Old quiz.review column split into seven new quiz.review* columns.
	*		*

	===Moodle 2.0===		===Moodle 2.0===

2011-10-13T14:02:19Z

Rough change-log

← Older revision		Revision as of 14:02, 13 October 2011
Line 31:		Line 31:

	==Rough change-log==		==Rough change-log==

			===Moodle 2.2===

			* Old quiz.popup column replaced by quiz.browsersecurity

			===Moodle 2.1 (new question engine)

			* Old quiz.optionflags and quiz.penaltyscheme columns replaced by quiz.preferredbehaviour.
			* New quiz.showblocks column.
			* Old quiz.review column split into seven new quiz.review* columns.
			*

	===Moodle 2.0===		===Moodle 2.0===

			* New field quiz.introformat.
			* New field quiz.questiondecimalpoints.
	* New field quiz.showuserpicture. See MDL-3156.		* New field quiz.showuserpicture. See MDL-3156.
	* All the quiz report tables are new. See [[Quiz_report_enhancements]]		* All the quiz report tables are new. See [[Quiz_report_enhancements]]

2011-10-13T13:57:50Z

Detailed table descriptions

← Older revision		Revision as of 13:57, 13 October 2011
Line 26:		Line 26:
	==Detailed table descriptions==		==Detailed table descriptions==

	In Moodle 2.0 dev, you can get these by going to Administration -> Development -> XMLDB and clicking on the [Doc] link next in any of the relevant rows (mod/quiz/db, mod/quiz/report/''xxx''/db). Looking directly there is much more likely to be up-to-date than relying on information that has been copied here.		In Moodle 2.x dev, you can get these by going to Administration -> Development -> XMLDB and clicking on the [Doc] link next in any of the relevant rows (mod/quiz/db, mod/quiz/report/''xxx''/db). Looking directly there is much more likely to be up-to-date than relying on information that has been copied here.

	(Wouldn't it be nice if that documentation was automatically ~~build~~ and available online.)		(Wouldn't it be nice if that documentation was automatically built and available online.)

	==Rough change-log==		==Rough change-log==