♥ Mysql database of provinces and cities of Iran (استان ها و شهرهای ایران)
Mysql of Iranian provinces and cities
Column |
Type |
Description |
id |
SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT |
Primary Key for a Country |
capital_city |
SMALLINT(5) NOT NULL |
Foreign key to cities table |
name |
VARCHAR(255) NOT NULL |
Persian country name |
name_en |
VARCHAR(255) NOT NULL |
English country name |
Column |
Type |
Description |
id |
SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT |
Primary Key for a Country |
country |
SMALLINT(5) NOT NULL |
Foreign key to countries table |
name |
VARCHAR(255) NOT NULL |
Persian province name |
name_en |
VARCHAR(255) NOT NULL |
English province name |
Column |
Type |
Description |
id |
SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT |
Primary Key for a Country |
province |
SMALLINT(5) NOT NULL |
Foreign key to provinces table |
name |
VARCHAR(255) NOT NULL |
Persian city name |
name_en |
VARCHAR(255) NOT NULL |
English city name |
latitude |
DECIMAL(10,8) NOT NULL |
City Latitude |
latitude |
DECIMAL(11,8) NOT NULL |
City Longitude |