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 | object_name | String | Object name (only present for deleted objects) | ||
| project_id | Integer | db_project.id | Project ID (only present for deleted objects) | ||||
| user_id | Integer | db_person.id | User 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 | Differences in case of an edit event | REMOVE AFTER v9.5 | ||||
| params_json | String | ||||||
| message | String | Additional messagecomments e.g. of task or process update |