|
id
|
mediumint(8) unsigned
|
|
|
|
|
name
|
varchar(100)
|
|
|
|
|
iso3
|
char(3)
|
|
|
|
|
iso2
|
char(2)
|
|
|
|
|
phonecode
|
varchar(255)
|
|
|
|
|
capital
|
varchar(255)
|
|
|
|
|
currency
|
varchar(255)
|
|
|
|
|
currency_symbol
|
varchar(255)
|
|
|
|
|
tld
|
varchar(255)
|
|
|
|
|
native
|
varchar(255)
|
|
|
|
|
region
|
varchar(255)
|
|
|
|
|
subregion
|
varchar(255)
|
|
|
|
|
timezones
|
text
|
|
|
|
|
translations
|
text
|
|
|
|
|
latitude
|
decimal(10,8)
|
|
|
|
|
longitude
|
decimal(11,8)
|
|
|
|
|
emoji
|
varchar(191)
|
|
|
|
|
emojiU
|
varchar(191)
|
|
|
|
|
created_at
|
timestamp
|
|
|
|
|
updated_at
|
timestamp
|
|
|
current_timestamp()
|
|
status
|
tinyint(1)
|
|
|
1
|
|
wikiDataId
|
varchar(255)
|
|
|
|