category_settings


Description

More data about categories, including localized properties such as names.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
category_setting_id BIGINT UNSIGNED 20 null
category_id BIGINT 19 null
categories.category_id category_settings_category_id_foreignC
locale VARCHAR 14 ''
setting_name VARCHAR 255 null
setting_value MEDIUMTEXT 16777215 NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc category_setting_id
category_settings_category_id Performance Asc category_id
category_settings_unique Must be unique Asc/Asc/Asc category_id + locale + setting_name

Relationships