Dataset dependent - Revision history

Bostelm: fix headlines

2009-12-27T14:20:44Z

fix headlines

← Older revision		Revision as of 14:20, 27 December 2009
Line 3:		Line 3:
	==Database tables==		==Database tables==

	===question_dataset_definitions=== Organises and stores properties for dataset items		===question_dataset_definitions===

			Organises and stores properties for dataset items

	This table is an indirect extension to the question table, because the 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 question table, because the 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.
Line 21:		Line 23:
	the number of dataset items		the number of dataset items

	===question_dataset_items=== Individual dataset items		===question_dataset_items===

			Individual dataset items

	Dataset items can be created for each dataset. The dataset_items table stores these possible values for the variables defined in the dataset_definitions table.		Dataset items can be created for each dataset. The dataset_items table stores these possible values for the variables defined in the dataset_definitions table.
Line 31:		Line 35:
	;value :varchar(255) NOT NULL default '',		;value :varchar(255) NOT NULL default '',

	===question_datasets=== Many-many relation between questions and dataset definitions		===question_datasets===

			Many-many relation between questions and dataset definitions

	The question_datasets table is used by dataset dependent question types (i.e. calculated) to link datasets to questions.		The question_datasets table is used by dataset dependent question types (i.e. calculated) to link datasets to questions.

Fulano2040: /* question_dataset_definitions */

2007-06-30T00:42:21Z

question_dataset_definitions

← Older revision		Revision as of 00:42, 30 June 2007
Line 15:		Line 15:
	;name :varchar(255) NOT NULL default '',		;name :varchar(255) NOT NULL default '',
	;type :int(10) NOT NULL default '0',		;type :int(10) NOT NULL default '0',
			this can be 1=LITERAL 2=FILE 3=LINK
	;options :varchar(255) NOT NULL default '',		;options :varchar(255) NOT NULL default '',
	the options for this dataset separated by ':'(distribution:min:max:decimals)		the options for this dataset separated by ':'(distribution:min:max:decimals)

Fulano2040: /* question_datasets */

2007-06-30T00:41:07Z

question_datasets

← Older revision		Revision as of 00:41, 30 June 2007
Line 38:		Line 38:
	id from the question table		id from the question table
	;datasetdefinition :int(10) unsigned NOT NULL default '0',		;datasetdefinition :int(10) unsigned NOT NULL default '0',
	id ~~form~~ the question_dataset_definitions		id from the question_dataset_definitions table

	==Response storage==		==Response storage==

Fulano2040: /* question_dataset_items */

2007-06-13T17:52:29Z

question_dataset_items

← Older revision		Revision as of 17:52, 13 June 2007
Line 22:		Line 22:
	===question_dataset_items=== Individual dataset items		===question_dataset_items=== Individual 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 dataset_definitions table.		Dataset items can be created for each dataset. The dataset_items table stores these possible values for the variables defined in the dataset_definitions table.

	;id :int(10) unsigned NOT NULL auto_increment,		;id :int(10) unsigned NOT NULL auto_increment,

Fulano2040: /* question_dataset_items */

2007-06-13T17:51:40Z

question_dataset_items

← Older revision		Revision as of 17:51, 13 June 2007
Line 22:		Line 22:
	===question_dataset_items=== Individual dataset items		===question_dataset_items=== Individual 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.		Dataset items can be created for each dataset. The quiz_dataset_items table stores these possible values for the variables defined in the dataset_definitions table.

	;id :int(10) unsigned NOT NULL auto_increment,		;id :int(10) unsigned NOT NULL auto_increment,

Fulano2040: /* question_datasets */

2007-06-13T17:51:12Z

question_datasets

← Older revision		Revision as of 17:51, 13 June 2007
Line 32:		Line 32:
	===question_datasets=== Many-many relation between questions and dataset definitions		===question_datasets=== Many-many relation between questions and dataset definitions

	The ~~quiz_question_datasets~~ table is used by dataset dependent ~~questionypes~~ (i.e. calculated) to link datasets to questions.		The question_datasets table is used by dataset dependent question types (i.e. calculated) to link datasets to questions.

	;id :int(10) unsigned NOT NULL auto_increment,		;id :int(10) unsigned NOT NULL auto_increment,
	;question :int(10) unsigned NOT NULL default '0',		;question :int(10) unsigned NOT NULL default '0',
			id from the question table
	;datasetdefinition :int(10) unsigned NOT NULL default '0',		;datasetdefinition :int(10) unsigned NOT NULL default '0',
			id form the question_dataset_definitions

	==Response storage==		==Response storage==

Fulano2040: /* question_dataset_definitions */

2007-06-13T17:47:08Z

question_dataset_definitions

← Older revision		Revision as of 17:47, 13 June 2007
Line 5:		Line 5:
	===question_dataset_definitions=== Organises and stores properties for dataset items		===question_dataset_definitions=== Organises and stores properties for dataset items

	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 question table, because the 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.

Fulano2040: /* quiz_dataset_items */

2007-06-13T17:45:22Z

quiz_dataset_items

← Older revision		Revision as of 17:45, 13 June 2007
Line 20:		Line 20:
	the number of dataset items		the number of dataset items

	===~~quiz_dataset_items~~=== Individual dataset items		===question_dataset_items=== Individual 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.		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.

Fulano2040: /* quiz_dataset_definitions */

2007-06-13T17:45:09Z

quiz_dataset_definitions

← Older revision		Revision as of 17:45, 13 June 2007
Line 3:		Line 3:
	==Database tables==		==Database tables==

	===~~quiz_dataset_definitions~~=== Organises and stores properties for dataset items		===question_dataset_definitions=== Organises and stores properties for dataset items

	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.

Fulano2040: /* quiz_question_datasets */

2007-06-13T17:44:47Z

quiz_question_datasets

← Older revision		Revision as of 17:44, 13 June 2007
Line 30:		Line 30:
	;value :varchar(255) NOT NULL default '',		;value :varchar(255) NOT NULL default '',

	===~~quiz_question_datasets~~===		===question_datasets=== Many-many relation between questions and dataset definitions

	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.