notification_subscription_settings


Description

Which email notifications a user has chosen to unsubscribe from.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
setting_id BIGINT 19 √ null
setting_name VARCHAR 64 null
setting_value MEDIUMTEXT 16777215 null
user_id BIGINT 19 null
users.user_id notification_subscription_settings_user_id_foreignC
context BIGINT 19 null
journals.journal_id notification_subscription_settings_context_foreignC
setting_type VARCHAR 6 null

(bool|int|float|string|object)

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc setting_id
notification_subscription_settings_context Performance Asc context
notification_subscription_settings_user_id Performance Asc user_id

Relationships

Close relationships within degrees of separation