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: Customers
| Customer ID   | Customer           | Segment     |
|:--------------|:-------------------|:------------|
| BP-11035      | Birgit Pfeffer     | Verbraucher |
| SP-19450      | Sara Probst        | Verbraucher |
| DS-11635      | Daniel Schiffer    | Verbraucher |
| MF-16510      | Maik Fuchs         | Verbraucher |
| LK-15970      | Leon Krüger        | Verbraucher |
| MR-18085      | Michelle Rothstein | Verbraucher |
| FB-12775      | Florian Braun      | Verbraucher |
| SG-19840      | Stefan Gloeckner   | Verbraucher |
| CN-11440      | Christine Neudorf  | Verbraucher |
| LF-16315      | Lukas Frei         | Verbraucher |


Table: Date
| Date                    |   Year | Start of Year           | End of Year             |   Month | Start of Month          | End of Month            |   Days in Month |   Day | Day Name   |   Day of Week |   Day of Year | Month Name   |   Quarter | Start of Quarter        | End of Quarter          |   Week of Year |   Week of Month | Start of Week           | End of Week             |   Fiscal Year |   Fiscal Quarter |   Fiscal Month |   Day Offset |   Month Offset |   Year Offset |   Quarter Offset |
|:------------------------|-------:|:------------------------|:------------------------|--------:|:------------------------|:------------------------|----------------:|------:|:-----------|--------------:|--------------:|:-------------|----------:|:------------------------|:------------------------|---------------:|----------------:|:------------------------|:------------------------|--------------:|-----------------:|---------------:|-------------:|---------------:|--------------:|-----------------:|
| 2015-01-05 00:00:00.000 |   2015 | 2015-01-01 00:00:00.000 | 2015-12-31 00:00:00.000 |       1 | 2015-01-01 00:00:00.000 | 2015-01-31 00:00:00.000 |              31 |     5 | Montag     |             0 |             5 | Januar       |         1 | 2015-01-01 00:00:00.000 | 2015-03-31 00:00:00.000 |              2 |               2 | 2015-01-05 00:00:00.000 | 2015-01-11 00:00:00.000 |          2015 |                3 |              7 |        -2338 |            -76 |            -6 |              -25 |
| 2015-01-06 00:00:00.000 |   2015 | 2015-01-01 00:00:00.000 | 2015-12-31 00:00:00.000 |       1 | 2015-01-01 00:00:00.000 | 2015-01-31 00:00:00.000 |              31 |     6 | Dienstag   |             1 |             6 | Januar       |         1 | 2015-01-01 00:00:00.000 | 2015-03-31 00:00:00.000 |              2 |               2 | 2015-01-05 00:00:00.000 | 2015-01-11 00:00:00.000 |          2015 |                3 |              7 |        -2337 |            -76 |            -6 |              -25 |
| 2015-01-07 00:00:00.000 |   2015 | 2015-01-01 00:00:00.000 | 2015-12-31 00:00:00.000 |       1 | 2015-01-01 00:00:00.000 | 2015-01-31 00:00:00.000 |              31 |     7 | Mittwoch   |             2 |             7 | Januar       |         1 | 2015-01-01 00:00:00.000 | 2015-03-31 00:00:00.000 |              2 |               2 | 2015-01-05 00:00:00.000 | 2015-01-11 00:00:00.000 |          2015 |                3 |              7 |        -2336 |            -76 |            -6 |              -25 |
| 2015-01-08 00:00:00.000 |   2015 | 2015-01-01 00:00:00.000 | 2015-12-31 00:00:00.000 |       1 | 2015-01-01 00:00:00.000 | 2015-01-31 00:00:00.000 |              31 |     8 | Donnerstag |             3 |             8 | Januar       |         1 | 2015-01-01 00:00:00.000 | 2015-03-31 00:00:00.000 |              2 |               2 | 2015-01-05 00:00:00.000 | 2015-01-11 00:00:00.000 |          2015 |                3 |              7 |        -2335 |            -76 |            -6 |              -25 |
| 2015-01-09 00:00:00.000 |   2015 | 2015-01-01 00:00:00.000 | 2015-12-31 00:00:00.000 |       1 | 2015-01-01 00:00:00.000 | 2015-01-31 00:00:00.000 |              31 |     9 | Freitag    |             4 |             9 | Januar       |         1 | 2015-01-01 00:00:00.000 | 2015-03-31 00:00:00.000 |              2 |               2 | 2015-01-05 00:00:00.000 | 2015-01-11 00:00:00.000 |          2015 |                3 |              7 |        -2334 |            -76 |            -6 |              -25 |
| 2015-01-10 00:00:00.000 |   2015 | 2015-01-01 00:00:00.000 | 2015-12-31 00:00:00.000 |       1 | 2015-01-01 00:00:00.000 | 2015-01-31 00:00:00.000 |              31 |    10 | Samstag    |             5 |            10 | Januar       |         1 | 2015-01-01 00:00:00.000 | 2015-03-31 00:00:00.000 |              2 |               2 | 2015-01-05 00:00:00.000 | 2015-01-11 00:00:00.000 |          2015 |                3 |              7 |        -2333 |            -76 |            -6 |              -25 |
| 2015-01-11 00:00:00.000 |   2015 | 2015-01-01 00:00:00.000 | 2015-12-31 00:00:00.000 |       1 | 2015-01-01 00:00:00.000 | 2015-01-31 00:00:00.000 |              31 |    11 | Sonntag    |             6 |            11 | Januar       |         1 | 2015-01-01 00:00:00.000 | 2015-03-31 00:00:00.000 |              2 |               2 | 2015-01-05 00:00:00.000 | 2015-01-11 00:00:00.000 |          2015 |                3 |              7 |        -2332 |            -76 |            -6 |              -25 |
| 2015-03-02 00:00:00.000 |   2015 | 2015-01-01 00:00:00.000 | 2015-12-31 00:00:00.000 |       3 | 2015-03-01 00:00:00.000 | 2015-03-31 00:00:00.000 |              31 |     2 | Montag     |             0 |            61 | März         |         1 | 2015-01-01 00:00:00.000 | 2015-03-31 00:00:00.000 |             10 |               2 | 2015-03-02 00:00:00.000 | 2015-03-08 00:00:00.000 |          2015 |                3 |              9 |        -2282 |            -74 |            -6 |              -25 |
| 2015-03-03 00:00:00.000 |   2015 | 2015-01-01 00:00:00.000 | 2015-12-31 00:00:00.000 |       3 | 2015-03-01 00:00:00.000 | 2015-03-31 00:00:00.000 |              31 |     3 | Dienstag   |             1 |            62 | März         |         1 | 2015-01-01 00:00:00.000 | 2015-03-31 00:00:00.000 |             10 |               2 | 2015-03-02 00:00:00.000 | 2015-03-08 00:00:00.000 |          2015 |                3 |              9 |        -2281 |            -74 |            -6 |              -25 |
| 2015-03-04 00:00:00.000 |   2015 | 2015-01-01 00:00:00.000 | 2015-12-31 00:00:00.000 |       3 | 2015-03-01 00:00:00.000 | 2015-03-31 00:00:00.000 |              31 |     4 | Mittwoch   |             2 |            63 | März         |         1 | 2015-01-01 00:00:00.000 | 2015-03-31 00:00:00.000 |             10 |               2 | 2015-03-02 00:00:00.000 | 2015-03-08 00:00:00.000 |          2015 |                3 |              9 |        -2280 |            -74 |            -6 |              -25 |


Table: Geo
|   GEO Index | City              | State         | Country    | Region   |
|------------:|:------------------|:--------------|:-----------|:---------|
|         389 | Thiais            | Ile-de-France | Frankreich | Zentral  |
|         390 | Chaville          | Ile-de-France | Frankreich | Zentral  |
|         391 | Taverny           | Ile-de-France | Frankreich | Zentral  |
|         392 | Viroflay          | Ile-de-France | Frankreich | Zentral  |
|         393 | Paris             | Ile-de-France | Frankreich | Zentral  |
|         394 | Pantin            | Ile-de-France | Frankreich | Zentral  |
|         395 | Houilles          | Ile-de-France | Frankreich | Zentral  |
|         396 | Vitry-sur-Seine   | Ile-de-France | Frankreich | Zentral  |
|         397 | Villiers-le-Bel   | Ile-de-France | Frankreich | Zentral  |
|         398 | Pontault-Combault | Ile-de-France | Frankreich | Zentral  |


Table: Orders
| Order ID        | Order Date              | Semd Date               | Send Mode      | Customer ID   |   GEO Index | Product ID      |   Revenue |   Quantity |   Rabatt |   Profit |
|:----------------|:------------------------|:------------------------|:---------------|:--------------|------------:|:----------------|----------:|-----------:|---------:|---------:|
| ES-2018-5755966 | 2018-01-12 00:00:00.000 | 2018-01-17 00:00:00.000 | Standardklasse | BN-11020      |           1 | BÜR-GE-10000995 |   1560.24 |          3 |        0 |   421.2  |
| ES-2020-3661350 | 2020-07-10 00:00:00.000 | 2020-07-15 00:00:00.000 | Standardklasse | JN-13765      |           1 | MÖB-BÜ-10004449 |    504.09 |          3 |        0 |   115.92 |
| ES-2020-1237764 | 2020-12-01 00:00:00.000 | 2020-12-07 00:00:00.000 | Standardklasse | KH-15130      |           6 | MÖB-BÜ-10001970 |    330.12 |          3 |        0 |    26.37 |
| ES-2017-3104322 | 2017-10-18 00:00:00.000 | 2017-10-22 00:00:00.000 | Standardklasse | FB-12670      |           8 | BÜR-OR-10003109 |     25.11 |          3 |        0 |     9.27 |
| ES-2020-2873001 | 2020-04-16 00:00:00.000 | 2020-04-22 00:00:00.000 | Standardklasse | MN-18025      |          11 | BÜR-ET-10002119 |     26.82 |          3 |        0 |     8.82 |
| ES-2020-1077620 | 2020-10-01 00:00:00.000 | 2020-10-05 00:00:00.000 | Standardklasse | CF-11335      |          11 | BÜR-KU-10004464 |     83.79 |          3 |        0 |     9.18 |
| IT-2019-3453314 | 2019-11-13 00:00:00.000 | 2019-11-18 00:00:00.000 | Standardklasse | TH-20860      |          13 | BÜR-ZU-10000134 |     66.42 |          3 |        0 |     3.96 |
| ES-2020-2282871 | 2020-01-17 00:00:00.000 | 2020-01-23 00:00:00.000 | Standardklasse | LR-15805      |          14 | BÜR-OR-10002505 |     24.48 |          3 |        0 |    11.43 |
| ES-2018-5512464 | 2018-06-05 00:00:00.000 | 2018-06-11 00:00:00.000 | Standardklasse | MF-17380      |          15 | BÜR-UM-10000655 |     35.73 |          3 |        0 |     8.55 |
| ES-2019-3093926 | 2019-06-18 00:00:00.000 | 2019-06-23 00:00:00.000 | Standardklasse | NH-18325      |          17 | BÜR-ZU-10002257 |     42.84 |          3 |        0 |    21.42 |


Table: Products
| Product ID      | Categorie   | Sub Categorie   | Product Name                     |
|:----------------|:------------|:----------------|:---------------------------------|
| BÜR-OR-10002067 | Bürobedarf  | Ordner          | Ibico Trennblätter, Recycelt     |
| BÜR-OR-10002118 | Bürobedarf  | Ordner          | Wilson Jones Ordner, Haltbar     |
| BÜR-OR-10004307 | Bürobedarf  | Ordner          | Avery Ordner, Durchsichtig       |
| BÜR-OR-10004670 | Bürobedarf  | Ordner          | Avery Ordnereinbände, Haltbar    |
| BÜR-OR-10003664 | Bürobedarf  | Ordner          | Cardinal Ordner, Durchsichtig    |
| BÜR-OR-10000488 | Bürobedarf  | Ordner          | Ibico Locher, Durchsichtig       |
| BÜR-OR-10001943 | Bürobedarf  | Ordner          | Cardinal Trennblätter, Haltbar   |
| BÜR-OR-10003109 | Bürobedarf  | Ordner          | Ibico Trennblätter, Durchsichtig |
| BÜR-OR-10002097 | Bürobedarf  | Ordner          | Cardinal Trennblätter, Recycelt  |
| BÜR-OR-10002505 | Bürobedarf  | Ordner          | Acco Lochverstärkungen, Haltbar  |


Table: Send Mode
| Send Mode       |
|:----------------|
| Standardklasse  |
| Am gleichen Tag |
| Zweite Klasse   |
| Erste Klasse    |


Table: Time Intellegence
| Name        |   Ordinal |
|:------------|----------:|
| % YTDoPYYTD |        -1 |
| AC          |        -1 |
| PY YTD      |        -1 |
| YTD         |        -1 |


Table: View Duplicates
| City       | State         | Country   | Region   |   Index |
|:-----------|:--------------|:----------|:---------|--------:|
| Ronanstown | South Dublin  | Irland    | Nord     |     224 |
| Ronanstown | South 'Dublin | Irland    | Nord     |     225 |

 


tables: name: Customers
data: Customers.csv
name: Date
data: Date.csv
name: Geo
data: Geo.csv
name: Orders
data: Orders.csv
name: Products
data: Products.csv
name: Send Mode
data: Send Mode.csv
name: Time Intellegence
data: Time Intellegence.csv
name: View Duplicates
data: View Duplicates.csv
label: Orders
Customer ID
Customers
Customer ID
Orders
GEO Index
Geo
GEO Index
Orders
Order Date
Date
Date
Orders
Send Mode
Send Mode
Send Mode
Orders
Product ID
Products
Product ID
output: {
    "joins": [
        {
            "from_table": "Orders",
            "from_column": "Customer ID",
            "to_table": "Customers",
            "to_column": "Customer ID"
        },
        {
            "from_table": "Orders",
            "from_column": "GEO Index",
            "to_table": "Geo",
            "to_column": "GEO Index"
        },
        {
            "from_table": "Orders",
            "from_column": "Order Date",
            "to_table": "Date",
            "to_column": "Date"
        },
        {
            "from_table": "Orders",
            "from_column": "Send Mode",
            "to_table": "Send Mode",
            "to_column": "Send Mode"
        },
        {
            "from_table": "Orders",
            "from_column": "Product ID",
            "to_table": "Products",
            "to_column": "Product ID"
        }
    ]
}