SWDB
← Versions / 6.6.0.1 /

country

Fields (20)

Name Type Null Key Default Extra
id binary(16) NO PRI NULL
iso varchar(255) YES NULL
position int NO 1
active tinyint(1) NO 1
iso3 varchar(45) YES NULL
display_state_in_registration tinyint(1) NO 0
force_state_in_registration tinyint(1) NO 0
check_vat_id_pattern tinyint(1) NO 0
vat_id_pattern varchar(255) YES NULL
vat_id_required tinyint(1) NO 0
customer_tax json YES NULL
company_tax json YES NULL
advanced_postal_code_pattern varchar(255) YES NULL
check_advanced_postal_code_pattern tinyint(1) NO 0
check_postal_code_pattern tinyint(1) NO 0
default_postal_code_pattern varchar(1024) YES NULL
postal_code_required tinyint(1) NO 0
created_at datetime(3) NO NULL
updated_at datetime(3) YES NULL
shipping_available tinyint(1) NO 1

Indexes (1)

Name Columns Unique
PRIMARY id Yes

Referenced By (9)

cart . country_id 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 id