event_log_settings


Description

Data about an event log entry. This data is commonly used to display information about an event to a user.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
event_log_setting_id BIGINT UNSIGNED 20 √ null
log_id BIGINT 19 null
event_log.log_id event_log_settings_log_idC
locale VARCHAR 14 ''
setting_name VARCHAR 255 null
setting_value MEDIUMTEXT 16777215 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc event_log_setting_id
event_log_settings_log_id Performance Asc log_id
event_log_settings_name_value Performance Asc/Asc setting_name + setting_value
event_log_settings_unique Must be unique Asc/Asc/Asc log_id + setting_name + locale

Relationships

Close relationships within degrees of separation