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: Classification
| Class   |   Lower Boundary |   Upper Boundary |
|:--------|-----------------:|-----------------:|
| A       |              0   |              0.7 |
| B       |              0.7 |              0.9 |
| C       |              0.9 |              1   |


Table: Customer
|   Customer Index | Customer Names   |   Customer Sales |   Cumulated Sales |   Cumulated Percentage | Customer Sales Group   | Selected Customers             |
|-----------------:|:-----------------|-----------------:|------------------:|-----------------------:|:-----------------------|:-------------------------------|
|                1 | Avon Corp        |      2.69477e+06 |       1.44426e+08 |               0.933247 | Lower Clients          | You are Selected Avon Corp     |
|                2 | WakeFern         |      2.36496e+06 |       1.54756e+08 |               1        | Lower Clients          | You are Selected WakeFern      |
|                3 | Elorac, Corp     |      3.20996e+06 |       5.89475e+07 |               0.380906 | Top Clients            | You are Selected Elorac, Corp  |
|                4 | ETUDE Ltd        |      3.28802e+06 |       4.27862e+07 |               0.276475 | Top Clients            | You are Selected ETUDE Ltd     |
|                5 | Procter Corp     |      2.97421e+06 |       9.29297e+07 |               0.600491 | Top Clients            | You are Selected Procter Corp  |
|                6 | PEDIFIX, Corp    |      2.8182e+06  |       1.36201e+08 |               0.880097 | Mid. Clients           | You are Selected PEDIFIX, Corp |
|                7 | New Ltd          |      2.86201e+06 |       1.2206e+08  |               0.788724 | Mid. Clients           | You are Selected New Ltd       |
|                8 | Medsep Group     |      2.82581e+06 |       1.33382e+08 |               0.861887 | Mid. Clients           | You are Selected Medsep Group  |
|                9 | Ei               |      3.27365e+06 |       4.60599e+07 |               0.297628 | Top Clients            | You are Selected Ei            |
|               10 | 21st Ltd         |      3.17011e+06 |       6.85015e+07 |               0.442642 | Top Clients            | You are Selected 21st Ltd      |


Table: Dates
| Date                    |   Year |   QuarterOfYear |   MonthOfYear |   DayOfMonth |   DateInt | MonthName   | Month & Year            | Quarter & Year   |   DayInWeek | DayOfWeekName   | WeekEnding              |   Week Number |   MonthnYear |   QuarternYear |   ShortYear | FY   | Short Month   | Quarter   |
|:------------------------|-------:|----------------:|--------------:|-------------:|----------:|:------------|:------------------------|:-----------------|------------:|:----------------|:------------------------|--------------:|-------------:|---------------:|------------:|:-----|:--------------|:----------|
| 2016-07-01 00:00:00.000 |   2016 |               3 |             7 |            1 |  20160701 | July        | 2016-07-01 00:00:00.000 | Q3 2016          |           5 | Friday          | 2016-07-02 00:00:00.000 |            27 |     20160700 |       20160300 |          16 | FY17 | Jul           | Q3        |
| 2016-07-02 00:00:00.000 |   2016 |               3 |             7 |            2 |  20160702 | July        | 2016-07-01 00:00:00.000 | Q3 2016          |           6 | Saturday        | 2016-07-02 00:00:00.000 |            27 |     20160700 |       20160300 |          16 | FY17 | Jul           | Q3        |
| 2016-07-03 00:00:00.000 |   2016 |               3 |             7 |            3 |  20160703 | July        | 2016-07-01 00:00:00.000 | Q3 2016          |           0 | Sunday          | 2016-07-09 00:00:00.000 |            28 |     20160700 |       20160300 |          16 | FY17 | Jul           | Q3        |
| 2016-07-04 00:00:00.000 |   2016 |               3 |             7 |            4 |  20160704 | July        | 2016-07-01 00:00:00.000 | Q3 2016          |           1 | Monday          | 2016-07-09 00:00:00.000 |            28 |     20160700 |       20160300 |          16 | FY17 | Jul           | Q3        |
| 2016-07-05 00:00:00.000 |   2016 |               3 |             7 |            5 |  20160705 | July        | 2016-07-01 00:00:00.000 | Q3 2016          |           2 | Tuesday         | 2016-07-09 00:00:00.000 |            28 |     20160700 |       20160300 |          16 | FY17 | Jul           | Q3        |
| 2016-07-06 00:00:00.000 |   2016 |               3 |             7 |            6 |  20160706 | July        | 2016-07-01 00:00:00.000 | Q3 2016          |           3 | Wednesday       | 2016-07-09 00:00:00.000 |            28 |     20160700 |       20160300 |          16 | FY17 | Jul           | Q3        |
| 2016-07-07 00:00:00.000 |   2016 |               3 |             7 |            7 |  20160707 | July        | 2016-07-01 00:00:00.000 | Q3 2016          |           4 | Thursday        | 2016-07-09 00:00:00.000 |            28 |     20160700 |       20160300 |          16 | FY17 | Jul           | Q3        |
| 2016-07-08 00:00:00.000 |   2016 |               3 |             7 |            8 |  20160708 | July        | 2016-07-01 00:00:00.000 | Q3 2016          |           5 | Friday          | 2016-07-09 00:00:00.000 |            28 |     20160700 |       20160300 |          16 | FY17 | Jul           | Q3        |
| 2016-07-09 00:00:00.000 |   2016 |               3 |             7 |            9 |  20160709 | July        | 2016-07-01 00:00:00.000 | Q3 2016          |           6 | Saturday        | 2016-07-09 00:00:00.000 |            28 |     20160700 |       20160300 |          16 | FY17 | Jul           | Q3        |
| 2016-07-10 00:00:00.000 |   2016 |               3 |             7 |           10 |  20160710 | July        | 2016-07-01 00:00:00.000 | Q3 2016          |           0 | Sunday          | 2016-07-16 00:00:00.000 |            29 |     20160700 |       20160300 |          16 | FY17 | Jul           | Q3        |


Table: Price Ranges
| Range   |   Min |   Max |
|:--------|------:|------:|
| Low     |     0 |     0 |
| Medium  |     0 |     0 |
| High    |     0 |     1 |


Table: Products
|   Index | Product Name   |   Product Sales |   Cumulated Sales |   Cumulated Percentage | ABC Class     |
|--------:|:---------------|----------------:|------------------:|-----------------------:|:--------------|
|       1 | Product 1      |     2.55715e+07 |       5.12875e+07 |               0.331409 | Top Products  |
|       2 | Product 2      |     2.29139e+07 |       7.42014e+07 |               0.479473 | Top Products  |
|       3 | Product 3      |     3.06628e+06 |       1.51899e+08 |               0.981537 | Less Products |
|       4 | Product 4      |     2.85729e+06 |       1.54756e+08 |               1        | Less Products |
|       5 | Product 5      |     1.70471e+07 |       1.1187e+08  |               0.722881 | Mid Products  |
|       6 | Product 6      |     3.34122e+06 |       1.36248e+08 |               0.880403 | Mid Products  |
|       7 | Product 7      |     2.5716e+07  |       2.5716e+07  |               0.166171 | Top Products  |
|       8 | Product 8      |     3.2156e+06  |       1.39463e+08 |               0.901182 | Less Products |
|       9 | Product 9      |     9.26164e+06 |       1.32907e+08 |               0.858813 | Mid Products  |
|      10 | Product 10     |     3.11565e+06 |       1.45723e+08 |               0.941632 | Less Products |


Table: Regions
|   Index | City                  | Country   |   Region Sales |   Cumulated Sales |   Cumulated Percentage | Region Group   | Full Name                      |
|--------:|:----------------------|:----------|---------------:|------------------:|-----------------------:|:---------------|:-------------------------------|
|       1 | LONDON                | UK        |    1.8707e+06  |       1.51057e+08 |              0.976099  | Lower Regions  | LONDON, UK                     |
|       2 | BERLIN                | Germany   |    1.9185e+06  |       1.47311e+08 |              0.951888  | Lower Regions  | BERLIN, Germany                |
|       3 | MADRID                | Spain     |    2.45867e+06 |       5.12184e+07 |              0.330962  | Top Regions    | MADRID, Spain                  |
|       4 | ROMA                  | Italy     |    2.5507e+06  |       4.12044e+07 |              0.266253  | Top Regions    | ROMA, Italy                    |
|       5 | KIEV                  | Ukraine   |    2.70132e+06 |       2.29228e+07 |              0.148122  | Top Regions    | KIEV, Ukraine                  |
|       6 | PARIS                 | France    |    2.89528e+06 |       9.03772e+06 |              0.0583997 | Top Regions    | PARIS, France                  |
|       7 | BUCURESTI (Bucharest) | Romania   |    1.99637e+06 |       1.41475e+08 |              0.914177  | Lower Regions  | BUCURESTI (Bucharest), Romania |
|       8 | BUDAPEST              | Hungary   |    2.04651e+06 |       1.37477e+08 |              0.888348  | Mid Regions    | BUDAPEST, Hungary              |
|       9 | Hamburg               | Germany   |    2.37384e+06 |       8.24801e+07 |              0.532968  | Top Regions    | Hamburg, Germany               |
|      10 | MINSK                 | Belarus   |    1.87605e+06 |       1.49187e+08 |              0.964011  | Lower Regions  | MINSK, Belarus                 |


Table: Sales
| OrderNumber   | OrderDate               | Channel   | Currency Code   | Warehouse Code   |   Delivery Region Index |   Product Description Index |   Order Quantity |   Unit Price |   Line Total |   Total Unit Cost |   Customer Name Index |
|:--------------|:------------------------|:----------|:----------------|:-----------------|------------------------:|----------------------------:|-----------------:|-------------:|-------------:|------------------:|----------------------:|
| SO - 000105   | 2013-01-01 00:00:00.000 | Wholesale | USD             | AXW291           |                      20 |                           7 |                6 |       1822.4 |      10934.4 |          1476.14  |                    49 |
| SO - 000120   | 2013-01-04 00:00:00.000 | Wholesale | USD             | AXW291           |                      25 |                           7 |                8 |       3095.4 |      24763.2 |          1795.33  |                    23 |
| SO - 000126   | 2013-01-04 00:00:00.000 | Wholesale | USD             | AXW291           |                      20 |                           7 |               11 |        174.2 |       1916.2 |            95.81  |                    46 |
| SO - 000153   | 2013-01-09 00:00:00.000 | Wholesale | USD             | AXW291           |                      20 |                           7 |               11 |       3926.2 |      43188.2 |          3062.44  |                     8 |
| SO - 000172   | 2013-01-15 00:00:00.000 | Wholesale | USD             | AXW291           |                      18 |                           7 |                6 |       1005   |       6030   |           743.7   |                     6 |
| SO - 000175   | 2013-01-16 00:00:00.000 | Wholesale | USD             | AXW291           |                      20 |                           7 |               11 |       2224.4 |      24468.4 |          1579.32  |                     1 |
| SO - 000192   | 2013-01-20 00:00:00.000 | Wholesale | USD             | AXW291           |                      31 |                           7 |                8 |       1152.4 |       9219.2 |           622.296 |                    24 |
| SO - 000193   | 2013-01-20 00:00:00.000 | Wholesale | USD             | AXW291           |                      24 |                           7 |                5 |       1085.4 |       5427   |           922.59  |                    25 |
| SO - 000194   | 2013-01-20 00:00:00.000 | Wholesale | USD             | AXW291           |                      27 |                           7 |                5 |       5031.7 |      25158.5 |          4025.36  |                    11 |
| SO - 000195   | 2013-01-21 00:00:00.000 | Wholesale | USD             | AXW291           |                      18 |                           7 |                8 |       1092.1 |       8736.8 |           436.84  |                    17 |

 


tables: name: Classification
data: Classification.csv
name: Customer
data: Customer.csv
name: Dates
data: Dates.csv
name: Price Ranges
data: Price Ranges.csv
name: Products
data: Products.csv
name: Regions
data: Regions.csv
name: Sales
data: Sales.csv
label: Sales
Customer Name Index
Customer
Customer Index
Sales
OrderDate
Dates
Date
Sales
Delivery Region Index
Regions
Index
Sales
Product Description Index
Products
Index
output: {
    "joins": [
        {
            "from_table": "Sales",
            "from_column": "Customer Name Index",
            "to_table": "Customer",
            "to_column": "Customer Index"
        },
        {
            "from_table": "Sales",
            "from_column": "OrderDate",
            "to_table": "Dates",
            "to_column": "Date"
        },
        {
            "from_table": "Sales",
            "from_column": "Delivery Region Index",
            "to_table": "Regions",
            "to_column": "Index"
        },
        {
            "from_table": "Sales",
            "from_column": "Product Description Index",
            "to_table": "Products",
            "to_column": "Index"
        }
    ]
}