Dataset dependent: Difference between revisions
From MoodleDocs
| Line 13: | Line 13: | ||
The quiz_question_datasets table is used by dataset dependent questionypes (i.e. calculated) to link datasets to questions. | The quiz_question_datasets table is used by dataset dependent questionypes (i.e. calculated) to link datasets to questions. | ||
;id :int(10) unsigned NOT NULL auto_increment, | |||
;question :int(10) unsigned NOT NULL default '0', | |||
;datasetdefinition :int(10) unsigned NOT NULL default '0', | |||
==Response storage== | ==Response storage== | ||
Revision as of 00:07, 7 February 2006
Database tables
quiz_dataset_definitions
This table is an indirect extension to the quiz_questions table, because the quiz_question_datasets table can link a question to one or more datasets. Each dataset represents a variable, that is used either in the questiontext or in the answer to a dataset dependent question.
quiz_dataset_items
Dataset items can be created for each dataset. The quiz_dataset_items table stores these possible values for the variables defined in the quiz_dataset_definitions table.
quiz_question_datasets
The quiz_question_datasets table is used by dataset dependent questionypes (i.e. calculated) to link datasets to questions.
- id
- int(10) unsigned NOT NULL auto_increment,
- question
- int(10) unsigned NOT NULL default '0',
- datasetdefinition
- int(10) unsigned NOT NULL default '0',
