track_changes
- Neill Magill
Owned by Neill Magill
Oct 25, 2022
1 min read
Loading data...
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. |