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: tbl_BusinessTravelLookUp
|   businesstravel_id | businesstravel_desc   |
|--------------------:|:----------------------|
|                   0 | Non_Travel            |
|                   1 | Travel_Rarely         |
|                   2 | Travel_Frequently     |


Table: tbl_DepartmentLookUp
|   department_id | department_desc        |
|----------------:|:-----------------------|
|               1 | Human Resources        |
|               2 | Sales                  |
|               3 | Research & Development |


Table: tbl_EducationFieldLookUp
|   educationfield_id | educationfield_desc   |
|--------------------:|:----------------------|
|                   1 | Technical Degree      |
|                   2 | Other                 |
|                   3 | Human Resources       |
|                   4 | Medical               |
|                   5 | Marketing             |
|                   6 | Life Sciences         |


Table: tbl_EducationLookUp
|   education_id | education_desc   |
|---------------:|:-----------------|
|              1 | Below College    |
|              2 | College          |
|              3 | Bachelor         |
|              4 | Master           |
|              5 | Doctor           |


Table: tbl_EmployeeAttrition
|   Employee_id |   Age | Attrition   |   BusinessTravel |   DailyRate |   Department |   DistanceFromHome |   Education |   EducationField |   EmployeeCount |   EmployeeNumber |   EnvironmentSatisfaction | Gender   |   HourlyRate |   JobInvolvement |   JobLevel |   JobRole |   JobSatisfaction |   MaritalStatus |   MonthlyIncome |   MonthlyRate |   NumCompaniesWorked | Over18   | OverTime   |   PercentSalaryHike |   PerformanceRating |   RelationshipSatisfaction |   StandardHours |   StockOptionLevel |   TotalWorkingYears |   TrainingTimesLastYear |   WorkLifeBalance |   YearsAtCompany |   YearsSinceLastPromotion |   YearsWithCurrManager | AgeGroup   | MonthlyIncomeGroup   | YearsAtCompanyGroup   | YearsSinceLastPromotionGroup   | YearsWithCurrentManagerGroup   | TotalWorkingYearsGroup   | Dept                   | Job_Role              | Over_Time   | PercentSalaryHikeGroup   | DistanceFromHomeGroup   |
|--------------:|------:|:------------|-----------------:|------------:|-------------:|-------------------:|------------:|-----------------:|----------------:|-----------------:|--------------------------:|:---------|-------------:|-----------------:|-----------:|----------:|------------------:|----------------:|----------------:|--------------:|---------------------:|:---------|:-----------|--------------------:|--------------------:|---------------------------:|----------------:|-------------------:|--------------------:|------------------------:|------------------:|-----------------:|--------------------------:|-----------------------:|:-----------|:---------------------|:----------------------|:-------------------------------|:-------------------------------|:-------------------------|:-----------------------|:----------------------|:------------|:-------------------------|:------------------------|
|             8 |    30 | False       |                1 |        1358 |            3 |                 24 |           1 |                6 |               1 |               11 |                         4 | M        |           67 |                3 |          1 |         9 |                 3 |               3 |            2693 |         13335 |                    1 | True     | False      |                  22 |                   2 |                          2 |              80 |                  1 |                   1 |                       2 |                 3 |                0 |                         0 |                      0 | 30 - 39    | $2000 - $3999        | < 1                   | < 1                            | < 1                            | 1 - 3                    | Research & Development | Laboratory Technician | No          | 20 - 22                  | More than 20            |
|            24 |    21 | False       |                1 |         391 |            3 |                 15 |           2 |                6 |               1 |               30 |                         3 | M        |           96 |                3 |          1 |         3 |                 4 |               1 |            1232 |         19281 |                    1 | True     | False      |                  14 |                   1 |                          4 |              80 |                  0 |                   0 |                       6 |                 3 |                0 |                         0 |                      0 | 20 - 29    | < $2000              | < 1                   | < 1                            | < 1                            | < 1                      | Research & Development | Research Scientist    | No          | 14 - 16                  | 11 - 15                 |
|            34 |    39 | True        |                1 |         895 |            2 |                  5 |           3 |                2 |               1 |               42 |                         4 | M        |           56 |                3 |          2 |         2 |                 4 |               2 |            2086 |          3335 |                    3 | True     | False      |                  14 |                   3 |                          3 |              80 |                  1 |                  19 |                       6 |                 4 |                0 |                         0 |                      0 | 30 - 39    | $2000 - $3999        | < 1                   | < 1                            | < 1                            | 11 - 25                  | Sales                  | Sales Representative  | No          | 14 - 16                  | 1 - 5                   |
|            41 |    35 | False       |                1 |         464 |            3 |                  4 |           2 |                1 |               1 |               53 |                         3 | M        |           75 |                3 |          1 |         9 |                 4 |               3 |            1951 |         10910 |                    1 | True     | False      |                  12 |                   1 |                          3 |              80 |                  1 |                   1 |                       3 |                 3 |                0 |                         0 |                      0 | 30 - 39    | < $2000              | < 1                   | < 1                            | < 1                            | 1 - 3                    | Research & Development | Laboratory Technician | No          | 11 - 13                  | 1 - 5                   |
|            42 |    27 | False       |                1 |        1240 |            3 |                  2 |           4 |                6 |               1 |               54 |                         4 | F        |           33 |                3 |          1 |         9 |                 1 |               3 |            2341 |         19715 |                    1 | True     | False      |                  13 |                   3 |                          4 |              80 |                  1 |                   1 |                       6 |                 3 |                0 |                         0 |                      0 | 20 - 29    | $2000 - $3999        | < 1                   | < 1                            | < 1                            | 1 - 3                    | Research & Development | Laboratory Technician | No          | 11 - 13                  | 1 - 5                   |
|            48 |    37 | False       |                1 |         408 |            3 |                 19 |           2 |                6 |               1 |               61 |                         2 | M        |           73 |                3 |          1 |         3 |                 2 |               2 |            3022 |         10227 |                    4 | True     | False      |                  21 |                   2 |                          1 |              80 |                  0 |                   8 |                       1 |                 3 |                0 |                         0 |                      0 | 30 - 39    | $2000 - $3999        | < 1                   | < 1                            | < 1                            | 7 - 10                   | Research & Development | Research Scientist    | No          | 20 - 22                  | 16 - 20                 |
|            68 |    45 | False       |                1 |        1339 |            3 |                  7 |           3 |                6 |               1 |               86 |                         2 | M        |           59 |                3 |          3 |         3 |                 1 |               3 |            9724 |         18787 |                    2 | True     | False      |                  17 |                   1 |                          3 |              80 |                  1 |                  25 |                       2 |                 3 |                0 |                         0 |                      0 | 40 - 49    | $8000 - $9999        | < 1                   | < 1                            | < 1                            | 11 - 25                  | Research & Development | Research Scientist    | No          | 17 - 19                  | 6 - 10                  |
|            75 |    36 | False       |                1 |         132 |            3 |                  6 |           3 |                6 |               1 |               97 |                         2 | F        |           55 |                4 |          1 |         9 |                 4 |               2 |            3038 |         22002 |                    3 | True     | False      |                  12 |                   3 |                          2 |              80 |                  0 |                   5 |                       3 |                 3 |                0 |                         0 |                      0 | 30 - 39    | $2000 - $3999        | < 1                   | < 1                            | < 1                            | 4 - 6                    | Research & Development | Laboratory Technician | No          | 11 - 13                  | 6 - 10                  |
|            87 |    23 | False       |                1 |         541 |            2 |                  2 |           1 |                2 |               1 |              113 |                         3 | M        |           62 |                3 |          1 |         2 |                 1 |               3 |            2322 |          9518 |                    3 | True     | False      |                  13 |                   3 |                          3 |              80 |                  1 |                   3 |                       3 |                 3 |                0 |                         0 |                      0 | 20 - 29    | $2000 - $3999        | < 1                   | < 1                            | < 1                            | 1 - 3                    | Sales                  | Sales Representative  | No          | 11 - 13                  | 1 - 5                   |
|           102 |    32 | False       |                1 |         827 |            3 |                  1 |           1 |                6 |               1 |              134 |                         4 | M        |           71 |                3 |          1 |         3 |                 1 |               1 |            2956 |         15178 |                    1 | True     | False      |                  13 |                   3 |                          4 |              80 |                  0 |                   1 |                       2 |                 3 |                0 |                         0 |                      0 | 30 - 39    | $2000 - $3999        | < 1                   | < 1                            | < 1                            | 1 - 3                    | Research & Development | Research Scientist    | No          | 11 - 13                  | 1 - 5                   |


Table: tbl_EnvironmentSatisfactionLookUp
|   environmentsatisfaction_id | environmentsatisfaction_desc   |
|-----------------------------:|:-------------------------------|
|                            1 | Low                            |
|                            2 | Medium                         |
|                            3 | High                           |
|                            4 | Very High                      |


Table: tbl_JobInvolvementLookUp
|   jobinvolvement_id | jobinvolvement_desc   |
|--------------------:|:----------------------|
|                   1 | Low                   |
|                   2 | Medium                |
|                   3 | High                  |
|                   4 | Very High             |


Table: tbl_JobLevelLookUp
|   joblevel_id | joblevel_desc   |
|--------------:|:----------------|
|             1 | Staff           |
|             2 | Team Leader     |
|             3 | Manager         |
|             4 | Senior Manager  |
|             5 | Director        |


Table: tbl_JobRoleLookUp
|   jobrole_id | jobrole_desc              |
|-------------:|:--------------------------|
|            1 | Sales Executive           |
|            2 | Sales Representative      |
|            3 | Research Scientist        |
|            4 | Human Resources           |
|            5 | Healthcare Representative |
|            6 | Research Director         |
|            7 | Manager                   |
|            8 | Manufacturing Director    |
|            9 | Laboratory Technician     |


Table: tbl_JobSatisfactionLookUp
|   jobsatisfaction_id | [jobsatisfaction_desc   |
|---------------------:|:------------------------|
|                    1 | Low                     |
|                    2 | Medium                  |
|                    3 | High                    |
|                    4 | Very High               |


Table: tbl_MaritalStatusLookUp
|   maritalstatus_id | maritalstatus_desc   |
|-------------------:|:---------------------|
|                  1 | Single               |
|                  2 | Married              |
|                  3 | Divorced             |


Table: tbl_PerformanceRatingLookUp
|   performancerating_id | performancerating_desc   |
|-----------------------:|:-------------------------|
|                      1 | Low                      |
|                      2 | Good                     |
|                      3 | Excellent                |
|                      4 | Outstanding              |


Table: tbl_RelationshipSatisfactionLookUp
|   relationshipsatisfaction_id | relationshipsatisfaction_desc   |
|------------------------------:|:--------------------------------|
|                             1 | Low                             |
|                             2 | Medium                          |
|                             3 | High                            |
|                             4 | Very High                       |


Table: tbl_WorkLifeBalanceLookUp
|   worklifebalance_id | worklifebalance_desc   |
|---------------------:|:-----------------------|
|                    1 | Bad                    |
|                    2 | Good                   |
|                    3 | Better                 |
|                    4 | Best                   |

 


tables: name: tbl_BusinessTravelLookUp
data: tbl_BusinessTravelLookUp.csv
name: tbl_DepartmentLookUp
data: tbl_DepartmentLookUp.csv
name: tbl_EducationFieldLookUp
data: tbl_EducationFieldLookUp.csv
name: tbl_EducationLookUp
data: tbl_EducationLookUp.csv
name: tbl_EmployeeAttrition
data: tbl_EmployeeAttrition.csv
name: tbl_EnvironmentSatisfactionLookUp
data: tbl_EnvironmentSatisfactionLookUp.csv
name: tbl_JobInvolvementLookUp
data: tbl_JobInvolvementLookUp.csv
name: tbl_JobLevelLookUp
data: tbl_JobLevelLookUp.csv
name: tbl_JobRoleLookUp
data: tbl_JobRoleLookUp.csv
name: tbl_JobSatisfactionLookUp
data: tbl_JobSatisfactionLookUp.csv
name: tbl_MaritalStatusLookUp
data: tbl_MaritalStatusLookUp.csv
name: tbl_PerformanceRatingLookUp
data: tbl_PerformanceRatingLookUp.csv
name: tbl_RelationshipSatisfactionLookUp
data: tbl_RelationshipSatisfactionLookUp.csv
name: tbl_WorkLifeBalanceLookUp
data: tbl_WorkLifeBalanceLookUp.csv
label: tbl_EmployeeAttrition
JobInvolvement
tbl_JobInvolvementLookUp
jobinvolvement_id
tbl_EmployeeAttrition
JobLevel
tbl_JobLevelLookUp
joblevel_id
tbl_EmployeeAttrition
JobSatisfaction
tbl_JobSatisfactionLookUp
jobsatisfaction_id
tbl_EmployeeAttrition
PerformanceRating
tbl_PerformanceRatingLookUp
performancerating_id
tbl_EmployeeAttrition
MaritalStatus
tbl_MaritalStatusLookUp
maritalstatus_id
tbl_EmployeeAttrition
JobRole
tbl_JobRoleLookUp
jobrole_id
tbl_EmployeeAttrition
RelationshipSatisfaction
tbl_RelationshipSatisfactionLookUp
relationshipsatisfaction_id
tbl_EmployeeAttrition
BusinessTravel
tbl_BusinessTravelLookUp
businesstravel_id
tbl_EmployeeAttrition
Education
tbl_EducationLookUp
education_id
tbl_EmployeeAttrition
EnvironmentSatisfaction
tbl_EnvironmentSatisfactionLookUp
environmentsatisfaction_id
tbl_EmployeeAttrition
Department
tbl_DepartmentLookUp
department_id
tbl_EmployeeAttrition
EducationField
tbl_EducationFieldLookUp
educationfield_id
tbl_EmployeeAttrition
WorkLifeBalance
tbl_WorkLifeBalanceLookUp
worklifebalance_id
output: {
    "joins": [
        {
            "from_table": "tbl_EmployeeAttrition",
            "from_column": "JobInvolvement",
            "to_table": "tbl_JobInvolvementLookUp",
            "to_column": "jobinvolvement_id"
        },
        {
            "from_table": "tbl_EmployeeAttrition",
            "from_column": "JobLevel",
            "to_table": "tbl_JobLevelLookUp",
            "to_column": "joblevel_id"
        },
        {
            "from_table": "tbl_EmployeeAttrition",
            "from_column": "JobSatisfaction",
            "to_table": "tbl_JobSatisfactionLookUp",
            "to_column": "jobsatisfaction_id"
        },
        {
            "from_table": "tbl_EmployeeAttrition",
            "from_column": "PerformanceRating",
            "to_table": "tbl_PerformanceRatingLookUp",
            "to_column": "performancerating_id"
        },
        {
            "from_table": "tbl_EmployeeAttrition",
            "from_column": "MaritalStatus",
            "to_table": "tbl_MaritalStatusLookUp",
            "to_column": "maritalstatus_id"
        },
        {
            "from_table": "tbl_EmployeeAttrition",
            "from_column": "JobRole",
            "to_table": "tbl_JobRoleLookUp",
            "to_column": "jobrole_id"
        },
        {
            "from_table": "tbl_EmployeeAttrition",
            "from_column": "RelationshipSatisfaction",
            "to_table": "tbl_RelationshipSatisfactionLookUp",
            "to_column": "relationshipsatisfaction_id"
        },
        {
            "from_table": "tbl_EmployeeAttrition",
            "from_column": "BusinessTravel",
            "to_table": "tbl_BusinessTravelLookUp",
            "to_column": "businesstravel_id"
        },
        {
            "from_table": "tbl_EmployeeAttrition",
            "from_column": "Education",
            "to_table": "tbl_EducationLookUp",
            "to_column": "education_id"
        },
        {
            "from_table": "tbl_EmployeeAttrition",
            "from_column": "EnvironmentSatisfaction",
            "to_table": "tbl_EnvironmentSatisfactionLookUp",
            "to_column": "environmentsatisfaction_id"
        },
        {
            "from_table": "tbl_EmployeeAttrition",
            "from_column": "Department",
            "to_table": "tbl_DepartmentLookUp",
            "to_column": "department_id"
        },
        {
            "from_table": "tbl_EmployeeAttrition",
            "from_column": "EducationField",
            "to_table": "tbl_EducationFieldLookUp",
            "to_column": "educationfield_id"
        },
        {
            "from_table": "tbl_EmployeeAttrition",
            "from_column": "WorkLifeBalance",
            "to_table": "tbl_WorkLifeBalanceLookUp",
            "to_column": "worklifebalance_id"
        }
    ]
}