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: Data Entry
| OpsDate                 |   Employee_ID |   Break |   ChangeOver |   CrewSize |   Changed Work Function |   Equipment Failure |   Forklift |   Material Unavailable |   Meeting |   Non-conforming material |   None |   Ordered Completed |   Other |   Shift Over |   NewReason | EmployeeName         | EmpType   | DepartmentID   |   Empty Comment |   Employee Total | DDLink    |
|:------------------------|--------------:|--------:|-------------:|-----------:|------------------------:|--------------------:|-----------:|-----------------------:|----------:|--------------------------:|-------:|--------------------:|--------:|-------------:|------------:|:---------------------|:----------|:---------------|----------------:|-----------------:|:----------|
| 2018-01-03 00:00:00.000 |          9646 |       1 |            0 |          0 |                       0 |                   0 |          0 |                      0 |         0 |                         0 |      0 |                   0 |       0 |            0 |           0 | **Emp ID Not Found** |           |                |               0 |                1 | 1/3/2018  |
| 2018-08-14 00:00:00.000 |          9646 |       1 |            0 |          0 |                       0 |                   0 |          0 |                      0 |         0 |                         0 |      0 |                   0 |       0 |            0 |           0 | **Emp ID Not Found** |           |                |               0 |                1 | 8/14/2018 |
| 2018-08-22 00:00:00.000 |          9646 |       1 |            0 |          0 |                       0 |                   0 |          0 |                      0 |         0 |                         0 |      0 |                   0 |       0 |            0 |           0 | **Emp ID Not Found** |           |                |               0 |                1 | 8/22/2018 |
| 2018-08-08 00:00:00.000 |          9646 |       1 |            0 |          0 |                       0 |                   0 |          0 |                      0 |         0 |                         0 |      0 |                   0 |       0 |            0 |           0 | **Emp ID Not Found** |           |                |               0 |                1 | 8/8/2018  |
| 2018-07-30 00:00:00.000 |          9646 |       1 |            0 |          0 |                       0 |                   0 |          0 |                      0 |         0 |                         0 |      0 |                   0 |       0 |            0 |           0 | **Emp ID Not Found** |           |                |               0 |                1 | 7/30/2018 |
| 2018-07-31 00:00:00.000 |          9646 |       1 |            0 |          0 |                       0 |                   0 |          0 |                      0 |         0 |                         0 |      0 |                   0 |       0 |            0 |           0 | **Emp ID Not Found** |           |                |               0 |                1 | 7/31/2018 |
| 2018-07-27 00:00:00.000 |          9646 |       1 |            0 |          0 |                       0 |                   0 |          0 |                      0 |         0 |                         0 |      0 |                   0 |       0 |            0 |           0 | **Emp ID Not Found** |           |                |               0 |                1 | 7/27/2018 |
| 2018-07-25 00:00:00.000 |          9646 |       1 |            0 |          0 |                       0 |                   0 |          0 |                      0 |         0 |                         0 |      0 |                   0 |       0 |            0 |           0 | **Emp ID Not Found** |           |                |               0 |                1 | 7/25/2018 |
| 2018-07-24 00:00:00.000 |          9646 |       1 |            0 |          0 |                       0 |                   0 |          0 |                      0 |         0 |                         0 |      0 |                   0 |       0 |            0 |           0 | **Emp ID Not Found** |           |                |               0 |                1 | 7/24/2018 |
| 2018-07-19 00:00:00.000 |          9646 |       1 |            0 |          0 |                       0 |                   0 |          0 |                      0 |         0 |                         0 |      0 |                   0 |       0 |            0 |           0 | **Emp ID Not Found** |           |                |               0 |                1 | 7/19/2018 |


Table: DDHLink
| DDH               |
|:------------------|
| 3/28/201800055017 |
| 5/17/201800055017 |
| 2/6/201800055017  |
| 5/16/201800055017 |
| 5/2/201800055017  |
| 2/22/201800055017 |
| 3/12/201800055017 |
| 4/2/201800055017  |
| 4/30/201800055017 |
| 7/20/201800055017 |


Table: DDLink
| DDLink          |
|:----------------|
| 3/28/2018000550 |
| 5/17/2018000550 |
| 2/6/2018000550  |
| 5/16/2018000550 |
| 5/2/2018000550  |
| 2/22/2018000550 |
| 3/12/2018000550 |
| 4/2/2018000550  |
| 4/30/2018000550 |
| 7/20/2018000550 |


Table: DeptWCLink
|   DeptWCLink |
|-------------:|
|  00067641077 |
|  00067642077 |
|  00067643077 |
|  00051151101 |
|  00052052006 |
|  00053053004 |
|  00054054013 |
|  00054054014 |
|  00054054018 |
|  00054054023 |


Table: dimLocation
|   WorkCenterNum | WorkCenterDesc         | Department       | WorkCenterType   |   DepartmentCode |   PlannedCrewSize |   DeptWCLink | Departments             | Workcenters                  | GroupDesc             |
|----------------:|:-----------------------|:-----------------|:-----------------|-----------------:|------------------:|-------------:|:------------------------|:-----------------------------|:----------------------|
|           41077 | Ech Res Assy Stockton  | US RDC Assembly  | Labor            |              676 |                 1 |  00067641077 | 000676-US RDC Assembly  | 41077-Ech Res Assy Stockton  | RDC                   |
|           42077 | Ech Res Assy Chicago   | US RDC Assembly  | Labor            |              676 |                 1 |  00067642077 | 000676-US RDC Assembly  | 42077-Ech Res Assy Chicago   | RDC                   |
|           43077 | Ech Res Assy NewCastle | US RDC Assembly  | Labor            |              676 |                 1 |  00067643077 | 000676-US RDC Assembly  | 43077-Ech Res Assy NewCastle | RDC                   |
|           51101 | Tool & Die Shop        | Tool & Die       | Machine          |              511 |                 1 |  00051151101 | 000511-Tool & Die       | 51101-Tool & Die Shop        | Press Shop/Tool & Die |
|           52006 | PULL FROM 541          | Roll Former      | Labor            |              520 |                 1 |  00052052006 | 000520-Roll Former      | 52006-PULL FROM 541          | Mills                 |
|           53004 | Mills LABOR            | Mills            | Labor            |              530 |                 1 |  00053053004 | 000530-Mills            | 53004-Mills LABOR            | Mills                 |
|           54013 | Sgl Hd Drill           | Metal Processing | Machine          |              540 |                 1 |  00054054013 | 000540-Metal Processing | 54013-Sgl Hd Drill           | Metal Processing      |
|           54014 | Gang Drill             | Metal Processing | Machine          |              540 |                 1 |  00054054014 | 000540-Metal Processing | 54014-Gang Drill             | Metal Processing      |
|           54018 | Pointer                | Metal Processing | Machine          |              540 |                 1 |  00054054018 | 000540-Metal Processing | 54018-Pointer                | Metal Processing      |
|           54023 | Metal Process Pull     | Metal Processing | Labor            |              540 |                 1 |  00054054023 | 000540-Metal Processing | 54023-Metal Process Pull     | Metal Processing      |


Table: Measures Table
|   OpsHour |
|----------:|
|        10 |
|         6 |
|         9 |
|        19 |
|        14 |
|        16 |
|        15 |
|        12 |
|        22 |
|         8 |


Table: OpsDates
| OpsDate                 |
|:------------------------|
| 2018-01-02 00:00:00.000 |
| 2018-01-03 00:00:00.000 |
| 2018-01-04 00:00:00.000 |
| 2018-01-05 00:00:00.000 |
| 2018-01-06 00:00:00.000 |
| 2018-01-07 00:00:00.000 |
| 2018-01-08 00:00:00.000 |
| 2018-01-09 00:00:00.000 |
| 2018-01-10 00:00:00.000 |
| 2018-01-11 00:00:00.000 |


Table: OpsHours
|   OpsHour | Operations Hour   |
|----------:|:------------------|
|         0 | Midnight          |
|         1 | 1 AM              |
|         2 | 2 AM              |
|         3 | 3 AM              |
|         4 | 4 AM              |
|         5 | 5 AM              |
|         6 | 6 AM              |
|         7 | 7 AM              |
|         8 | 8 AM              |
|         9 | 9 AM              |


Table: Production Hours
| OpsDate                 |   WorkCenter |   OpsHour |   ProdHours | DWH              | DDH               | Hour    | Date-Hour         |   DeptWCLink | DDLink          |   DepartmentCode | DepartmentDesc   |
|:------------------------|-------------:|----------:|------------:|:-----------------|:------------------|:--------|:------------------|-------------:|:----------------|-----------------:|:-----------------|
| 2018-03-28 00:00:00.000 |        55007 |        17 |           1 | 3/28/20185500717 | 3/28/201800055017 | Hour-17 | 3/28/2018 Hour-17 |  00055055007 | 3/28/2018000550 |              550 | Press Shop       |
| 2018-05-17 00:00:00.000 |        55007 |        17 |           1 | 5/17/20185500717 | 5/17/201800055017 | Hour-17 | 5/17/2018 Hour-17 |  00055055007 | 5/17/2018000550 |              550 | Press Shop       |
| 2018-02-06 00:00:00.000 |        55007 |        17 |           1 | 2/6/20185500717  | 2/6/201800055017  | Hour-17 | 2/6/2018 Hour-17  |  00055055007 | 2/6/2018000550  |              550 | Press Shop       |
| 2018-05-16 00:00:00.000 |        55007 |        17 |           1 | 5/16/20185500717 | 5/16/201800055017 | Hour-17 | 5/16/2018 Hour-17 |  00055055007 | 5/16/2018000550 |              550 | Press Shop       |
| 2018-05-02 00:00:00.000 |        55007 |        17 |           1 | 5/2/20185500717  | 5/2/201800055017  | Hour-17 | 5/2/2018 Hour-17  |  00055055007 | 5/2/2018000550  |              550 | Press Shop       |
| 2018-02-22 00:00:00.000 |        55007 |        17 |           1 | 2/22/20185500717 | 2/22/201800055017 | Hour-17 | 2/22/2018 Hour-17 |  00055055007 | 2/22/2018000550 |              550 | Press Shop       |
| 2018-03-12 00:00:00.000 |        55007 |        17 |           1 | 3/12/20185500717 | 3/12/201800055017 | Hour-17 | 3/12/2018 Hour-17 |  00055055007 | 3/12/2018000550 |              550 | Press Shop       |
| 2018-04-02 00:00:00.000 |        55007 |        17 |           1 | 4/2/20185500717  | 4/2/201800055017  | Hour-17 | 4/2/2018 Hour-17  |  00055055007 | 4/2/2018000550  |              550 | Press Shop       |
| 2018-04-30 00:00:00.000 |        55007 |        17 |           1 | 4/30/20185500717 | 4/30/201800055017 | Hour-17 | 4/30/2018 Hour-17 |  00055055007 | 4/30/2018000550 |              550 | Press Shop       |
| 2018-07-20 00:00:00.000 |        55007 |        17 |           1 | 7/20/20185500717 | 7/20/201800055017 | Hour-17 | 7/20/2018 Hour-17 |  00055055007 | 7/20/2018000550 |              550 | Press Shop       |


Table: vDownHours
| OpsDate                 | WorkCenter   |   OpHour | DWHLink          | DT_Reason   | DT_Comment   |   DT_Duration | Date-Hour        | Operations Hour   |
|:------------------------|:-------------|---------:|:-----------------|:------------|:-------------|--------------:|:-----------------|:------------------|
| 2018-01-03 00:00:00.000 | 57002        |       11 | 1/3/20185700211  | None        |              |             1 | 1/3/2018 Hour-11 | Hour-11           |
| 2018-01-03 00:00:00.000 | 58094        |       11 | 1/3/20185809411  | None        |              |             1 | 1/3/2018 Hour-11 | Hour-11           |
| 2018-01-02 00:00:00.000 | 54017C       |       11 | 1/2/201854017C11 | None        |              |             1 | 1/2/2018 Hour-11 | Hour-11           |
| 2018-01-03 00:00:00.000 | 56003A       |       11 | 1/3/201856003A11 | None        |              |             1 | 1/3/2018 Hour-11 | Hour-11           |
| 2018-01-02 00:00:00.000 | 53001        |       11 | 1/2/20185300111  | None        |              |             1 | 1/2/2018 Hour-11 | Hour-11           |
| 2018-01-02 00:00:00.000 | 55007        |       11 | 1/2/20185500711  | None        |              |             1 | 1/2/2018 Hour-11 | Hour-11           |
| 2018-01-03 00:00:00.000 | 54018C       |       11 | 1/3/201854018C11 | None        |              |             1 | 1/3/2018 Hour-11 | Hour-11           |
| 2018-01-04 00:00:00.000 | 54017B       |       11 | 1/4/201854017B11 | None        |              |             1 | 1/4/2018 Hour-11 | Hour-11           |
| 2018-01-08 00:00:00.000 | 54017C       |       11 | 1/8/201854017C11 | None        |              |             1 | 1/8/2018 Hour-11 | Hour-11           |
| 2018-01-05 00:00:00.000 | 55503        |       11 | 1/5/20185550311  | None        |              |             1 | 1/5/2018 Hour-11 | Hour-11           |


Table: vPaidHour
| OpsDate                 |   DepartmentID |   OpHour |   RegHours |   OT_Hours | DDH               |
|:------------------------|---------------:|---------:|-----------:|-----------:|:------------------|
| 2018-01-03 00:00:00.000 |            560 |       18 |          1 |          0 | 1/3/201800056018  |
| 2018-01-04 00:00:00.000 |            560 |       18 |          1 |          0 | 1/4/201800056018  |
| 2018-01-08 00:00:00.000 |            560 |       18 |          1 |          0 | 1/8/201800056018  |
| 2018-01-09 00:00:00.000 |            560 |       18 |          1 |          0 | 1/9/201800056018  |
| 2018-01-10 00:00:00.000 |            560 |       18 |          1 |          0 | 1/10/201800056018 |
| 2018-01-16 00:00:00.000 |            560 |       18 |          1 |          0 | 1/16/201800056018 |
| 2018-01-17 00:00:00.000 |            560 |       18 |          1 |          0 | 1/17/201800056018 |
| 2018-01-18 00:00:00.000 |            560 |       18 |          1 |          0 | 1/18/201800056018 |
| 2018-01-22 00:00:00.000 |            560 |       18 |          1 |          0 | 1/22/201800056018 |
| 2018-01-23 00:00:00.000 |            560 |       18 |          1 |          0 | 1/23/201800056018 |


Table: vProdHours
| OpsDate                 | WorkCenter   |   OpsHour |   ProdHours | WCLink           |
|:------------------------|:-------------|----------:|------------:|:-----------------|
| 2018-02-22 00:00:00.000 | 54018B       |         6 |           1 | 2/22/201854018B6 |
| 2018-02-21 00:00:00.000 | 54018B       |         6 |           1 | 2/21/201854018B6 |
| 2018-03-01 00:00:00.000 | 54018B       |         6 |           1 | 3/1/201854018B6  |
| 2018-02-20 00:00:00.000 | 54018B       |         6 |           1 | 2/20/201854018B6 |
| 2018-06-11 00:00:00.000 | 54018B       |         6 |           1 | 6/11/201854018B6 |
| 2018-03-22 00:00:00.000 | 54018B       |         6 |           1 | 3/22/201854018B6 |
| 2018-06-27 00:00:00.000 | 54018B       |         6 |           1 | 6/27/201854018B6 |
| 2018-04-27 00:00:00.000 | 54018B       |         6 |           1 | 4/27/201854018B6 |
| 2018-03-15 00:00:00.000 | 54018B       |         6 |           1 | 3/15/201854018B6 |
| 2018-07-05 00:00:00.000 | 54018B       |         6 |           1 | 7/5/201854018B6  |

 


tables: name: Data Entry
data: Data Entry.csv
name: DDHLink
data: DDHLink.csv
name: DDLink
data: DDLink.csv
name: DeptWCLink
data: DeptWCLink.csv
name: dimLocation
data: dimLocation.csv
name: Measures Table
data: Measures Table.csv
name: OpsDates
data: OpsDates.csv
name: OpsHours
data: OpsHours.csv
name: Production Hours
data: Production Hours.csv
name: vDownHours
data: vDownHours.csv
name: vPaidHour
data: vPaidHour.csv
name: vProdHours
data: vProdHours.csv
label: Production Hours
OpsHour
OpsHours
OpsHour
vDownHours
DWHLink
Production Hours
DWH
output: {
    "joins": [
        {
            "from_table": "Production Hours",
            "from_column": "OpsHour",
            "to_table": "OpsHours",
            "to_column": "OpsHour"
        },
        {
            "from_table": "vDownHours",
            "from_column": "DWHLink",
            "to_table": "Production Hours",
            "to_column": "DWH"
        }
    ]
}