v6.7.7.1
← Shopware 6.7.7.1

Shopware 6.7.7.1 language

Columns

9 columns

Column Type Nullable Additional
id binary(16) NO Primary Key
name varchar(50) NO
parent_id binary(16) YES Index Foreign Key → language.id
locale_id binary(16) NO Index Foreign Key → locale.id
translation_code_id binary(16) YES Index Foreign Key → locale.id
custom_fields json YES
created_at datetime(3) NO
updated_at datetime(3) YES
active tinyint(1) NO Default: 0

Indexes

5 indexes

Index Name Columns Unique
fk.language.locale_id locale_id No
fk.language.parent_id parent_id No
idx.language.language_id_parent_language_id id,parent_id No
idx.language.translation_code_id translation_code_id No
PRIMARY id Yes

Relations (from this table)

3 relations

Local Field Foreign Table Foreign Field
locale_id locale id
parent_id language id
translation_code_id locale id

Relations (to this table)

58 relations

Local Field Foreign Table Foreign Field
id app_action_button_translation language_id
id app_cms_block_translation language_id
id app_flow_action_translation language_id
id app_script_condition_translation language_id
id app_translation language_id
id category_translation language_id
id cms_page_translation language_id
id cms_slot_translation language_id
id country_state_translation language_id
id country_translation language_id
id currency_translation language_id
id customer_group_translation language_id
id delivery_time_translation language_id
id document_type_translation language_id
id import_export_profile_translation language_id
id landing_page_translation language_id
id language parent_id
id locale_translation language_id
id mail_header_footer_translation language_id
id mail_template_media language_id
id mail_template_translation language_id
id mail_template_type_translation language_id
id measurement_display_unit_translation language_id
id measurement_system_translation language_id
id media_translation language_id
id newsletter_recipient language_id
id number_range_translation language_id
id number_range_type_translation language_id
id order language_id
id payment_method_translation language_id
id plugin_translation language_id
id product_cross_selling_translation language_id
id product_feature_set_translation language_id
id product_keyword_dictionary language_id
id product_manufacturer_translation language_id
id product_review language_id
id product_search_config language_id
id product_search_keyword language_id
id product_sorting_translation language_id
id product_stream_translation language_id
id product_translation language_id
id promotion_translation language_id
id property_group_option_translation language_id
id property_group_translation language_id
id sales_channel language_id
id sales_channel_domain language_id
id sales_channel_language language_id
id sales_channel_translation language_id
id sales_channel_type_translation language_id
id salutation_translation language_id
id seo_url language_id
id shipping_method_translation language_id
id state_machine_state_translation language_id
id state_machine_translation language_id
id tax_provider_translation language_id
id tax_rule_type_translation language_id
id theme_translation language_id
id unit_translation language_id