CREATE TABLE "Country" (
	"name" varchar(255),
	"id" int,
	"iso_a2" varchar(255),
	"iso_a3" varchar(255),
	"continent_id" int CONSTRAINT Continent_id REFERENCES Continent(id),
	"economic_group_id" int CONSTRAINT EconomicGroup_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 CONSTRAINT Country_id REFERENCES Country(id)
);
CREATE TABLE "City" (
	"name" varchar(255),
	"state_id" int CONSTRAINT State_id REFERENCES State(id)
);