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: Bill of Material
| Item   | Component   |
|:-------|:------------|
| Item A | Compo 1     |
| Item A | Compo 2     |
| Item A | Compo 3     |
| Item A | Compo 4     |
| Item A | Compo 5     |
| Item A | Compo 6     |
| Item A | Compo 7     |
| Item A | Compo 8     |
| Item A | Compo 9     |
| Item A | Compo 10    |


Table: Budget
| Item   |   Revenue |   Qty | Budget Date             |   Year |
|:-------|----------:|------:|:------------------------|-------:|
| Item A |      3000 |   600 | 2021-01-01 00:00:00.000 |   2021 |
| Item B |       600 |   200 | 2021-01-01 00:00:00.000 |   2021 |
| Item C |      5000 |  1000 | 2021-01-01 00:00:00.000 |   2021 |


Table: Calendar
| Date                    |   Year |   Month | MonthName   | MonthNS   |
|:------------------------|-------:|--------:|:------------|:----------|
| 2019-01-01 00:00:00.000 |   2019 |       1 | janv        | JANV      |
| 2019-01-02 00:00:00.000 |   2019 |       1 | janv        | JANV      |
| 2019-01-03 00:00:00.000 |   2019 |       1 | janv        | JANV      |
| 2019-01-04 00:00:00.000 |   2019 |       1 | janv        | JANV      |
| 2019-01-05 00:00:00.000 |   2019 |       1 | janv        | JANV      |
| 2019-01-06 00:00:00.000 |   2019 |       1 | janv        | JANV      |
| 2019-01-07 00:00:00.000 |   2019 |       1 | janv        | JANV      |
| 2019-01-08 00:00:00.000 |   2019 |       1 | janv        | JANV      |
| 2019-01-09 00:00:00.000 |   2019 |       1 | janv        | JANV      |
| 2019-01-10 00:00:00.000 |   2019 |       1 | janv        | JANV      |


Table: Firm Order
| Item   |   Qty |   Revenue | FO Date                 |   Year |
|:-------|------:|----------:|:------------------------|-------:|
| Item A |   200 |      1000 | 2021-05-05 00:00:00.000 |   2021 |
| Item B |   500 |      1500 | 2021-07-06 00:00:00.000 |   2021 |
| Item C |   300 |      1500 | 2021-10-12 00:00:00.000 |   2021 |


Table: Forecast
| Item   | Forecast Date           |   Qty |   Revenue |   Year |
|:-------|:------------------------|------:|----------:|-------:|
| Item A | 2021-05-20 00:00:00.000 |   100 |       500 |   2021 |
| Item B | 2021-09-01 00:00:00.000 |     0 |         0 |   2021 |
| Item C | 2021-11-25 00:00:00.000 |   500 |      2000 |   2021 |


Table: ITEM
| Item   | Description   |
|:-------|:--------------|
| Item A | Item A        |
| Item B | Item B        |
| Item C | Item C        |


Table: Sales
| Item   | SalesDate               |   Quantity |   Revenue |   Year |
|:-------|:------------------------|-----------:|----------:|-------:|
| Item A | 2019-06-01 00:00:00.000 |        100 |       500 |   2019 |
| Item B | 2019-01-06 00:00:00.000 |        200 |       600 |   2019 |
| Item C | 2019-12-20 00:00:00.000 |        300 |      1800 |   2019 |
| Item A | 2020-02-05 00:00:00.000 |        200 |       900 |   2020 |
| Item B | 2020-07-19 00:00:00.000 |        400 |      1200 |   2020 |
| Item C | 2020-11-20 00:00:00.000 |        400 |      2000 |   2020 |
| Item A | 2021-04-13 00:00:00.000 |        300 |      1500 |   2021 |
| Item B | 2021-03-02 00:00:00.000 |        600 |      1800 |   2021 |
| Item C | 2021-02-26 00:00:00.000 |        500 |      1500 |   2021 |

 


tables: name: Bill of Material
data: Bill of Material.csv
name: Budget
data: Budget.csv
name: Calendar
data: Calendar.csv
name: Firm Order
data: Firm Order.csv
name: Forecast
data: Forecast.csv
name: ITEM
data: ITEM.csv
name: Sales
data: Sales.csv
label: ITEM
Item
Firm Order
Item
Sales
Item
ITEM
Item
Bill of Material
Item
ITEM
Item
ITEM
Item
Budget
Item
ITEM
Item
Forecast
Item
output: {
    "joins": [
        {
            "from_table": "ITEM",
            "from_column": "Item",
            "to_table": "Firm Order",
            "to_column": "Item"
        },
        {
            "from_table": "Sales",
            "from_column": "Item",
            "to_table": "ITEM",
            "to_column": "Item"
        },
        {
            "from_table": "Bill of Material",
            "from_column": "Item",
            "to_table": "ITEM",
            "to_column": "Item"
        },
        {
            "from_table": "ITEM",
            "from_column": "Item",
            "to_table": "Budget",
            "to_column": "Item"
        },
        {
            "from_table": "ITEM",
            "from_column": "Item",
            "to_table": "Forecast",
            "to_column": "Item"
        }
    ]
}