CREATE TABLE `City` (
  `ID` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  `Name` TEXT NOT NULL DEFAULT '',
  `CountryCode` TEXT NOT NULL DEFAULT '',
  `District` TEXT NOT NULL DEFAULT '',
  `Population` INTEGER NOT NULL DEFAULT 0,
  FOREIGN KEY (`CountryCode`) REFERENCES `Country` (`Code`)
);
City
CREATE TABLE `Country` (
  `Code` TEXT NOT NULL DEFAULT '',
  `Name` TEXT NOT NULL DEFAULT '',
  `Continent` TEXT NOT NULL DEFAULT 'Asia',
  `Region` TEXT NOT NULL DEFAULT '',
  `SurfaceArea` REAL NOT NULL DEFAULT 0.00,
  `IndepYear` INTEGER DEFAULT NULL,
  `Population` INTEGER NOT NULL DEFAULT 0,
  `LifeExpectancy` REAL DEFAULT NULL,
  `GNP` REAL DEFAULT NULL,
  `GNPOld` REAL DEFAULT NULL,
  `LocalName` TEXT NOT NULL DEFAULT '',
  `GovernmentForm` TEXT NOT NULL DEFAULT '',
  `HeadOfState` TEXT DEFAULT NULL,
  `Capital` INTEGER DEFAULT NULL,
  `Code2` TEXT NOT NULL DEFAULT '',
  PRIMARY KEY (`Code`)
);
Country
CREATE TABLE `CountryLanguage` (
  `CountryCode` TEXT NOT NULL DEFAULT '',
  `Language` TEXT NOT NULL DEFAULT '',
  `IsOfficial`TEXT NOT NULL DEFAULT 'F',
  `Percentage` REAL NOT NULL DEFAULT 0.0,
  PRIMARY KEY (`CountryCode`,`Language`),
  FOREIGN KEY (`CountryCode`) REFERENCES `Country` (`Code`)
);
CountryLanguage
original_column_name,column_name,column_description,data_format,value_description
Code,,the unique country code of the country,text,
Name,,the country name,text,
Continent,,the continent that the country locates,text,
Region,,the region that the country locates,text,
SurfaceArea,Surface Area,the surface area of the country,real,
IndepYear,Independence Year,the year that the country declared independence ,integer,
Population,,the number of the population in the area,integer,"commonsense evidence:

more population --> more crowded"
LifeExpectancy,Life Expectancy,the life expectancy at birth of the country,real,"commonsense evidence:

 Life expectancy at birth is defined as how long, on average, a newborn can expect to live if current death rates do not change"
GNP,Gross National Product,the GNP of the country,real,"commonsense evidence:

 GNP measures the total monetary value of the output produced by a country's residents. "
GNPOld,Gross National Product Old,Gross national product - old value.,real,
LocalName,Local Name,The country's local name,text,
GovernmentForm,Government Form,The country's goverment form.,text,"commonsense evidence:

Republic: governmentform contains ""Republic"""
HeadOfState,Head Of State,The head of state full name.,text,
Capital,,The country's capital ,integer,"commonsense evidence:

if the capital is null, it means this country doesn't have a city where a region's government is located"
Code2,,The second country code.,text,
Country
original_column_name,column_name,column_description,data_format,value_description
CountryCode,Country Code,The unique code for country ,text,
Language,,Country language,text,
IsOfficial,Is Official,Information on whether the language is official in a given country,text,T / F
Percentage,,Percentage of language use,real,
CountryLanguage
original_column_name,column_name,column_description,data_format,value_description
ID,,the unique id for the city,integer,
Name,,the name of the city,text,
CountryCode,Country Code,the country code of the country that the city is belonged,text,
District,,the district where the city locates,text,
Population,,the number of the population in the area,integer,"commonsense evidence:

more population --> more crowded"
City