Difference between revisions of "Short Answer question type"

Jump to: navigation, search
 
(Database tables)
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.

Response storage

Question->options

State->options