RQP question type

Revision as of 00:18, 7 February 2006 by Gustav Delius (talk | contribs) (Database tables)

Jump to: navigation, search

Database tables

quiz_rqp

id 
int(10) unsigned NOT NULL auto_increment,
question 
int(10) unsigned NOT NULL default '0',
type 
int(10) unsigned NOT NULL default '0',
source 
longblob NOT NULL default ,
format 
varchar(255) NOT NULL default ,
flags 
tinyint(3) unsigned NOT NULL default '0',
maxscore 
int(10) unsigned NOT NULL default '1',

quiz_rqp_servers

id 
int(10) unsigned NOT NULL auto_increment,
typeid 
int(10) unsigned NOT NULL default '0',
url 
varchar(255) NOT NULL default ,
can_render 
tinyint(2) unsigned NOT NULL default '0',
can_author 
tinyint(2) unsigned NOT NULL default '0',

quiz_rqp_states

id 
int(10) unsigned NOT NULL auto_increment,
stateid 
int(10) unsigned NOT NULL default '0',
responses 
text NOT NULL default ,
persistent_data 
text NOT NULL default ,
template_vars 
text NOT NULL default ,

quiz_rqp_types

id int(10) 
unsigned NOT NULL auto_increment,
name 
varchar(255) NOT NULL default ,

Response storage

Question->options

State->options