Audit trail on objects
| Column | Type | References | Comments |
|---|---|---|---|
| id | Integer | Primary key | |
| vdb_id | Integer | ||
| object_id | Integer | Object ID | |
| object_type | Integer | Object type | |
| project_id | Integer | db_project.id | |
| user_id | Integer | db_person.id | User ID |
| document_id | Integer | db_document.id | Related document ID |
| message_id | Integer | db_message.id | Related message ID |
| task_update_id | Integer | db_task_update.id | Related task update ID |
| process_update_id | Integer | db_process_update.id | Related process update ID |
| created | Date | Date | |
| event_code | String | Event code - one of CREATED | MODIFIED | UPDATED | DELETED | |
| event_sub_code | String | Event sub code | |
| xml_string | String | REMOVE AFTER v9.5 | |
| params_json | String | ||
| message | String | Additional comments e.g. of task or process update |