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: example programs
| Program Description   | Program Short Name   |   programID |   Person ID |
|:----------------------|:---------------------|------------:|------------:|
| After School Program  | ASP                  |           1 |       23271 |
| After School Program  | ASP                  |           1 |       23272 |
| After School Program  | ASP                  |           1 |       23507 |
| After School Program  | ASP                  |           1 |       24255 |
| After School Program  | ASP                  |           1 |       24290 |
| After School Program  | ASP                  |           1 |       24595 |
| After School Program  | ASP                  |           1 |       24596 |
| After School Program  | ASP                  |           1 |       24707 |
| After School Program  | ASP                  |           1 |       24770 |
| After School Program  | ASP                  |           1 |       24780 |


Table: roster example
|   person ID | last name   | first name   |   grade |   school ID | full_name          |
|------------:|:------------|:-------------|--------:|------------:|:-------------------|
|       31461 | lname24     | fname24      |       9 |           1 | lname24, fname24   |
|       33767 | lname31     | fname31      |       9 |           1 | lname31, fname31   |
|       28191 | lname48     | fname48      |       9 |           1 | lname48, fname48   |
|       27905 | lname51     | fname51      |       9 |           1 | lname51, fname51   |
|       27083 | lname75     | fname75      |       9 |           1 | lname75, fname75   |
|       28023 | lname87     | fname87      |       9 |           1 | lname87, fname87   |
|       31824 | lname92     | fname92      |       9 |           1 | lname92, fname92   |
|       34612 | lname100    | fname100     |       9 |           1 | lname100, fname100 |
|       34488 | lname104    | fname104     |       9 |           1 | lname104, fname104 |
|       27909 | lname108    | fname108     |       9 |           1 | lname108, fname108 |


Table: school ID
|   school ID |   Count | school name   |
|------------:|--------:|:--------------|
|           6 |      79 | school 6      |
|           3 |     194 | school 3      |
|           4 |     120 | school 4      |
|           5 |     151 | school 5      |
|           2 |     414 | school 2      |
|           1 |     497 | school 1      |
|           9 |       1 | school 9      |


Table: student fact
|   person ID |
|------------:|
|       34091 |
|       34169 |
|       34067 |
|       34187 |
|       34106 |
|       34327 |
|       32764 |
|       34089 |
|       32205 |
|       32204 |

 


tables: name: example programs
data: example programs.csv
name: roster example
data: roster example.csv
name: school ID
data: school ID.csv
name: student fact
data: student fact.csv
label: roster example
school ID
school ID
school ID
example programs
Person ID
student fact
person ID
roster example
person ID
student fact
person ID
output: {
    "joins": [
        {
            "from_table": "roster example",
            "from_column": "school ID",
            "to_table": "school ID",
            "to_column": "school ID"
        },
        {
            "from_table": "example programs",
            "from_column": "Person ID",
            "to_table": "student fact",
            "to_column": "person ID"
        },
        {
            "from_table": "roster example",
            "from_column": "person ID",
            "to_table": "student fact",
            "to_column": "person ID"
        }
    ]
}