This space is archived
For current information please use the current ExamSys documentation
track_changes
Purpose:Â Stores changes to data. Mainly used to log changes to questions.
Joins: users table.
Field | Type | Purpose |
---|---|---|
id | int(4) | Primary Key â auto increment. |
type | varchar(40) | Type of the change, i.e. 'Edit Question' or 'New Option' |
typeID | int(4) | ID of the piece of data that has been changed. Could be paper, question or option ID depending on the change. |
editor | int(10) unsigned | User ID of the member of staff who did the change. |
old | text | The old value of the object. |
new | text | The new value of the object. |
changed | datetime | Datetime when the change occurred. |
part | text | The field changed. |