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: Email_Data
|   User_ID | Type   | Email_Region   | Email_Office   | Email_Department   |   NoEmails |   Email Range |
|----------:|:-------|:---------------|:---------------|:-------------------|-----------:|--------------:|
|       320 | Sent   | ANOTHER REGION | ANOTHER OFFICE | ANOTHER DEPARTMENT |        962 |          1000 |
|       707 | Sent   | ANOTHER REGION | ANOTHER OFFICE | ANOTHER DEPARTMENT |       1456 |          1500 |
|      1296 | Sent   | ANOTHER REGION | ANOTHER OFFICE | ANOTHER DEPARTMENT |       2240 |          2500 |
|      1130 | Sent   | ANOTHER REGION | ANOTHER OFFICE | ANOTHER DEPARTMENT |       1031 |          1500 |
|       411 | Sent   | ANOTHER REGION | ANOTHER OFFICE | ANOTHER DEPARTMENT |       2663 |          3000 |
|       417 | Sent   | ANOTHER REGION | ANOTHER OFFICE | ANOTHER DEPARTMENT |       2385 |          2500 |
|       249 | Sent   | ANOTHER REGION | ANOTHER OFFICE | ANOTHER DEPARTMENT |        699 |          1000 |
|         4 | Sent   | ANOTHER REGION | ANOTHER OFFICE | ANOTHER DEPARTMENT |        557 |          1000 |
|       562 | Sent   | ANOTHER REGION | ANOTHER OFFICE | ANOTHER DEPARTMENT |       2290 |          2500 |
|      1016 | Sent   | ANOTHER REGION | ANOTHER OFFICE | ANOTHER DEPARTMENT |       2907 |          3000 |


Table: Employee_Roster_Data
|   User_ID |   Tenure_Yrs |   Seniority |   Rating |   Survey_Score |   Promotion |   Salary_USD |   Avg Admin Hrs Range |   Avg Client Hrs Range |   Avg Attribute Level Range |   Client Time Range |   Admin Time Range |   Utilization Range |
|----------:|-------------:|------------:|---------:|---------------:|------------:|-------------:|----------------------:|-----------------------:|----------------------------:|--------------------:|-------------------:|--------------------:|
|       798 |         1.55 |           6 |        3 |        80.6606 |           1 |     297188   |                    20 |                    180 |                           1 |                 1.1 |                0.1 |                 1.2 |
|       799 |         1.6  |           6 |        3 |        65.9382 |           1 |     116654   |                    40 |                    120 |                           0 |                 0.8 |                0.2 |                 0.9 |
|       801 |         0.03 |           6 |        3 |        78.175  |           1 |     138914   |                     0 |                      0 |                           3 |                 0   |                0   |                 0   |
|       803 |         2.32 |           6 |        3 |        82.5523 |           1 |     155632   |                    20 |                    160 |                           2 |                 0.9 |                0.1 |                 0.9 |
|       805 |         4.97 |           6 |        3 |        85.2755 |           1 |      92131.4 |                    20 |                    100 |                           3 |                 0.6 |                0.1 |                 0.6 |
|       811 |         3.82 |           6 |        3 |        49.2381 |           1 |     117410   |                     0 |                     40 |                           3 |                 0.2 |                0   |                 0.2 |
|       812 |         0.54 |           6 |        3 |        44.386  |           1 |     108368   |                    20 |                    140 |                           4 |                 0.9 |                0.1 |                 0.9 |
|       813 |         1.4  |           6 |        3 |        64.6547 |           1 |      87092.5 |                    40 |                    120 |                           2 |                 0.8 |                0.2 |                 0.9 |
|       818 |         0.04 |           6 |        3 |        75.2225 |           1 |      40374.4 |                     0 |                     40 |                           4 |                 0.2 |                0   |                 0.2 |
|       820 |         5.85 |           6 |        3 |        68.3068 |           1 |      66779.4 |                     0 |                      0 |                           3 |                 0   |                0   |                 0   |


Table: Hours
|   UserId |   Admin Hrs |   Client Hrs |   Target Client Hrs |   Total Working Hrs |   NoMonths |
|---------:|------------:|-------------:|--------------------:|--------------------:|-----------:|
|      593 |           0 |         38   |                38   |                 320 |          2 |
|     1257 |           0 |        144   |               144   |                 320 |          2 |
|       23 |           0 |        176   |               176   |                 320 |          2 |
|      238 |           0 |         96   |                96   |                 320 |          2 |
|      570 |           0 |        216   |               216   |                 320 |          2 |
|      547 |           0 |         87.5 |                87.5 |                 320 |          2 |
|     1065 |           0 |        155   |               155   |                 320 |          2 |
|      470 |           0 |        211   |               211   |                 320 |          2 |
|     1128 |           0 |        122   |               122   |                 320 |          2 |
|      181 |           0 |        169.5 |               169.5 |                 320 |          2 |


Table: Skills
|   UserId |   Attribute Level |
|---------:|------------------:|
|      261 |           2.54545 |
|      593 |           2.15789 |
|      355 |           2.46154 |
|      687 |           2.11111 |
|      902 |           3.02128 |
|      570 |           1.28571 |
|       23 |           1.66667 |
|      238 |           1.87037 |
|      879 |           2.875   |
|      547 |           2.22581 |

 


tables: name: Email_Data
data: Email_Data.csv
name: Employee_Roster_Data
data: Employee_Roster_Data.csv
name: Hours
data: Hours.csv
name: Skills
data: Skills.csv
label: Hours
UserId
Employee_Roster_Data
User_ID
Skills
UserId
Employee_Roster_Data
User_ID
Email_Data
User_ID
Employee_Roster_Data
User_ID
output: {
    "joins": [
        {
            "from_table": "Hours",
            "from_column": "UserId",
            "to_table": "Employee_Roster_Data",
            "to_column": "User_ID"
        },
        {
            "from_table": "Skills",
            "from_column": "UserId",
            "to_table": "Employee_Roster_Data",
            "to_column": "User_ID"
        },
        {
            "from_table": "Email_Data",
            "from_column": "User_ID",
            "to_table": "Employee_Roster_Data",
            "to_column": "User_ID"
        }
    ]
}