publication_settings


Description

More data about publications, including localized properties such as the title and abstract.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
publication_setting_id BIGINT UNSIGNED 20 null
publication_id BIGINT 19 null
publications.publication_id publication_settings_publication_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 publication_setting_id
publication_settings_name_value Performance Asc/Asc setting_name + setting_value
publication_settings_publication_id Performance Asc publication_id
publication_settings_unique Must be unique Asc/Asc/Asc publication_id + locale + setting_name

Relationships