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: 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 |
|---------:|:-----------------|-----------:|-------------:|----------------:|--------------:|:-----------------------------|:------------|:-------------------|:-------------------|:-------------------------------|:--------------------|:-----------------------------------------------------------------------|:----------------------|:--------------|:---------|:--------------------|:--------------|--------------:|:------------------------|:------------------------|----------:|-----------------------:|--------:|-----------:|
|    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 | 2015-03-26 00:00:00.000 | 2015-03-29 00:00:00.000 | -189.714  |                     12 |  249.07 |      88837 |
|    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 | 2015-04-25 00:00:00.000 | 2015-04-26 00:00:00.000 | 1628.37   |                     18 |   59.22 |      88839 |
|    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 | 2015-04-20 00:00:00.000 | 2015-04-22 00:00:00.000 |   -4.48   |                     18 | 5572.18 |      88838 |
|    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 | 2015-04-20 00:00:00.000 | 2015-04-21 00:00:00.000 | 3193.28   |                     11 | 2941.42 |      88838 |
|    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 | 2015-04-20 00:00:00.000 | 2015-04-21 00:00:00.000 |   43.6917 |                      8 |  522.46 |      88838 |
|    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 | 2015-03-23 00:00:00.000 | 2015-03-25 00:00:00.000 |  349.059  |                      2 |   25.31 |      88836 |
|    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 | 2015-04-29 00:00:00.000 | 2015-04-29 00:00:00.000 |    1.992  |                     18 |  513.33 |      88840 |
|    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 | 2015-01-16 00:00:00.000 | 2015-01-16 00:00:00.000 |  -22.01   |                      5 |   15.7  |      88745 |
|    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 | 2015-01-16 00:00:00.000 | 2015-01-21 00:00:00.000 |  426.46   |                      6 |  680.65 |      88745 |
|    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 | 2015-05-03 00:00:00.000 | 2015-05-05 00:00:00.000 |   19.5546 |                     10 |   28.34 |      88746 |


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 |   Order Qtr |   Ship Qtr |
|---------:|:-----------------|-----------:|-------------:|----------------:|--------------:|:------------------|:------------|:-------------------|:-------------------|:-------------------------------|:--------------------|:---------------------------------------------------------|----------------------:|:--------------|:---------|:--------------------|:---------------|--------------:|:------------------------|:------------------------|----------:|-----------------------:|---------:|-----------:|------------:|-----------:|
|    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 |           2 |          2 |
|    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 |           2 |          2 |
|    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 |           1 |          2 |
|    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 |           2 |          2 |
|     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 |           1 |          1 |
|    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 |           1 |          1 |
|    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 |           2 |          2 |
|     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 |           2 |          2 |
|    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 |           2 |          2 |
|    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 |           1 |          1 |


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


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


Table: Region_Supervisor
| Region   | Supervisor   |
|:---------|:-------------|
| East     | SupervisorA  |
| West     | SupervisorB  |
| South    | SupervisorC  |
| Central  | SupervisorD  |


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 |

 


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