db_audit
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 |