Note: You are currently viewing documentation for Moodle 3.8. Up-to-date documentation for the latest stable version of Moodle may be available here: Dataset dependent.

Development:Dataset dependent: Difference between revisions

From MoodleDocs
Line 5: Line 5:
===quiz_dataset_definitions===  
===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.
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.
;id :int(10) unsigned NOT NULL auto_increment,
;category :int(10) unsigned NOT NULL default '0',
;name :varchar(255) NOT NULL default '',
;type :int(10) NOT NULL default '0',
;options :varchar(255) NOT NULL default '',
;itemcount :int(10) unsigned NOT NULL default '0',


===quiz_dataset_items===
===quiz_dataset_items===

Revision as of 00:09, 7 February 2006

Template:Questiontype developer docs

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.

id
int(10) unsigned NOT NULL auto_increment,
category
int(10) unsigned NOT NULL default '0',
name
varchar(255) NOT NULL default ,
type
int(10) NOT NULL default '0',
options
varchar(255) NOT NULL default ,
itemcount
int(10) unsigned NOT NULL default '0',

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',

Response storage

Question->options

State->options