Migrations
When you install Laravel Countries, the following database migrations will be executed to create the necessary table structure for storing countries, regions, geographical data, and translations.
Here is an overview of the migrations: Below is a breakdown of each column and its purpose:
Countries Table
| Column Name | Description |
|---|---|
id | The primary key for the table. (integer, auto-increment) |
lc_region_id | The foreign key linking to the lc_regions table. (tinyInteger, unsigned) |
uid | A unique identifier for the country record. (ulid, unique) |
official_name | The official name of the country. (string) |
capital | The name of the country's capital. (string) |
iso_alpha_2 | The two-letter ISO 3166-1 alpha-2 country code. (string, length: 10) |
iso_alpha_3 | The three-letter ISO 3166-1 alpha-3 country code. (string, length: 10) |
iso_numeric | The ISO 3166-1 numeric country code. (smallInteger, nullable) |
international_phone | The international dialing code for the country. (string, nullable, length: 150) |
geoname_id | The ID linking to the GeoNames geographical database. (string, nullable, length: 10) |
wmo | Country abbreviations by the World Meteorological Organization (WMO). (string, nullable) |
independence_day | The year the country gained independence. (year, nullable) |
population | The population of the country. (smallInteger, nullable) |
area | The total area of the country in square kilometers. (smallInteger, nullable) |
gdp | The gross domestic product (GDP) of the country in billions of USD. (string, nullable) |
languages | A list of languages spoken in the country in JSON format. (json, default: []) |
tld | The top-level domains (TLDs) associated with the country. (json, default: []) |
alternative_tld | Alternative top-level domains (TLDs) associated with the country. (json, default: []) |
borders | A list of countries that share a border with this country. (json, default: []) |
timezones | The timezones associated with the country. (json, default: {main: [], others: []}) |
currency | Detailed currency information including name, code, symbol, unit, banknotes, and coins. (json, default: {...}) |
flag_emoji | The emoji representation of the country's flag. (json, default: []) |
flag_colors | The colors that make up the country's flag. (json, default: []) |
flag_colors_web | The web-safe colors used for the country's flag. (json, default: []) |
flag_colors_contrast | Contrast colors to ensure text legibility on top of the flag's colors. (json, default: []) |
flag_colors_hex | The hexadecimal color codes of the flag. (json, default: []) |
flag_colors_rgb | The RGB values of the flag's colors. (json, default: []) |
flag_colors_cmyk | The CMYK values of the flag's colors. (json, default: []) |
flag_colors_hsl | The HSL values of the flag's colors. (json, default: []) |
flag_colors_hsv | The HSV values of the flag's colors. (json, default: []) |
flag_colors_pantone | The Pantone color codes of the flag. (json, default: []) |
visible | Indicates whether the country is visible in the system. (boolean, default: true) |
timestamps | Auto-generated timestamps for when the record is created or updated. (created_at, updated_at) |
unique | Ensures uniqueness based on the region and ISO Alpha-2 code. ((lc_region_id, iso_alpha_2)) |
foreign key | Links to the lc_regions table, with cascading deletes. ((lc_region_id)) |
Regions Table
| Column Name | Description |
|---|---|
id | The primary key of the table, automatically incremented. (tinyIncrements) |
iso_alpha_2 | ISO 3166-1 Alpha-2 code. (string, length: 10) |
icao | International Civil Aviation Organization (ICAO) region. (string, length: 10) |
iucn | International Union for Conservation of Nature (IUCN) region. (string, length: 10) |
tdwg | World Geographical Scheme for Recording Plant Distributions code. (string, length: 10) |
is_visible | Visibility status, defaulting to true. (boolean, default: true) |
Coordinates Table
| Column Name | Description |
|---|---|
id | The primary key of the table, automatically incremented. (increments) |
lc_country_id | The foreign key linking to the lc_countries table. (integer, unsigned) |
latitude | The latitude coordinate. (string, nullable) |
longitude | The longitude coordinate. (string, nullable) |
degrees_with_decimal | Coordinates in degrees with decimal format. (string, nullable) |
degrees_minutes_seconds | Coordinates in degrees, minutes, and seconds format. (string, nullable) |
degrees_and_decimal_minutes | Coordinates in degrees and decimal minutes format. (string, nullable) |
gps | GPS data in JSON format. (json, nullable) |
Geographical Table
| Column Name | Description |
|---|---|
id | The primary key of the table, automatically incremented. (increments) |
lc_country_id | The foreign key linking to the lc_countries table. (integer, unsigned) |
type | The type of the geographical data. (string) |
features_type | The feature type of the geographical data. (string) |
properties | Additional properties stored in JSON format. (json) |
geometry | Geometrical data stored in JSON format. (json) |
Extras Table
| Column Name | Description |
|---|---|
id | Primary key: auto-incremented extra information ID. (increments) |
lc_country_id | Foreign key linking to the lc_countries table. (integer, unsigned) |
national_sport | The national sport of the country, if applicable. (string, nullable) |
cybersecurity_agency | Name of the country's national cybersecurity agency. (string, nullable) |
popular_technologies | A list of popular technologies used in the country (e.g., programming languages, platforms). (json, nullable) |
internet | Information about the country's internet infrastructure, including speed and penetration. (json, nullable) |
religions | A list of religions practiced in the country. (json, nullable) |
international_organizations | A list of international organizations the country is a member of (e.g., UN, WTO). (json, nullable) |