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
| Ops Date                |   Year |   MonthNum |   WeekSort | MonthName   |   MonthSort | Week Start Date         | WeekNum   | WeekName    | LY WeekName   | LY Week   | LY WeekNum   |
|:------------------------|-------:|-----------:|-----------:|:------------|------------:|:------------------------|:----------|:------------|:--------------|:----------|:-------------|
| 2017-01-01 00:00:00.000 |   2017 |          1 |    2017    | 2017:Jan    |     2017.01 |                         |           | WS-         | WS-           |           |              |
| 2017-01-02 00:00:00.000 |   2017 |          1 |    2037.17 | 2017:Jan    |     2017.01 | 2017-01-02 00:00:00.000 | 2017.01   | WS-1/2/2017 | WS-           |           |              |
| 2017-01-03 00:00:00.000 |   2017 |          1 |    2037.17 | 2017:Jan    |     2017.01 | 2017-01-02 00:00:00.000 | 2017.01   | WS-1/2/2017 | WS-           |           |              |
| 2017-01-04 00:00:00.000 |   2017 |          1 |    2037.17 | 2017:Jan    |     2017.01 | 2017-01-02 00:00:00.000 | 2017.01   | WS-1/2/2017 | WS-           |           |              |
| 2017-01-05 00:00:00.000 |   2017 |          1 |    2037.17 | 2017:Jan    |     2017.01 | 2017-01-02 00:00:00.000 | 2017.01   | WS-1/2/2017 | WS-           |           |              |
| 2017-01-06 00:00:00.000 |   2017 |          1 |    2037.17 | 2017:Jan    |     2017.01 | 2017-01-02 00:00:00.000 | 2017.01   | WS-1/2/2017 | WS-           |           |              |
| 2017-01-07 00:00:00.000 |   2017 |          1 |    2037.17 | 2017:Jan    |     2017.01 | 2017-01-02 00:00:00.000 | 2017.01   | WS-1/2/2017 | WS-           |           |              |
| 2017-01-08 00:00:00.000 |   2017 |          1 |    2037.17 | 2017:Jan    |     2017.01 | 2017-01-02 00:00:00.000 | 2017.01   | WS-1/2/2017 | WS-           |           |              |
| 2017-01-09 00:00:00.000 |   2017 |          1 |    2037.17 | 2017:Jan    |     2017.01 | 2017-01-09 00:00:00.000 | 2017.02   | WS-1/9/2017 | WS-           |           |              |
| 2017-01-10 00:00:00.000 |   2017 |          1 |    2037.17 | 2017:Jan    |     2017.01 | 2017-01-09 00:00:00.000 | 2017.02   | WS-1/9/2017 | WS-           |           |              |


Table: deptLink
| Ops Date                | deptLink        |   Department ID | LY deptLink   |
|:------------------------|:----------------|----------------:|:--------------|
| 2018-06-12 00:00:00.000 | 6/12/2018000530 |             530 |               |
| 2018-06-13 00:00:00.000 | 6/13/2018000530 |             530 |               |
| 2018-06-15 00:00:00.000 | 6/15/2018000530 |             530 |               |
| 2018-06-11 00:00:00.000 | 6/11/2018000530 |             530 |               |
| 2018-06-14 00:00:00.000 | 6/14/2018000530 |             530 |               |
| 2018-08-02 00:00:00.000 | 8/2/2018000530  |             530 |               |
| 2018-07-31 00:00:00.000 | 7/31/2018000530 |             530 |               |
| 2018-08-03 00:00:00.000 | 8/3/2018000530  |             530 |               |
| 2018-08-01 00:00:00.000 | 8/1/2018000530  |             530 |               |
| 2018-08-04 00:00:00.000 | 8/4/2018000530  |             530 |               |


Table: Earned Hours & Headcount
| Ops Date                |   DepartmentID |   Head Count |   Paid Hours | deptLink        |
|:------------------------|---------------:|-------------:|-------------:|:----------------|
| 2017-01-09 00:00:00.000 |           6715 |            2 |            8 | 1/9/2017006715  |
| 2017-01-10 00:00:00.000 |           6715 |            2 |            8 | 1/10/2017006715 |
| 2017-01-11 00:00:00.000 |           6715 |            2 |            8 | 1/11/2017006715 |
| 2017-01-12 00:00:00.000 |           6715 |            2 |            8 | 1/12/2017006715 |
| 2017-01-13 00:00:00.000 |           6715 |            2 |            8 | 1/13/2017006715 |
| 2017-01-16 00:00:00.000 |           6715 |            2 |            8 | 1/16/2017006715 |
| 2017-01-17 00:00:00.000 |           6715 |            2 |            8 | 1/17/2017006715 |
| 2017-01-18 00:00:00.000 |           6715 |            2 |            8 | 1/18/2017006715 |
| 2017-01-19 00:00:00.000 |           6715 |            2 |            8 | 1/19/2017006715 |
| 2017-01-23 00:00:00.000 |           6715 |            2 |            8 | 1/23/2017006715 |


Table: LY Headcount
| deptLink        |   LY Head Count |   LY Paid Hours |
|:----------------|----------------:|----------------:|
| 1/9/2017006715  |               2 |               8 |
| 1/10/2017006715 |               2 |               8 |
| 1/11/2017006715 |               2 |               8 |
| 1/12/2017006715 |               2 |               8 |
| 1/13/2017006715 |               2 |               8 |
| 1/16/2017006715 |               2 |               8 |
| 1/17/2017006715 |               2 |               8 |
| 1/18/2017006715 |               2 |               8 |
| 1/19/2017006715 |               2 |               8 |
| 1/23/2017006715 |               2 |               8 |


Table: LY WO Hours
| Ops Date                | WorkCenterDesc   |   LY Actual Hours |   LY Planned Hours | WCLink                   |
|:------------------------|:-----------------|------------------:|-------------------:|:-------------------------|
| 2018-06-12 00:00:00.000 | Orbital Wrapper  |                 0 |               0.01 | 6/12/2018Orbital Wrapper |
| 2018-06-14 00:00:00.000 | Orbital Wrapper  |                 0 |               0.01 | 6/14/2018Orbital Wrapper |
| 2018-06-11 00:00:00.000 | Orbital Wrapper  |                 0 |               0.01 | 6/11/2018Orbital Wrapper |
| 2018-07-11 00:00:00.000 | Orbital Wrapper  |                 0 |               0.01 | 7/11/2018Orbital Wrapper |
| 2018-07-10 00:00:00.000 | Orbital Wrapper  |                 0 |               0.01 | 7/10/2018Orbital Wrapper |
| 2018-07-13 00:00:00.000 | Orbital Wrapper  |                 0 |               0.01 | 7/13/2018Orbital Wrapper |
| 2018-07-12 00:00:00.000 | Orbital Wrapper  |                 0 |               0.01 | 7/12/2018Orbital Wrapper |
| 2018-07-09 00:00:00.000 | Orbital Wrapper  |                 0 |               0.01 | 7/9/2018Orbital Wrapper  |
| 2018-06-13 00:00:00.000 | Orbital Wrapper  |                 0 |               0.01 | 6/13/2018Orbital Wrapper |
| 2018-06-15 00:00:00.000 | Orbital Wrapper  |                 0 |               0.01 | 6/15/2018Orbital Wrapper |


Table: vWO_Hours
|   ORDERNUMBER | SHORTITEM   | LONGITEM   |   MCU | OPSDATE                 |   ACTUALHOURS |   PLANNEDHOURS | SHIPQUANTITY   |   WorkCenterNum | WorkCenterDesc         |   Department ID | Department Name        | deptLink        | WCLink   |
|--------------:|:------------|:-----------|------:|:------------------------|--------------:|---------------:|:---------------|----------------:|:-----------------------|----------------:|:-----------------------|:----------------|:---------|
|       1030282 |             | DCB02      | 57006 | 2018-06-11 00:00:00.000 |             0 |           0.01 |                |           57006 | PULL FROM IMPORT RACKS |             571 | Coating Lines-Direct 1 | 6/11/2018000571 |          |
|       1030449 |             | B106-B     | 57006 | 2018-06-11 00:00:00.000 |             0 |           0.01 |                |           57006 | PULL FROM IMPORT RACKS |             571 | Coating Lines-Direct 1 | 6/11/2018000571 |          |
|       1030626 |             | UB25-G     | 57006 | 2018-06-11 00:00:00.000 |             0 |           0.01 |                |           57006 | PULL FROM IMPORT RACKS |             571 | Coating Lines-Direct 1 | 6/11/2018000571 |          |
|       1030627 |             | UP25-G     | 57006 | 2018-06-11 00:00:00.000 |             0 |           0.01 |                |           57006 | PULL FROM IMPORT RACKS |             571 | Coating Lines-Direct 1 | 6/11/2018000571 |          |
|       1030673 |             | A507-G     | 57006 | 2018-06-15 00:00:00.000 |             0 |           0.01 |                |           57006 | PULL FROM IMPORT RACKS |             571 | Coating Lines-Direct 1 | 6/15/2018000571 |          |
|       1031104 |             | MBR16      | 57006 | 2018-06-12 00:00:00.000 |             0 |           0.01 |                |           57006 | PULL FROM IMPORT RACKS |             571 | Coating Lines-Direct 1 | 6/12/2018000571 |          |
|       1031197 |             | B113-N     | 57006 | 2018-06-14 00:00:00.000 |             0 |           0.01 |                |           57006 | PULL FROM IMPORT RACKS |             571 | Coating Lines-Direct 1 | 6/14/2018000571 |          |
|       1031199 |             | B113D-N    | 57006 | 2018-06-14 00:00:00.000 |             0 |           0.01 |                |           57006 | PULL FROM IMPORT RACKS |             571 | Coating Lines-Direct 1 | 6/14/2018000571 |          |
|       1037841 |             | AB507      | 57006 | 2018-07-12 00:00:00.000 |             0 |           0.01 |                |           57006 | PULL FROM IMPORT RACKS |             571 | Coating Lines-Direct 1 | 7/12/2018000571 |          |
|       1037847 |             | AB301      | 57006 | 2018-07-11 00:00:00.000 |             0 |           0.01 |                |           57006 | PULL FROM IMPORT RACKS |             571 | Coating Lines-Direct 1 | 7/11/2018000571 |          |


Table: WCLink
| WCLink   |
|:---------|
|          |

 


tables: name: Calendar
data: Calendar.csv
name: deptLink
data: deptLink.csv
name: Earned Hours & Headcount
data: Earned Hours & Headcount.csv
name: LY Headcount
data: LY Headcount.csv
name: LY WO Hours
data: LY WO Hours.csv
name: vWO_Hours
data: vWO_Hours.csv
name: WCLink
data: WCLink.csv
label: vWO_Hours
OPSDATE
Calendar
Ops Date
vWO_Hours
deptLink
deptLink
deptLink
deptLink
deptLink
Earned Hours & Headcount
deptLink
output: {
    "joins": [
        {
            "from_table": "vWO_Hours",
            "from_column": "OPSDATE",
            "to_table": "Calendar",
            "to_column": "Ops Date"
        },
        {
            "from_table": "vWO_Hours",
            "from_column": "deptLink",
            "to_table": "deptLink",
            "to_column": "deptLink"
        },
        {
            "from_table": "deptLink",
            "from_column": "deptLink",
            "to_table": "Earned Hours & Headcount",
            "to_column": "deptLink"
        }
    ]
}