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: Calendario
| Data                    |   Ano | Nome do Mês   | Nome do Dia   |   Trimestre |
|:------------------------|------:|:--------------|:--------------|------------:|
| 2020-07-01 00:00:00.000 |  2020 | julho         | quarta-feira  |           3 |
| 2020-07-02 00:00:00.000 |  2020 | julho         | quinta-feira  |           3 |
| 2020-07-03 00:00:00.000 |  2020 | julho         | sexta-feira   |           3 |
| 2020-07-04 00:00:00.000 |  2020 | julho         | sábado        |           3 |
| 2020-07-05 00:00:00.000 |  2020 | julho         | domingo       |           3 |
| 2020-07-06 00:00:00.000 |  2020 | julho         | segunda-feira |           3 |
| 2020-07-07 00:00:00.000 |  2020 | julho         | terça-feira   |           3 |
| 2020-07-08 00:00:00.000 |  2020 | julho         | quarta-feira  |           3 |
| 2020-07-09 00:00:00.000 |  2020 | julho         | quinta-feira  |           3 |
| 2020-07-10 00:00:00.000 |  2020 | julho         | sexta-feira   |           3 |


Table: META_2017
| DATA                    |   TOTAL_VENDA |   VALOR_CANCELADO |   NUMERO_CUPOM_FISCAL | forma_pagamento   | Vendedor   |
|:------------------------|--------------:|------------------:|----------------------:|:------------------|:-----------|
| 2017-12-01 00:00:00.000 |          46.9 |                 0 |                  5802 | DINHEIRO          | Bia        |
| 2017-12-02 00:00:00.000 |          46.9 |                 0 |                  5927 | DINHEIRO          | Bia        |
| 2017-12-03 00:00:00.000 |          46.9 |                 0 |                  6105 | DINHEIRO          | Bia        |
| 2017-12-03 00:00:00.000 |          46.9 |                 0 |                  6114 | DINHEIRO          | Bia        |
| 2017-12-03 00:00:00.000 |          46.9 |                 0 |                  6183 | DINHEIRO          | Bia        |
| 2017-12-06 00:00:00.000 |          46.9 |                 0 |                  6722 | DINHEIRO          | Bia        |
| 2017-12-08 00:00:00.000 |          46.9 |                 0 |                  7086 | DINHEIRO          | Bia        |
| 2017-12-08 00:00:00.000 |          46.9 |                 0 |                  7091 | DINHEIRO          | Bia        |
| 2017-12-09 00:00:00.000 |          46.9 |                 0 |                  7261 | DINHEIRO          | Bia        |
| 2017-12-09 00:00:00.000 |          46.9 |                 0 |                  7275 | DINHEIRO          | Bia        |


Table: META_2018
| DATA                    |   TOTAL_VENDA |   VALOR_CANCELADO |   NUMERO_CUPOM_FISCAL | Vendedor   | forma_pagamento   |
|:------------------------|--------------:|------------------:|----------------------:|:-----------|:------------------|
| 2018-12-17 00:00:00.000 |          34.9 |                 0 |                    14 | Julio      | C.Credito         |
| 2018-12-17 00:00:00.000 |          34.9 |                 0 |                    25 | Julio      | C.Debito          |
| 2018-12-18 00:00:00.000 |          34.9 |                 0 |                    43 | Julio      | C.Debito          |
| 2018-12-18 00:00:00.000 |          34.9 |                 0 |                    46 | Julio      | Dinheiro          |
| 2018-12-18 00:00:00.000 |          34.9 |                 0 |                    49 | Julio      | C.Debito          |
| 2018-12-18 00:00:00.000 |          34.9 |                 0 |                    51 | Julio      | Dinheiro          |
| 2018-12-18 00:00:00.000 |          34.9 |                 0 |                    58 | Julio      | Dinheiro          |
| 2018-12-18 00:00:00.000 |          34.9 |                 0 |                    65 | Julio      | C.Credito         |
| 2018-12-18 00:00:00.000 |          34.9 |                 0 |                    68 | Julio      | Dinheiro          |
| 2018-12-18 00:00:00.000 |          34.9 |                 0 |                    69 | Julio      | Dinheiro          |


Table: META_2019
| DATA                    |   TOTAL_VENDA |   VALOR_CANCELADO |   NUMERO_CUPOM_FISCAL | Vendedor   | forma_pagamento   |
|:------------------------|--------------:|------------------:|----------------------:|:-----------|:------------------|
| 2019-01-27 00:00:00.000 |           224 |                 0 |                  3006 | Paulo      | Dinheiro          |
| 2019-01-21 00:00:00.000 |           630 |                 0 |                  2822 | Paulo      | Dinheiro          |
| 2019-01-24 00:00:00.000 |           409 |                 0 |                  2918 | Paulo      | Dinheiro          |
| 2019-01-26 00:00:00.000 |           224 |                 0 |                  2965 | Paulo      | Dinheiro          |
| 2019-01-27 00:00:00.000 |           352 |                 0 |                  3016 | Paulo      | C.Credito         |
| 2019-01-28 00:00:00.000 |           616 |                 0 |                  3031 | Paulo      | C.Debito          |
| 2019-01-25 00:00:00.000 |           587 |                 0 |                  2945 | Paulo      | Dinheiro          |
| 2019-01-28 00:00:00.000 |           258 |                 0 |                  3048 | Paulo      | Dinheiro          |
| 2019-01-25 00:00:00.000 |           288 |                 0 |                  2947 | Paulo      | Dinheiro          |
| 2019-01-21 00:00:00.000 |           604 |                 0 |                  2851 | Paulo      | Dinheiro          |


Table: UNION
| DATA                    |   TOTAL_VENDA |   VALOR_CANCELADO |   NUMERO_CUPOM_FISCAL | forma_pagamento   | Vendedor   |
|:------------------------|--------------:|------------------:|----------------------:|:------------------|:-----------|
| 2017-12-01 00:00:00.000 |          46.9 |                 0 |                  5802 | DINHEIRO          | Bia        |
| 2017-12-02 00:00:00.000 |          46.9 |                 0 |                  5927 | DINHEIRO          | Bia        |
| 2017-12-03 00:00:00.000 |          46.9 |                 0 |                  6105 | DINHEIRO          | Bia        |
| 2017-12-03 00:00:00.000 |          46.9 |                 0 |                  6114 | DINHEIRO          | Bia        |
| 2017-12-03 00:00:00.000 |          46.9 |                 0 |                  6183 | DINHEIRO          | Bia        |
| 2017-12-06 00:00:00.000 |          46.9 |                 0 |                  6722 | DINHEIRO          | Bia        |
| 2017-12-08 00:00:00.000 |          46.9 |                 0 |                  7086 | DINHEIRO          | Bia        |
| 2017-12-08 00:00:00.000 |          46.9 |                 0 |                  7091 | DINHEIRO          | Bia        |
| 2017-12-09 00:00:00.000 |          46.9 |                 0 |                  7261 | DINHEIRO          | Bia        |
| 2017-12-09 00:00:00.000 |          46.9 |                 0 |                  7275 | DINHEIRO          | Bia        |

 


tables: name: Calendario
data: Calendario.csv
name: META_2017
data: META_2017.csv
name: META_2018
data: META_2018.csv
name: META_2019
data: META_2019.csv
name: UNION
data: UNION.csv
label: META_2018
DATA
Calendario
Data
META_2017
DATA
Calendario
Data
META_2019
DATA
Calendario
Data
UNION
DATA
Calendario
Data
output: {
    "joins": [
        {
            "from_table": "META_2018",
            "from_column": "DATA",
            "to_table": "Calendario",
            "to_column": "Data"
        },
        {
            "from_table": "META_2017",
            "from_column": "DATA",
            "to_table": "Calendario",
            "to_column": "Data"
        },
        {
            "from_table": "META_2019",
            "from_column": "DATA",
            "to_table": "Calendario",
            "to_column": "Data"
        },
        {
            "from_table": "UNION",
            "from_column": "DATA",
            "to_table": "Calendario",
            "to_column": "Data"
        }
    ]
}