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                    |   Year |   MonthNum | MonthName   | Quarter   |   Days |
|:------------------------|-------:|-----------:|:------------|:----------|-------:|
| 2019-01-01 00:00:00.000 |   2019 |          1 | January     | Qtr 1     |      1 |
| 2019-01-02 00:00:00.000 |   2019 |          1 | January     | Qtr 1     |      2 |
| 2019-01-03 00:00:00.000 |   2019 |          1 | January     | Qtr 1     |      3 |
| 2019-01-04 00:00:00.000 |   2019 |          1 | January     | Qtr 1     |      4 |
| 2019-01-05 00:00:00.000 |   2019 |          1 | January     | Qtr 1     |      5 |
| 2019-01-06 00:00:00.000 |   2019 |          1 | January     | Qtr 1     |      6 |
| 2019-01-07 00:00:00.000 |   2019 |          1 | January     | Qtr 1     |      7 |
| 2019-01-08 00:00:00.000 |   2019 |          1 | January     | Qtr 1     |      8 |
| 2019-01-09 00:00:00.000 |   2019 |          1 | January     | Qtr 1     |      9 |
| 2019-01-10 00:00:00.000 |   2019 |          1 | January     | Qtr 1     |     10 |


Table: Categories
|   CategoryID | CategoryName   | Description                                                |
|-------------:|:---------------|:-----------------------------------------------------------|
|            1 | Beverages      | Soft drinks, coffees, teas, beers, and ales                |
|            2 | Condiments     | Sweet and savory sauces, relishes, spreads, and seasonings |
|            3 | Confections    | Desserts, candies, and sweet breads                        |
|            4 | Dairy Products | Cheeses                                                    |
|            5 | Grains/Cereals | Breads, crackers, pasta, and cereal                        |
|            6 | Meat/Poultry   | Prepared meats                                             |
|            7 | Produce        | Dried fruit and bean curd                                  |
|            8 | Seafood        | Seaweed and fish                                           |


Table: Customers
| CustomerID   | CompanyName                        | ContactName        | ContactTitle         | Address                       | City        | Country   | Phone          |
|:-------------|:-----------------------------------|:-------------------|:---------------------|:------------------------------|:------------|:----------|:---------------|
| ALFKI        | Alfreds Futterkiste                | Maria Anders       | Sales Representative | Obere Str. 57                 | Berlin      | Germany   | 030-0074321    |
| ANATR        | Ana Trujillo Emparedados y helados | Ana Trujillo       | Owner                | Avda. de la Constitución 2222 | México D.F. | Mexico    | (5) 555-4729   |
| ANTON        | Antonio Moreno Taquería            | Antonio Moreno     | Owner                | Mataderos  2312               | México D.F. | Mexico    | (5) 555-3932   |
| AROUT        | Around the Horn                    | Thomas Hardy       | Sales Representative | 120 Hanover Sq.               | London      | UK        | (171) 555-7788 |
| BERGS        | Berglunds snabbköp                 | Christina Berglund | Order Administrator  | Berguvsvägen  8               | Luleå       | Sweden    | 0921-12 34 65  |
| BLAUS        | Blauer See Delikatessen            | Hanna Moos         | Sales Representative | Forsterstr. 57                | Mannheim    | Germany   | 0621-08460     |
| BLONP        | Blondel père et fils               | Frédérique Citeaux | Marketing Manager    | 24, place Kléber              | Strasbourg  | France    | 88.60.15.31    |
| BOLID        | Bólido Comidas preparadas          | Martín Sommer      | Owner                | C/ Araquil, 67                | Madrid      | Spain     | (91) 555 22 82 |
| BONAP        | Bon app'                           | Laurence Lebihan   | Owner                | 12, rue des Bouchers          | Marseille   | France    | 91.24.45.40    |
| BOTTM        | Bottom-Dollar Markets              | Elizabeth Lincoln  | Accounting Manager   | 23 Tsawassen Blvd.            | Tsawassen   | Canada    | (604) 555-4729 |


Table: Employees
|   EmployeeID | LastName   | FirstName   | Title                    | TitleOfCourtesy   | BirthDate               | HireDate                | Address               | City     | Country   | HomePhone      | ReportsTo   | FullName         |
|-------------:|:-----------|:------------|:-------------------------|:------------------|:------------------------|:------------------------|:----------------------|:---------|:----------|:---------------|:------------|:-----------------|
|            1 | Davolio    | Nancy       | Sales Representative     | Ms.               | 1968-12-08 00:00:00.000 | 2012-05-01 00:00:00.000 | 507 - 20th Ave. E.    | Seattle  | USA       | (206) 555-9857 | 2           | Nancy Davolio    |
|              |            |             |                          |                   |                         |                         | Apt. 2A               |          |           |                |             |                  |
|            2 | Fuller     | Andrew      | Vice President, Sales    | Dr.               | 1952-02-19 00:00:00.000 | 2012-08-14 00:00:00.000 | 908 W. Capital Way    | Tacoma   | USA       | (206) 555-9482 |             | Andrew Fuller    |
|            3 | Leverling  | Janet       | Sales Representative     | Ms.               | 1963-08-30 00:00:00.000 | 2012-04-01 00:00:00.000 | 722 Moss Bay Blvd.    | Kirkland | USA       | (206) 555-3412 | 2           | Janet Leverling  |
|            4 | Peacock    | Margaret    | Sales Representative     | Mrs.              | 1958-09-19 00:00:00.000 | 2013-05-03 00:00:00.000 | 4110 Old Redmond Rd.  | Redmond  | USA       | (206) 555-8122 | 2           | Margaret Peacock |
|            5 | Buchanan   | Steven      | Sales Manager            | Mr.               | 1955-03-04 00:00:00.000 | 2013-10-17 00:00:00.000 | 14 Garrett Hill       | London   | UK        | (71) 555-4848  | 2           | Steven Buchanan  |
|            6 | Suyama     | Michael     | Sales Representative     | Mr.               | 1963-07-02 00:00:00.000 | 2013-10-17 00:00:00.000 | Coventry House        | London   | UK        | (71) 555-7773  | 5           | Michael Suyama   |
|              |            |             |                          |                   |                         |                         | Miner Rd.             |          |           |                |             |                  |
|            7 | King       | Robert      | Sales Representative     | Mr.               | 1960-05-29 00:00:00.000 | 2014-01-02 00:00:00.000 | Edgeham Hollow        | London   | UK        | (71) 555-5598  | 5           | Robert King      |
|              |            |             |                          |                   |                         |                         | Winchester Way        |          |           |                |             |                  |
|            8 | Callahan   | Laura       | Inside Sales Coordinator | Ms.               | 1958-01-09 00:00:00.000 | 2014-03-05 00:00:00.000 | 4726 - 11th Ave. N.E. | Seattle  | USA       | (206) 555-1189 | 2           | Laura Callahan   |
|            9 | Dodsworth  | Anne        | Sales Representative     | Ms.               | 1969-07-02 00:00:00.000 | 2014-11-15 00:00:00.000 | 7 Houndstooth Rd.     | London   | UK        | (71) 555-4444  | 5           | Anne Dodsworth   |


Table: GeoLocation
| City        | Country   |
|:------------|:----------|
| London      | UK        |
| New Orleans | USA       |
| Ann Arbor   | USA       |
| Tokyo       | Japan     |
| Oviedo      | Spain     |
| Osaka       | Japan     |
| Melbourne   | Australia |
| Manchester  | UK        |
| Göteborg    | Sweden    |
| São Paulo   | Brazil    |


Table: Orders Details
|   OrderID |   ProductID |   UnitPrice |   Quantity |   Discount |   Discount Amount |   Total Sales |
|----------:|------------:|------------:|-----------:|-----------:|------------------:|--------------:|
|     10251 |          65 |       21.05 |         20 |          0 |                 0 |           421 |
|     10253 |          31 |       12.5  |         20 |          0 |                 0 |           250 |
|     10255 |           2 |       19    |         20 |          0 |                 0 |           380 |
|     10261 |          21 |       10    |         20 |          0 |                 0 |           200 |
|     10261 |          35 |       18    |         20 |          0 |                 0 |           360 |
|     10265 |          70 |       15    |         20 |          0 |                 0 |           300 |
|     10273 |          33 |        2.5  |         20 |          0 |                 0 |            50 |
|     10274 |          71 |       21.5  |         20 |          0 |                 0 |           430 |
|     10277 |          28 |       45.6  |         20 |          0 |                 0 |           912 |
|     10280 |          55 |       24    |         20 |          0 |                 0 |           480 |


Table: Orders
|   OrderID | CustomerID   |   EmployeeID | OrderDate               | RequiredDate            | ShippedDate             |   ShipVia |   Freight | ShipName                   | ShipAddress             | ShipCity       | ShipCountry   |
|----------:|:-------------|-------------:|:------------------------|:------------------------|:------------------------|----------:|----------:|:---------------------------|:------------------------|:---------------|:--------------|
|     10250 | HANAR        |            4 | 2019-07-08 00:00:00.000 | 2019-08-05 00:00:00.000 | 2019-07-12 00:00:00.000 |         2 |     65.83 | Hanari Carnes              | Rua do Paço, 67         | Rio de Janeiro | Brazil        |
|     10252 | SUPRD        |            4 | 2019-07-09 00:00:00.000 | 2019-08-06 00:00:00.000 | 2019-07-11 00:00:00.000 |         2 |     51.3  | Suprêmes délices           | Boulevard Tirou, 255    | Charleroi      | Belgium       |
|     10261 | QUEDE        |            4 | 2019-07-19 00:00:00.000 | 2019-08-16 00:00:00.000 | 2019-07-30 00:00:00.000 |         2 |      3.05 | Que Delícia                | Rua da Panificadora, 12 | Rio de Janeiro | Brazil        |
|     10294 | RATTC        |            4 | 2019-08-30 00:00:00.000 | 2019-09-27 00:00:00.000 | 2019-09-05 00:00:00.000 |         2 |    147.26 | Rattlesnake Canyon Grocery | 2817 Milton Dr.         | Albuquerque    | USA           |
|     10299 | RICAR        |            4 | 2019-09-06 00:00:00.000 | 2019-10-04 00:00:00.000 | 2019-09-13 00:00:00.000 |         2 |     29.76 | Ricardo Adocicados         | Av. Copacabana, 267     | Rio de Janeiro | Brazil        |
|     10302 | SUPRD        |            4 | 2019-09-10 00:00:00.000 | 2019-10-08 00:00:00.000 | 2019-10-09 00:00:00.000 |         2 |      6.27 | Suprêmes délices           | Boulevard Tirou, 255    | Charleroi      | Belgium       |
|     10315 | ISLAT        |            4 | 2019-09-26 00:00:00.000 | 2019-10-24 00:00:00.000 | 2019-10-03 00:00:00.000 |         2 |     41.76 | Island Trading             | Garden House            | Cowes          | UK            |
|           |              |              |                         |                         |                         |           |           |                            | Crowther Way            |                |               |
|     10326 | BOLID        |            4 | 2019-10-10 00:00:00.000 | 2019-11-07 00:00:00.000 | 2019-10-14 00:00:00.000 |         2 |     77.92 | Bólido Comidas preparadas  | C/ Araquil, 67          | Madrid         | Spain         |
|     10329 | SPLIR        |            4 | 2019-10-15 00:00:00.000 | 2019-11-26 00:00:00.000 | 2019-10-23 00:00:00.000 |         2 |    191.67 | Split Rail Beer & Ale      | P.O. Box 555            | Lander         | USA           |
|     10342 | FRANK        |            4 | 2019-10-30 00:00:00.000 | 2019-11-13 00:00:00.000 | 2019-11-04 00:00:00.000 |         2 |     54.83 | Frankenversand             | Berliner Platz 43       | München        | Germany       |


Table: Product
|   ProductID | ProductName                     |   SupplierID |   CategoryID | QuantityPerUnit     |   UnitPrice |   UnitsInStock |   UnitsOnOrder |   ReorderLevel | Discontinued   |
|------------:|:--------------------------------|-------------:|-------------:|:--------------------|------------:|---------------:|---------------:|---------------:|:---------------|
|           1 | Chai                            |            1 |            1 | 10 boxes x 20 bags  |       18    |             39 |              0 |             10 | False          |
|           2 | Chang                           |            1 |            1 | 24 - 12 oz bottles  |       19    |             17 |             40 |             25 | False          |
|           3 | Aniseed Syrup                   |            1 |            2 | 12 - 550 ml bottles |       10    |             13 |             70 |             25 | False          |
|           4 | Chef Anton's Cajun Seasoning    |            2 |            2 | 48 - 6 oz jars      |       22    |             53 |              0 |              0 | False          |
|           5 | Chef Anton's Gumbo Mix          |            2 |            2 | 36 boxes            |       21.35 |              0 |              0 |              0 | True           |
|           6 | Grandma's Boysenberry Spread    |            3 |            2 | 12 - 8 oz jars      |       25    |            120 |              0 |             25 | False          |
|           7 | Uncle Bob's Organic Dried Pears |            3 |            7 | 12 - 1 lb pkgs.     |       30    |             15 |              0 |             10 | False          |
|           8 | Northwoods Cranberry Sauce      |            3 |            2 | 12 - 12 oz jars     |       40    |              6 |              0 |              0 | False          |
|           9 | Mishi Kobe Niku                 |            4 |            6 | 18 - 500 g pkgs.    |       97    |             29 |              0 |              0 | True           |
|          10 | Ikura                           |            4 |            8 | 12 - 200 ml jars    |       31    |             31 |              0 |              0 | False          |


Table: Shippers
|   ShipperID | CompanyName      | Phone          |
|------------:|:-----------------|:---------------|
|           1 | Speedy Express   | (503) 555-9831 |
|           2 | United Package   | (503) 555-3199 |
|           3 | Federal Shipping | (503) 555-9931 |


Table: Suppliers
|   SupplierID | CompanyName                        | ContactName                | ContactTitle             | Address                   | City        | Country   | Phone          |
|-------------:|:-----------------------------------|:---------------------------|:-------------------------|:--------------------------|:------------|:----------|:---------------|
|            1 | Exotic Liquids                     | Charlotte Cooper           | Purchasing Manager       | 49 Gilbert St.            | London      | UK        | (171) 555-2222 |
|            2 | New Orleans Cajun Delights         | Shelley Burke              | Order Administrator      | P.O. Box 78934            | New Orleans | USA       | (100) 555-4822 |
|            3 | Grandma Kelly's Homestead          | Regina Murphy              | Sales Representative     | 707 Oxford Rd.            | Ann Arbor   | USA       | (313) 555-5735 |
|            4 | Tokyo Traders                      | Yoshi Nagase               | Marketing Manager        | 9-8 Sekimai               | Tokyo       | Japan     | (03) 3555-5011 |
|              |                                    |                            |                          | Musashino-shi             |             |           |                |
|            5 | Cooperativa de Quesos 'Las Cabras' | Antonio del Valle Saavedra | Export Administrator     | Calle del Rosal 4         | Oviedo      | Spain     | (98) 598 76 54 |
|            6 | Mayumi's                           | Mayumi Ohno                | Marketing Representative | 92 Setsuko                | Osaka       | Japan     | (06) 431-7877  |
|              |                                    |                            |                          | Chuo-ku                   |             |           |                |
|            7 | Pavlova, Ltd.                      | Ian Devling                | Marketing Manager        | 74 Rose St.               | Melbourne   | Australia | (03) 444-2343  |
|              |                                    |                            |                          | Moonie Ponds              |             |           |                |
|            8 | Specialty Biscuits, Ltd.           | Peter Wilson               | Sales Representative     | 29 King's Way             | Manchester  | UK        | (161) 555-4448 |
|            9 | PB Knäckebröd AB                   | Lars Peterson              | Sales Agent              | Kaloadagatan 13           | Göteborg    | Sweden    | 031-987 65 43  |
|           10 | Refrescos Americanas LTDA          | Carlos Diaz                | Marketing Manager        | Av. das Americanas 12.890 | São Paulo   | Brazil    | (11) 555 4640  |

 


tables: name: Calendar
data: Calendar.csv
name: Categories
data: Categories.csv
name: Customers
data: Customers.csv
name: Employees
data: Employees.csv
name: GeoLocation
data: GeoLocation.csv
name: Orders Details
data: Orders Details.csv
name: Orders
data: Orders.csv
name: Product
data: Product.csv
name: Shippers
data: Shippers.csv
name: Suppliers
data: Suppliers.csv
label: Product
CategoryID
Categories
CategoryID
Orders
EmployeeID
Employees
EmployeeID
Orders Details
OrderID
Orders
OrderID
Orders Details
ProductID
Product
ProductID
Product
SupplierID
Suppliers
SupplierID
Orders
CustomerID
Customers
CustomerID
Orders
ShipVia
Shippers
ShipperID
Orders
ShipCity
GeoLocation
City
output: {
    "joins": [
        {
            "from_table": "Product",
            "from_column": "CategoryID",
            "to_table": "Categories",
            "to_column": "CategoryID"
        },
        {
            "from_table": "Orders",
            "from_column": "EmployeeID",
            "to_table": "Employees",
            "to_column": "EmployeeID"
        },
        {
            "from_table": "Orders Details",
            "from_column": "OrderID",
            "to_table": "Orders",
            "to_column": "OrderID"
        },
        {
            "from_table": "Orders Details",
            "from_column": "ProductID",
            "to_table": "Product",
            "to_column": "ProductID"
        },
        {
            "from_table": "Product",
            "from_column": "SupplierID",
            "to_table": "Suppliers",
            "to_column": "SupplierID"
        },
        {
            "from_table": "Orders",
            "from_column": "CustomerID",
            "to_table": "Customers",
            "to_column": "CustomerID"
        },
        {
            "from_table": "Orders",
            "from_column": "ShipVia",
            "to_table": "Shippers",
            "to_column": "ShipperID"
        },
        {
            "from_table": "Orders",
            "from_column": "ShipCity",
            "to_table": "GeoLocation",
            "to_column": "City"
        }
    ]
}