notification_settings


Description

More data about notifications, including localized properties.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
notification_setting_id BIGINT UNSIGNED 20 null
notification_id BIGINT 19 null
notifications.notification_id notification_settings_notification_id_foreignC
locale VARCHAR 14 NULL
setting_name VARCHAR 64 null
setting_value MEDIUMTEXT 16777215 null
setting_type VARCHAR 6 null

(bool|int|float|string|object)

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc notification_setting_id
notification_settings_notification_id Performance Asc notification_id
notification_settings_unique Must be unique Asc/Asc/Asc notification_id + locale + setting_name

Relationships