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: Date
| Date                    |   Year |   Quarters in Year |   Month No |   Days in Month |   DateInt | Month Name   | Short Month   | Initial of Month   | Month & Year   | Quarter & Year   |   Days in Week | Day Name   | Day Initials   | End of the Week         | End of the Month        |   ISO Week Number |   ISO Year |   ISO Day of Year | Week & Year   |   Week No and Year |   Month No and Year |   Quarter No and Year | Fiscal Year   | Fiscal Quarter   |   Fiscal Period |   Fiscal Week | Fiscal Year & Week   |   Fiscal Week No and Year | Is After Today   | Is Working Day   | Is Holiday   | Is Business Day   | Day Type   |   Week Offset |   Month Offset |   Quarter Offset |   Year Offset |   Fiscal Year Offset | Week Completed   | Month Completed   | Quarter Completed   | IsThismonth   | IsToday   | Yesterday   |
|:------------------------|-------:|-------------------:|-----------:|----------------:|----------:|:-------------|:--------------|:-------------------|:---------------|:-----------------|---------------:|:-----------|:---------------|:------------------------|:------------------------|------------------:|-----------:|------------------:|:--------------|-------------------:|--------------------:|----------------------:|:--------------|:-----------------|----------------:|--------------:|:---------------------|--------------------------:|:-----------------|:-----------------|:-------------|:------------------|:-----------|--------------:|---------------:|-----------------:|--------------:|---------------------:|:-----------------|:------------------|:--------------------|:--------------|:----------|:------------|
| 2020-01-01 00:00:00.000 |   2020 |                  1 |          1 |               1 |  20200101 | January      | Jan           | J​                  | Jan 2020       | Q1 2020          |              3 | Wednesday  | W​​​              | 2020-01-05 00:00:00.000 | 2020-01-31 00:00:00.000 |                 1 |       2020 |                 3 | 2020-01       |           20200100 |            20200100 |              20200100 | FY21          | FQ1              |               1 |             1 | 2020-01              |                  20200100 | False            | True             | Unknown      | True              | Weekday    |           -97 |            -22 |               -7 |            -1 |                   -1 | True             | True              | True                | False         | False     | False       |
| 2020-01-02 00:00:00.000 |   2020 |                  1 |          1 |               2 |  20200102 | January      | Jan           | J​                  | Jan 2020       | Q1 2020          |              4 | Thursday   | T​​​​              | 2020-01-05 00:00:00.000 | 2020-01-31 00:00:00.000 |                 1 |       2020 |                 4 | 2020-01       |           20200100 |            20200100 |              20200100 | FY21          | FQ1              |               1 |             1 | 2020-01              |                  20200100 | False            | True             | Unknown      | True              | Weekday    |           -97 |            -22 |               -7 |            -1 |                   -1 | True             | True              | True                | False         | False     | False       |
| 2020-01-03 00:00:00.000 |   2020 |                  1 |          1 |               3 |  20200103 | January      | Jan           | J​                  | Jan 2020       | Q1 2020          |              5 | Friday     | F​​​​​              | 2020-01-05 00:00:00.000 | 2020-01-31 00:00:00.000 |                 1 |       2020 |                 5 | 2020-01       |           20200100 |            20200100 |              20200100 | FY21          | FQ1              |               1 |             1 | 2020-01              |                  20200100 | False            | True             | Unknown      | True              | Weekday    |           -97 |            -22 |               -7 |            -1 |                   -1 | True             | True              | True                | False         | False     | False       |
| 2020-01-06 00:00:00.000 |   2020 |                  1 |          1 |               6 |  20200106 | January      | Jan           | J​                  | Jan 2020       | Q1 2020          |              1 | Monday     | M​              | 2020-01-12 00:00:00.000 | 2020-01-31 00:00:00.000 |                 2 |       2020 |                 8 | 2020-02       |           20200200 |            20200100 |              20200100 | FY21          | FQ1              |               1 |             2 | 2020-02              |                  20200200 | False            | True             | Unknown      | True              | Weekday    |           -96 |            -22 |               -7 |            -1 |                   -1 | True             | True              | True                | False         | False     | False       |
| 2020-01-07 00:00:00.000 |   2020 |                  1 |          1 |               7 |  20200107 | January      | Jan           | J​                  | Jan 2020       | Q1 2020          |              2 | Tuesday    | T​​              | 2020-01-12 00:00:00.000 | 2020-01-31 00:00:00.000 |                 2 |       2020 |                 9 | 2020-02       |           20200200 |            20200100 |              20200100 | FY21          | FQ1              |               1 |             2 | 2020-02              |                  20200200 | False            | True             | Unknown      | True              | Weekday    |           -96 |            -22 |               -7 |            -1 |                   -1 | True             | True              | True                | False         | False     | False       |
| 2020-01-08 00:00:00.000 |   2020 |                  1 |          1 |               8 |  20200108 | January      | Jan           | J​                  | Jan 2020       | Q1 2020          |              3 | Wednesday  | W​​​              | 2020-01-12 00:00:00.000 | 2020-01-31 00:00:00.000 |                 2 |       2020 |                10 | 2020-02       |           20200200 |            20200100 |              20200100 | FY21          | FQ1              |               1 |             2 | 2020-02              |                  20200200 | False            | True             | Unknown      | True              | Weekday    |           -96 |            -22 |               -7 |            -1 |                   -1 | True             | True              | True                | False         | False     | False       |
| 2020-01-09 00:00:00.000 |   2020 |                  1 |          1 |               9 |  20200109 | January      | Jan           | J​                  | Jan 2020       | Q1 2020          |              4 | Thursday   | T​​​​              | 2020-01-12 00:00:00.000 | 2020-01-31 00:00:00.000 |                 2 |       2020 |                11 | 2020-02       |           20200200 |            20200100 |              20200100 | FY21          | FQ1              |               1 |             2 | 2020-02              |                  20200200 | False            | True             | Unknown      | True              | Weekday    |           -96 |            -22 |               -7 |            -1 |                   -1 | True             | True              | True                | False         | False     | False       |
| 2020-01-10 00:00:00.000 |   2020 |                  1 |          1 |              10 |  20200110 | January      | Jan           | J​                  | Jan 2020       | Q1 2020          |              5 | Friday     | F​​​​​              | 2020-01-12 00:00:00.000 | 2020-01-31 00:00:00.000 |                 2 |       2020 |                12 | 2020-02       |           20200200 |            20200100 |              20200100 | FY21          | FQ1              |               1 |             2 | 2020-02              |                  20200200 | False            | True             | Unknown      | True              | Weekday    |           -96 |            -22 |               -7 |            -1 |                   -1 | True             | True              | True                | False         | False     | False       |
| 2020-01-13 00:00:00.000 |   2020 |                  1 |          1 |              13 |  20200113 | January      | Jan           | J​                  | Jan 2020       | Q1 2020          |              1 | Monday     | M​              | 2020-01-19 00:00:00.000 | 2020-01-31 00:00:00.000 |                 3 |       2020 |                15 | 2020-03       |           20200300 |            20200100 |              20200100 | FY21          | FQ1              |               1 |             3 | 2020-03              |                  20200300 | False            | True             | Unknown      | True              | Weekday    |           -95 |            -22 |               -7 |            -1 |                   -1 | True             | True              | True                | False         | False     | False       |
| 2020-01-14 00:00:00.000 |   2020 |                  1 |          1 |              14 |  20200114 | January      | Jan           | J​                  | Jan 2020       | Q1 2020          |              2 | Tuesday    | T​​              | 2020-01-19 00:00:00.000 | 2020-01-31 00:00:00.000 |                 3 |       2020 |                16 | 2020-03       |           20200300 |            20200100 |              20200100 | FY21          | FQ1              |               1 |             3 | 2020-03              |                  20200300 | False            | True             | Unknown      | True              | Weekday    |           -95 |            -22 |               -7 |            -1 |                   -1 | True             | True              | True                | False         | False     | False       |


Table: Orders
|   Item ID |   Quantity | Orderdate               |   Order Types |   Order ID |   Sales channel ID |   Price per product |
|----------:|-----------:|:------------------------|--------------:|-----------:|-------------------:|--------------------:|
|      1407 |          1 | 2020-06-15 00:00:00.000 |             1 |     207495 |               4.01 |                  47 |
|      1407 |          1 | 2020-04-23 00:00:00.000 |             1 |     190014 |               4.01 |                  68 |
|      1407 |          1 | 2020-02-15 00:00:00.000 |             1 |     171881 |               4.01 |                   6 |
|      1407 |          1 | 2020-01-07 00:00:00.000 |             1 |     162212 |               4.01 |                  99 |
|      1407 |          1 | 2020-03-04 00:00:00.000 |             1 |     176367 |               4.01 |                  94 |
|      1407 |          1 | 2020-04-15 00:00:00.000 |             1 |     187388 |               4.01 |                  86 |
|      1407 |          1 | 2020-04-05 00:00:00.000 |             1 |     184717 |               4.01 |                  38 |
|      1407 |          1 | 2020-06-11 00:00:00.000 |             1 |     206667 |               4.01 |                  64 |
|      1407 |          1 | 2020-06-05 00:00:00.000 |             1 |     204461 |               4.01 |                   5 |
|      1407 |          1 | 2020-12-20 00:00:00.000 |             1 |     269548 |               4.01 |                  27 |


Table: ordertype
| Order type   |   ID |
|:-------------|-----:|
| Order        |    1 |
| Returns      |    3 |


Table: Product
| Product Group   |   ItemID |
|:----------------|---------:|
| Group1-100140   |     1700 |
| Group1-100140   |     1695 |
| Group1-100140   |     1701 |
| Group1-100140   |     1702 |
| Group1-100140   |     1699 |
| Group1-100140   |     1694 |
| Group1-100140   |     1697 |
| Group1-100140   |     2471 |
| Group1-100140   |     1698 |
| Group1-100140   |     2014 |


Table: Saleschannel
|     ID | Sales Channel   |
|-------:|:----------------|
|   4.01 | Channel 1       |
|  12    | Channel 2       |
| 104.01 | Channel 3       |

 


tables: name: Date
data: Date.csv
name: Orders
data: Orders.csv
name: ordertype
data: ordertype.csv
name: Product
data: Product.csv
name: Saleschannel
data: Saleschannel.csv
label: Orders
Orderdate
Date
Date
Orders
Sales channel ID
Saleschannel
ID
Orders
Order Types
ordertype
ID
Orders
Item ID
Product
ItemID
output: {
    "joins": [
        {
            "from_table": "Orders",
            "from_column": "Orderdate",
            "to_table": "Date",
            "to_column": "Date"
        },
        {
            "from_table": "Orders",
            "from_column": "Sales channel ID",
            "to_table": "Saleschannel",
            "to_column": "ID"
        },
        {
            "from_table": "Orders",
            "from_column": "Order Types",
            "to_table": "ordertype",
            "to_column": "ID"
        },
        {
            "from_table": "Orders",
            "from_column": "Item ID",
            "to_table": "Product",
            "to_column": "ItemID"
        }
    ]
}