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: %ObjetivoReban╠âo
|   %ObjetivoRebaño |
|------------------:|
|              0.5  |
|              0.55 |
|              0.6  |
|              0.65 |
|              0.7  |
|              0.75 |
|              0.8  |
|              0.85 |
|              0.9  |
|              0.95 |


Table: COVID 19
| iso_code   |   CountryID | date                    |   total_cases |   new_cases |   total_deaths |   new_deaths |
|:-----------|------------:|:------------------------|--------------:|------------:|---------------:|-------------:|
| VUT        |         178 | 2021-06-16 00:00:00.000 |             4 |           0 |              1 |            0 |
| VUT        |         178 | 2021-06-17 00:00:00.000 |             4 |           0 |              1 |            0 |
| VUT        |         178 | 2021-06-18 00:00:00.000 |             4 |           0 |              1 |            0 |
| VUT        |         178 | 2021-06-19 00:00:00.000 |             4 |           0 |              1 |            0 |
| VUT        |         178 | 2021-06-20 00:00:00.000 |             4 |           0 |              1 |            0 |
| VUT        |         178 | 2021-06-21 00:00:00.000 |             4 |           0 |              1 |            0 |
| VUT        |         178 | 2021-06-22 00:00:00.000 |             4 |           0 |              1 |            0 |
| VUT        |         178 | 2021-06-23 00:00:00.000 |             4 |           0 |              1 |            0 |
| VUT        |         178 | 2021-06-24 00:00:00.000 |             4 |           0 |              1 |            0 |
| VUT        |         178 | 2021-06-25 00:00:00.000 |             4 |           0 |              1 |            0 |


Table: COVID_19
| iso_code   |   CountryID | date                    |   total_cases |   new_cases |   total_deaths |   new_deaths |
|:-----------|------------:|:------------------------|--------------:|------------:|---------------:|-------------:|
| VUT        |         178 | 2021-04-22 00:00:00.000 |             4 |           0 |              1 |            0 |
| VUT        |         178 | 2021-04-23 00:00:00.000 |             4 |           0 |              1 |            0 |
| VUT        |         178 | 2021-04-24 00:00:00.000 |             4 |           0 |              1 |            0 |
| VUT        |         178 | 2021-04-25 00:00:00.000 |             4 |           0 |              1 |            0 |
| VUT        |         178 | 2021-04-26 00:00:00.000 |             4 |           0 |              1 |            0 |
| VUT        |         178 | 2021-04-27 00:00:00.000 |             4 |           0 |              1 |            0 |
| VUT        |         178 | 2021-04-28 00:00:00.000 |             4 |           0 |              1 |            0 |
| VUT        |         178 | 2021-04-29 00:00:00.000 |             4 |           0 |              1 |            0 |
| VUT        |         178 | 2021-04-30 00:00:00.000 |             4 |           0 |              1 |            0 |
| VUT        |         178 | 2021-05-01 00:00:00.000 |             4 |           0 |              1 |            0 |


Table: Economia
|   CountryID |   Ranking |   ef_2021_score |           GDP |   Gasto público | ef_world_rank (Top 10)   | Tipo de ingreso Como Columna   |
|------------:|----------:|----------------:|--------------:|----------------:|:-------------------------|:-------------------------------|
|           1 |       146 |              53 |   76624000000 |            76.1 | Otros                    | Ingreso Bajo                   |
|           2 |        66 |              65 |   39832000000 |            74.6 | Otros                    | Ingreso Medio                  |
|           3 |       162 |              50 |  668827000000 |            55.4 | Otros                    | Ingreso Alto                   |
|           4 |       140 |              54 |  200830000000 |            86.9 | Otros                    | Ingreso Medio                  |
|           5 |       148 |              53 |  911562000000 |            52.8 | Otros                    | Ingreso Alto                   |
|           6 |        32 |              72 |   33426000000 |            81.3 | Otros                    | Ingreso Medio                  |
|           7 |         3 |              82 | 1362070000000 |            58.1 | Top 10                   | Ingreso Muy Alto               |
|           8 |        25 |              74 |  476812000000 |            29.1 | Otros                    | Ingreso Muy Alto               |
|           9 |        38 |              70 |  187346000000 |            65.2 | Otros                    | Ingreso Alto                   |
|          10 |        70 |              65 |   12798000000 |            87.6 | Otros                    | Ingreso Muy Alto               |


Table: Factores_Riesgo (2)
| iso_code   | country_id   | date                    | extreme_poverty   | cardiovasc_death_rate   | diabetes_prevalence   | female_smokers   | male_smokers   |
|:-----------|:-------------|:------------------------|:------------------|:------------------------|:----------------------|:-----------------|:---------------|
| FRO        |              | 2021-06-16 00:00:00.000 |                   |                         |                       |                  |                |
| FRO        |              | 2021-06-17 00:00:00.000 |                   |                         |                       |                  |                |
| FRO        |              | 2021-06-18 00:00:00.000 |                   |                         |                       |                  |                |
| FRO        |              | 2021-06-19 00:00:00.000 |                   |                         |                       |                  |                |
| FRO        |              | 2021-06-20 00:00:00.000 |                   |                         |                       |                  |                |
| FRO        |              | 2021-06-21 00:00:00.000 |                   |                         |                       |                  |                |
| FRO        |              | 2021-06-22 00:00:00.000 |                   |                         |                       |                  |                |
| FRO        |              | 2021-06-23 00:00:00.000 |                   |                         |                       |                  |                |
| FRO        |              | 2021-06-24 00:00:00.000 |                   |                         |                       |                  |                |
| FRO        |              | 2021-06-25 00:00:00.000 |                   |                         |                       |                  |                |


Table: Factores_Riesgo
| iso_code   | country_id   | date                    | extreme_poverty   | cardiovasc_death_rate   | diabetes_prevalence   | female_smokers   | male_smokers   |
|:-----------|:-------------|:------------------------|:------------------|:------------------------|:----------------------|:-----------------|:---------------|
| OWID_ASI   |              | 2020-01-22 00:00:00.000 |                   |                         |                       |                  |                |
| OWID_ASI   |              | 2020-01-23 00:00:00.000 |                   |                         |                       |                  |                |
| OWID_ASI   |              | 2020-01-24 00:00:00.000 |                   |                         |                       |                  |                |
| OWID_ASI   |              | 2020-01-25 00:00:00.000 |                   |                         |                       |                  |                |
| OWID_ASI   |              | 2020-01-26 00:00:00.000 |                   |                         |                       |                  |                |
| OWID_ASI   |              | 2020-01-27 00:00:00.000 |                   |                         |                       |                  |                |
| OWID_ASI   |              | 2020-01-28 00:00:00.000 |                   |                         |                       |                  |                |
| OWID_ASI   |              | 2020-01-29 00:00:00.000 |                   |                         |                       |                  |                |
| OWID_ASI   |              | 2020-01-30 00:00:00.000 |                   |                         |                       |                  |                |
| OWID_ASI   |              | 2020-01-31 00:00:00.000 |                   |                         |                       |                  |                |


Table: Medidas_sanitarias (2)
| iso_code   | country_id   | date                    | icu_patients   | total_tests   | new_tests   | total_vaccinations   | new_vaccinations   | people_vaccinated_per_hundred   | people_fully_vaccinated_per_hundred   |
|:-----------|:-------------|:------------------------|:---------------|:--------------|:------------|:---------------------|:-------------------|:--------------------------------|:--------------------------------------|
| OWID_INT   |              | 2021-06-16 00:00:00.000 |                |               |             |                      |                    |                                 |                                       |
| OWID_INT   |              | 2021-06-17 00:00:00.000 |                |               |             |                      |                    |                                 |                                       |
| OWID_INT   |              | 2021-06-18 00:00:00.000 |                |               |             |                      |                    |                                 |                                       |
| OWID_INT   |              | 2021-06-19 00:00:00.000 |                |               |             |                      |                    |                                 |                                       |
| OWID_INT   |              | 2021-06-20 00:00:00.000 |                |               |             |                      |                    |                                 |                                       |
| OWID_INT   |              | 2021-06-21 00:00:00.000 |                |               |             |                      |                    |                                 |                                       |
| OWID_INT   |              | 2021-06-22 00:00:00.000 |                |               |             |                      |                    |                                 |                                       |
| OWID_INT   |              | 2021-06-23 00:00:00.000 |                |               |             |                      |                    |                                 |                                       |
| OWID_INT   |              | 2021-06-24 00:00:00.000 |                |               |             |                      |                    |                                 |                                       |
| OWID_INT   |              | 2021-06-25 00:00:00.000 |                |               |             |                      |                    |                                 |                                       |


Table: Medidas_sanitarias
| iso_code   | CountryID   | date                    | icu_patients   | total_tests   | new_tests   | total_vaccinations   | new_vaccinations   | people_vaccinated_per_hundred   | people_fully_vaccinated_per_hundred   | Poblacion   | country_id   |
|:-----------|:------------|:------------------------|:---------------|:--------------|:------------|:---------------------|:-------------------|:--------------------------------|:--------------------------------------|:------------|:-------------|
| OWID_INT   |             | 2020-02-07 00:00:00.000 |                |               |             |                      |                    |                                 |                                       |             |              |
| OWID_INT   |             | 2020-02-08 00:00:00.000 |                |               |             |                      |                    |                                 |                                       |             |              |
| OWID_INT   |             | 2020-02-09 00:00:00.000 |                |               |             |                      |                    |                                 |                                       |             |              |
| OWID_INT   |             | 2020-02-10 00:00:00.000 |                |               |             |                      |                    |                                 |                                       |             |              |
| OWID_INT   |             | 2020-02-11 00:00:00.000 |                |               |             |                      |                    |                                 |                                       |             |              |
| OWID_INT   |             | 2020-02-12 00:00:00.000 |                |               |             |                      |                    |                                 |                                       |             |              |
| OWID_INT   |             | 2020-02-13 00:00:00.000 |                |               |             |                      |                    |                                 |                                       |             |              |
| OWID_INT   |             | 2020-02-14 00:00:00.000 |                |               |             |                      |                    |                                 |                                       |             |              |
| OWID_INT   |             | 2020-02-15 00:00:00.000 |                |               |             |                      |                    |                                 |                                       |             |              |
| OWID_INT   |             | 2020-02-16 00:00:00.000 |                |               |             |                      |                    |                                 |                                       |             |              |


Table: Pais
|   CountryID | iso_code   | País        | continent     |   Población | country_name_reducido   | Continente_sin_discriminar_sudamerica_de_norteamerica   |
|------------:|:-----------|:------------|:--------------|------------:|:------------------------|:--------------------------------------------------------|
|           1 | AFG        | Afghanistan | Asia          |    38041754 | Afg.                    | Asia                                                    |
|           2 | ALB        | Albania     | Europe        |     2854191 | Alb.                    | Europe                                                  |
|           3 | DZA        | Algeria     | Africa        |    43053054 | Alg.                    | Africa                                                  |
|           4 | AGO        | Angola      | Africa        |    31825295 | Ang.                    | Africa                                                  |
|           5 | ARG        | Argentina   | South America |    44938712 | Arg.                    | America                                                 |
|           6 | ARM        | Armenia     | Asia          |     2957731 | Arm.                    | Asia                                                    |
|           7 | AUS        | Australia   | Oceania       |    25364307 | Aus.                    | Oceania                                                 |
|           8 | AUT        | Austria     | Europe        |     8877067 | Aus.                    | Europe                                                  |
|           9 | AZE        | Azerbaijan  | Asia          |    10023318 | Aze.                    | Asia                                                    |
|          10 | BHS        | Bahamas     | North America |      389482 | Bah.                    | America                                                 |


Table: Pai╠üs vs Vacunacio╠ün
| iso_code   |   % Vacunación | Estado de Vacunación   |
|:-----------|---------------:|:-----------------------|
| ABW        |          64.07 | Mayor a 60%            |
| AFG        |           0.56 | Menor a 30%            |
| AGO        |           2.21 | Menor a 30%            |
| AIA        |          59.76 | Entre 30 y 60%         |
| ALB        |          19.99 | Menor a 30%            |
| AND        |          52.57 | Entre 30 y 60%         |
| ARE        |          73.6  | Mayor a 60%            |
| ARG        |          23.87 | Menor a 30%            |
| ARM        |           2.55 | Menor a 30%            |
| ATG        |          32.93 | Entre 30 y 60%         |


Table: tabla_calendario
| Fecha                   |   FechaSK |   Año |   Trimestre |   Mes |   AñoMes |   Semana |   Dia |   DiaSemana |   NbAño | NbTrimestre   | NbTrimestreAño   | NbMes   | nbMes3L   | NbDia   | NbSemana   | NdDiaSemana   |
|:------------------------|----------:|------:|------------:|------:|---------:|---------:|------:|------------:|--------:|:--------------|:-----------------|:--------|:----------|:--------|:-----------|:--------------|
| 2020-07-01 00:00:00.000 |  20200701 |  2020 |           3 |     7 |   202007 |       27 |     1 |           3 |    2020 | T3            | T3/20            | julio   | jul       | 1 jul   | Sem 27 /20 | miércoles     |
| 2020-07-02 00:00:00.000 |  20200702 |  2020 |           3 |     7 |   202007 |       27 |     2 |           4 |    2020 | T3            | T3/20            | julio   | jul       | 2 jul   | Sem 27 /20 | jueves        |
| 2020-07-03 00:00:00.000 |  20200703 |  2020 |           3 |     7 |   202007 |       27 |     3 |           5 |    2020 | T3            | T3/20            | julio   | jul       | 3 jul   | Sem 27 /20 | viernes       |
| 2020-07-04 00:00:00.000 |  20200704 |  2020 |           3 |     7 |   202007 |       27 |     4 |           6 |    2020 | T3            | T3/20            | julio   | jul       | 4 jul   | Sem 27 /20 | sábado        |
| 2020-07-05 00:00:00.000 |  20200705 |  2020 |           3 |     7 |   202007 |       27 |     5 |           7 |    2020 | T3            | T3/20            | julio   | jul       | 5 jul   | Sem 27 /20 | domingo       |
| 2020-07-06 00:00:00.000 |  20200706 |  2020 |           3 |     7 |   202007 |       28 |     6 |           1 |    2020 | T3            | T3/20            | julio   | jul       | 6 jul   | Sem 28 /20 | lunes         |
| 2020-07-07 00:00:00.000 |  20200707 |  2020 |           3 |     7 |   202007 |       28 |     7 |           2 |    2020 | T3            | T3/20            | julio   | jul       | 7 jul   | Sem 28 /20 | martes        |
| 2020-07-08 00:00:00.000 |  20200708 |  2020 |           3 |     7 |   202007 |       28 |     8 |           3 |    2020 | T3            | T3/20            | julio   | jul       | 8 jul   | Sem 28 /20 | miércoles     |
| 2020-07-09 00:00:00.000 |  20200709 |  2020 |           3 |     7 |   202007 |       28 |     9 |           4 |    2020 | T3            | T3/20            | julio   | jul       | 9 jul   | Sem 28 /20 | jueves        |
| 2020-07-10 00:00:00.000 |  20200710 |  2020 |           3 |     7 |   202007 |       28 |    10 |           5 |    2020 | T3            | T3/20            | julio   | jul       | 10 jul  | Sem 28 /20 | viernes       |


Table: Tabla_Medidas_Calculadas


 


tables: name: %ObjetivoReban╠âo
data: %ObjetivoReban╠âo.csv
name: COVID 19
data: COVID 19.csv
name: COVID_19
data: COVID_19.csv
name: Economia
data: Economia.csv
name: Factores_Riesgo (2)
data: Factores_Riesgo (2).csv
name: Factores_Riesgo
data: Factores_Riesgo.csv
name: Medidas_sanitarias (2)
data: Medidas_sanitarias (2).csv
name: Medidas_sanitarias
data: Medidas_sanitarias.csv
name: Pais
data: Pais.csv
name: Pai╠üs vs Vacunacio╠ün
data: Pai╠üs vs Vacunacio╠ün.csv
name: tabla_calendario
data: tabla_calendario.csv
name: Tabla_Medidas_Calculadas
data: Tabla_Medidas_Calculadas.csv
label: Pais
CountryID
Economia
CountryID
COVID_19
iso_code
Pais
iso_code
Medidas_sanitarias
iso_code
Pais
iso_code
Factores_Riesgo
iso_code
Pais
iso_code
Factores_Riesgo
date
tabla_calendario
Fecha
Medidas_sanitarias
date
tabla_calendario
Fecha
COVID_19
date
tabla_calendario
Fecha
output: {
    "joins": [
        {
            "from_table": "Pais",
            "from_column": "CountryID",
            "to_table": "Economia",
            "to_column": "CountryID"
        },
        {
            "from_table": "COVID_19",
            "from_column": "iso_code",
            "to_table": "Pais",
            "to_column": "iso_code"
        },
        {
            "from_table": "Medidas_sanitarias",
            "from_column": "iso_code",
            "to_table": "Pais",
            "to_column": "iso_code"
        },
        {
            "from_table": "Factores_Riesgo",
            "from_column": "iso_code",
            "to_table": "Pais",
            "to_column": "iso_code"
        },
        {
            "from_table": "Factores_Riesgo",
            "from_column": "date",
            "to_table": "tabla_calendario",
            "to_column": "Fecha"
        },
        {
            "from_table": "Medidas_sanitarias",
            "from_column": "date",
            "to_table": "tabla_calendario",
            "to_column": "Fecha"
        },
        {
            "from_table": "COVID_19",
            "from_column": "date",
            "to_table": "tabla_calendario",
            "to_column": "Fecha"
        }
    ]
}