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: Calendar
| Date                    |
|:------------------------|
| 1990-01-01 00:00:00.000 |
| 1990-01-02 00:00:00.000 |
| 1990-01-03 00:00:00.000 |
| 1990-01-04 00:00:00.000 |
| 1990-01-05 00:00:00.000 |
| 1990-01-06 00:00:00.000 |
| 1990-01-07 00:00:00.000 |
| 1990-01-08 00:00:00.000 |
| 1990-01-09 00:00:00.000 |
| 1990-01-10 00:00:00.000 |


Table: Countries
| Origin             | Country       |
|:-------------------|:--------------|
| United States West | United States |
| United States East | United States |
| Japan              | Japan         |
| Canada             | Canada        |
| UK                 | UK            |
| France             | France        |
| Germany            | Germany       |
| Italy              | Italy         |
| Switzerland        | Switzerland   |
| Australia          | Australia     |


Table: Flight Types
| Flight Type   |
|:--------------|
| Domestic      |
| International |


Table: Islands
| Island       |
|:-------------|
| Hawaii State |
| Oahu         |
| Maui         |
| Molokai      |
| Lanai        |
| Kauai        |
| Big Island   |
| Hilo         |
| Kona         |


Table: Visitors by Month
| Date                    | Flight Type   |   Monthly Visitors | Island   |
|:------------------------|:--------------|-------------------:|:---------|
| 1990-01-01 00:00:00.000 | Domestic      |             139620 | Maui     |
| 1991-01-01 00:00:00.000 | Domestic      |             122868 | Maui     |
| 1992-01-01 00:00:00.000 | Domestic      |             122271 | Maui     |
| 1993-01-01 00:00:00.000 | Domestic      |             134753 | Maui     |
| 1994-01-01 00:00:00.000 | Domestic      |             127883 | Maui     |
| 1995-01-01 00:00:00.000 | Domestic      |             138432 | Maui     |
| 1996-01-01 00:00:00.000 | Domestic      |             132564 | Maui     |
| 1997-01-01 00:00:00.000 | Domestic      |             133688 | Maui     |
| 1998-01-01 00:00:00.000 | Domestic      |             132828 | Maui     |
| 1999-01-01 00:00:00.000 | Domestic      |             139723 | Maui     |


Table: Visitors by Origin
|   Visitors | Flight Type   | Origin             | Date                    | Island   |
|-----------:|:--------------|:-------------------|:------------------------|:---------|
|          0 | International | China              | 1991-12-31 00:00:00.000 | Molokai  |
|          0 | International | United States West | 1996-12-31 00:00:00.000 | Molokai  |
|          0 | International | United States East | 1996-12-31 00:00:00.000 | Molokai  |
|          0 | International | United States East | 1998-12-31 00:00:00.000 | Molokai  |
|          0 | International | Australia          | 1998-12-31 00:00:00.000 | Molokai  |
|          0 | International | New Zealand        | 1998-12-31 00:00:00.000 | Molokai  |
|          0 | International | United States West | 1999-12-31 00:00:00.000 | Molokai  |
|          0 | International | United States East | 1999-12-31 00:00:00.000 | Molokai  |
|          0 | International | France             | 2000-12-31 00:00:00.000 | Molokai  |
|          0 | International | Italy              | 2000-12-31 00:00:00.000 | Molokai  |

 


tables: name: Calendar
data: Calendar.csv
name: Countries
data: Countries.csv
name: Flight Types
data: Flight Types.csv
name: Islands
data: Islands.csv
name: Visitors by Month
data: Visitors by Month.csv
name: Visitors by Origin
data: Visitors by Origin.csv
label: Visitors by Origin
Flight Type
Flight Types
Flight Type
Visitors by Origin
Island
Islands
Island
Visitors by Month
Flight Type
Flight Types
Flight Type
Visitors by Month
Island
Islands
Island
Visitors by Origin
Origin
Countries
Origin
output: {
    "joins": [
        {
            "from_table": "Visitors by Origin",
            "from_column": "Flight Type",
            "to_table": "Flight Types",
            "to_column": "Flight Type"
        },
        {
            "from_table": "Visitors by Origin",
            "from_column": "Island",
            "to_table": "Islands",
            "to_column": "Island"
        },
        {
            "from_table": "Visitors by Month",
            "from_column": "Flight Type",
            "to_table": "Flight Types",
            "to_column": "Flight Type"
        },
        {
            "from_table": "Visitors by Month",
            "from_column": "Island",
            "to_table": "Islands",
            "to_column": "Island"
        },
        {
            "from_table": "Visitors by Origin",
            "from_column": "Origin",
            "to_table": "Countries",
            "to_column": "Origin"
        }
    ]
}