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: censoIndia
| India/ State/ Union Territory/ District/ Sub-district   | Name          |   Population |
|:--------------------------------------------------------|:--------------|-------------:|
| SUB-DISTRICT                                            | 'N' Thingdawl |        19840 |
| SUB-DISTRICT                                            | Balod         |       125407 |
| SUB-DISTRICT                                            | Devsar        |        31893 |
| SUB-DISTRICT                                            | Nabadwip      |       135314 |
| SUB-DISTRICT                                            | A.Konduru     |        48463 |
| SUB-DISTRICT                                            | Aali          |       137800 |
| SUB-DISTRICT                                            | Aalo          |        34916 |
| SUB-DISTRICT                                            | Abdasa        |       117538 |
| SUB-DISTRICT                                            | Abhanpur      |       242089 |
| SUB-DISTRICT                                            | Abhyachandpur |        23588 |


Table: censoSelecionados
| cidade       | DISTRICT   | SUB-DISTRICT   |   populacao |
|:-------------|:-----------|:---------------|------------:|
| Agra         | 4418797    | 2186655        |     2186655 |
| Ahmedabad    | 7214225    | 5585528        |     5585528 |
| Allahabad    | 5954391    | 1395816        |     1395816 |
| Amritsar     | 2490656    |                |     2490656 |
| Aurangabad   | 2540073    | 1873567        |     1873567 |
| Bangalore    | 9621551    |                |     9621551 |
| Bhopal       | 2371061    |                |     2371061 |
| Bhubaneshwar |            | 885363         |      885363 |
| Chandigarh   | 1055450    | 1055450        |     1055450 |
| Chennai      | 4646732    |                |     4646732 |


Table: Cidades
| cidade       |   latitude |   longitude |
|:-------------|-----------:|------------:|
| New Delhi    |    27.3982 |     73.9038 |
| Gurgaon      |    27.2447 |     73.7626 |
| Kolkata      |    22.5412 |     88.3725 |
| Mumbai       |    19.1144 |     72.8485 |
| Bangalore    |    12.955  |     77.6344 |
| Pune         |    18.5511 |     73.8497 |
| Hyderabad    |    17.4328 |     78.3963 |
| Secunderabad |    17.4711 |     78.5262 |
| Chennai      |    13.0349 |     80.2382 |
| Lucknow      |    21.7381 |     65.5534 |


Table: cotacao
|   paisID | Moeda   | pais          | sigla   | paraDolar   |
|---------:|:--------|:--------------|:--------|:------------|
|        1 | Rs.     | Índia         | INR     | 0.01335497  |
|       14 | $       | Austrália     | AUD     | 0.7222      |
|       17 | null    | null          | null    |             |
|       30 | R$      | Brasil        | BRL     | 0.19767533  |
|       37 | $       | Canadá        | CAD     | 0.7832173   |
|       94 | IDR     | Indonésia     | IDR     | 6.95401E-05 |
|      148 | NZ$     | Nova Zelândia | NZD     | 0.6735      |
|      162 | P       | Filipinas     | PHP     | 0.01949508  |
|      166 | QR      | Catar         | QAR     | 0.2746499   |
|      184 | $       | Singapura     | SGD     | 0.7431629   |


Table: cozinhas
|   restauranteId | cozinhaEspecifica   |   avaliacaoFaixa |
|----------------:|:--------------------|-----------------:|
|        18454586 | North Indian        |                3 |
|          123294 | North Indian        |                3 |
|          122064 | North Indian        |                3 |
|         1600298 | North Indian        |                3 |
|         1600007 | North Indian        |                3 |
|         1600307 | North Indian        |                3 |
|         1600212 | North Indian        |                3 |
|         2200011 | North Indian        |                3 |
|         2200030 | North Indian        |                3 |
|         2200149 | North Indian        |                3 |


Table: faixasAvaliacao
|   faixasAvaliacao |
|------------------:|
|               0   |
|               0.5 |
|               1   |
|               1.5 |
|               2   |
|               2.5 |
|               3   |
|               3.5 |
|               4   |
|               4.5 |


Table: faixasCustoParaDois
|   faixasCustoParaDois |
|----------------------:|
|                     0 |
|                     5 |
|                    10 |
|                    15 |
|                    20 |
|                    25 |
|                    30 |
|                    35 |
|                    40 |
|                    45 |


Table: Medidas
| Coluna   |
|----------|


Table: ordem Cozinhas
| cozinhaEspecifica   |   Contagem |
|:--------------------|-----------:|
| Continental         |        739 |
| American            |        390 |
| Asian               |        236 |
| North Indian        |       3968 |
| Thai                |        234 |
| European            |        148 |
| Mexican             |        181 |
| Chinese             |       2739 |
| Cafe                |        706 |
| Italian             |        768 |


Table: ordemCidade
| cidade    |   Restaurantes por Cidade |
|:----------|--------------------------:|
| Kolkata   |                        20 |
| Mumbai    |                        20 |
| Bangalore |                        20 |
| Pune      |                        20 |
| Chennai   |                        20 |
| Kochi     |                        20 |
| Jaipur    |                        20 |
| Goa       |                        20 |
| Indore    |                        20 |
| Nashik    |                        20 |


Table: ordemRestaurante
| avaliacaoTexto   |   Personalizar |   avaliacaoFaixa |
|:-----------------|---------------:|-----------------:|
| Very Good        |              4 |                1 |
| Excellent        |              5 |                0 |
| Poor             |              1 |                4 |
| Good             |              3 |                2 |
| Average          |              2 |                3 |
| Not rated        |              0 |                5 |


Table: restaurantes
| temEntrega   | urlFoto                                                                                                                                                           | urlRestaurante                                                                                                                                      |   FaixaPreco | avaliacaoTexto   | avaliacaoCor   |   avaliacaoVotos |   avaliacaoAvaliacao |   restauranteId | restauranteNome            | restauranteCozinhas            |   custoParaDois | restaurants.restaurant.switch_to_order_menu   | temReserva   |   latitude | endereco                                                                            | cidade    |   paisID |   cidadeID | CEP   |   longitude | localidade               | urlImagemDestaque   | Moeda   |   custoParaDoisDolar |   avaliacaoAvaliacao (compartimentos) |   custoParaDoisDolar (compartimentos) |   ordemRestaurante |   avaliacaoFaixa |
|:-------------|:------------------------------------------------------------------------------------------------------------------------------------------------------------------|:----------------------------------------------------------------------------------------------------------------------------------------------------|-------------:|:-----------------|:---------------|-----------------:|---------------------:|----------------:|:---------------------------|:-------------------------------|----------------:|:----------------------------------------------|:-------------|-----------:|:------------------------------------------------------------------------------------|:----------|---------:|-----------:|:------|------------:|:-------------------------|:--------------------|:--------|---------------------:|--------------------------------------:|--------------------------------------:|-------------------:|-----------------:|
| False        | https://www.zomato.com/ncr/shahi-muradabadi-munirka-new-delhi/photos?utm_source=api_basic_user&utm_medium=api&utm_campaign=v2.1#tabtop                            | https://www.zomato.com/ncr/shahi-muradabadi-munirka-new-delhi?utm_source=api_basic_user&utm_medium=api&utm_campaign=v2.1                            |            1 | Not rated        | CBCBC8         |                0 |                    0 |        18025119 | Shahi Muradabadi           | Mughlai                        |             300 | False                                         | False        |          0 | 247/A, Rama Market, Munirka, New Delhi                                              | New Delhi |        1 |          1 |       |           0 | Munirka                  |                     | Rs.     |              4.00649 |                                     0 |                                     0 |                  0 |                5 |
| False        | https://www.zomato.com/ncr/aloo-bhaji-restaurant-okhla-new-delhi/photos?utm_source=api_basic_user&utm_medium=api&utm_campaign=v2.1#tabtop                         | https://www.zomato.com/ncr/aloo-bhaji-restaurant-okhla-new-delhi?utm_source=api_basic_user&utm_medium=api&utm_campaign=v2.1                         |            2 | Not rated        | CBCBC8         |                0 |                    0 |        18432628 | Aloo Bhaji Restaurant      | North Indian                   |             500 | False                                         | False        |          0 | C-19, DDA Sheds, Okhla Phase 1, New Delhi                                           | New Delhi |        1 |          1 |       |           0 | Okhla Phase 1            |                     | Rs.     |              6.67749 |                                     0 |                                     5 |                  0 |                5 |
| False        | https://www.zomato.com/ncr/shree-jagannath-restaurant-qutab-institutional-area-new-delhi/photos?utm_source=api_basic_user&utm_medium=api&utm_campaign=v2.1#tabtop | https://www.zomato.com/ncr/shree-jagannath-restaurant-qutab-institutional-area-new-delhi?utm_source=api_basic_user&utm_medium=api&utm_campaign=v2.1 |            1 | Not rated        | CBCBC8         |                0 |                    0 |        18306540 | Shree Jagannath Restaurant | North Indian                   |             350 | False                                         | False        |          0 | F-44, Gummad Wali Gali, Katwaria Sarai, Qutab Institutional Area, New Delhi         | New Delhi |        1 |          1 |       |           0 | Qutab Institutional Area |                     | Rs.     |              4.67424 |                                     0 |                                     0 |                  0 |                5 |
| False        | https://www.zomato.com/ncr/koolees-milkshake-bar-sarojini-nagar-new-delhi/photos?utm_source=api_basic_user&utm_medium=api&utm_campaign=v2.1#tabtop                | https://www.zomato.com/ncr/koolees-milkshake-bar-sarojini-nagar-new-delhi?utm_source=api_basic_user&utm_medium=api&utm_campaign=v2.1                |            1 | Not rated        | CBCBC8         |                0 |                    0 |        18492652 | Koolees Milkshake Bar      | Beverages                      |             150 | False                                         | False        |          0 | 85, Ring Road Market, Sulekha Vihar, Sarojini Nagar, New Delhi                      | New Delhi |        1 |          1 |       |           0 | Sarojini Nagar           |                     | Rs.     |              2.00325 |                                     0 |                                     0 |                  0 |                5 |
| False        | https://www.zomato.com/ncr/al-kausars-zakir-nagar-new-delhi/photos?utm_source=api_basic_user&utm_medium=api&utm_campaign=v2.1#tabtop                              | https://www.zomato.com/ncr/al-kausars-zakir-nagar-new-delhi?utm_source=api_basic_user&utm_medium=api&utm_campaign=v2.1                              |            1 | Not rated        | CBCBC8         |                0 |                    0 |        18349925 | Al-Kausar's                | Chinese                        |             200 | False                                         | False        |          0 | K-65, Chinar Apartment, Jamia Nagar, Near Zakir Nagar, New Delhi                    | New Delhi |        1 |          1 |       |           0 | Zakir Nagar              |                     | Rs.     |              2.67099 |                                     0 |                                     0 |                  0 |                5 |
| False        | https://www.zomato.com/ncr/delhi-6-foods-daryaganj-new-delhi/photos?utm_source=api_basic_user&utm_medium=api&utm_campaign=v2.1#tabtop                             | https://www.zomato.com/ncr/delhi-6-foods-daryaganj-new-delhi?utm_source=api_basic_user&utm_medium=api&utm_campaign=v2.1                             |            1 | Not rated        | CBCBC8         |                0 |                    0 |        18449652 | Delhi 6 Foods              | North Indian                   |             300 | False                                         | False        |          0 | 3787, Netaji Subhash Marg, Daryaganj, New Delhi                                     | New Delhi |        1 |          1 |       |           0 | Daryaganj                |                     | Rs.     |              4.00649 |                                     0 |                                     0 |                  0 |                5 |
| False        | https://www.zomato.com/ncr/cakery-shakarpur-new-delhi/photos?utm_source=api_basic_user&utm_medium=api&utm_campaign=v2.1#tabtop                                    | https://www.zomato.com/ncr/cakery-shakarpur-new-delhi?utm_source=api_basic_user&utm_medium=api&utm_campaign=v2.1                                    |            2 | Not rated        | CBCBC8         |                0 |                    0 |        18463999 | Cake'ry                    | Bakery                         |             500 | False                                         | False        |          0 | B-125 Main Market, Shakarpur, New Delhi                                             | New Delhi |        1 |          1 |       |           0 | Shakarpur                |                     | Rs.     |              6.67749 |                                     0 |                                     5 |                  0 |                5 |
| False        | https://www.zomato.com/ncr/spice-studio-geeta-colony-new-delhi/photos?utm_source=api_basic_user&utm_medium=api&utm_campaign=v2.1#tabtop                           | https://www.zomato.com/ncr/spice-studio-geeta-colony-new-delhi?utm_source=api_basic_user&utm_medium=api&utm_campaign=v2.1                           |            1 | Not rated        | CBCBC8         |                0 |                    0 |        18472613 | Spice Studio               | Seafood, Mughlai, North Indian |             400 | False                                         | False        |          0 | Shop 17/38, Near Geeta Apartments, Geeta Colony, New Delhi                          | New Delhi |        1 |          1 |       |           0 | Geeta Colony             |                     | Rs.     |              5.34199 |                                     0 |                                     5 |                  0 |                5 |
| False        | https://www.zomato.com/ncr/bawejas-haandi-geeta-colony-new-delhi/photos?utm_source=api_basic_user&utm_medium=api&utm_campaign=v2.1#tabtop                         | https://www.zomato.com/ncr/bawejas-haandi-geeta-colony-new-delhi?utm_source=api_basic_user&utm_medium=api&utm_campaign=v2.1                         |            2 | Not rated        | CBCBC8         |                0 |                    0 |        18455553 | Baweja's Haandi            | North Indian                   |             600 | False                                         | False        |          0 | 11/89, Near Kanchan Studio and Geeta Colony Police Station, Geeta Colony, New Delhi | New Delhi |        1 |          1 |       |           0 | Geeta Colony             |                     | Rs.     |              8.01298 |                                     0 |                                     5 |                  0 |                5 |
| False        | https://www.zomato.com/ncr/parantha-on-call-geeta-colony-new-delhi/photos?utm_source=api_basic_user&utm_medium=api&utm_campaign=v2.1#tabtop                       | https://www.zomato.com/ncr/parantha-on-call-geeta-colony-new-delhi?utm_source=api_basic_user&utm_medium=api&utm_campaign=v2.1                       |            1 | Not rated        | CBCBC8         |                0 |                    0 |        18446496 | Parantha on Call           | North Indian                   |             100 | False                                         | False        |          0 | Geeta Colony, New Delhi                                                             | New Delhi |        1 |          1 |       |           0 | Geeta Colony             |                     | Rs.     |              1.3355  |                                     0 |                                     0 |                  0 |                5 |

 


tables: name: censoIndia
data: censoIndia.csv
name: censoSelecionados
data: censoSelecionados.csv
name: Cidades
data: Cidades.csv
name: cotacao
data: cotacao.csv
name: cozinhas
data: cozinhas.csv
name: faixasAvaliacao
data: faixasAvaliacao.csv
name: faixasCustoParaDois
data: faixasCustoParaDois.csv
name: Medidas
data: Medidas.csv
name: ordem Cozinhas
data: ordem Cozinhas.csv
name: ordemCidade
data: ordemCidade.csv
name: ordemRestaurante
data: ordemRestaurante.csv
name: restaurantes
data: restaurantes.csv
label: cozinhas
restauranteId
restaurantes
restauranteId
restaurantes
paisID
cotacao
paisID
restaurantes
custoParaDoisDolar (compartimentos)
faixasCustoParaDois
faixasCustoParaDois
restaurantes
cidade
censoSelecionados
cidade
restaurantes
avaliacaoAvaliacao (compartimentos)
faixasAvaliacao
faixasAvaliacao
restaurantes
avaliacaoTexto
ordemRestaurante
avaliacaoTexto
output: {
    "joins": [
        {
            "from_table": "cozinhas",
            "from_column": "restauranteId",
            "to_table": "restaurantes",
            "to_column": "restauranteId"
        },
        {
            "from_table": "restaurantes",
            "from_column": "paisID",
            "to_table": "cotacao",
            "to_column": "paisID"
        },
        {
            "from_table": "restaurantes",
            "from_column": "custoParaDoisDolar (compartimentos)",
            "to_table": "faixasCustoParaDois",
            "to_column": "faixasCustoParaDois"
        },
        {
            "from_table": "restaurantes",
            "from_column": "cidade",
            "to_table": "censoSelecionados",
            "to_column": "cidade"
        },
        {
            "from_table": "restaurantes",
            "from_column": "avaliacaoAvaliacao (compartimentos)",
            "to_table": "faixasAvaliacao",
            "to_column": "faixasAvaliacao"
        },
        {
            "from_table": "restaurantes",
            "from_column": "avaliacaoTexto",
            "to_table": "ordemRestaurante",
            "to_column": "avaliacaoTexto"
        }
    ]
}