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


Table: Orders
|   Row ID | Order Priority   |   Discount |   Unit Price |   Shipping Cost |   Customer ID | Customer Name          | Ship Mode   | Customer Segment   | Product Category   | Product Sub-Category   | Product Container   | Product Name   |   Product Base Margin | Region   | State or Province   | City            |   Postal Code | Order Date              | Ship Date               |     Profit |   Quantity ordered new |   Sales |   Order ID |   MES |   AÑO |
|---------:|:-----------------|-----------:|-------------:|----------------:|--------------:|:-----------------------|:------------|:-------------------|:-------------------|:-----------------------|:--------------------|:---------------|----------------------:|:---------|:--------------------|:----------------|--------------:|:------------------------|:------------------------|-----------:|-----------------------:|--------:|-----------:|------:|------:|
|    20334 | Low              |       0.04 |         6.48 |            5.74 |           119 | Judy Kennedy           | Regular Air | Corporate          | Office Supplies    | Paper                  | Small Box           | Xerox 1994     |                  0.37 | West     | Utah                | Kearns          |         84118 | 2012-12-30 00:00:00.000 | 2013-01-01 00:00:00.000 |  -26.105   |                     13 |   86.17 |      86524 |    12 |  2012 |
|    18129 | Low              |       0.02 |         6.48 |            5.9  |           119 | Judy Kennedy           | Regular Air | Corporate          | Office Supplies    | Paper                  | Small Box           | Xerox 1976     |                  0.37 | West     | Utah                | Kearns          |         84118 | 2013-04-18 00:00:00.000 | 2013-04-22 00:00:00.000 |  -17.58    |                      2 |   15.27 |      86526 |     4 |  2013 |
|    24273 | Not Specified    |       0.02 |         6.48 |            9.17 |           194 | Tammy Goldman          | Regular Air | Corporate          | Office Supplies    | Paper                  | Small Box           | Xerox 1996     |                  0.37 | West     | Utah                | Lehi            |         84043 | 2010-01-10 00:00:00.000 | 2010-01-11 00:00:00.000 | -105.685   |                      4 |   28.2  |      90431 |     1 |  2010 |
|    18904 | High             |       0.06 |         6.48 |            6.74 |           247 | Marshall Brandt Briggs | Regular Air | Corporate          | Office Supplies    | Paper                  | Small Box           | Xerox 215      |                  0.37 | South    | Tennessee           | Maryville       |         37804 | 2013-01-13 00:00:00.000 | 2013-01-15 00:00:00.000 | -284.578   |                     10 |   67.71 |      89145 |     1 |  2013 |
|    19823 | Medium           |       0.08 |         6.48 |            7.03 |           266 | Ross Frederick         | Regular Air | Corporate          | Office Supplies    | Paper                  | Small Box           | Xerox 214      |                  0.37 | Central  | Texas               | San Antonio     |         78207 | 2010-11-15 00:00:00.000 | 2010-11-16 00:00:00.000 |    8.932   |                     10 |   67.86 |      90594 |    11 |  2010 |
|    24425 | Low              |       0.06 |         6.48 |            7.86 |           300 | Larry W Lehman         | Regular Air | Corporate          | Office Supplies    | Paper                  | Small Box           | Xerox 213      |                  0.37 | East     | New Hampshire       | Dover           |          3820 | 2013-08-07 00:00:00.000 | 2013-08-11 00:00:00.000 |   -5.64768 |                      1 |   10.08 |      87393 |     8 |  2013 |
|    24864 | Medium           |       0.01 |         6.48 |            7.49 |           358 | Chris F Brandt         | Regular Air | Corporate          | Office Supplies    | Paper                  | Small Box           | Xerox 220      |                  0.37 | East     | Pennsylvania        | King of Prussia |         19406 | 2013-10-23 00:00:00.000 | 2013-10-25 00:00:00.000 |  -28.88    |                      4 |   30.45 |      91137 |    10 |  2013 |
|    24662 | Low              |       0.08 |         6.48 |            7.91 |           500 | Brenda Cowan           | Regular Air | Corporate          | Office Supplies    | Paper                  | Small Box           | Xerox 216      |                  0.37 | West     | Utah                | Ogden           |         84404 | 2013-05-31 00:00:00.000 | 2013-06-07 00:00:00.000 | -179.11    |                     14 |   90.21 |      90372 |     5 |  2013 |
|    18593 | High             |       0    |         6.48 |            7.86 |           533 | Jamie Dixon            | Regular Air | Corporate          | Office Supplies    | Paper                  | Small Box           | Xerox 213      |                  0.37 | Central  | Missouri            | Lees Summit     |         64064 | 2011-03-23 00:00:00.000 | 2011-03-24 00:00:00.000 | -101.85    |                      7 |   48.76 |      88512 |     3 |  2011 |
|    20281 | Medium           |       0.05 |         6.48 |            6.57 |           537 | Nelson Coley           | Regular Air | Corporate          | Office Supplies    | Paper                  | Small Box           | Xerox 20       |                  0.37 | Central  | Illinois            | Urbana          |         61801 | 2013-08-05 00:00:00.000 | 2013-08-07 00:00:00.000 |  -23.3751  |                     10 |   67.48 |      89904 |     8 |  2013 |


Table: Returns
|   Order ID | Status   |
|-----------:|:---------|
|         65 | Returned |
|        612 | Returned |
|        614 | Returned |
|        678 | Returned |
|        710 | Returned |
|        740 | Returned |
|        775 | Returned |
|        833 | Returned |
|        902 | Returned |
|       3300 | Returned |


Table: Users
| Region   | Manager   |
|:---------|:----------|
| Central  | Chris     |
| East     | Erin      |
| South    | Sam       |
| West     | William   |

 


tables: name: calendar
data: calendar.csv
name: Orders
data: Orders.csv
name: Returns
data: Returns.csv
name: Users
data: Users.csv
label: Orders
Region
Users
Region
Orders
Order ID
Returns
Order ID
output: {
    "joins": [
        {
            "from_table": "Orders",
            "from_column": "Region",
            "to_table": "Users",
            "to_column": "Region"
        },
        {
            "from_table": "Orders",
            "from_column": "Order ID",
            "to_table": "Returns",
            "to_column": "Order ID"
        }
    ]
}