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: calender entry
| date                    |   workcenter |   capacity total |
|:------------------------|-------------:|-----------------:|
| 2021-09-10 00:00:00.000 |          200 |              480 |
| 2021-09-10 00:00:00.000 |          200 |              480 |
| 2021-09-10 00:00:00.000 |          200 |              480 |
| 2021-09-10 00:00:00.000 |          100 |              480 |
| 2021-09-11 00:00:00.000 |          100 |              480 |
| 2021-09-11 00:00:00.000 |          100 |              480 |
| 2021-09-11 00:00:00.000 |          200 |              480 |
| 2021-09-11 00:00:00.000 |          100 |             1440 |
| 2021-12-30 00:00:00.000 |          200 |              480 |
| 2021-12-30 00:00:00.000 |          200 |              480 |


Table: capacity ledgers entry
|   entry |   workcenter | posting date            |   run time |
|--------:|-------------:|:------------------------|-----------:|
|       1 |          100 | 2021-09-10 00:00:00.000 |        170 |
|       2 |          100 | 2021-09-10 00:00:00.000 |         90 |
|       3 |          100 | 2021-09-10 00:00:00.000 |        110 |
|       4 |          100 | 2021-09-10 00:00:00.000 |         50 |
|       5 |          100 | 2021-09-11 00:00:00.000 |        434 |
|       6 |          100 | 2021-09-11 00:00:00.000 |        420 |
|       7 |          100 | 2021-09-11 00:00:00.000 |        550 |
|       8 |          100 | 2021-09-11 00:00:00.000 |        226 |


Table: Date
| Date                    |   Month |
|:------------------------|--------:|
| 2021-01-01 00:00:00.000 |       1 |
| 2021-01-02 00:00:00.000 |       1 |
| 2021-01-03 00:00:00.000 |       1 |
| 2021-01-04 00:00:00.000 |       1 |
| 2021-01-05 00:00:00.000 |       1 |
| 2021-01-06 00:00:00.000 |       1 |
| 2021-01-07 00:00:00.000 |       1 |
| 2021-01-08 00:00:00.000 |       1 |
| 2021-01-09 00:00:00.000 |       1 |
| 2021-01-10 00:00:00.000 |       1 |


Table: workcenters
|   workcenter |
|-------------:|
|          100 |
|          200 |

 


tables: name: calender entry
data: calender entry.csv
name: capacity ledgers entry
data: capacity ledgers entry.csv
name: Date
data: Date.csv
name: workcenters
data: workcenters.csv
label: capacity ledgers entry
workcenter
workcenters
workcenter
calender entry
workcenter
workcenters
workcenter
output: {
    "joins": [
        {
            "from_table": "capacity ledgers entry",
            "from_column": "workcenter",
            "to_table": "workcenters",
            "to_column": "workcenter"
        },
        {
            "from_table": "calender entry",
            "from_column": "workcenter",
            "to_table": "workcenters",
            "to_column": "workcenter"
        }
    ]
}