navigation_menu_item_assignment_settings


Description

More data about navigation menu item assignments to navigation menus, including localized content.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
navigation_menu_item_assignment_setting_id BIGINT UNSIGNED 20 √ null
navigation_menu_item_assignment_id BIGINT 19 null
navigation_menu_item_assignments.navigation_menu_item_assignment_id assignment_settings_navigation_menu_item_assignment_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 navigation_menu_item_assignment_setting_id
navigation_menu_item_assignment_settings_n_m_i_a_id Performance Asc navigation_menu_item_assignment_id
navigation_menu_item_assignment_settings_unique Must be unique Asc/Asc/Asc navigation_menu_item_assignment_id + locale + setting_name

Relationships

Close relationships within degrees of separation