questions_metadata

Purpose: Extensible table to allow any metadata information to be associated with a question.
Joins: questions table.

Field	Type	Purpose
id	int(11)	Primary Key auto_increment
questionID	int(11)	questionID from the questions table (this is a foreign key from Rogo 7.4)
type	varchar(255)	The type (or name) of the metadata information. (e.g. 'town')
value	varchar(255)	The value of the metadata information. (e.g. 'London')

ExamSys (Archive)