Short Answer question type: Difference between revisions
From MoodleDocs
No edit summary |
|||
Line 2: | Line 2: | ||
==Database tables== | ==Database tables== | ||
The quiz_shortanswer table is an extension of the quiz_questions table. | |||
;id | |||
:int(10) unsigned NOT NULL auto_increment, | |||
:Primary key | |||
;question | |||
:int(10) unsigned NOT NULL default '0', | |||
:Foreign key to the id field of the quiz_questions table | |||
;answers | |||
:varchar(255) NOT NULL default '', | |||
:A comma separated list of answer ids. This is redundant | |||
;usecase | |||
:tinyint(2) NOT NULL default '0', | |||
:used to decide whether to do a case sensitive or case insensitive comparison for grading. | |||
==Response storage== | ==Response storage== |
Revision as of 23:30, 5 February 2006
Database tables
The quiz_shortanswer table is an extension of the quiz_questions table.
- id
- int(10) unsigned NOT NULL auto_increment,
- Primary key
- question
- int(10) unsigned NOT NULL default '0',
- Foreign key to the id field of the quiz_questions table
- answers
- varchar(255) NOT NULL default ,
- A comma separated list of answer ids. This is redundant
- usecase
- tinyint(2) NOT NULL default '0',
- used to decide whether to do a case sensitive or case insensitive comparison for grading.