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: Order Date
| Order Date              |   Day Number Of Week | English Day Name of Week   |   Day Number of Month |   Day Number of Year |   Week Number of Year | English Month Name   |   Month Number of Year |   Calendar Quarter |   Year Month | Order Date Month   |   Order Date Year | Is Weekend   |
|:------------------------|---------------------:|:---------------------------|----------------------:|---------------------:|----------------------:|:---------------------|-----------------------:|-------------------:|-------------:|:-------------------|------------------:|:-------------|
| 2017-01-02 00:00:00.000 |                    2 | Monday                     |                     2 |                    2 |                     1 | January              |                      1 |                  1 |       201701 | Jan-2017           |              2017 | False        |
| 2017-01-09 00:00:00.000 |                    2 | Monday                     |                     9 |                    9 |                     2 | January              |                      1 |                  1 |       201701 | Jan-2017           |              2017 | False        |
| 2017-01-16 00:00:00.000 |                    2 | Monday                     |                    16 |                   16 |                     3 | January              |                      1 |                  1 |       201701 | Jan-2017           |              2017 | False        |
| 2017-01-23 00:00:00.000 |                    2 | Monday                     |                    23 |                   23 |                     4 | January              |                      1 |                  1 |       201701 | Jan-2017           |              2017 | False        |
| 2017-01-30 00:00:00.000 |                    2 | Monday                     |                    30 |                   30 |                     5 | January              |                      1 |                  1 |       201701 | Jan-2017           |              2017 | False        |
| 2017-02-06 00:00:00.000 |                    2 | Monday                     |                     6 |                   37 |                     6 | February             |                      2 |                  1 |       201702 | Feb-2017           |              2017 | False        |
| 2017-02-13 00:00:00.000 |                    2 | Monday                     |                    13 |                   44 |                     7 | February             |                      2 |                  1 |       201702 | Feb-2017           |              2017 | False        |
| 2017-02-20 00:00:00.000 |                    2 | Monday                     |                    20 |                   51 |                     8 | February             |                      2 |                  1 |       201702 | Feb-2017           |              2017 | False        |
| 2017-02-27 00:00:00.000 |                    2 | Monday                     |                    27 |                   58 |                     9 | February             |                      2 |                  1 |       201702 | Feb-2017           |              2017 | False        |
| 2017-03-06 00:00:00.000 |                    2 | Monday                     |                     6 |                   65 |                    10 | March                |                      3 |                  1 |       201703 | Mar-2017           |              2017 | False        |


Table: Product
| Product Key   | Subcategory Key   | Product Name          | Product Description   | Standard Cost   | Color   | Product Prefix   | Product Subcategory   | Product Category   |
|:--------------|:------------------|:----------------------|:----------------------|:----------------|:--------|:-----------------|:----------------------|:-------------------|
| AR-5381       |                   | Adjustable Race       | No description        |                 | NA      | AR               | Internal Product      | Internal Product   |
| BA-8327       |                   | Bearing Ball          | No description        |                 | NA      | BA               | Internal Product      | Internal Product   |
| BE-2349       |                   | Bb Ball Bearing       | No description        |                 | NA      | BE               | Internal Product      | Internal Product   |
| BE-2908       |                   | Headset Ball Bearings | No description        |                 | NA      | BE               | Internal Product      | Internal Product   |
| BL-2036       |                   | Blade                 | No description        |                 | NA      | BL               | Internal Product      | Internal Product   |
| CR-9981       |                   | Crown Race            | No description        |                 | NA      | CR               | Internal Product      | Internal Product   |
| CS-2812       |                   | Chain Stays           | No description        |                 | NA      | CS               | Internal Product      | Internal Product   |
| DC-8732       |                   | Decal 1               | No description        |                 | NA      | DC               | Internal Product      | Internal Product   |
| DC-9824       |                   | Decal 2               | No description        |                 | NA      | DC               | Internal Product      | Internal Product   |
| DT-2377       |                   | Down Tube             | No description        |                 | NA      | DT               | Internal Product      | Internal Product   |


Table: Sales Territories
| Sales Territory Region   | Country        | Continent     |
|:-------------------------|:---------------|:--------------|
| Northwest                | United States  | North America |
| Northeast                | United States  | North America |
| Central                  | United States  | North America |
| Southwest                | United States  | North America |
| Southeast                | United States  | North America |
| Canada                   | Canada         | North America |
| France                   | France         | Europe        |
| Germany                  | Germany        | Europe        |
| Australia                | Australia      | Pacific       |
| United Kingdom           | United Kingdom | Europe        |


Table: Sales
| Product Key   | Order Date              | Sales Territory Region   |   Order Quantity |   Unit Price |   Line Total Sales PQ |   Line Total Sales |
|:--------------|:------------------------|:-------------------------|-----------------:|-------------:|----------------------:|-------------------:|
| WB-H098       | 2020-02-04 00:00:00.000 | Southwest                |                3 |         4.99 |                 14.97 |              14.97 |
| WB-H098       | 2020-02-04 00:00:00.000 | Southwest                |                3 |         4.99 |                 14.97 |              14.97 |
| WB-H098       | 2020-02-09 00:00:00.000 | Southwest                |                3 |         4.99 |                 14.97 |              14.97 |
| WB-H098       | 2020-02-11 00:00:00.000 | Southwest                |                3 |         4.99 |                 14.97 |              14.97 |
| WB-H098       | 2020-02-15 00:00:00.000 | Southwest                |                3 |         4.99 |                 14.97 |              14.97 |
| WB-H098       | 2020-02-16 00:00:00.000 | Southwest                |                3 |         4.99 |                 14.97 |              14.97 |
| WB-H098       | 2020-02-21 00:00:00.000 | Southwest                |                3 |         4.99 |                 14.97 |              14.97 |
| WB-H098       | 2020-02-23 00:00:00.000 | Southwest                |                3 |         4.99 |                 14.97 |              14.97 |
| WB-H098       | 2020-03-03 00:00:00.000 | Southwest                |                3 |         4.99 |                 14.97 |              14.97 |
| WB-H098       | 2020-03-04 00:00:00.000 | Southwest                |                3 |         4.99 |                 14.97 |              14.97 |

 


tables: name: Order Date
data: Order Date.csv
name: Product
data: Product.csv
name: Sales Territories
data: Sales Territories.csv
name: Sales
data: Sales.csv
label: Sales
Product Key
Product
Product Key
Sales
Sales Territory Region
Sales Territories
Sales Territory Region
Sales
Order Date
Order Date
Order Date
output: {
    "joins": [
        {
            "from_table": "Sales",
            "from_column": "Product Key",
            "to_table": "Product",
            "to_column": "Product Key"
        },
        {
            "from_table": "Sales",
            "from_column": "Sales Territory Region",
            "to_table": "Sales Territories",
            "to_column": "Sales Territory Region"
        },
        {
            "from_table": "Sales",
            "from_column": "Order Date",
            "to_table": "Order Date",
            "to_column": "Order Date"
        }
    ]
}