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   |   Calendar Quarter |   Year Month | Month Year   |   Calendar Year | IsWeekend   |   Month |
|:------------------------|---------------------:|:---------------------------|----------------------:|---------------------:|----------------------:|:---------------------|-------------------:|-------------:|:-------------|----------------:|:------------|--------:|
| 2022-12-30 00:00:00.000 |                    6 | Friday                     |                    30 |                  364 |                    53 | December             |                  4 |       202212 | Dec-2022     |            2022 | False       |      12 |
| 2022-12-23 00:00:00.000 |                    6 | Friday                     |                    23 |                  357 |                    52 | December             |                  4 |       202212 | Dec-2022     |            2022 | False       |      12 |
| 2022-12-16 00:00:00.000 |                    6 | Friday                     |                    16 |                  350 |                    51 | December             |                  4 |       202212 | Dec-2022     |            2022 | False       |      12 |
| 2022-12-09 00:00:00.000 |                    6 | Friday                     |                     9 |                  343 |                    50 | December             |                  4 |       202212 | Dec-2022     |            2022 | False       |      12 |
| 2022-12-02 00:00:00.000 |                    6 | Friday                     |                     2 |                  336 |                    49 | December             |                  4 |       202212 | Dec-2022     |            2022 | False       |      12 |
| 2022-11-25 00:00:00.000 |                    6 | Friday                     |                    25 |                  329 |                    48 | November             |                  4 |       202211 | Nov-2022     |            2022 | False       |      11 |
| 2022-11-18 00:00:00.000 |                    6 | Friday                     |                    18 |                  322 |                    47 | November             |                  4 |       202211 | Nov-2022     |            2022 | False       |      11 |
| 2022-11-11 00:00:00.000 |                    6 | Friday                     |                    11 |                  315 |                    46 | November             |                  4 |       202211 | Nov-2022     |            2022 | False       |      11 |
| 2022-11-04 00:00:00.000 |                    6 | Friday                     |                     4 |                  308 |                    45 | November             |                  4 |       202211 | Nov-2022     |            2022 | False       |      11 |
| 2022-10-28 00:00:00.000 |                    6 | Friday                     |                    28 |                  301 |                    44 | October              |                  4 |       202210 | Oct-2022     |            2022 | False       |      10 |


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       | 2021-01-26 00:00:00.000 | Southwest                |                3 |         4.99 |                 14.97 |              14.97 |
| WB-H098       | 2021-01-15 00:00:00.000 | Southwest                |                3 |         4.99 |                 14.97 |              14.97 |
| WB-H098       | 2021-01-12 00:00:00.000 | Southwest                |                3 |         4.99 |                 14.97 |              14.97 |
| WB-H098       | 2021-01-05 00:00:00.000 | Southwest                |                3 |         4.99 |                 14.97 |              14.97 |
| WB-H098       | 2021-01-03 00:00:00.000 | Southwest                |                3 |         4.99 |                 14.97 |              14.97 |
| WB-H098       | 2020-12-26 00:00:00.000 | Southwest                |                3 |         4.99 |                 14.97 |              14.97 |
| WB-H098       | 2020-12-25 00:00:00.000 | Southwest                |                3 |         4.99 |                 14.97 |              14.97 |
| WB-H098       | 2020-12-22 00:00:00.000 | Southwest                |                3 |         4.99 |                 14.97 |              14.97 |
| WB-H098       | 2020-12-21 00:00:00.000 | Southwest                |                3 |         4.99 |                 14.97 |              14.97 |
| WB-H098       | 2020-12-19 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"
        }
    ]
}