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: dCalendario
| Data                    |   Ano |   Mês |   Dia |   Dia da Semana |   Trimestre | Mes-Ano   |   Class Mes-Ano | Nome do Mês   |
|:------------------------|------:|------:|------:|----------------:|------------:|:----------|----------------:|:--------------|
| 2018-07-01 00:00:00.000 |  2018 |     7 |     1 |               0 |           3 | jul-2018  |          201807 | jul           |
| 2018-07-02 00:00:00.000 |  2018 |     7 |     2 |               1 |           3 | jul-2018  |          201807 | jul           |
| 2018-07-03 00:00:00.000 |  2018 |     7 |     3 |               2 |           3 | jul-2018  |          201807 | jul           |
| 2018-07-04 00:00:00.000 |  2018 |     7 |     4 |               3 |           3 | jul-2018  |          201807 | jul           |
| 2018-07-05 00:00:00.000 |  2018 |     7 |     5 |               4 |           3 | jul-2018  |          201807 | jul           |
| 2018-07-06 00:00:00.000 |  2018 |     7 |     6 |               5 |           3 | jul-2018  |          201807 | jul           |
| 2018-07-07 00:00:00.000 |  2018 |     7 |     7 |               6 |           3 | jul-2018  |          201807 | jul           |
| 2018-07-08 00:00:00.000 |  2018 |     7 |     8 |               0 |           3 | jul-2018  |          201807 | jul           |
| 2018-07-09 00:00:00.000 |  2018 |     7 |     9 |               1 |           3 | jul-2018  |          201807 | jul           |
| 2018-07-10 00:00:00.000 |  2018 |     7 |    10 |               2 |           3 | jul-2018  |          201807 | jul           |


Table: dFiliais
| ID_Filial   | Filial          | Url Imagem                                                                  |
|:------------|:----------------|:----------------------------------------------------------------------------|
| FL001       | Filial Central  | https://uploaddeimagens.com.br/images/002/792/726/full/Colmeia_Central.png  |
| FL001       | Filial Central  | https://uploaddeimagens.com.br/images/002/792/726/full/Colmeia_Central.png  |
| FL001       | Filial Central  | https://uploaddeimagens.com.br/images/002/792/726/full/Colmeia_Central.png  |
| FL001       | Filial Central  | https://uploaddeimagens.com.br/images/002/792/726/full/Colmeia_Central.png  |
| FL002       | Filial Nordeste | https://uploaddeimagens.com.br/images/002/792/742/full/v2uFKtKm_400x400.jpg |
| FL002       | Filial Nordeste | https://uploaddeimagens.com.br/images/002/792/742/full/v2uFKtKm_400x400.jpg |
| FL002       | Filial Nordeste | https://uploaddeimagens.com.br/images/002/792/742/full/v2uFKtKm_400x400.jpg |
| FL003       | Filial Norte    | https://uploaddeimagens.com.br/images/002/792/739/full/Colmeia_Norte.jpg    |
| FL003       | Filial Norte    | https://uploaddeimagens.com.br/images/002/792/739/full/Colmeia_Norte.jpg    |
| FL003       | Filial Norte    | https://uploaddeimagens.com.br/images/002/792/739/full/Colmeia_Norte.jpg    |


Table: dGuinches
| ID_Guinche   | Nome      | Cidade           | Estado   |
|:-------------|:----------|:-----------------|:---------|
| GUI001       | Guichê 01 | Salvador         | BA       |
| GUI002       | Guichê 02 | Feira de Santana | BA       |
| GUI003       | Guichê 03 | Ilhéus           | BA       |
| GUI004       | Guichê 04 | Porto Seguro     | BA       |
| GUI005       | Guichê 05 | Alagoinhas       | BA       |
| GUI006       | Guichê 06 | Brasilia         | DF       |
| GUI007       | Guichê 07 | Gama             | DF       |
| GUI008       | Guichê 08 | Ceilândia        | DF       |
| GUI009       | Guichê 09 | Taguatinga       | DF       |
| GUI010       | Guichê 10 | Planaltina       | DF       |


Table: dPracasdevenda
| ID_PracaVenda   | Cidade           | Estado   |
|:----------------|:-----------------|:---------|
| PVBA01          | Salvador         | BA       |
| PVBA02          | Feira de Santana | BA       |
| PVBA03          | Ilhéus           | BA       |
| PVBA04          | Porto Seguro     | BA       |
| PVBA05          | Alagoinhas       | BA       |
| PVDF01          | Brasilia         | DF       |
| PVDF02          | Gama             | DF       |
| PVDF03          | Ceilândia        | DF       |
| PVDF04          | Taguatinga       | DF       |
| PVDF05          | Planaltina       | DF       |


Table: dProduto
| ID_Produto   | Produto         |   Valor |
|:-------------|:----------------|--------:|
| PS001        | Convencional    |      80 |
| PS002        | Executivo       |     100 |
| PS003        | SemiLeito       |     140 |
| PS004        | Leito           |     180 |
| PS005        | Cargas Diversas |      50 |


Table: fVendasGuinche
| Data Venda              | ID_Produto   | ID_PracaVenda   |   QT |    Valor Produto  |    Venda Total   | ID_Filial    |  ID_Guinche    |
|:------------------------|:-------------|:----------------|-----:|------------------:|-----------------:|:-------------|:---------------|
| 2018-11-28 00:00:00.000 | PS004        | PVPA01          |   30 |               180 |             5400 | FL002        | GUI001         |
| 2018-11-29 00:00:00.000 | PS004        | PVPA03          |   30 |               180 |             5400 | FL003        | GUI044         |
| 2018-02-09 00:00:00.000 | PS004        | PVMA02          |   30 |               180 |             5400 | FL002        | GUI018         |
| 2018-08-29 00:00:00.000 | PS004        | PVTO04          |   30 |               180 |             5400 | FL002        | GUI039         |
| 2018-12-12 00:00:00.000 | PS004        | PVRO05          |   30 |               180 |             5400 | FL003        | GUI049         |
| 2018-01-29 00:00:00.000 | PS004        | PVRO01          |   30 |               180 |             5400 | FL003        | GUI031         |
| 2018-03-01 00:00:00.000 | PS004        | PVPA03          |   30 |               180 |             5400 | FL002        | GUI003         |
| 2019-06-01 00:00:00.000 | PS004        | PVMT04          |   30 |               180 |             5400 | FL002        | GUI039         |
| 2019-02-23 00:00:00.000 | PS004        | PVMS02          |   30 |               180 |             5400 | FL003        | GUI048         |
| 2019-06-26 00:00:00.000 | PS004        | PVMS05          |   30 |               180 |             5400 | FL003        | GUI031         |


Table: ImagensFilial
| ID_Filial   | Url Imagem                                                                  |
|:------------|:----------------------------------------------------------------------------|
| FL001       | https://uploaddeimagens.com.br/images/002/792/726/full/Colmeia_Central.png  |
| FL002       | https://uploaddeimagens.com.br/images/002/792/742/full/v2uFKtKm_400x400.jpg |
| FL003       | https://uploaddeimagens.com.br/images/002/792/739/full/Colmeia_Norte.jpg    |

 


tables: name: dCalendario
data: dCalendario.csv
name: dFiliais
data: dFiliais.csv
name: dGuinches
data: dGuinches.csv
name: dPracasdevenda
data: dPracasdevenda.csv
name: dProduto
data: dProduto.csv
name: fVendasGuinche
data: fVendasGuinche.csv
name: ImagensFilial
data: ImagensFilial.csv
label: fVendasGuinche
ID_Produto
dProduto
ID_Produto
fVendasGuinche
 ID_Guinche 
dGuinches
ID_Guinche
fVendasGuinche
ID_PracaVenda
dPracasdevenda
ID_PracaVenda
fVendasGuinche
Data Venda
dCalendario
Data
fVendasGuinche
ID_Filial 
dFiliais
ID_Filial
fVendasGuinche
ID_Filial 
ImagensFilial
ID_Filial
output: {
    "joins": [
        {
            "from_table": "fVendasGuinche",
            "from_column": "ID_Produto",
            "to_table": "dProduto",
            "to_column": "ID_Produto"
        },
        {
            "from_table": "fVendasGuinche",
            "from_column": " ID_Guinche ",
            "to_table": "dGuinches",
            "to_column": "ID_Guinche"
        },
        {
            "from_table": "fVendasGuinche",
            "from_column": "ID_PracaVenda",
            "to_table": "dPracasdevenda",
            "to_column": "ID_PracaVenda"
        },
        {
            "from_table": "fVendasGuinche",
            "from_column": "Data Venda",
            "to_table": "dCalendario",
            "to_column": "Data"
        },
        {
            "from_table": "fVendasGuinche",
            "from_column": "ID_Filial ",
            "to_table": "dFiliais",
            "to_column": "ID_Filial"
        },
        {
            "from_table": "fVendasGuinche",
            "from_column": "ID_Filial ",
            "to_table": "ImagensFilial",
            "to_column": "ID_Filial"
        }
    ]
}