questions_metadata

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

FieldTypePurpose
idint(11)Primary Key auto_increment
questionIDint(11)questionID from the questions table (this is a foreign key from Rogo 7.4)
typevarchar(255)The type (or name) of the metadata information. (e.g. 'town')
valuevarchar(255)The value of the metadata information. (e.g. 'London')