author_settings


Description

More data about authors, including localized properties such as their name and affiliation.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
author_setting_id BIGINT UNSIGNED 20 √ null
author_id BIGINT 19 null
authors.author_id author_settings_author_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 author_setting_id
author_settings_author_id Performance Asc author_id
author_settings_unique Must be unique Asc/Asc/Asc author_id + locale + setting_name

Relationships

Close relationships within degrees of separation