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.
Field | Type | Purpose |
---|---|---|
id | int(11) | Primary Key – auto increment. |
paperID | mediumint(8) unsigned | ID of the paper to apply the metadata to. |
name | varchar(255) | Metadata type (e.g. 'additional_notes') |
value | varchar(255) | Associated value (e.g. 'notes go here') |