library_file_settings


Description

More data about library files, including localized content such as names.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
library_file_setting_id BIGINT UNSIGNED 20 null
file_id BIGINT 19 null
library_files.file_id library_file_settings_file_id_foreignC
locale VARCHAR 14 ''
setting_name VARCHAR 255 null
setting_value MEDIUMTEXT 16777215 NULL
setting_type VARCHAR 6 null

(bool|int|float|string|object|date)

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc library_file_setting_id
library_file_settings_file_id Performance Asc file_id
library_file_settings_unique Must be unique Asc/Asc/Asc file_id + locale + setting_name

Relationships