paper_metadata

Purpose: Used for general paper metadata, such as the Safe Exam Browser keys, or any other general data. The id, paperID and name must be a unique combination.
Joins: properties table.

FieldTypePurpose
idint(11)Primary Key – auto increment.
paperIDmediumint(8) unsignedID of the paper to apply the metadata to.
namevarchar(255)Metadata type (e.g. 'additional_notes')
valuevarchar(255)Associated value (e.g. 'notes go here')