subscription_type_settings


Description

More data about subscription types, including localized properties such as names.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
subscription_type_setting_id BIGINT UNSIGNED 20 null
type_id BIGINT 19 null
subscription_types.type_id subscription_type_settings_type_idC
locale VARCHAR 14 ''
setting_name VARCHAR 255 null
setting_value MEDIUMTEXT 16777215 NULL
setting_type VARCHAR 6 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc subscription_type_setting_id
subscription_type_settings_type_id Performance Asc type_id
subscription_type_settings_unique Must be unique Asc/Asc/Asc type_id + locale + setting_name

Relationships