citation_settings


Description

Additional data about citations, including localized content.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
citation_setting_id BIGINT UNSIGNED 20 null
citation_id BIGINT 19 null
citations.citation_id citation_settings_citation_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 citation_setting_id
citation_settings_citation_id Performance Asc citation_id
citation_settings_unique Must be unique Asc/Asc/Asc citation_id + locale + setting_name

Relationships