Menu

SQL Table detailing Country Regions

Used MySQL Workbench to create a table of data about countries and their regions.

In the table below, the first column represents the country_id, which is a unique identifier for each row. The second column is the region_id, which groups countries by region (such as North America, Europe, or Asia). The only part that required a bit of review was setting up the primary key, so I went back to my notes to make sure I configured it correctly.

SQL Table detailing Country Regions - image 1 - student project