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: Assessments
|   STUDENT_KEY | SUBLEVEL1_SHORTNAME   |   SCHOOL_KEY | local_student_id                           | TEST_SHORTNAME   |   DISTRICT_ID |   Performance_Level |   Performance_Score | Achievmement_Category   |
|--------------:|:----------------------|-------------:|:-------------------------------------------|:-----------------|--------------:|--------------------:|--------------------:|:------------------------|
|        194637 | MATH                  |          425 | 0x5881132CC9EF892B136428BB239328A0827085E3 | SB               |             1 |                   1 |                0.25 | Below Basic             |
|        194645 | MATH                  |          425 | 0x1313BBF505614F8A8897AF89F9A3039BC363D5B2 | SB               |             1 |                   1 |                0.25 | Below Basic             |
|        194646 | MATH                  |          425 | 0xFA82F5989D9F9A8406FA24AE2652214F2642B019 | SB               |             1 |                   1 |                0.25 | Below Basic             |
|        194672 | MATH                  |          425 | 0x0BFEB4011FDACB5C275BF060CD4BFCA66BBC70FA | SB               |             1 |                   1 |                0.25 | Below Basic             |
|        194673 | MATH                  |          425 | 0x6BA5A7B11B1D6F35CF3F97E46B9C0C3A5981CE53 | SB               |             1 |                   1 |                0.25 | Below Basic             |
|        194674 | MATH                  |          425 | 0x274E34109719C41448387AC2DED9696EE1E60BA9 | SB               |             1 |                   1 |                0.25 | Below Basic             |
|        194675 | MATH                  |          425 | 0x7B662FC0097AB174C6C2AB834B2A4DFDD74572AC | SB               |             1 |                   1 |                0.25 | Below Basic             |
|        194683 | MATH                  |          425 | 0xB005B07AB5AB175A366FB666A7982E74627C8C63 | SB               |             1 |                   1 |                0.25 | Below Basic             |
|        194686 | MATH                  |          425 | 0x37294AD0A7079E03A121749B4DFAECD34954267D | SB               |             1 |                   1 |                0.25 | Below Basic             |
|        194687 | MATH                  |          425 | 0x8D2355D02C81758D75FCD2065C95DC0EF2E5BF1D | SB               |             1 |                   1 |                0.25 | Below Basic             |


Table: AssessmentsMod
|   STUDENT_KEY | SUBLEVEL1_SHORTNAME   |   SCHOOL_KEY | local_student_id                           | TEST_SHORTNAME   |   DISTRICT_ID |   Performance_Level |   Performance_Score | Achievmement_Category   |   School_Year | School_date             |
|--------------:|:----------------------|-------------:|:-------------------------------------------|:-----------------|--------------:|--------------------:|--------------------:|:------------------------|--------------:|:------------------------|
|        194637 | MATH                  |          425 | 0x5881132CC9EF892B136428BB239328A0827085E3 | SB               |             1 |                   1 |                0.25 | Below Basic             |          2018 | 2018-09-01 00:00:00.000 |
|        194645 | MATH                  |          425 | 0x1313BBF505614F8A8897AF89F9A3039BC363D5B2 | SB               |             1 |                   1 |                0.25 | Below Basic             |          2018 | 2018-09-01 00:00:00.000 |
|        194646 | MATH                  |          425 | 0xFA82F5989D9F9A8406FA24AE2652214F2642B019 | SB               |             1 |                   1 |                0.25 | Below Basic             |          2018 | 2018-09-01 00:00:00.000 |
|        194672 | MATH                  |          425 | 0x0BFEB4011FDACB5C275BF060CD4BFCA66BBC70FA | SB               |             1 |                   1 |                0.25 | Below Basic             |          2018 | 2018-09-01 00:00:00.000 |
|        194673 | MATH                  |          425 | 0x6BA5A7B11B1D6F35CF3F97E46B9C0C3A5981CE53 | SB               |             1 |                   1 |                0.25 | Below Basic             |          2018 | 2018-09-01 00:00:00.000 |
|        194674 | MATH                  |          425 | 0x274E34109719C41448387AC2DED9696EE1E60BA9 | SB               |             1 |                   1 |                0.25 | Below Basic             |          2018 | 2018-09-01 00:00:00.000 |
|        194675 | MATH                  |          425 | 0x7B662FC0097AB174C6C2AB834B2A4DFDD74572AC | SB               |             1 |                   1 |                0.25 | Below Basic             |          2018 | 2018-09-01 00:00:00.000 |
|        194683 | MATH                  |          425 | 0xB005B07AB5AB175A366FB666A7982E74627C8C63 | SB               |             1 |                   1 |                0.25 | Below Basic             |          2018 | 2018-09-01 00:00:00.000 |
|        194686 | MATH                  |          425 | 0x37294AD0A7079E03A121749B4DFAECD34954267D | SB               |             1 |                   1 |                0.25 | Below Basic             |          2018 | 2018-09-01 00:00:00.000 |
|        194687 | MATH                  |          425 | 0x8D2355D02C81758D75FCD2065C95DC0EF2E5BF1D | SB               |             1 |                   1 |                0.25 | Below Basic             |          2018 | 2018-09-01 00:00:00.000 |


Table: Dates
| Date                    |   Year |   SchoolYear | SchoolYearDesc   |
|:------------------------|-------:|-------------:|:-----------------|
| 2020-01-01 00:00:00.000 |   2020 |         2019 | 2019-2020        |
| 2020-01-02 00:00:00.000 |   2020 |         2019 | 2019-2020        |
| 2020-01-03 00:00:00.000 |   2020 |         2019 | 2019-2020        |
| 2020-01-04 00:00:00.000 |   2020 |         2019 | 2019-2020        |
| 2020-01-05 00:00:00.000 |   2020 |         2019 | 2019-2020        |
| 2020-01-06 00:00:00.000 |   2020 |         2019 | 2019-2020        |
| 2020-01-07 00:00:00.000 |   2020 |         2019 | 2019-2020        |
| 2020-01-08 00:00:00.000 |   2020 |         2019 | 2019-2020        |
| 2020-01-09 00:00:00.000 |   2020 |         2019 | 2019-2020        |
| 2020-01-10 00:00:00.000 |   2020 |         2019 | 2019-2020        |


Table: DISTRICT
|   DISTRICT_ID | DISTRICT_PUBLIC_NAME   | DISTRICT_SHORT_TITLE   |
|--------------:|:-----------------------|:-----------------------|
|             1 | 001 District           | 001 District           |
|             2 | 002 District           | 002 District           |


Table: School Plus Others
|   SCHOOL_KEY | SCHOOL_NAME   |
|-------------:|:--------------|
|          410 | 410 School    |
|          418 | 418 School    |
|          425 | 425 School    |
|          441 | 441 School    |
|          449 | 449 School    |
|          504 | 504 School    |
|          512 | 512 School    |
|          519 | 519 School    |
|          536 | 536 School    |
|          543 | 543 School    |


Table: School_LKP
|   SCHOOL_YEAR | SchoolYearDescription   |   DISTRICT_ID |   SCHOOL_KEY |   SCHOOL_ID | SCHOOL_NAME   |
|--------------:|:------------------------|--------------:|-------------:|------------:|:--------------|
|          2018 | 2018-2019               |             1 |          410 |         112 | 410 School    |
|          2018 | 2018-2019               |             1 |          418 |         118 | 418 School    |
|          2018 | 2018-2019               |             1 |          425 |         127 | 425 School    |
|          2018 | 2018-2019               |             2 |          441 |         235 | 441 School    |
|          2018 | 2018-2019               |             2 |          449 |         248 | 449 School    |
|          2020 | 2020-2021               |             1 |          504 |         112 | 504 School    |
|          2020 | 2020-2021               |             1 |          512 |         118 | 512 School    |
|          2020 | 2020-2021               |             1 |          519 |         127 | 519 School    |
|          2020 | 2020-2021               |             2 |          536 |         236 | 536 School    |
|          2020 | 2020-2021               |             2 |          543 |         248 | 543 School    |


Table: Top N
|   Top N |
|--------:|
|       1 |
|       2 |
|       3 |
|       4 |
|       5 |
|       6 |
|       7 |
|       8 |
|       9 |
|      10 |

 


tables: name: Assessments
data: Assessments.csv
name: AssessmentsMod
data: AssessmentsMod.csv
name: Dates
data: Dates.csv
name: DISTRICT
data: DISTRICT.csv
name: School Plus Others
data: School Plus Others.csv
name: School_LKP
data: School_LKP.csv
name: Top N
data: Top N.csv
label: Assessments
SCHOOL_KEY
School_LKP
SCHOOL_KEY
School_LKP
DISTRICT_ID
DISTRICT
DISTRICT_ID
AssessmentsMod
School_date
Dates
Date
AssessmentsMod
SCHOOL_KEY
School_LKP
SCHOOL_KEY
output: {
    "joins": [
        {
            "from_table": "Assessments",
            "from_column": "SCHOOL_KEY",
            "to_table": "School_LKP",
            "to_column": "SCHOOL_KEY"
        },
        {
            "from_table": "School_LKP",
            "from_column": "DISTRICT_ID",
            "to_table": "DISTRICT",
            "to_column": "DISTRICT_ID"
        },
        {
            "from_table": "AssessmentsMod",
            "from_column": "School_date",
            "to_table": "Dates",
            "to_column": "Date"
        },
        {
            "from_table": "AssessmentsMod",
            "from_column": "SCHOOL_KEY",
            "to_table": "School_LKP",
            "to_column": "SCHOOL_KEY"
        }
    ]
}