Short Answer question type

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.