← Shopware 6.7.7.1

Shopware 6.7.7.1 country

Columns

21 columns

Column Type Nullable Additional
id binary(16) NO Primary Key
iso varchar(255) YES
position int NO Default: 1
active tinyint(1) NO Default: 1
iso3 varchar(45) YES
display_state_in_registration tinyint(1) NO Default: 0
force_state_in_registration tinyint(1) NO Default: 0
check_vat_id_pattern tinyint(1) NO Default: 0
vat_id_pattern varchar(255) YES
vat_id_required tinyint(1) NO Default: 0
customer_tax json YES
company_tax json YES
advanced_postal_code_pattern varchar(255) YES
check_advanced_postal_code_pattern tinyint(1) NO Default: 0
check_postal_code_pattern tinyint(1) NO Default: 0
default_postal_code_pattern varchar(1024) YES
postal_code_required tinyint(1) NO Default: 0
created_at datetime(3) NO
updated_at datetime(3) YES
shipping_available tinyint(1) NO Default: 1
is_eu tinyint(1) NO Default: 0

Indexes

1 indexes

Index Name Columns Unique
PRIMARY id Yes

Relations (to this table)

8 relations

Local Field Foreign Table Foreign Field
id country_state country_id
id country_translation country_id
id currency_country_rounding country_id
id customer_address country_id
id order_address country_id
id sales_channel country_id
id sales_channel_country country_id
id tax_rule country_id