http://wiki.mipt.ru/index.php?action=history&feed=atom&title=Development%3ADataset_dependentDevelopment:Dataset dependent - История изменений2026-05-07T16:24:48ZИстория изменений этой страницы в викиMediaWiki 1.42.1http://wiki.mipt.ru/index.php?title=Development:Dataset_dependent&diff=11026&oldid=prevОлег Давидович: 1 версия импортирована2024-10-21T08:51:10Z<p>1 версия импортирована</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<tr class="diff-title" lang="ru">
<td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">← Предыдущая версия</td>
<td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">Версия от 08:51, 21 октября 2024</td>
</tr><tr><td colspan="2" class="diff-notice" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>Олег Давидовичhttp://wiki.mipt.ru/index.php?title=Development:Dataset_dependent&diff=11025&oldid=prev1>Bostelm: fix headlines2009-12-27T14:20:44Z<p>fix headlines</p>
<p><b>Новая страница</b></p><div>{{Questiontype developer docs}}<br />
<br />
==Database tables==<br />
<br />
===question_dataset_definitions=== <br />
<br />
Organises and stores properties for dataset items<br />
<br />
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.<br />
<br />
<br />
<br />
;id :int(10) unsigned NOT NULL auto_increment,<br />
;category :int(10) unsigned NOT NULL default '0', <br />
when this is a shared dataset the value is the category id <br />
when this is a private dataset the value is 0<br />
;name :varchar(255) NOT NULL default '',<br />
;type :int(10) NOT NULL default '0',<br />
this can be 1=LITERAL 2=FILE 3=LINK<br />
;options :varchar(255) NOT NULL default '', <br />
the options for this dataset separated by ':'(distribution:min:max:decimals)<br />
;itemcount :int(10) unsigned NOT NULL default '0',<br />
the number of dataset items<br />
<br />
===question_dataset_items=== <br />
<br />
Individual dataset items<br />
<br />
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.<br />
<br />
;id :int(10) unsigned NOT NULL auto_increment,<br />
;definition :int(10) unsigned NOT NULL default '0',<br />
id corresponding to the question_dataset_definitions table<br />
;number :int(10) unsigned NOT NULL default '0',<br />
;value :varchar(255) NOT NULL default '',<br />
<br />
===question_datasets=== <br />
<br />
Many-many relation between questions and dataset definitions<br />
<br />
The question_datasets table is used by dataset dependent question types (i.e. calculated) to link datasets to questions.<br />
<br />
;id :int(10) unsigned NOT NULL auto_increment,<br />
;question :int(10) unsigned NOT NULL default '0',<br />
id from the question table<br />
;datasetdefinition :int(10) unsigned NOT NULL default '0',<br />
id from the question_dataset_definitions table<br />
<br />
==Response storage==<br />
<br />
==Question->options==<br />
<br />
==State->options==<br />
<br />
[[Category:Developer]]<br />
[[Category:Quiz]]</div>1>Bostelm