countries_id int not_null auto_increment comment(Primary key - unique identifier for each country)
countries_name varchar(255) not_null comment(Full country name)
countries_iso_code_2 char(2) not_null comment(ISO 3166-1 alpha-2 country code - two-letter code)
countries_iso_code_3 char(3) not_null comment(ISO 3166-1 alpha-3 country code - three-letter code)
address_format_id int not_null comment(FK to address_format table - defines how addresses are formatted for this country)
status tinyint(1) default(1) comment(Country status - 0: inactive, 1: active for selection)
--
primary countries_id
idx_countries_name countries_name
##
engine innodb
character_set utf8mb4
collate utf8mb4_unicode_ci
comment Countries list with ISO codes and address formatting configuration