Versions
The versions table contains data about changes that have happened to objects in the organization. This data is currently unused anywhere by the system.
This table can be used to determine which changes happened on what, as well as metadata about the change such as when it was created.
Columns
| Column Name | Description | Type | Nullable |
|---|---|---|---|
| id | The numerical identifier of the object. | INT8 | No |
| item_type | The class name of the type of item that was changed. | VARCHAR | No |
| item_id | The numerical identifier of the related object for this change. Can be used with item_type to look up the object itself in the appropriate table. |
INT4 | No |
| event | The type of update that occurred. | VARCHAR | No |
| whodunnit | A representation of IDs that made the change. | VARCHAR | Yes |
| object | A JSON representation of the object before the changes were made. | JSONB | Yes |
| object_changes | A JSON representation of the changes that were made to the object. | JSONB | Yes |
| created_at | The UTC timestamp when this object was created. | TIMESTAMP | No |