Олег Давидович: 1 версия импортирована

2024-10-21T08:53:04Z

1 версия импортирована

← Предыдущая версия	Версия от 08:53, 21 октября 2024
(нет различий)

1>TimHunt: Reverted edits by Dooug (Talk); changed back to last version by TimHunt

2009-03-08T09:56:49Z

Reverted edits by Dooug (Talk); changed back to last version by TimHunt

Новая страница

{{Quiz developer docs}}

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

==Quiz settings and runtime overview==

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 [[Development:Question_database_structure]] for details.

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

[[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==

* Fields that hold an overall score, like quiz.grade, should be NUMBER(10,5).
* Fields that hold an individual question score, like quiz_question_instances.grade, should be NUMBER(12,7).

==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.

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

==Rough change-log==

===Moodle 2.0===

* New field quiz.showuserpicture. See MDL-3156.
* All the quiz report tables are new. See [[Development:Quiz_report_enhancements]]
* All fields that store grades were reviewed and set to the recommended types mentioned above.
* Never used quiz_question_versions table was removed.

===Moodle 1.9===

* Time limit field changed to int(10).

===Moodle 1.7===

* New table quiz_feedback.

==See also==

* [[Development:Question_database_structure| Question bank/engine database structure]]
* [[Development:Database_schema_introduction|Database schema introduction]]

[[Category:Developer]]
[[Category:Quiz]]

Development:Quiz database structure - История изменений

Олег Давидович: 1 версия импортирована

1>TimHunt: Reverted edits by Dooug (Talk); changed back to last version by TimHunt