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: Append1
|   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 | Country       | Region   | State or Province   | City          |   Postal Code | Order Date   | Ship Date   |    Profit |   Quantity ordered new |   Sales |   Order ID | Year                    | S/P   | S/P - Copy   | Region_Supervisor.Region   | Region_Supervisor.Supervisor   | Region_Cost.Region   |   Region_Cost.Cost |
|---------:|:-----------------|-----------:|-------------:|----------------:|--------------:|:----------------|:------------|:-------------------|:-------------------|:-----------------------|:--------------------|:---------------------------------------------|----------------------:|:--------------|:---------|:--------------------|:--------------|--------------:|:-------------|:------------|----------:|-----------------------:|--------:|-----------:|:------------------------|:------|:-------------|:---------------------------|:-------------------------------|:---------------------|-------------------:|
|    20631 | High             |       0.06 |        55.48 |           14.3  |            24 | Edna Thomas     | Regular Air | Corporate          | Office Supplies    | Paper                  | Small Box           | Xerox 194                                    |                  0.37 | United States | West     | California          | Laguna Niguel |         92677 | 1/28/2015    | 1/29/2015   |  -28.2968 |                      1 |   67.49 |      87651 | 2015-01-28 00:00:00.000 |       |              | West                       | Patrick                        | West                 |            2000000 |
|    25762 | Critical         |       0.04 |        18.97 |            9.54 |           136 | Dale Gillespie  | Regular Air | Small Business     | Office Supplies    | Paper                  | Small Box           | Xerox 1939                                   |                  0.37 | United States | West     | California          | Petaluma      |         94952 | 5/16/2015    | 5/17/2015   |    3.04   |                      5 |  101.74 |      88534 | 2015-05-16 00:00:00.000 |       |              | West                       | Patrick                        | West                 |            2000000 |
|    24273 | Not Specified    |       0.02 |         6.48 |            9.17 |           194 | Tammy Goldman   | Regular Air | Corporate          | Office Supplies    | Paper                  | Small Box           | Xerox 1996                                   |                  0.37 | United States | West     | Utah                | Lehi          |         84043 | 1/10/2015    | 1/11/2015   | -105.685  |                      4 |   28.2  |      90431 | 2015-01-10 00:00:00.000 |       |              | West                       | Patrick                        | West                 |            2000000 |
|    19823 | Medium           |       0.08 |         6.48 |            7.03 |           266 | Ross Frederick  | Regular Air | Corporate          | Office Supplies    | Paper                  | Small Box           | Xerox 214                                    |                  0.37 | United States | Central  | Texas               | San Antonio   |         78207 | 5/15/2015    | 5/16/2015   |    8.932  |                     10 |   67.86 |      90594 | 2015-05-15 00:00:00.000 |       |              | Central                    | John                           | Central              |           20000000 |
|    19108 | Low              |       0.07 |         6.68 |            6.92 |           353 | Bonnie Chambers | Regular Air | Home Office        | Office Supplies    | Paper                  | Small Box           | Xerox 1898                                   |                  0.37 | United States | West     | Arizona             | Glendale      |         85301 | 5/14/2015    | 5/21/2015   | -141.12   |                     16 |  104.84 |      89647 | 2015-05-14 00:00:00.000 |       |              | West                       | Patrick                        | West                 |            2000000 |
|    23153 | Not Specified    |       0.03 |        48.04 |           19.99 |           445 | Judy Barrett    | Regular Air | Small Business     | Office Supplies    | Paper                  | Small Box           | 14-7/8 x 11 Blue Bar Computer Printout Paper |                  0.37 | United States | Central  | Nebraska            | Norfolk       |         68701 | 4/11/2015    | 4/13/2015   |   -4.46   |                      2 |  101.71 |      88083 | 2015-04-11 00:00:00.000 |       |              | Central                    | John                           | Central              |           20000000 |
|    18757 | Not Specified    |       0.02 |         6.48 |            6.6  |           493 | Douglas Buck    | Regular Air | Consumer           | Office Supplies    | Paper                  | Small Box           | Xerox 21                                     |                  0.37 | United States | West     | Washington          | Seatac        |         98158 | 1/20/2015    | 1/22/2015   |  -92.05   |                     10 |   66.71 |      88906 | 2015-01-20 00:00:00.000 |       |              | West                       | Patrick                        | West                 |            2000000 |
|    19895 | Low              |       0.02 |        48.04 |            5.09 |           510 | Gregory Rao     | Regular Air | Corporate          | Office Supplies    | Paper                  | Small Box           | Xerox 1910                                   |                  0.37 | United States | West     | California          | Manteca       |         95336 | 1/13/2015    | 1/13/2015   |  105.253  |                      3 |  152.54 |      90058 | 2015-01-13 00:00:00.000 |       |              | West                       | Patrick                        | West                 |            2000000 |
|    25949 | Not Specified    |       0.1  |         6.48 |            5.9  |           597 | Alexandra Wise  | Regular Air | Small Business     | Office Supplies    | Paper                  | Small Box           | Xerox 1976                                   |                  0.37 | United States | Central  | Indiana             | Columbus      |         47201 | 6/10/2015    | 6/10/2015   |  -51.635  |                     19 |  116.8  |      86310 | 2015-06-10 00:00:00.000 |       |              | Central                    | John                           | Central              |           20000000 |
|    21274 | Medium           |       0.06 |         6.48 |            7.37 |           600 | Vickie Morse    | Regular Air | Corporate          | Office Supplies    | Paper                  | Small Box           | Xerox 210                                    |                  0.37 | United States | East     | Maryland            | Reisterstown  |         21136 | 3/13/2015    | 3/14/2015   |  -75.44   |                      5 |   32.39 |      87579 | 2015-03-13 00:00:00.000 |       |              | East                       | LJ                             | East                 |            1000000 |


Table: Group Table
| Region   |   Sum of Sales |
|:---------|---------------:|
| West     |         524585 |
| East     |         590450 |
| Central  |         438621 |
| South    |         347222 |


Table: Orders Weekly
|   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   | Country       | Region   | State or Province   | City          |   Postal Code |   Order Date |   Ship Date |    Profit |   Quantity ordered new |   Sales |   Order ID |              S/P |   S/P - Copy |
|---------:|:-----------------|-----------:|-------------:|----------------:|--------------:|:-----------------------------|:------------|:-------------------|:-------------------|:-------------------------------|:--------------------|:-----------------------------------------------------------------------|:----------------------|:--------------|:---------|:--------------------|:--------------|--------------:|-------------:|------------:|----------:|-----------------------:|--------:|-----------:|-----------------:|-------------:|
|    22378 | Critical         |       0    |        19.98 |            5.97 |          3379 | Annette McIntyre             | Express Air | Corporate          | Office Supplies    | Paper                          | Small Box           | Xerox 1936                                                             | 0.38                  | United States | South    | Georgia             | Kennesaw      |         30144 |        42089 |       42092 | -189.714  |                     12 |  249.07 |      88837 | -47252.1         |           -1 |
|    20366 | Critical         |       0.05 |         3.14 |            1.92 |          3379 | Annette McIntyre             | Express Air | Home Office        | Office Supplies    | Scissors, Rulers and Trimmers  | Wrap Bag            | Serrated Blade or Curved Handle Hand Letter Openers                    | 0.84                  | United States | South    | Georgia             | Kennesaw      |         30144 |        42119 |       42120 | 1628.37   |                     18 |   59.22 |      88839 |  96432.1         |            1 |
|    23181 | Critical         |       0.03 |       315.98 |           19.99 |          3380 | Eva Decker                   | Regular Air | Home Office        | Office Supplies    | Binders and Binder Accessories | Small Box           | GBC ProClick™ 150 Presentation Binding System                          | 0.38                  | United States | South    | Georgia             | La Grange     |         30240 |        42114 |       42116 |   -4.48   |                     18 | 5572.18 |      88838 | -24963.4         |           -1 |
|    23182 | Critical         |       0.09 |       276.2  |           24.49 |          3380 | Eva Decker                   | Regular Air | Home Office        | Furniture          | Chairs & Chairmats             | Large Box           | SAFCO Arco Folding Chair                                               |                       | United States | South    | Georgia             | La Grange     |         30240 |        42114 |       42115 | 3193.28   |                     11 | 2941.42 |      88838 |      9.39279e+06 |            1 |
|    23183 | Critical         |       0.03 |        63.94 |           14.48 |          3380 | Eva Decker                   | Regular Air | Home Office        | Furniture          | Office Furnishings             | Small Box           | Howard Miller 16" Diameter Gallery Wall Clock                          | 0.46                  | United States | South    | Georgia             | La Grange     |         30240 |        42114 |       42115 |   43.6917 |                      8 |  522.46 |      88838 |  22827.2         |            1 |
|    24161 | Not Specified    |       0.05 |        11.97 |            5.81 |          3381 | Christopher Norton Patterson | Regular Air | Corporate          | Office Supplies    | Pens & Art Supplies            | Small Pack          | Staples SlimLine Pencil Sharpener                                      | 0.6                   | United States | South    | Georgia             | Macon         |         31204 |        42086 |       42088 |  349.059  |                      2 |   25.31 |      88836 |   8834.69        |            1 |
|    25841 | Medium           |       0.02 |        28.53 |            1.49 |          3381 | Christopher Norton Patterson | Regular Air | Home Office        | Office Supplies    | Binders and Binder Accessories | Small Box           | Lock-Up Easel 'Spel-Binder'                                            | 0.38                  | United States | South    | Georgia             | Macon         |         31204 |        42123 |       42123 |    1.992  |                     18 |  513.33 |      88840 |   1022.55        |            1 |
|    22341 | Low              |       0.04 |         2.98 |            2.03 |          3385 | Daniel Richmond              | Express Air | Corporate          | Office Supplies    | Pens & Art Supplies            | Wrap Bag            | Premium Writing Pencils, Soft, #2 by Central Association for the Blind | 0.57                  | United States | East     | Ohio                | Boardman      |         44512 |        42020 |       42020 |  -22.01   |                      5 |   15.7  |      88745 |   -345.557       |           -1 |
|    22342 | Low              |       0.01 |       125.99 |            8.99 |          3385 | Daniel Richmond              | Regular Air | Corporate          | Technology         | Telephones and Communication   | Small Box           | M70                                                                    | 0.59                  | United States | East     | Ohio                | Boardman      |         44512 |        42020 |       42025 |  426.46   |                      6 |  680.65 |      88745 | 290270           |            1 |
|    23190 | Critical         |       0    |         2.61 |            0.5  |          3386 | Carmen Elmore                | Regular Air | Corporate          | Office Supplies    | Labels                         | Small Box           | Avery 494                                                              | 0.39                  | United States | East     | Ohio                | Bowling Green |         43402 |        42127 |       42129 |   19.5546 |                     10 |   28.34 |      88746 |    554.177       |            1 |


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 | Country       | Region   | State or Province   | City           |   Postal Code | Order Date              | Ship Date               |    Profit |   Quantity ordered new |    Sales |   Order ID | Year                    |   AVG of Sales |   YEAR OF DATE |   DAY OF ORDER DATE |   MONTH OF DATE |
|---------:|:-----------------|-----------:|-------------:|----------------:|--------------:|:------------------|:------------|:-------------------|:-------------------|:-------------------------------|:--------------------|:---------------------------------------------------------|----------------------:|:--------------|:---------|:--------------------|:---------------|--------------:|:------------------------|:------------------------|----------:|-----------------------:|---------:|-----------:|:------------------------|---------------:|---------------:|--------------------:|----------------:|
|    24844 | Medium           |       0.09 |        78.69 |           19.99 |            14 | Gwendolyn F Tyson | Regular Air | Small Business     | Furniture          | Office Furnishings             | Small Box           | Howard Miller 12-3/4 Diameter Accuwave DS ™ Wall Clock   |                  0.43 | United States | Central  | Minnesota           | Prior Lake     |         55372 | 2015-05-12 00:00:00.000 | 2015-05-14 00:00:00.000 |  803.471  |                     16 |  1164.45 |      86838 | 2015-05-12 00:00:00.000 |        983.891 |           2015 |                  12 |               5 |
|    25933 | High             |       0    |        99.99 |           19.99 |            43 | Theodore Moran    | Regular Air | Consumer           | Technology         | Office Machines                | Small Box           | AT&T 2230 Dual Handset Phone With Caller ID/Call Waiting |                  0.52 | United States | West     | Washington          | Redmond        |         98052 | 2015-05-10 00:00:00.000 | 2015-05-11 00:00:00.000 |   25.9138 |                      6 |   647.07 |      91454 | 2015-05-10 00:00:00.000 |        983.891 |           2015 |                  10 |               5 |
|    23880 | High             |       0.08 |       896.99 |           19.99 |            84 | Helen Stein       | Regular Air | Corporate          | Office Supplies    | Binders and Binder Accessories | Small Box           | GBC DocuBind TL300 Electric Binding System               |                  0.38 | United States | East     | Ohio                | Cincinnati     |         45231 | 2015-03-30 00:00:00.000 | 2015-04-02 00:00:00.000 | 7402.32   |                     13 | 10728    |      87366 | 2015-03-30 00:00:00.000 |        983.891 |           2015 |                  30 |               3 |
|    24663 | Low              |       0.05 |       161.55 |           19.99 |            87 | Norman Shields    | Regular Air | Corporate          | Office Supplies    | Storage & Organization         | Small Box           | Fellowes Super Stor/Drawer® Files                        |                  0.66 | United States | West     | California          | Vacaville      |         95687 | 2015-06-03 00:00:00.000 | 2015-06-08 00:00:00.000 | 1892.42   |                     19 |  3127.69 |      90596 | 2015-06-03 00:00:00.000 |        983.891 |           2015 |                   3 |               6 |
|     5361 | Critical         |       0.02 |        49.99 |           19.99 |           181 | Wesley Waller     | Regular Air | Small Business     | Technology         | Computer Peripherals           | Small Box           | Zoom V.92 USB External Faxmodem                          |                  0.41 | United States | West     | California          | San Francisco  |         94122 | 2015-02-21 00:00:00.000 | 2015-02-21 00:00:00.000 |  -76.89   |                     18 |   901.81 |      38087 | 2015-02-21 00:00:00.000 |        983.891 |           2015 |                  21 |               2 |
|    23361 | Critical         |       0.02 |        49.99 |           19.99 |           184 | Phillip Holmes    | Regular Air | Small Business     | Technology         | Computer Peripherals           | Small Box           | Zoom V.92 USB External Faxmodem                          |                  0.41 | United States | East     | Massachusetts       | Arlington      |          2474 | 2015-02-21 00:00:00.000 | 2015-02-21 00:00:00.000 |  -76.89   |                      5 |   250.5  |      88360 | 2015-02-21 00:00:00.000 |        983.891 |           2015 |                  21 |               2 |
|    25158 | Critical         |       0    |       161.55 |           19.99 |           197 | Samantha Weaver   | Regular Air | Small Business     | Office Supplies    | Storage & Organization         | Small Box           | Fellowes Super Stor/Drawer® Files                        |                  0.66 | United States | Central  | Kansas              | Overland Park  |         66212 | 2015-04-02 00:00:00.000 | 2015-04-04 00:00:00.000 | 1167.16   |                     19 |  3108.98 |      88921 | 2015-04-02 00:00:00.000 |        983.891 |           2015 |                   2 |               4 |
|     7158 | Critical         |       0    |       161.55 |           19.99 |           198 | Leroy Blanchard   | Regular Air | Small Business     | Office Supplies    | Storage & Organization         | Small Box           | Fellowes Super Stor/Drawer® Files                        |                  0.66 | United States | Central  | Michigan            | Detroit        |         48138 | 2015-04-02 00:00:00.000 | 2015-04-04 00:00:00.000 | 1014.92   |                     77 | 12599.5  |      51072 | 2015-04-02 00:00:00.000 |        983.891 |           2015 |                   2 |               4 |
|    23153 | Not Specified    |       0.03 |        48.04 |           19.99 |           445 | Judy Barrett      | Regular Air | Small Business     | Office Supplies    | Paper                          | Small Box           | 14-7/8 x 11 Blue Bar Computer Printout Paper             |                  0.37 | United States | Central  | Nebraska            | Norfolk        |         68701 | 2015-04-11 00:00:00.000 | 2015-04-13 00:00:00.000 |   -4.46   |                      2 |   101.71 |      88083 | 2015-04-11 00:00:00.000 |        983.891 |           2015 |                  11 |               4 |
|    18467 | Low              |       0.07 |       165.2  |           19.99 |           463 | Debbie Stevenson  | Regular Air | Small Business     | Office Supplies    | Storage & Organization         | Small Box           | Economy Rollaway Files                                   |                  0.59 | United States | West     | California          | West Hollywood |         90069 | 2015-01-14 00:00:00.000 | 2015-01-16 00:00:00.000 |  521.69   |                      7 |  1081.54 |      88061 | 2015-01-14 00:00:00.000 |        983.891 |           2015 |                  14 |               1 |


Table: Region_Cost
| Region   |      Cost |
|:---------|----------:|
| East     |   1000000 |
| West     |   2000000 |
| North    |   5000000 |
| South    | 100000000 |
| Central  |  20000000 |


Table: Region_Supervisor
| Region   | Supervisor   |
|:---------|:-------------|
| East     | LJ           |
| West     | Patrick      |
| Central  | John         |
| South    | Soham        |


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: Supervisor_Salary
| Supervisor   |   Salary |
|:-------------|---------:|
| LJ           |     9999 |
| John         |     8888 |
| Patrick      |     7777 |
| Soham        |    20000 |


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

 


tables: name: Append1
data: Append1.csv
name: Group Table
data: Group Table.csv
name: Orders Weekly
data: Orders Weekly.csv
name: Orders
data: Orders.csv
name: Region_Cost
data: Region_Cost.csv
name: Region_Supervisor
data: Region_Supervisor.csv
name: Returns
data: Returns.csv
name: Supervisor_Salary
data: Supervisor_Salary.csv
name: Users
data: Users.csv
label: Orders
Region
Region_Cost
Region
Orders
Region
Region_Supervisor
Region
Orders
Order ID
Returns
Order ID
Supervisor_Salary
Supervisor
Region_Supervisor
Supervisor
Users
Region
Region_Cost
Region
Group Table
Region
Region_Cost
Region
Append1
Region
Region_Cost
Region
output: {
    "joins": [
        {
            "from_table": "Orders",
            "from_column": "Region",
            "to_table": "Region_Cost",
            "to_column": "Region"
        },
        {
            "from_table": "Orders",
            "from_column": "Region",
            "to_table": "Region_Supervisor",
            "to_column": "Region"
        },
        {
            "from_table": "Orders",
            "from_column": "Order ID",
            "to_table": "Returns",
            "to_column": "Order ID"
        },
        {
            "from_table": "Supervisor_Salary",
            "from_column": "Supervisor",
            "to_table": "Region_Supervisor",
            "to_column": "Supervisor"
        },
        {
            "from_table": "Users",
            "from_column": "Region",
            "to_table": "Region_Cost",
            "to_column": "Region"
        },
        {
            "from_table": "Group Table",
            "from_column": "Region",
            "to_table": "Region_Cost",
            "to_column": "Region"
        },
        {
            "from_table": "Append1",
            "from_column": "Region",
            "to_table": "Region_Cost",
            "to_column": "Region"
        }
    ]
}