Short Answer question type

Revision as of 23:30, 5 February 2006 by Gustav Delius (talk | contribs) (Database tables)

Jump to: navigation, search

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