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: CALENDAR
| Date                    |   Year |   QuarterOfYear |   MonthOfYear |   DayOfMonth |   DateInt | MonthName   | MonthInCalendar   | QuarterInCalendar   |   DayInWeek | DayOfWeekName   | WeekEnding              |   Week Number |   MonthnYear |   QuarternYear |   ShortYear | FY   |
|:------------------------|-------:|----------------:|--------------:|-------------:|----------:|:------------|:------------------|:--------------------|------------:|:----------------|:------------------------|--------------:|-------------:|---------------:|------------:|:-----|
| 2020-07-19 00:00:00.000 |   2020 |               3 |             7 |           19 |  20200719 | juli        | jul 2020          | Q3 2020             |           6 | zondag          | 2020-07-19 00:00:00.000 |            29 |     20200700 |       20200300 |          20 | FY21 |
| 2020-07-20 00:00:00.000 |   2020 |               3 |             7 |           20 |  20200720 | juli        | jul 2020          | Q3 2020             |           0 | maandag         | 2020-07-26 00:00:00.000 |            30 |     20200700 |       20200300 |          20 | FY21 |
| 2020-07-21 00:00:00.000 |   2020 |               3 |             7 |           21 |  20200721 | juli        | jul 2020          | Q3 2020             |           1 | dinsdag         | 2020-07-26 00:00:00.000 |            30 |     20200700 |       20200300 |          20 | FY21 |
| 2020-07-31 00:00:00.000 |   2020 |               3 |             7 |           31 |  20200731 | juli        | jul 2020          | Q3 2020             |           4 | vrijdag         | 2020-08-02 00:00:00.000 |            31 |     20200700 |       20200300 |          20 | FY21 |
| 2020-07-28 00:00:00.000 |   2020 |               3 |             7 |           28 |  20200728 | juli        | jul 2020          | Q3 2020             |           1 | dinsdag         | 2020-08-02 00:00:00.000 |            31 |     20200700 |       20200300 |          20 | FY21 |
| 2020-07-29 00:00:00.000 |   2020 |               3 |             7 |           29 |  20200729 | juli        | jul 2020          | Q3 2020             |           2 | woensdag        | 2020-08-02 00:00:00.000 |            31 |     20200700 |       20200300 |          20 | FY21 |
| 2020-07-18 00:00:00.000 |   2020 |               3 |             7 |           18 |  20200718 | juli        | jul 2020          | Q3 2020             |           5 | zaterdag        | 2020-07-19 00:00:00.000 |            29 |     20200700 |       20200300 |          20 | FY21 |
| 2020-07-27 00:00:00.000 |   2020 |               3 |             7 |           27 |  20200727 | juli        | jul 2020          | Q3 2020             |           0 | maandag         | 2020-08-02 00:00:00.000 |            31 |     20200700 |       20200300 |          20 | FY21 |
| 2020-07-26 00:00:00.000 |   2020 |               3 |             7 |           26 |  20200726 | juli        | jul 2020          | Q3 2020             |           6 | zondag          | 2020-07-26 00:00:00.000 |            30 |     20200700 |       20200300 |          20 | FY21 |
| 2020-07-25 00:00:00.000 |   2020 |               3 |             7 |           25 |  20200725 | juli        | jul 2020          | Q3 2020             |           5 | zaterdag        | 2020-07-26 00:00:00.000 |            30 |     20200700 |       20200300 |          20 | FY21 |


Table: CUSTOMERS
|   CUSTOMER-id | CUSTOMER-NAME   |
|--------------:|:----------------|
|             1 | CUSTOMER A      |
|             2 | CUSTOMER B      |
|             3 | CUSTOMER C      |
|             4 | CUSTOMER D      |
|             5 | CUSTOMER E      |
|             6 | CUSTOMER F      |
|             7 | CUSTOMER G      |
|             8 | CUSTOMER H      |
|             9 | CUSTOMER I      |


Table: PRODUCTS
|   PRODUCT-id | PRODUCT-NAME   |
|-------------:|:---------------|
|            1 | PRODUCT A      |
|            2 | PRODUCT B      |
|            3 | PRODUCT C      |
|            4 | PRODUCT D      |
|            5 | PRODUCT E      |
|            6 | PRODUCT F      |
|            7 | PRODUCT G      |
|            8 | PRODUCT H      |
|            9 | PRODUCT I      |


Table: sales customer 1
| Date                    |   product |   customer |   sales |
|:------------------------|----------:|-----------:|--------:|
| 2020-01-01 00:00:00.000 |         5 |          1 |    3799 |
| 2020-01-01 00:00:00.000 |         5 |          1 |    3316 |
| 2020-01-01 00:00:00.000 |         5 |          1 |    4911 |
| 2020-01-01 00:00:00.000 |         5 |          1 |    3604 |
| 2020-01-01 00:00:00.000 |         5 |          1 |    4392 |
| 2020-01-01 00:00:00.000 |         5 |          1 |    2918 |
| 2020-01-01 00:00:00.000 |         5 |          1 |    4432 |
| 2020-01-01 00:00:00.000 |         5 |          1 |    4318 |
| 2020-01-01 00:00:00.000 |         5 |          1 |    2903 |
| 2020-01-01 00:00:00.000 |         5 |          1 |    4543 |


Table: Sales measures
| Column   |
|----------|


Table: SALESDATA
| Date                    |   product |   customer |   sales |
|:------------------------|----------:|-----------:|--------:|
| 2020-01-01 00:00:00.000 |         3 |          6 |     146 |
| 2020-01-01 00:00:00.000 |         3 |          6 |     318 |
| 2020-01-01 00:00:00.000 |         3 |          6 |     186 |
| 2020-01-01 00:00:00.000 |         3 |          6 |     136 |
| 2020-01-01 00:00:00.000 |         3 |          6 |     549 |
| 2020-01-01 00:00:00.000 |         3 |          6 |     238 |
| 2020-01-01 00:00:00.000 |         3 |          6 |     331 |
| 2020-01-01 00:00:00.000 |         3 |          6 |     798 |
| 2020-01-01 00:00:00.000 |         3 |          6 |     791 |
| 2020-01-01 00:00:00.000 |         3 |          6 |     605 |

 


tables: name: CALENDAR
data: CALENDAR.csv
name: CUSTOMERS
data: CUSTOMERS.csv
name: PRODUCTS
data: PRODUCTS.csv
name: sales customer 1
data: sales customer 1.csv
name: Sales measures
data: Sales measures.csv
name: SALESDATA
data: SALESDATA.csv
label: SALESDATA
customer
CUSTOMERS
CUSTOMER-id
SALESDATA
product
PRODUCTS
PRODUCT-id
SALESDATA
Date
CALENDAR
Date
output: {
    "joins": [
        {
            "from_table": "SALESDATA",
            "from_column": "customer",
            "to_table": "CUSTOMERS",
            "to_column": "CUSTOMER-id"
        },
        {
            "from_table": "SALESDATA",
            "from_column": "product",
            "to_table": "PRODUCTS",
            "to_column": "PRODUCT-id"
        },
        {
            "from_table": "SALESDATA",
            "from_column": "Date",
            "to_table": "CALENDAR",
            "to_column": "Date"
        }
    ]
}