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 | |||||
| objectproject_name | String | Object name (only present for deleted objects) | projectid | 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_projecttask_update.id | Project ID (only present for deleted objects) | userRelated task update ID | |||
| process_update_id | Integer | db_process_personupdate.id | User 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 | Differences in case of an edit event | |||||
| message | String | Additional messagecomments e.g. of task or process update |