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: Billionaires
|   No. | Name            |   Net worth (USD) |   Age | Nationality   | Source(s) of wealth        |
|------:|:----------------|------------------:|------:|:--------------|:---------------------------|
|     1 | Jeff Bezos      |               112 |    54 | United States | Amazon                     |
|     2 | Bill Gates      |                90 |    62 | United States | Microsoft                  |
|     3 | Warren Buffett  |                84 |    87 | United States | Berkshire Hathaway         |
|     4 | Bernard Arnault |                72 |    69 | France        | LVMH                       |
|     5 | Mark Zuckerberg |                71 |    33 | United States | Facebook                   |
|     6 | Amancio Ortega  |                70 |    81 | Spain         | Inditex, Zara              |
|     7 | Carlos Slim     |                67 |    78 | Mexico        | América Móvil, Grupo Carso |
|     8 | Charles Koch    |                60 |    82 | United States | Koch Industries            |
|     8 | David Koch      |                60 |    77 | United States | Koch Industries            |
|    10 | Larry Ellison   |                58 |    73 | United States | Oracle Corporation         |


Table: Customer Details
|   Customer Index | Customer Names     |
|-----------------:|:-------------------|
|                1 | Christy  Olson     |
|                2 | Dan  Peterson      |
|                3 | Mable  Lindsey     |
|                4 | Kyle  Carr         |
|                5 | Rachel  Gomez      |
|                6 | Isabel  Cross      |
|                7 | Billie  Chandler   |
|                8 | Sylvester  Morales |
|                9 | Rachel  Gomez      |
|               10 | Beth  Tucker       |


Table: Date
| Date                    |   Month num | Month name   |
|:------------------------|------------:|:-------------|
| 2019-01-01 00:00:00.000 |           1 | Jan          |
| 2019-01-02 00:00:00.000 |           1 | Jan          |
| 2019-01-03 00:00:00.000 |           1 | Jan          |
| 2019-01-04 00:00:00.000 |           1 | Jan          |
| 2019-01-05 00:00:00.000 |           1 | Jan          |
| 2019-01-06 00:00:00.000 |           1 | Jan          |
| 2019-01-07 00:00:00.000 |           1 | Jan          |
| 2019-01-08 00:00:00.000 |           1 | Jan          |
| 2019-01-09 00:00:00.000 |           1 | Jan          |
| 2019-01-10 00:00:00.000 |           1 | Jan          |


Table: Invoked Function
| Date                    |   Year |   QuarterOfYear |   MonthOfYear |   DayOfMonth |   DateInt | MonthName   | MonthInCalendar   | QuarterInCalendar   |   DayInWeek | DayOfWeekName   | WeekEnding              |   Week Number |   MonthnYear |   QuarternYear |   ShortYear | FY   |
|:------------------------|-------:|----------------:|--------------:|-------------:|----------:|:------------|:------------------|:--------------------|------------:|:----------------|:------------------------|--------------:|-------------:|---------------:|------------:|:-----|
| 2021-05-20 00:00:00.000 |   2021 |               2 |             5 |           20 |  20210520 | May         | May 2021          | Q2 2021             |           3 | Thursday        | 2021-05-23 00:00:00.000 |            21 |     20210500 |       20210200 |          21 | FY22 |
| 2021-05-21 00:00:00.000 |   2021 |               2 |             5 |           21 |  20210521 | May         | May 2021          | Q2 2021             |           4 | Friday          | 2021-05-23 00:00:00.000 |            21 |     20210500 |       20210200 |          21 | FY22 |
| 2021-05-22 00:00:00.000 |   2021 |               2 |             5 |           22 |  20210522 | May         | May 2021          | Q2 2021             |           5 | Saturday        | 2021-05-23 00:00:00.000 |            21 |     20210500 |       20210200 |          21 | FY22 |
| 2021-05-23 00:00:00.000 |   2021 |               2 |             5 |           23 |  20210523 | May         | May 2021          | Q2 2021             |           6 | Sunday          | 2021-05-23 00:00:00.000 |            21 |     20210500 |       20210200 |          21 | FY22 |
| 2021-05-24 00:00:00.000 |   2021 |               2 |             5 |           24 |  20210524 | May         | May 2021          | Q2 2021             |           0 | Monday          | 2021-05-30 00:00:00.000 |            22 |     20210500 |       20210200 |          21 | FY22 |
| 2021-05-25 00:00:00.000 |   2021 |               2 |             5 |           25 |  20210525 | May         | May 2021          | Q2 2021             |           1 | Tuesday         | 2021-05-30 00:00:00.000 |            22 |     20210500 |       20210200 |          21 | FY22 |
| 2021-05-26 00:00:00.000 |   2021 |               2 |             5 |           26 |  20210526 | May         | May 2021          | Q2 2021             |           2 | Wednesday       | 2021-05-30 00:00:00.000 |            22 |     20210500 |       20210200 |          21 | FY22 |
| 2021-05-27 00:00:00.000 |   2021 |               2 |             5 |           27 |  20210527 | May         | May 2021          | Q2 2021             |           3 | Thursday        | 2021-05-30 00:00:00.000 |            22 |     20210500 |       20210200 |          21 | FY22 |
| 2021-05-28 00:00:00.000 |   2021 |               2 |             5 |           28 |  20210528 | May         | May 2021          | Q2 2021             |           4 | Friday          | 2021-05-30 00:00:00.000 |            22 |     20210500 |       20210200 |          21 | FY22 |
| 2021-05-29 00:00:00.000 |   2021 |               2 |             5 |           29 |  20210529 | May         | May 2021          | Q2 2021             |           5 | Saturday        | 2021-05-30 00:00:00.000 |            22 |     20210500 |       20210200 |          21 | FY22 |


Table: Product Details
|   Product ID | Product Name   |
|-------------:|:---------------|
|            1 | Colde roller   |
|            2 | C Can          |
|            3 | Amlodipine     |
|            4 | Brilinta       |
|            5 | Humira         |
|            6 | Lyrica         |
|            7 | Xanax          |
|            8 | Imbruvica      |
|            9 | Prednisone     |
|           10 | Onpattro       |


Table: Region
|   Index | State      | City                  | Country   |
|--------:|:-----------|:----------------------|:----------|
|       1 | Oregon     | LONDON                | UK        |
|       2 | California | BERLIN                | Germany   |
|       3 | Wyoming    | MADRID                | Spain     |
|       4 | California | ROMA                  | Italy     |
|       5 | Wyoming    | KIEV                  | Ukraine   |
|       6 | California | PARIS                 | France    |
|       7 | Nevada     | BUCURESTI (Bucharest) | Romania   |
|       8 | Wyoming    | BUDAPEST              | Hungary   |
|       9 | California | Hamburg               | Germany   |
|      10 | California | MINSK                 | Belarus   |


Table: Sales Details
|   Order ID | OrderDate               |   Customer Name Index | Channel    | Currency Code   | Code     |   Region ID |   Product ID |   Quantity |   Unit Price |    Unit Cost |
|-----------:|:------------------------|----------------------:|:-----------|:----------------|:---------|------------:|-------------:|-----------:|-------------:|-------------:|
|      11004 | 2019-01-01 00:00:00.000 |                     8 | Industries | Euro            | INX005RT |          49 |           26 |          6 |        978.2 |      684.74  |
|      11011 | 2019-01-02 00:00:00.000 |                   111 | Industries | Euro            | INX005RT |          33 |           26 |         12 |       3872.6 |     2517.19  |
|      11088 | 2019-01-08 00:00:00.000 |                    93 | Industries | Euro            | INX005RT |          48 |           26 |          6 |       1105.5 |      851.235 |
|      11102 | 2019-01-09 00:00:00.000 |                    15 | Industries | Euro            | INX005RT |          39 |           26 |          9 |       1072   |      600.32  |
|      11117 | 2019-01-11 00:00:00.000 |                   100 | Industries | Euro            | INX005RT |          45 |           26 |          7 |       2345   |     1219.4   |
|      11126 | 2019-01-12 00:00:00.000 |                    88 | Industries | Euro            | INX005RT |          43 |           26 |         10 |        201   |      160.8   |
|      11192 | 2019-01-16 00:00:00.000 |                    13 | Industries | Euro            | INX005RT |          51 |           26 |          8 |       1862.6 |      949.926 |
|      11206 | 2019-01-18 00:00:00.000 |                    91 | Industries | Euro            | INX005RT |          46 |           26 |          7 |        737   |      626.45  |
|      11209 | 2019-01-18 00:00:00.000 |                    59 | Industries | Euro            | INX005RT |           2 |           26 |          8 |       2512.5 |     1331.62  |
|      11241 | 2019-01-21 00:00:00.000 |                     4 | Industries | Euro            | INX005RT |          60 |           26 |         10 |        857.6 |      497.408 |

 


tables: name: Billionaires
data: Billionaires.csv
name: Customer Details
data: Customer Details.csv
name: Date
data: Date.csv
name: Invoked Function
data: Invoked Function.csv
name: Product Details
data: Product Details.csv
name: Region
data: Region.csv
name: Sales Details
data: Sales Details.csv
label: Sales Details
Product ID
Product Details
Product ID
Sales Details
Region ID
Region
Index
output: {
    "joins": [
        {
            "from_table": "Sales Details",
            "from_column": "Product ID",
            "to_table": "Product Details",
            "to_column": "Product ID"
        },
        {
            "from_table": "Sales Details",
            "from_column": "Region ID",
            "to_table": "Region",
            "to_column": "Index"
        }
    ]
}