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