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: 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        | Region   | PostalCode   | Country   | Phone          | Fax            |
|:-------------|:-----------------------------------|:-------------------|:---------------------|:------------------------------|:------------|:---------|:-------------|:----------|:---------------|:---------------|
| ALFKI        | Alfreds Futterkiste                | Maria Anders       | Sales Representative | Obere Str. 57                 | Berlin      |          | 12209        | Germany   | 030-0074321    | 030-0076545    |
| ANATR        | Ana Trujillo Emparedados y helados | Ana Trujillo       | Owner                | Avda. de la Constitución 2222 | México D.F. |          | 05021        | Mexico    | (5) 555-4729   | (5) 555-3745   |
| ANTON        | Antonio Moreno Taquería            | Antonio Moreno     | Owner                | Mataderos  2312               | México D.F. |          | 05023        | Mexico    | (5) 555-3932   |                |
| AROUT        | Around the Horn                    | Thomas Hardy       | Sales Representative | 120 Hanover Sq.               | London      |          | WA1 1DP      | UK        | (171) 555-7788 | (171) 555-6750 |
| BERGS        | Berglunds snabbköp                 | Christina Berglund | Order Administrator  | Berguvsvägen  8               | Luleå       |          | S-958 22     | Sweden    | 0921-12 34 65  | 0921-12 34 67  |
| BLAUS        | Blauer See Delikatessen            | Hanna Moos         | Sales Representative | Forsterstr. 57                | Mannheim    |          | 68306        | Germany   | 0621-08460     | 0621-08924     |
| BLONP        | Blondesddsl père et fils           | Frédérique Citeaux | Marketing Manager    | 24, place Kléber              | Strasbourg  |          | 67000        | France    | 88.60.15.31    | 88.60.15.32    |
| BOLID        | Bólido Comidas preparadas          | Martín Sommer      | Owner                | C/ Araquil, 67                | Madrid      |          | 28023        | Spain     | (91) 555 22 82 | (91) 555 91 99 |
| BONAP        | Bon app'                           | Laurence Lebihan   | Owner                | 12, rue des Bouchers          | Marseille   |          | 13008        | France    | 91.24.45.40    | 91.24.45.41    |
| BOTTM        | Bottom-Dollar Markets              | Elizabeth Lincoln  | Accounting Manager   | 23 Tsawassen Blvd.            | Tsawassen   | BC       | T2F 8M4      | Canada    | (604) 555-4729 | (604) 555-3745 |


Table: Employees
|   EmployeeID | LastName   | FirstName   | Title                    | TitleOfCourtesy   | BirthDate               | HireDate                | Address               | City     | Region   | PostalCode   | Country   | HomePhone      |   Extension | Notes                                                                                                                                                                                                                                                                                                                                                                                                                                                            | ReportsTo   | PhotoPath                              |
|-------------:|:-----------|:------------|:-------------------------|:------------------|:------------------------|:------------------------|:----------------------|:---------|:---------|:-------------|:----------|:---------------|------------:|:-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:------------|:---------------------------------------|
|            1 | Davolio    | Nancy       | Sales Representative     | Ms.               | 1948-12-08 00:00:00.000 | 1992-05-01 00:00:00.000 | 507 - 20th Ave. E.    | Seattle  | WA       | 98122        | USA       | (206) 555-9857 |        5467 | Education includes a BA in psychology from Colorado State University in 1970.  She also completed "The Art of the Cold Call."  Nancy is a member of Toastmasters International.                                                                                                                                                                                                                                                                                  | 2           | http://accweb/emmployees/davolio.bmp   |
|              |            |             |                          |                   |                         |                         | Apt. 2A               |          |          |              |           |                |             |                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |             |                                        |
|            2 | Fuller     | Andrew      | Vice President, Sales    | Dr.               | 1952-02-19 00:00:00.000 | 1992-08-14 00:00:00.000 | 908 W. Capital Way    | Tacoma   | WA       | 98401        | USA       | (206) 555-9482 |        3457 | Andrew received his BTS commercial in 1974 and a Ph.D. in international marketing from the University of Dallas in 1981.  He is fluent in French and Italian and reads German.  He joined the company as a sales representative, was promoted to sales manager in January 1992 and to vice president of sales in March 1993.  Andrew is a member of the Sales Management Roundtable, the Seattle Chamber of Commerce, and the Pacific Rim Importers Association. |             | http://accweb/emmployees/fuller.bmp    |
|            3 | Leverling  | Janet       | Sales Representative     | Ms.               | 1963-08-30 00:00:00.000 | 1992-04-01 00:00:00.000 | 722 Moss Bay Blvd.    | Kirkland | WA       | 98033        | USA       | (206) 555-3412 |        3355 | Janet has a BS degree in chemistry from Boston College (1984).  She has also completed a certificate program in food retailing management.  Janet was hired as a sales associate in 1991 and promoted to sales representative in February 1992.                                                                                                                                                                                                                  | 2           | http://accweb/emmployees/leverling.bmp |
|            4 | Peacock    | Margaret    | Sales Representative     | Mrs.              | 1937-09-19 00:00:00.000 | 1993-05-03 00:00:00.000 | 4110 Old Redmond Rd.  | Redmond  | WA       | 98052        | USA       | (206) 555-8122 |        5176 | Margaret holds a BA in English literature from Concordia College (1958) and an MA from the American Institute of Culinary Arts (1966).  She was assigned to the London office temporarily from July through November 1992.                                                                                                                                                                                                                                       | 2           | http://accweb/emmployees/peacock.bmp   |
|            5 | Buchanan   | Steven      | Sales Manager            | Mr.               | 1955-03-04 00:00:00.000 | 1993-10-17 00:00:00.000 | 14 Garrett Hill       | London   |          | SW1 8JR      | UK        | (71) 555-4848  |        3453 | Steven Buchanan graduated from St. Andrews University, Scotland, with a BSC degree in 1976.  Upon joining the company as a sales representative in 1992, he spent 6 months in an orientation program at the Seattle office and then returned to his permanent post in London.  He was promoted to sales manager in March 1993.  Mr. Buchanan has completed the courses "Successful Telemarketing" and "International Sales Management."  He is fluent in French. | 2           | http://accweb/emmployees/buchanan.bmp  |
|            6 | Suyama     | Michael     | Sales Representative     | Mr.               | 1963-07-02 00:00:00.000 | 1993-10-17 00:00:00.000 | Coventry House        | London   |          | EC2 7JR      | UK        | (71) 555-7773  |         428 | Michael is a graduate of Sussex University (MA, economics, 1983) and the University of California at Los Angeles (MBA, marketing, 1986).  He has also taken the courses "Multi-Cultural Selling" and "Time Management for the Sales Professional."  He is fluent in Japanese and can read and write French, Portuguese, and Spanish.                                                                                                                             | 5           | http://accweb/emmployees/davolio.bmp   |
|              |            |             |                          |                   |                         |                         | Miner Rd.             |          |          |              |           |                |             |                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |             |                                        |
|            7 | King       | Robert      | Sales Representative     | Mr.               | 1960-05-29 00:00:00.000 | 1994-01-02 00:00:00.000 | Edgeham Hollow        | London   |          | RG1 9SP      | UK        | (71) 555-5598  |         465 | Robert King served in the Peace Corps and traveled extensively before completing his degree in English at the University of Michigan in 1992, the year he joined the company.  After completing a course entitled "Selling in Europe," he was transferred to the London office in March 1993.                                                                                                                                                                    | 5           | http://accweb/emmployees/davolio.bmp   |
|              |            |             |                          |                   |                         |                         | Winchester Way        |          |          |              |           |                |             |                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |             |                                        |
|            8 | Callahan   | Laura       | Inside Sales Coordinator | Ms.               | 1958-01-09 00:00:00.000 | 1994-03-05 00:00:00.000 | 4726 - 11th Ave. N.E. | Seattle  | WA       | 98105        | USA       | (206) 555-1189 |        2344 | Laura received a BA in psychology from the University of Washington.  She has also completed a course in business French.  She reads and writes French.                                                                                                                                                                                                                                                                                                          | 2           | http://accweb/emmployees/davolio.bmp   |
|            9 | Dodsworth  | Anne        | Sales Representative     | Ms.               | 1966-01-27 00:00:00.000 | 1994-11-15 00:00:00.000 | 7 Houndstooth Rd.     | London   |          | WG2 7LT      | UK        | (71) 555-4444  |         452 | Anne has a BA degree in English from St. Lawrence College.  She is fluent in French and German.                                                                                                                                                                                                                                                                                                                                                                  | 5           | http://accweb/emmployees/davolio.bmp   |


Table: Order Details
|   OrderID |   ProductID |   UnitPrice |   Quantity |   Discount |   Total |
|----------:|------------:|------------:|-----------:|-----------:|--------:|
|     10508 |          39 |          18 |         10 |          0 |     180 |
|     10521 |          35 |          18 |          3 |          0 |      54 |
|     10530 |          76 |          18 |         50 |          0 |     900 |
|     10546 |          35 |          18 |         30 |          0 |     540 |
|     10553 |          35 |          18 |          6 |          0 |     108 |
|     10566 |          76 |          18 |         10 |          0 |     180 |
|     10569 |          76 |          18 |         30 |          0 |     540 |
|     10575 |          76 |          18 |         10 |          0 |     180 |
|     10576 |           1 |          18 |         10 |          0 |     180 |
|     10577 |          39 |          18 |         10 |          0 |     180 |


Table: Orders
|   OrderID | CustomerID   |   EmployeeID | OrderDate               | RequiredDate            | ShippedDate             |   ShipVia |   Freight | ShipName               | ShipAddress        | ShipCity       | ShipRegion   |   ShipPostalCode | ShipCountry   |
|----------:|:-------------|-------------:|:------------------------|:------------------------|:------------------------|----------:|----------:|:-----------------------|:-------------------|:---------------|:-------------|-----------------:|:--------------|
|     10249 | TOMSP        |            6 | 1996-07-05 00:00:00.000 | 1996-08-16 00:00:00.000 | 1996-07-10 00:00:00.000 |         1 |     11.61 | Toms Spezialitäten     | Luisenstr. 48      | Münster        |              |            44087 | Germany       |
|     10260 | OTTIK        |            4 | 1996-07-19 00:00:00.000 | 1996-08-16 00:00:00.000 | 1996-07-29 00:00:00.000 |         1 |     55.09 | Ottilies Käseladen     | Mehrheimerstr. 369 | Köln           |              |            50739 | Germany       |
|     10267 | FRANK        |            4 | 1996-07-29 00:00:00.000 | 1996-08-26 00:00:00.000 | 1996-08-06 00:00:00.000 |         1 |    208.58 | Frankenversand         | Berliner Platz 43  | München        |              |            80805 | Germany       |
|     10273 | QUICK        |            3 | 1996-08-05 00:00:00.000 | 1996-09-02 00:00:00.000 | 1996-08-12 00:00:00.000 |         3 |     76.07 | QUICK-Stop             | Taucherstraße 10   | Cunewalde      |              |            01307 | Germany       |
|     10277 | MORGK        |            2 | 1996-08-09 00:00:00.000 | 1996-09-06 00:00:00.000 | 1996-08-13 00:00:00.000 |         3 |    125.77 | Morgenstern Gesundkost | Heerstr. 22        | Leipzig        |              |            04179 | Germany       |
|     10279 | LEHMS        |            8 | 1996-08-13 00:00:00.000 | 1996-09-10 00:00:00.000 | 1996-08-16 00:00:00.000 |         2 |     25.83 | Lehmanns Marktstand    | Magazinweg 7       | Frankfurt a.M. |              |            60528 | Germany       |
|     10284 | LEHMS        |            4 | 1996-08-19 00:00:00.000 | 1996-09-16 00:00:00.000 | 1996-08-27 00:00:00.000 |         1 |     76.56 | Lehmanns Marktstand    | Magazinweg 7       | Frankfurt a.M. |              |            60528 | Germany       |
|     10285 | QUICK        |            1 | 1996-08-20 00:00:00.000 | 1996-09-17 00:00:00.000 | 1996-08-26 00:00:00.000 |         2 |     76.83 | QUICK-Stop             | Taucherstraße 10   | Cunewalde      |              |            01307 | Germany       |
|     10286 | QUICK        |            8 | 1996-08-21 00:00:00.000 | 1996-09-18 00:00:00.000 | 1996-08-30 00:00:00.000 |         3 |    229.24 | QUICK-Stop             | Taucherstraße 10   | Cunewalde      |              |            01307 | Germany       |
|     10301 | WANDK        |            8 | 1996-09-09 00:00:00.000 | 1996-10-07 00:00:00.000 | 1996-09-17 00:00:00.000 |         2 |     45.08 | Die Wandernde Kuh      | Adenauerallee 900  | Stuttgart      |              |            70563 | Germany       |


Table: Products
|   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        | Region   | PostalCode   | Country   | Phone          | Fax            | HomePage                                                                                   |
|-------------:|:-----------------------------------|:---------------------------|:-------------------------|:--------------------------|:------------|:---------|:-------------|:----------|:---------------|:---------------|:-------------------------------------------------------------------------------------------|
|            1 | Exotic Liquids                     | Charlotte Cooper           | Purchasing Manager       | 49 Gilbert St.            | London      |          | EC1 4SD      | UK        | (171) 555-2222 |                |                                                                                            |
|            2 | New Orleans Cajun Delights         | Shelley Burke              | Order Administrator      | P.O. Box 78934            | New Orleans | LA       | 70117        | USA       | (100) 555-4822 |                | #CAJUN.HTM#                                                                                |
|            3 | Grandma Kelly's Homestead          | Regina Murphy              | Sales Representative     | 707 Oxford Rd.            | Ann Arbor   | MI       | 48104        | USA       | (313) 555-5735 | (313) 555-3349 |                                                                                            |
|            4 | Tokyo Traders                      | Yoshi Nagase               | Marketing Manager        | 9-8 Sekimai Musashino-shi | Tokyo       |          | 100          | Japan     | (03) 3555-5011 |                |                                                                                            |
|            5 | Cooperativa de Quesos 'Las Cabras' | Antonio del Valle Saavedra | Export Administrator     | Calle del Rosal 4         | Oviedo      | Asturias | 33007        | Spain     | (98) 598 76 54 |                |                                                                                            |
|            6 | Mayumi's                           | Mayumi Ohno                | Marketing Representative | 92 Setsuko Chuo-ku        | Osaka       |          | 545          | Japan     | (06) 431-7877  |                | Mayumi's (on the World Wide Web)#http://www.microsoft.com/accessdev/sampleapps/mayumi.htm# |
|            7 | Pavlova, Ltd.                      | Ian Devling                | Marketing Manager        | 74 Rose St. Moonie Ponds  | Melbourne   | Victoria | 3058         | Australia | (03) 444-2343  | (03) 444-6588  |                                                                                            |
|            8 | Specialty Biscuits, Ltd.           | Peter Wilson               | Sales Representative     | 29 King's Way             | Manchester  |          | M14 GSD      | UK        | (161) 555-4448 |                |                                                                                            |
|            9 | PB Knäckebröd AB                   | Lars Peterson              | Sales Agent              | Kaloadagatan 13           | Göteborg    |          | S-345 67     | Sweden    | 031-987 65 43  | 031-987 65 91  |                                                                                            |
|           10 | Refrescos Americanas LTDA          | Carlos Diaz                | Marketing Manager        | Av. das Americanas 12.890 | Sao Paulo   |          | 5442         | Brazil    | (11) 555 4640  |                |                                                                                            |

 


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