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: 2020 Paid Days & OT
|   Year | Month     |   MonthNum |   Working Days |   Holidays |   PAID Days |   Planned S/D Days |   Net Paid Days |   CN DL OT |   CN DL Lost Time |   CN IL OT | Mon   |
|-------:|:----------|-----------:|---------------:|-----------:|------------:|-------------------:|----------------:|-----------:|------------------:|-----------:|:------|
|   2020 | January   |          1 |             22 |          1 |          23 |                  0 |              23 | 0.0440843  |             0.075 | 0.0440843  | JAN   |
|   2020 | February  |          2 |             20 |          0 |          20 |                  0 |              20 | 0.0459212  |             0.075 | 0.0459212  | FEB   |
|   2020 | March     |          3 |             22 |          0 |          22 |                  0 |              22 | 0.0440843  |             0.075 | 0.0440843  | MAR   |
|   2020 | April     |          4 |             21 |          1 |          22 |                  0 |              22 | 0.0710136  |             0.075 | 0.0710136  | APR   |
|   2020 | May       |          5 |             20 |          1 |          21 |                  0 |              21 | 0.062689   |             0.075 | 0.062689   | MAY   |
|   2020 | June      |          6 |             22 |          0 |          22 |                  0 |              22 | 0.0571673  |             0.075 | 0.0571673  | JUN   |
|   2020 | July      |          7 |             22 |          1 |          23 |                  0 |              23 | 0.0333463  |             0.075 | 0.0333463  | JUL   |
|   2020 | August    |          8 |             21 |          0 |          21 |                  0 |              21 | 0.0387563  |             0.075 | 0.0387563  | AUG   |
|   2020 | September |          9 |             21 |          1 |          22 |                  0 |              22 | 0.0387563  |             0.075 | 0.0387563  | SEP   |
|   2020 | October   |         10 |             22 |          0 |          22 |                  0 |              22 | 0.00865188 |             0.075 | 0.00865188 | OCT   |


Table: Calendar
| Date                    | Long date               | MM-YY                   |   Year |   MonthNum | Month   | Period                  | Qtr   | Mon   |
|:------------------------|:------------------------|:------------------------|-------:|-----------:|:--------|:------------------------|:------|:------|
| 2016-07-01 00:00:00.000 | 2016-07-01 00:00:00.000 | 2016-07-01 00:00:00.000 |   2016 |          7 | July    | 2016-07-01 00:00:00.000 | Q3    | Jul   |
| 2016-07-02 00:00:00.000 | 2016-07-02 00:00:00.000 | 2016-07-02 00:00:00.000 |   2016 |          7 | July    | 2016-07-01 00:00:00.000 | Q3    | Jul   |
| 2016-07-03 00:00:00.000 | 2016-07-03 00:00:00.000 | 2016-07-03 00:00:00.000 |   2016 |          7 | July    | 2016-07-01 00:00:00.000 | Q3    | Jul   |
| 2016-07-04 00:00:00.000 | 2016-07-04 00:00:00.000 | 2016-07-04 00:00:00.000 |   2016 |          7 | July    | 2016-07-01 00:00:00.000 | Q3    | Jul   |
| 2016-07-05 00:00:00.000 | 2016-07-05 00:00:00.000 | 2016-07-05 00:00:00.000 |   2016 |          7 | July    | 2016-07-01 00:00:00.000 | Q3    | Jul   |
| 2016-07-06 00:00:00.000 | 2016-07-06 00:00:00.000 | 2016-07-06 00:00:00.000 |   2016 |          7 | July    | 2016-07-01 00:00:00.000 | Q3    | Jul   |
| 2016-07-07 00:00:00.000 | 2016-07-07 00:00:00.000 | 2016-07-07 00:00:00.000 |   2016 |          7 | July    | 2016-07-01 00:00:00.000 | Q3    | Jul   |
| 2016-07-08 00:00:00.000 | 2016-07-08 00:00:00.000 | 2016-07-08 00:00:00.000 |   2016 |          7 | July    | 2016-07-01 00:00:00.000 | Q3    | Jul   |
| 2016-07-09 00:00:00.000 | 2016-07-09 00:00:00.000 | 2016-07-09 00:00:00.000 |   2016 |          7 | July    | 2016-07-01 00:00:00.000 | Q3    | Jul   |
| 2016-07-10 00:00:00.000 | 2016-07-10 00:00:00.000 | 2016-07-10 00:00:00.000 |   2016 |          7 | July    | 2016-07-01 00:00:00.000 | Q3    | Jul   |


Table: Dates
| Date                    |   Year |   QuarterOfYear |   MonNum |   DayOfMonth |   DateInt | MonthName   | Mon Year   | Qtr Year   |   DayInWeek | DayOfWeekName   | WeekEnding              |   Week Number |   MonthnYear |   QuarternYear |   ShortYear | FY   |
|:------------------------|-------:|----------------:|---------:|-------------:|----------:|:------------|:-----------|:-----------|------------:|:----------------|:------------------------|--------------:|-------------:|---------------:|------------:|:-----|
| 2020-07-01 00:00:00.000 |   2020 |               3 |        7 |            1 |  20200701 | July        | Jul 2020   | Q3 2020    |           3 | Wednesday       | 2020-07-04 00:00:00.000 |            27 |     20200700 |       20200300 |          20 | FY21 |
| 2020-07-02 00:00:00.000 |   2020 |               3 |        7 |            2 |  20200702 | July        | Jul 2020   | Q3 2020    |           4 | Thursday        | 2020-07-04 00:00:00.000 |            27 |     20200700 |       20200300 |          20 | FY21 |
| 2020-07-03 00:00:00.000 |   2020 |               3 |        7 |            3 |  20200703 | July        | Jul 2020   | Q3 2020    |           5 | Friday          | 2020-07-04 00:00:00.000 |            27 |     20200700 |       20200300 |          20 | FY21 |
| 2020-07-04 00:00:00.000 |   2020 |               3 |        7 |            4 |  20200704 | July        | Jul 2020   | Q3 2020    |           6 | Saturday        | 2020-07-04 00:00:00.000 |            27 |     20200700 |       20200300 |          20 | FY21 |
| 2020-07-05 00:00:00.000 |   2020 |               3 |        7 |            5 |  20200705 | July        | Jul 2020   | Q3 2020    |           0 | Sunday          | 2020-07-11 00:00:00.000 |            28 |     20200700 |       20200300 |          20 | FY21 |
| 2020-07-06 00:00:00.000 |   2020 |               3 |        7 |            6 |  20200706 | July        | Jul 2020   | Q3 2020    |           1 | Monday          | 2020-07-11 00:00:00.000 |            28 |     20200700 |       20200300 |          20 | FY21 |
| 2020-07-07 00:00:00.000 |   2020 |               3 |        7 |            7 |  20200707 | July        | Jul 2020   | Q3 2020    |           2 | Tuesday         | 2020-07-11 00:00:00.000 |            28 |     20200700 |       20200300 |          20 | FY21 |
| 2020-07-08 00:00:00.000 |   2020 |               3 |        7 |            8 |  20200708 | July        | Jul 2020   | Q3 2020    |           3 | Wednesday       | 2020-07-11 00:00:00.000 |            28 |     20200700 |       20200300 |          20 | FY21 |
| 2020-07-09 00:00:00.000 |   2020 |               3 |        7 |            9 |  20200709 | July        | Jul 2020   | Q3 2020    |           4 | Thursday        | 2020-07-11 00:00:00.000 |            28 |     20200700 |       20200300 |          20 | FY21 |
| 2020-07-10 00:00:00.000 |   2020 |               3 |        7 |           10 |  20200710 | July        | Jul 2020   | Q3 2020    |           5 | Friday          | 2020-07-11 00:00:00.000 |            28 |     20200700 |       20200300 |          20 | FY21 |


Table: Dept_LU
|   Dept | Labor Type   | OH Type   | Labor Group   |
|-------:|:-------------|:----------|:--------------|
|     20 | I            | F         | Sales         |
|     25 | I            | F         | Sales         |
|     29 | I            | F         | Sales         |
|    270 | I            | F         | Sales         |
|    311 | D            | V         | DL            |
|    312 | D            | V         | DL            |
|    316 | D            | V         | DL            |
|    317 | D            | V         | DL            |
|    318 | D            | V         | DL            |
|    319 | D            | V         | DL            |


Table: EE Info
|   WH Code | DIV_NAME   | D or I   | Var/Fix   | EMP_NAME   |   Loc |   Dpt | H/S   | Shift   | EMP_ DATE               |   PAY_    RATE |   Shift       Diff | Next Review Date        | Increase%   |   Month of Increase |   Rate w Increase |   Yr of Service |   VDays |
|----------:|:-----------|:---------|:----------|:-----------|------:|------:|:------|:--------|:------------------------|---------------:|-------------------:|:------------------------|:------------|--------------------:|------------------:|----------------:|--------:|
|        10 | CN         | D        | V         | New add1   |    10 |   311 | H     | 1       | 2020-01-01 00:00:00.000 |          11.5  |               0    |                         |             |                   1 |           11.5    |               0 |       0 |
|        10 | CN         | D        | V         | New add2   |    10 |   311 | H     | 2C      | 2020-03-01 00:00:00.000 |          11.5  |               0.35 |                         |             |                   3 |           11.85   |               0 |       0 |
|        10 | CN         | D        | V         | New add3   |    10 |   312 | H     | 1       | 2020-04-01 00:00:00.000 |          11.5  |               0    |                         |             |                   4 |           11.5    |               0 |       0 |
|        10 | CN         | I        | F         | New Maint  |    10 |   458 | H     | 3C      | 2019-10-15 00:00:00.000 |          22    |               0.5  |                         |             |                  10 |           22.5    |               1 |       5 |
|        10 | CN         | D        | V         | EE1        |    10 |   311 | H     | 2C      | 1999-03-29 00:00:00.000 |          12    |               0.35 | 2020-03-29 00:00:00.000 | 0.02        |                   3 |           12.59   |              21 |      20 |
|        10 | CN         | D        | V         | EE2        |    10 |   311 | H     | 3C      | 2019-08-27 00:00:00.000 |          11.5  |               0.5  | 2019-11-25 00:00:00.000 | 0.02        |                  11 |           12.23   |               1 |       5 |
|        10 | CN         | D        | V         | EE3        |    10 |   311 | H     | 3C      | 2019-09-14 00:00:00.000 |          11.5  |               0.5  | 2019-12-12 00:00:00.000 | 0.02        |                  12 |           12.23   |               1 |       5 |
|        10 | CN         | D        | V         | EE10       |    10 |   311 | H     | 2C      | 2015-12-21 00:00:00.000 |          14.75 |               0.35 | 2020-06-12 00:00:00.000 | 0.02        |                   6 |           15.395  |               5 |      10 |
|        10 | CN         | I        | V         | EE42       |    10 |   421 | H     | 1       | 2003-11-24 00:00:00.000 |          29.79 |               0    | 2019-11-24 00:00:00.000 | 0.02        |                  11 |           30.3858 |              17 |      20 |
|        10 | CN         | I        | V         | EE43       |    10 |   421 | H     | 1       | 2004-11-22 00:00:00.000 |          14.12 |               0    | 2020-01-09 00:00:00.000 | 0.02        |                   1 |           14.4024 |              16 |      20 |


Table: FILER example
|   WH Code | DIV_NAME   | D or I   | Var/Fix   | EMP_NAME   |   Loc |   Dpt | H/S   | Shift   | EMP_ DATE               |   PAY_    RATE |   Shift       Diff | Next Review Date        | Increase%   |   Month of Increase |   Rate w Increase |   Yr of Service |   VDays |
|----------:|:-----------|:---------|:----------|:-----------|------:|------:|:------|:--------|:------------------------|---------------:|-------------------:|:------------------------|:------------|--------------------:|------------------:|----------------:|--------:|
|        10 | CN         | D        | V         | New add1   |    10 |   311 | H     | 1       | 2020-01-01 00:00:00.000 |          11.5  |               0    |                         |             |                   1 |            11.5   |               0 |       0 |
|        10 | CN         | D        | V         | New add2   |    10 |   311 | H     | 2C      | 2020-03-01 00:00:00.000 |          11.5  |               0.35 |                         |             |                   3 |            11.85  |               0 |       0 |
|        10 | CN         | D        | V         | New add3   |    10 |   312 | H     | 1       | 2020-04-01 00:00:00.000 |          11.5  |               0    |                         |             |                   4 |            11.5   |               0 |       0 |
|        10 | CN         | D        | V         | EE1        |    10 |   311 | H     | 2C      | 1999-03-29 00:00:00.000 |          12    |               0.35 | 2020-03-29 00:00:00.000 | 0.02        |                   3 |            12.59  |              21 |      20 |
|        10 | CN         | D        | V         | EE2        |    10 |   311 | H     | 3C      | 2019-08-27 00:00:00.000 |          11.5  |               0.5  | 2019-11-25 00:00:00.000 | 0.02        |                  11 |            12.23  |               1 |       5 |
|        10 | CN         | D        | V         | EE3        |    10 |   311 | H     | 3C      | 2019-09-14 00:00:00.000 |          11.5  |               0.5  | 2019-12-12 00:00:00.000 | 0.02        |                  12 |            12.23  |               1 |       5 |
|        10 | CN         | D        | V         | EE10       |    10 |   311 | H     | 2C      | 2015-12-21 00:00:00.000 |          14.75 |               0.35 | 2020-06-12 00:00:00.000 | 0.02        |                   6 |            15.395 |               5 |      10 |


Table: IL-Vac Coverage Factor
|   WH Code |   Dept |   Factor |
|----------:|-------:|---------:|
|        10 |    421 |     1    |
|        10 |    458 |     0.56 |


Table: IL-Vac Coverage
|   Dept |   Vac Days |   Tot Pd Days |     Vac % |   Factor |   Coverage% |   WH Code |
|-------:|-----------:|--------------:|----------:|---------:|------------:|----------:|
|    421 |        255 |          4192 | 0.0608302 |     1    |   0.0608302 |        10 |
|    458 |        165 |          3406 | 0.0484439 |     0.56 |   0.0271286 |        10 |


Table: Review Rate
| Type   |   Rate |   WH Code | Wage Type   |
|:-------|-------:|----------:|:------------|
| Hourly |  0.02  |        10 | H           |
| Hourly |  0.025 |        60 | H           |


Table: VacationDay-Hrly
|   Years of Svc |   VDays | Wage Type   |
|---------------:|--------:|:------------|
|              0 |       0 | H           |
|              1 |       5 | H           |
|              2 |      10 | H           |
|              3 |      10 | H           |
|              4 |      10 | H           |
|              5 |      10 | H           |
|              6 |      10 | H           |
|              7 |      10 | H           |
|              8 |      10 | H           |
|              9 |      10 | H           |


Table: values examples
| EMP_NAME   |
|:-----------|
| New add1   |
| New add2   |
| New add3   |
| New Maint  |
| EE1        |
| EE2        |
| EE3        |
| EE10       |
| EE42       |
| EE43       |


Table: WH_LU
| Warehouse     |   WH Code | WH   |
|:--------------|----------:|:-----|
| Canton        |        10 | CN   |
| Florida       |        40 | FL   |
| Casey RGM     |        29 | RG   |
| Casey Telecom |        30 | CS   |
| Marshall      |        50 | MA   |
| Rantoul       |        60 | RA   |

 


tables: name: 2020 Paid Days & OT
data: 2020 Paid Days & OT.csv
name: Calendar
data: Calendar.csv
name: Dates
data: Dates.csv
name: Dept_LU
data: Dept_LU.csv
name: EE Info
data: EE Info.csv
name: FILER example
data: FILER example.csv
name: IL-Vac Coverage Factor
data: IL-Vac Coverage Factor.csv
name: IL-Vac Coverage
data: IL-Vac Coverage.csv
name: Review Rate
data: Review Rate.csv
name: VacationDay-Hrly
data: VacationDay-Hrly.csv
name: values examples
data: values examples.csv
name: WH_LU
data: WH_LU.csv
label: Review Rate
WH Code
WH_LU
WH Code
EE Info
Yr of Service
VacationDay-Hrly
Years of Svc
Calendar
Month
2020 Paid Days & OT
Month
EE Info
Dpt
IL-Vac Coverage
Dept
EE Info
WH Code
WH_LU
WH Code
EE Info
Dpt
Dept_LU
Dept
EE Info
Dpt
IL-Vac Coverage Factor
Dept
output: {
    "joins": [
        {
            "from_table": "Review Rate",
            "from_column": "WH Code",
            "to_table": "WH_LU",
            "to_column": "WH Code"
        },
        {
            "from_table": "EE Info",
            "from_column": "Yr of Service",
            "to_table": "VacationDay-Hrly",
            "to_column": "Years of Svc"
        },
        {
            "from_table": "Calendar",
            "from_column": "Month",
            "to_table": "2020 Paid Days & OT",
            "to_column": "Month"
        },
        {
            "from_table": "EE Info",
            "from_column": "Dpt",
            "to_table": "IL-Vac Coverage",
            "to_column": "Dept"
        },
        {
            "from_table": "EE Info",
            "from_column": "WH Code",
            "to_table": "WH_LU",
            "to_column": "WH Code"
        },
        {
            "from_table": "EE Info",
            "from_column": "Dpt",
            "to_table": "Dept_LU",
            "to_column": "Dept"
        },
        {
            "from_table": "EE Info",
            "from_column": "Dpt",
            "to_table": "IL-Vac Coverage Factor",
            "to_column": "Dept"
        }
    ]
}