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: Award
| Company name   | Award Date              |
|:---------------|:------------------------|
| xyz            | 2020-09-01 00:00:00.000 |
| xyz            | 2020-10-02 00:00:00.000 |
| xyz            | 2020-11-04 00:00:00.000 |
| xyz            | 2021-01-02 00:00:00.000 |
| abc            | 2021-12-01 00:00:00.000 |
| abc            | 2021-10-10 00:00:00.000 |
| yyz            | 2021-01-02 00:00:00.000 |
| yyz            | 2021-02-02 00:00:00.000 |


Table: Calendar
| Date                    | Month   |
|:------------------------|:--------|
| 2021-01-01 00:00:00.000 | 01/2021 |
| 2021-01-02 00:00:00.000 | 01/2021 |
| 2021-01-03 00:00:00.000 | 01/2021 |
| 2021-01-04 00:00:00.000 | 01/2021 |
| 2021-01-05 00:00:00.000 | 01/2021 |
| 2021-01-06 00:00:00.000 | 01/2021 |
| 2021-01-07 00:00:00.000 | 01/2021 |
| 2021-01-08 00:00:00.000 | 01/2021 |
| 2021-01-09 00:00:00.000 | 01/2021 |
| 2021-01-10 00:00:00.000 | 01/2021 |


Table: Data
| ID   | Order   |
|:-----|:--------|
| TR1  | T2      |
| TR1  | T1      |
| TR1  | T3      |
| TR1  | T4      |
| TR1  | T5      |
| TR1  | T6      |
| TR1  | R1      |
| TR2  | T1      |
| TR3  | T2      |
| TR4  | T3      |


Table: Priority
| Order   |   Priority |
|:--------|-----------:|
| R1      |          1 |
| T1      |          2 |
| T2      |          3 |
| T3      |          4 |
| T4      |          5 |
| T5      |          6 |
| T6      |          7 |


Table: Report
| ID   | (Desired Result) Order   | Order   |
|:-----|:-------------------------|:--------|
| TR1  | R1                       | R1      |
| TR2  | T1                       | T1      |
| TR3  | T2                       | T2      |
| TR4  | T3                       | T3      |
| TR5  | T1                       | T1      |
| TR20 | No                       | No      |


Table: Table 2
| My Column   |
|:------------|
| TR1         |
| TR1         |
| TR1         |
| TR1         |
| TR1         |
| TR1         |
| TR1         |
| TR2         |
| TR3         |
| TR4         |


Table: Table
| Name   | Date                    |   Score | Month   |
|:-------|:------------------------|--------:|:--------|
| Jack   | 2021-01-01 00:00:00.000 |       2 | 01/2021 |
| Jill   | 2021-01-02 00:00:00.000 |       3 | 01/2021 |
| Joe    | 2021-01-01 00:00:00.000 |       1 | 01/2021 |
| Jack   | 2021-01-09 00:00:00.000 |       1 | 01/2021 |
| Jill   | 2021-01-10 00:00:00.000 |       2 | 01/2021 |
| Joe    | 2021-01-12 00:00:00.000 |       1 | 01/2021 |
| Joe    | 2021-02-03 00:00:00.000 |       1 | 02/2021 |
| Jill   | 2021-02-18 00:00:00.000 |       3 | 02/2021 |
| Joe    | 2021-02-19 00:00:00.000 |       1 | 02/2021 |
| Jill   | 2021-03-02 00:00:00.000 |       2 | 03/2021 |


Table: TableA
| Column1   | Column2   | Output   |
|:----------|:----------|:---------|
| A         | B         | B        |
| B         | C         | C        |
| C         | A         | A        |
|           |           | A        |
|           |           | B        |
|           |           | C        |

 


tables: name: Award
data: Award.csv
name: Calendar
data: Calendar.csv
name: Data
data: Data.csv
name: Priority
data: Priority.csv
name: Report
data: Report.csv
name: Table 2
data: Table 2.csv
name: Table
data: Table.csv
name: TableA
data: TableA.csv
label: Data
ID
Report
ID
Data
Order
Priority
Order
output: {
    "joins": [
        {
            "from_table": "Data",
            "from_column": "ID",
            "to_table": "Report",
            "to_column": "ID"
        },
        {
            "from_table": "Data",
            "from_column": "Order",
            "to_table": "Priority",
            "to_column": "Order"
        }
    ]
}