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: Categoria
|   CategoriaID | Categoria       | Departamento   | Descricao                  |
|--------------:|:----------------|:---------------|:---------------------------|
|             1 | Mens Clothes    | Clothing       | Fashion for Men            |
|             2 | Womens wear     | Clothing       | Fashion for Women          |
|             3 | Sportwear       | Clothing       | Clothing for Active Adults |
|             4 | Bath Clothes    | Clothing       | Beachwear                  |
|             5 | Womens Footwear | Shoes          | Ladies Shoes               |
|             6 | Mens Footwear   | Shoes          | Men Shoes                  |
|             7 | Childrens wear  | Clothing       | 3-15 Years                 |
|             8 | Babywear        | Clothing       | 0-3 Years                  |


Table: Clientes
|   ClienteID | Cliente                 | NomeContato            | Endereco                       | Cidade      | Pais    | PaisCodigo   | Regiao        | CEP   |   Latitude |   Longitude | Fax            | Telefone       |
|------------:|:------------------------|:-----------------------|:-------------------------------|:------------|:--------|:-------------|:--------------|:------|-----------:|------------:|:---------------|:---------------|
|           1 | Eintrach GS             | Albert von Einstein    | Obere Str. 57                  | Berlin      | Germany | DE           | Europe        | 12209 |    52.4015 |   13.0997   | 030-0076545    | 030-0074321    |
|           2 | La Tienda de la Esquina | Paco el Maco           | Avda. de la Constitución 2222  | Mexico City | Mexico  | MX           | North America | 5021  |    19.6319 |  -99.1334   | (5) 555-3745   | (5) 555-4729   |
|           3 | La Ropa Vieja           | Sancho Panza           | C/ Ritual de lo Habitual  2312 | Mexico City | Mexico  | MX           | North America | 5023  |    19.5457 |  -99.139    | NULL           | (5) 555-3932   |
|           4 | Dr Jims Trousers        | Carl Montgomery        | 120 Hanover Sq.                | London      | UK      | GB           | Europe        | NULL  |    51.5416 |   -0.224499 | (171) 555-6750 | (171) 555-7788 |
|           5 | Urras Shop              | Urra Gurra Aktersnurra | Berguvsvägen  8                | Gothenburg  | Sweden  | SE           | Europe        | NULL  |    57.8118 |   12.2267   | 0921-12 34 67  | 0921-12 34 65  |
|           6 | Man Kleider             | Herman Hinschler       | Forsterstr. 57                 | Mannheim    | Germany | DE           | Europe        | 68306 |    49.502  |    8.50687  | 0621-08924     | 0621-08460     |
|           7 | Menàge à Trois          | Julie Binoché          | 24, place Kléber               | Strasbourg  | France  | FR           | Europe        | 67000 |    48.7837 |    7.54466  | 88.60.15.32    | 88.60.15.31    |
|           8 | Las Corbatas            | Julio Iglesias         | C/ de Don Quijote, 67          | Madrid      | Spain   | ES           | Europe        | 28023 |    40.4262 |   -3.71241  | (91) 555 91 99 | (91) 555 22 82 |
|           9 | La Legion Mercenaire    | Bernard de Gaule       | 12, rue des Bouchers           | Marseille   | France  | FR           | Europe        | 13008 |    43.2611 |    5.38866  | 91.24.45.41    | 91.24.45.40    |
|          10 | Big Foot Shoes          | James Hendersson       | 23 Tsawassen Blvd.             | Vancouver   | Canada  | CA           | North America | NULL  |    49.0301 | -123.098    | (604) 555-3745 | (604) 555-4729 |


Table: dataset_final
| Data                    |   ClienteID |   FuncionarioID |   ValorFrete |   CupomID | EmpresaFrete   | DataEntrega             | Cliente      | Cidade    | Pais   | Regiao        | CEP   |   Extensao | NomeFuncionario   | Genero   | DataAdmissao            |   Escritorio | Supervisor        | Cargo                |   SalarioAnual |   MetaVendas |   ProdutoID |   Quantidade |    Valor |   Desconto |      Custo |   ValorLiquido |   CategoriaID | Produto               |   FornecedorID | Categoria    | Departamento   | Descricao                  | Fornecedor              | FornecedorPais   |   diaVenda |   mesVenda |   anoVenda | diaSemanaVenda   |   prazoEntrega |   totalProduto | estacao   |
|:------------------------|------------:|----------------:|-------------:|----------:|:---------------|:------------------------|:-------------|:----------|:-------|:--------------|:------|-----------:|:------------------|:---------|:------------------------|-------------:|:------------------|:---------------------|---------------:|-------------:|------------:|-------------:|---------:|-----------:|-----------:|---------------:|--------------:|:----------------------|---------------:|:-------------|:---------------|:---------------------------|:------------------------|:-----------------|-----------:|-----------:|-----------:|:-----------------|---------------:|---------------:|:----------|
| 2016-11-21 00:00:00.000 |          62 |               3 |        20.01 |     10637 | One Liners     | 2016-11-24 00:00:00.000 | Roba di Piel | Sao Paulo | Brazil | South America |       |       1020 | Rob Carsson       | M        | 2012-10-01 00:00:00.000 |            1 | Fletcher G. Mason | Sales Representative |         193000 |      3600000 |          11 |           10 |   267.7  |          0 |   216.837  |        50.863  |             1 | Desperado Jeans       |              5 | Mens Clothes | Clothing       | Fashion for Men            | Los Hombres Machos      | Spain            |         21 |         11 |       2016 | Monday           |              3 |            509 | primavera |
| 2017-06-09 00:00:00.000 |          62 |               3 |        24.03 |     10868 | One Liners     | 2017-06-24 00:00:00.000 | Roba di Piel | Sao Paulo | Brazil | South America |       |       1020 | Rob Carsson       | M        | 2012-10-01 00:00:00.000 |            1 | Fletcher G. Mason | Sales Representative |         193000 |      3600000 |          35 |           30 |   187.2  |          0 |   165.11   |        22.0896 |             4 | LA. Shorts            |             16 | Bath Clothes | Clothing       | Beachwear                  | Smooth Clothes          | USA              |          9 |          6 |       2017 | Friday           |             15 |            663 | outono    |
| 2017-06-09 00:00:00.000 |          62 |               3 |        24.03 |     10868 | One Liners     | 2017-06-24 00:00:00.000 | Roba di Piel | Sao Paulo | Brazil | South America |       |       1020 | Rob Carsson       | M        | 2012-10-01 00:00:00.000 |            1 | Fletcher G. Mason | Sales Representative |         193000 |      3600000 |          26 |           20 |   666.4  |          0 |   587.765  |        78.6352 |             3 | Bike Helmet           |             11 | Sportwear    | Clothing       | Clothing for Active Adults | Der Bahnhof             | Germany          |          9 |          6 |       2017 | Friday           |             15 |           1573 | outono    |
| 2017-02-05 00:00:00.000 |          62 |               3 |        31.39 |     10728 | One Liners     | 2017-02-09 00:00:00.000 | Roba di Piel | Sao Paulo | Brazil | South America |       |       1020 | Rob Carsson       | M        | 2012-10-01 00:00:00.000 |            1 | Fletcher G. Mason | Sales Representative |         193000 |      3600000 |          60 |           15 |    79.95 |          0 |    64.7595 |        15.1905 |             3 | Game Over T-Shirt     |             28 | Sportwear    | Clothing       | Clothing for Active Adults | FrisersAfrong           | France           |          5 |          2 |       2017 | Sunday           |              4 |            228 | verão     |
| 2017-02-05 00:00:00.000 |          62 |               3 |        31.39 |     10728 | One Liners     | 2017-02-09 00:00:00.000 | Roba di Piel | Sao Paulo | Brazil | South America |       |       1020 | Rob Carsson       | M        | 2012-10-01 00:00:00.000 |            1 | Fletcher G. Mason | Sales Representative |         193000 |      3600000 |          40 |            6 |   106.92 |          0 |    86.6052 |        20.3148 |             8 | Duck Trousers         |             19 | Babywear     | Clothing       | 0-3 Years                  | Mayflower               | USA              |          5 |          2 |       2017 | Sunday           |              4 |            122 | verão     |
| 2017-02-05 00:00:00.000 |          62 |               3 |        31.39 |     10728 | One Liners     | 2017-02-09 00:00:00.000 | Roba di Piel | Sao Paulo | Brazil | South America |       |       1020 | Rob Carsson       | M        | 2012-10-01 00:00:00.000 |            1 | Fletcher G. Mason | Sales Representative |         193000 |      3600000 |          30 |           15 |   356.25 |          0 |   288.562  |        67.6875 |             8 | Baby Dark Lounge Suit |             13 | Babywear     | Clothing       | 0-3 Years                  | Executive Clothing GMBH | Germany          |          5 |          2 |       2017 | Sunday           |              4 |           1015 | verão     |
| 2017-02-05 00:00:00.000 |          62 |               3 |        31.39 |     10728 | One Liners     | 2017-02-09 00:00:00.000 | Roba di Piel | Sao Paulo | Brazil | South America |       |       1020 | Rob Carsson       | M        | 2012-10-01 00:00:00.000 |            1 | Fletcher G. Mason | Sales Representative |         193000 |      3600000 |          55 |           12 |   450.84 |          0 |   365.18   |        85.6596 |             3 | Feiss Fleece Trousers |             25 | Sportwear    | Clothing       | Clothing for Active Adults | Mountain International  | Canada           |          5 |          2 |       2017 | Sunday           |              4 |           1028 | verão     |
| 2017-05-31 00:00:00.000 |          62 |               3 |        40.33 |     10913 | One Liners     | 2017-06-11 00:00:00.000 | Roba di Piel | Sao Paulo | Brazil | South America |       |       1020 | Rob Carsson       | M        | 2012-10-01 00:00:00.000 |            1 | Fletcher G. Mason | Sales Representative |         193000 |      3600000 |          58 |           15 |   774.45 |          0 |   683.065  |        91.3851 |             8 | Ga-Ga Dress           |             27 | Babywear     | Clothing       | 0-3 Years                  | Gal Export              | France           |         31 |          5 |       2017 | Wednesday        |             11 |           1371 | outono    |
| 2017-11-30 00:00:00.000 |          62 |               3 |        72.38 |     10914 | One Liners     | 2017-12-14 00:00:00.000 | Roba di Piel | Sao Paulo | Brazil | South America |       |       1020 | Rob Carsson       | M        | 2012-10-01 00:00:00.000 |            1 | Fletcher G. Mason | Sales Representative |         193000 |      3600000 |          71 |           25 |   750.75 |          0 |   662.162  |        88.5885 |             1 | Atles Lussekofta      |             15 | Mens Clothes | Clothing       | Fashion for Men            | Bar Åkeri               | Norway           |         30 |         11 |       2017 | Thursday         |             14 |           2215 | primavera |
| 2017-06-24 00:00:00.000 |          62 |               3 |        74.31 |     10961 | One Liners     | 2017-07-06 00:00:00.000 | Roba di Piel | Sao Paulo | Brazil | South America |       |       1020 | Rob Carsson       | M        | 2012-10-01 00:00:00.000 |            1 | Fletcher G. Mason | Sales Representative |         193000 |      3600000 |          76 |           60 | 23334.6  |          0 | 20581.1    |      2753.48   |             2 | Minnki Pälsii         |             23 | Womens wear  | Clothing       | Fashion for Women          | Nordik Koskenkorva      | Finland          |         24 |          6 |       2017 | Saturday         |             12 |         165209 | inverno   |


Table: Escritorios
|   Escritorios | EscritorioLocalizacao   |
|--------------:|:------------------------|
|             1 | Stockholm               |
|             2 | Lund                    |
|             3 | Paris                   |
|             4 | Nice                    |
|             5 | Seattle                 |


Table: FatoCabecalho_DadosModelagem
| Data                    |   ClienteID |   FuncionarioID |   ValorFrete |   CupomID | EmpresaFrete   | DataEntrega             |
|:------------------------|------------:|----------------:|-------------:|----------:|:---------------|:------------------------|
| 2016-11-21 00:00:00.000 |          62 |               3 |        20.01 |     10637 | One Liners     | 2016-11-24 00:00:00.000 |
| 2017-09-16 00:00:00.000 |          64 |               3 |        20.36 |     11019 | One Liners     | 2017-10-03 00:00:00.000 |
| 2017-11-11 00:00:00.000 |          54 |               3 |        21.39 |     10531 | One Liners     | 2017-11-25 00:00:00.000 |
| 2018-03-30 00:00:00.000 |          19 |               3 |        21.76 |     11047 | One Liners     | 2018-04-15 00:00:00.000 |
| 2017-11-26 00:00:00.000 |          35 |               3 |        21.92 |     10901 | One Liners     | 2017-12-15 00:00:00.000 |
| 2016-10-18 00:00:00.000 |          19 |               3 |        22.56 |     10256 | One Liners     | 2016-10-30 00:00:00.000 |
| 2017-01-19 00:00:00.000 |          31 |               3 |        22.66 |     10709 | One Liners     | 2017-02-03 00:00:00.000 |
| 2017-01-23 00:00:00.000 |          37 |               3 |        23.09 |     10712 | One Liners     | 2017-02-03 00:00:00.000 |
| 2015-07-27 00:00:00.000 |          46 |               3 |        23.11 |     10543 | One Liners     | 2015-08-13 00:00:00.000 |
| 2015-06-16 00:00:00.000 |          37 |               3 |        23.33 |     10442 | One Liners     | 2015-06-17 00:00:00.000 |


Table: FatoDetalhes_DadosModelagem
|   CupomID |   ProdutoID |   Quantidade |   Valor |   Desconto |    Custo |   ValorLiquido |   valorTotal |
|----------:|------------:|-------------:|--------:|-----------:|---------:|---------------:|-------------:|
|     10356 |          69 |           20 |    41   |          0 |  35.424  |         5.576  |      111.52  |
|     10934 |           6 |           20 |    74   |          0 |  65.268  |         8.732  |      174.64  |
|     10763 |          24 |           20 |    87.4 |          0 |  70.794  |        16.606  |      332.12  |
|     11073 |          24 |           20 |    92   |          0 |  81.144  |        10.856  |      217.12  |
|     10984 |          24 |           20 |    92.8 |          0 |  81.8496 |        10.9504 |      219.008 |
|     10695 |          24 |           20 |    98.4 |          0 |  79.704  |        18.696  |      373.92  |
|     10626 |          60 |           20 |    99   |          0 |  80.19   |        18.81   |      376.2   |
|     10464 |          60 |           20 |   103.6 |          0 |  85.7808 |        17.8192 |      356.384 |
|     10821 |          35 |           20 |   117   |          0 |  94.77   |        22.23   |      444.6   |
|     10958 |           5 |           20 |   123.4 |          0 | 108.839  |        14.5612 |      291.224 |


Table: Fornecedores
|   FornecedorID | Fornecedor         | FornecedorContato   | FornecedorPais   |
|---------------:|:-------------------|:--------------------|:-----------------|
|              1 | Sunny Clothes      | Peter Shilton       | UK               |
|              2 | Big L              | James Brown         | USA              |
|              3 | Dressed for Succes | Glenn Miller        | USA              |
|              4 | Nitsuchiba         | James Sushi         | Japan            |
|              5 | Los Hombres Machos | Antonio Banderas    | Spain            |
|              6 | SatSUMAs           | Hirosho Tayoto      | Japan            |
|              7 | New Balls          | Pat Cash            | Australia        |
|              8 | Hot Pants          | David Leg           | UK               |
|              9 | Goa Kläder         | Tomas Ravelli       | Sweden           |
|             10 | Samba              | Ronaldinho          | Brazil           |


Table: Funcionarios
|   FuncionarioID |   Extensao | NomeFuncionario   | Genero   | DataAdmissao            |   Escritorio | Supervisor        | Cargo                |   SalarioAnual | MetaVendas   |
|----------------:|-----------:|:------------------|:---------|:------------------------|-------------:|:------------------|:---------------------|---------------:|:-------------|
|              11 |        501 | Rock Rollman      | M        | 2012-10-01 00:00:00.000 |            5 | Fletcher G. Mason | Sales Representative |         135000 | 300000       |
|               2 |        101 | Eli Preston       | M        | 2011-09-15 00:00:00.000 |            1 | Fletcher G. Mason | Sales Representative |          97000 | 90000        |
|               3 |        102 | Rob Carsson       | M        | 2012-10-01 00:00:00.000 |            1 | Fletcher G. Mason | Sales Representative |         193000 | 360000       |
|              14 |        301 | Joan Callins      | F        | 2012-09-03 00:00:00.000 |            3 | Yvette E. Irwin   | Sales Manager        |          83000 | 90000        |
|               5 |        302 | Ingrid Hendrix    | F        | 2013-10-17 00:00:00.000 |            3 | Fletcher G. Mason | Sales Representative |         111300 | 100000       |
|              56 |        401 | Lennart Skoglund  | M        | 2012-01-18 00:00:00.000 |            4 | Fletcher G. Mason | Sales Representative |         121200 | 150000       |
|               7 |        201 | Tom Lindwall      | M        | 2013-11-22 00:00:00.000 |            2 | Fletcher G. Mason | Sales Representative |         181000 | 340000       |
|              68 |        202 | Leif Shine        | M        | 2012-03-05 00:00:00.000 |            2 | Dorian X. Banks   | Sales Coordinator    |         165000 | 320000       |
|               9 |        103 | Helen Brolin      | F        | 2013-02-15 00:00:00.000 |            1 | Fletcher G. Mason | Sales Representative |         137000 | 250000       |
|              17 |        222 | David Lesterman   | M        | 2011-10-11 00:00:00.000 |            2 | Xander Z. Miller  | Product Manager      |          75500 |              |


Table: Produtos
|   ProdutoID |   CategoriaID | Produto           |   FornecedorID |
|------------:|--------------:|:------------------|---------------:|
|           1 |             1 | Lenin Jeansshorts |              1 |
|           2 |             1 | Mr X Trousers     |              1 |
|           3 |             2 | Chantell Shirt    |              1 |
|           4 |             2 | Oyaki Kimono      |              2 |
|           5 |             1 | O-Man Underwear   |              2 |
|           6 |             2 | Shagall Socks     |              3 |
|           7 |             7 | Conserve Shoes    |              3 |
|           8 |             2 | Tuxedo            |              3 |
|           9 |             6 | Fuji Boots        |              4 |
|          10 |             8 | Sapporoo Gloves   |              4 |

 


tables: name: Categoria
data: Categoria.csv
name: Clientes
data: Clientes.csv
name: dataset_final
data: dataset_final.csv
name: Escritorios
data: Escritorios.csv
name: FatoCabecalho_DadosModelagem
data: FatoCabecalho_DadosModelagem.csv
name: FatoDetalhes_DadosModelagem
data: FatoDetalhes_DadosModelagem.csv
name: Fornecedores
data: Fornecedores.csv
name: Funcionarios
data: Funcionarios.csv
name: Produtos
data: Produtos.csv
label: FatoDetalhes_DadosModelagem
CupomID
FatoCabecalho_DadosModelagem
CupomID
FatoDetalhes_DadosModelagem
ProdutoID
Produtos
ProdutoID
FatoCabecalho_DadosModelagem
ClienteID
Clientes
ClienteID
FatoCabecalho_DadosModelagem
FuncionarioID
Funcionarios
FuncionarioID
Produtos
CategoriaID
Categoria
CategoriaID
Produtos
FornecedorID
Fornecedores
FornecedorID
output: {
    "joins": [
        {
            "from_table": "FatoDetalhes_DadosModelagem",
            "from_column": "CupomID",
            "to_table": "FatoCabecalho_DadosModelagem",
            "to_column": "CupomID"
        },
        {
            "from_table": "FatoDetalhes_DadosModelagem",
            "from_column": "ProdutoID",
            "to_table": "Produtos",
            "to_column": "ProdutoID"
        },
        {
            "from_table": "FatoCabecalho_DadosModelagem",
            "from_column": "ClienteID",
            "to_table": "Clientes",
            "to_column": "ClienteID"
        },
        {
            "from_table": "FatoCabecalho_DadosModelagem",
            "from_column": "FuncionarioID",
            "to_table": "Funcionarios",
            "to_column": "FuncionarioID"
        },
        {
            "from_table": "Produtos",
            "from_column": "CategoriaID",
            "to_table": "Categoria",
            "to_column": "CategoriaID"
        },
        {
            "from_table": "Produtos",
            "from_column": "FornecedorID",
            "to_table": "Fornecedores",
            "to_column": "FornecedorID"
        }
    ]
}