Task: equi-join-detect (source dataset: Auto-BI)

Your are given a database with related tables used for business intelligence analysis. Your task is to identify all key/foreign-key join relationships between the tables for this database. Recall that a join is a relationship between two tables, that allows rows from one table to be combined with rows from another, based on a set of common join columns.
 
 
No explanation needed. Please return all join relationships in the following JSON format:
{
  "joins": [
    {
      "from_table": "table-1",
      "from_column": "column-1",
      "to_table": "table-2",
      "to_column": "column-3"
    }, 
	...
  ]
}

Tables:

Table: Category
|   CategoryID | CategoryName              |
|-------------:|:--------------------------|
|            1 | Politics                  |
|            2 | Alien life                |
|            3 | Exploration               |
|            4 | Natural world             |
|            5 | Death and disaster        |
|            6 | War and conflict          |
|            7 | Sports                    |
|            8 | Economy                   |
|            9 | Entertainment and culture |
|           10 | Health and medicine       |


Table: Continent
|   ContinentID | ContinentName   | Summary          |
|--------------:|:----------------|:-----------------|
|             1 | Asia            | Big              |
|             2 | Africa          | Biggish          |
|             3 | Europe          | Home             |
|             4 | Australasia     | NULL             |
|             5 | South America   | Lots of trees    |
|             6 | North America   | NULL             |
|             7 | Antarctic       | Full of penguins |
|             8 | Not applicable  | NULL             |


Table: Country
|   CountryID | CountryName            |   ContinentID |
|------------:|:-----------------------|--------------:|
|           1 | Ukraine                |             3 |
|           2 | France                 |             3 |
|           3 | Germany                |             3 |
|           4 | Italy                  |             3 |
|           5 | United States          |             6 |
|           6 | Bosnia and Herzegovina |             3 |
|           7 | United Kingdom         |             3 |
|           8 | Japan                  |             1 |
|           9 | Indonesia              |             1 |
|          10 | Vietnam                |             1 |


Table: Event
|   EventID | EventName                         | EventDetails                                                                                                                                                                                                                                         | EventDate   |   EventCountryID |   EventCategoryID | Category                  | Continent   | Country        |
|----------:|:----------------------------------|:-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:------------|-----------------:|------------------:|:--------------------------|:------------|:---------------|
|         5 | The UK declares war on Germany    | Following Germany's invasion of Poland, the UK's Prime Minister Neville Chamberlain concluded a speech with the words "I have to tell you now that no such undertaking has been received and that consequently this country is at war with Germany." | 03-09-1939  |                7 |                 6 | War and conflict          | Europe      | United Kingdom |
|        12 | Brexit vote                       | By a narrow majority Britain votes to leave the European Union (England and Wales voted to leave, although Scotland and Northern Ireland voted to remain).                                                                                           | 23-06-2016  |                7 |                 1 | Politics                  | Europe      | United Kingdom |
|        13 | London Olympic games              | Widely considered a success, the London Olympics started on 27th July with an opening ceremony which included the Spice Girls and a dramatisation of the NHS.                                                                                        | 27-07-2012  |                7 |                 7 | Sports                    | Europe      | United Kingdom |
|        15 | Last edition of "Top of the Pops" | The last edition of "Top of the Pops" is broadcast.  The show was hosted by Jimmy Savile, subsquently to be disgraced as a serial sex offender.                                                                                                      | 30-07-2006  |                7 |                 9 | Entertainment and culture | Europe      | United Kingdom |
|        16 | London Eye opens                  | The London Eye is a giant Ferris wheel on the South Bank of the River Thames in London, built to celebrate the millennium (although it opened late).                                                                                                 | 09-03-2000  |                7 |                 9 | Entertainment and culture | Europe      | United Kingdom |
|        17 | First Harry Potter Book published | Harry Potter and the Philosopher's Stone was first published, the first of an eventual series of 7 by the authoress JK Rowling                                                                                                                       | 30-07-1997  |                7 |                 9 | Entertainment and culture | Europe      | United Kingdom |
|        18 | Teletubbies first broadcast       | Tinky-Winky, Dipsy, Laa Laa and Po (not forgetting Nu Nu, the vacuum cleaner) first hit the UK's television screens on this momentous date in history.                                                                                               | 31-03-1997  |                7 |                 9 | Entertainment and culture | Europe      | United Kingdom |
|        20 | Premier League starts             | The first season ended (as it did 11 times subsequently) with Alex Ferguson ’s Mancheser United taking the trophy. Teddy Sheringham finished as top scorer with 22 goals (one for Nottingham Forest , 21 for Spurs ).                                | 15-08-1992  |                7 |                 7 | Sports                    | Europe      | United Kingdom |
|        21 | Margaret Thatcher resigns         | Rather than face a humiliating second round of the Conservative Party leadership election, Margraret Thatcher bows out after 11 years in government.                                                                                                 | 22-11-1990  |                7 |                 1 | Politics                  | Europe      | United Kingdom |
|        24 | Hillsborough                      | 96 people died in the crowd gathered to watch a football match between Liverpool and Nottingham Forest  Lord Justice Taylor’s report on the disaster subsequently found there had been a series of problems leading to the huge death toll.          | 15-04-1989  |                7 |                 5 | Death and disaster        | Europe      | United Kingdom |

 


tables: name: Category
data: Category.csv
name: Continent
data: Continent.csv
name: Country
data: Country.csv
name: Event
data: Event.csv
label: Country
ContinentID
Continent
ContinentID
Event
EventCategoryID
Category
CategoryID
Event
EventCountryID
Country
CountryID
output: {
    "joins": [
        {
            "from_table": "Country",
            "from_column": "ContinentID",
            "to_table": "Continent",
            "to_column": "ContinentID"
        },
        {
            "from_table": "Event",
            "from_column": "EventCategoryID",
            "to_table": "Category",
            "to_column": "CategoryID"
        },
        {
            "from_table": "Event",
            "from_column": "EventCountryID",
            "to_table": "Country",
            "to_column": "CountryID"
        }
    ]
}