track_changes

Purpose: Stores changes to data. Mainly used to log changes to questions.
Joins: users table.

FieldTypePurpose
idint(4)Primary Key – auto increment.
typevarchar(40)Type of the change, i.e. 'Edit Question' or 'New Option'
typeIDint(4)ID of the piece of data that has been changed. Could be paper, question or option ID depending on the change.
editorint(10) unsignedUser ID of the member of staff who did the change.
oldtextThe old value of the object.
newtextThe new value of the object.
changeddatetimeDatetime when the change occurred.
parttextThe field changed.