← Shopware 6.4.15.2

Shopware 6.4.15.2 country

Country definitions used for shipping, billing, tax rules, and address validation.

Columns

17 columns

Column Type Nullable Additional
id binary(16) NO Primary Key
iso varchar(255) YES
position int(11) NO Default: 1
tax_free tinyint(1) NO Default: 0
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
company_tax_free 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 longtext YES
company_tax longtext YES
created_at datetime(3) NO
updated_at datetime(3) YES
shipping_available tinyint(1) NO Default: 1

Indexes

1 indexes

Index Name Columns Unique
PRIMARY id Yes

Relations (to this table)

9 relations

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