CREATE TABLE `Country` (
	`name` varchar(255),
	`id` int,
	`iso_a2` varchar(255),
	`iso_a3` varchar(255),
	`continent_id` int,
	`economic_group_id` int,
	FOREIGN KEY(`continent_id`) REFERENCES `Continent` (`id`),
	FOREIGN KEY(`economic_group_id`) REFERENCES `EconomicGroup` (`id`)
);
CREATE TABLE `Continent` (
	`name` varchar(255)
);
CREATE TABLE `EconomicGroup` (
	`name` varchar(255)
);
CREATE TABLE `State` (
	`name` varchar(255),
	`short` varchar(255),
	`country_id` int,
	FOREIGN KEY(`country_id`) REFERENCES `Country` (`id`)
);
CREATE TABLE `City` (
	`name` varchar(255),
	`state_id` int,
	FOREIGN KEY(`state_id`) REFERENCES `State` (`id`)
);