← Shopware 5.6.8

Shopware 5.6.8 s_core_countries

Country definitions with ISO codes, tax-free settings, and address format configuration.

Columns

15 columns

Column Type Nullable Additional
id int(11) NO Primary Key, auto_increment
countryname varchar(255) YES
countryiso varchar(255) YES
areaID int(11) YES Index
countryen varchar(255) YES
position int(11) YES
notice text YES
taxfree int(11) YES
taxfree_ustid int(11) YES
taxfree_ustid_checked int(11) YES
active int(11) YES
iso3 varchar(45) YES
display_state_in_registration int(1) NO
force_state_in_registration int(1) NO
allow_shipping int(1) NO Default: 1

Indexes

2 indexes

Index Name Columns Unique
areaID areaID No
PRIMARY id Yes

Relations (to this table)

2 relations

Local Field Foreign Table Foreign Field
id s_core_countries_attributes countryID
id s_user_addresses country_id