db_audit

Audit trail on objects

ColumnTypeReferencesComments
idInteger Primary key
vdb_idInteger  
object_idInteger Object ID
object_typeInteger Object type
project_idIntegerdb_project.id 
user_idIntegerdb_person.idUser ID
document_idIntegerdb_document.idRelated document ID
message_idIntegerdb_message.idRelated message ID
task_update_idIntegerdb_task_update.idRelated task update ID
process_update_idIntegerdb_process_update.idRelated process update ID
createdDate Date
event_codeString Event code - one of CREATED | MODIFIED | UPDATED | DELETED
event_sub_codeString Event sub code
xml_stringString REMOVE AFTER v9.5
params_jsonString  
messageString Additional comments e.g. of task or process update