Table zones

Table zones holds the state/province information for each country type. The table can be updated through Setup -> Zones.

Table Type: InnoDB

Field Type Default Description
id int (11) NOT NULL PRIMARY KEY - Auto increment field to hold unique ID
countries_iso_code_3 char(3) NULL Holds the ISO code of the country where the zone is located.
zone_code varchar(32) NULL Holds the abreviation o the zone (e.g. NY for new York)
zone_name varchar(32) NULL Holds the full name of the zone.