submission_file_settings


Description

Localized data about submission files like published metadata.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
submission_file_setting_id BIGINT UNSIGNED 20 √ null
submission_file_id BIGINT UNSIGNED 20 null
submission_files.submission_file_id submission_file_settings_submission_file_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 submission_file_setting_id
submission_file_settings_submission_file_id Performance Asc submission_file_id
submission_file_settings_unique Must be unique Asc/Asc/Asc submission_file_id + locale + setting_name

Relationships

Close relationships within degrees of separation