event_log


Description

A log of all events related to an object like a submission.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
log_id BIGINT 19 null
event_log_settings.log_id event_log_settings_log_idC
assoc_type BIGINT 19 null
assoc_id BIGINT 19 null
user_id BIGINT 19 NULL
users.user_id event_log_user_id_foreignC

NULL if it’s system or automated event

date_logged DATETIME 19 null
event_type BIGINT 19 NULL
message TEXT 65535 NULL
is_translated BIT 3 NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc log_id
event_log_assoc Performance Asc/Asc assoc_type + assoc_id
event_log_user_id Performance Asc user_id

Relationships