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: AEROLINEA
|   IDAEROLINEA | NOMBREAEROLINEA                                      | CODIGOAEROLINEA   |
|--------------:|:-----------------------------------------------------|:------------------|
|             1 | Titan Airways                                        | 02Q               |
|             2 | Tradewind Aviation                                   | 04Q               |
|             3 | Comlux Aviation, AG                                  | 05Q               |
|             4 | Master Top Linhas Aereas Ltd.                        | 06Q               |
|             5 | Flair Airlines Ltd.                                  | 07Q               |
|             6 | Swift Air, LLC d/b/a Eastern Air Lines d/b/a Eastern | 09Q               |
|             7 | DCA                                                  | 0BQ               |
|             8 | ACM AIR CHARTER GmbH                                 | 0CQ               |
|             9 | Maine Aviation Aircraft Charter, LLC                 | 0FQ               |
|            10 | Inter Island Airways, d/b/a Inter Island Air         | 0GQ               |


Table: AEROPUERTO
|   IDAEROPUERTO | NOMBREAEROPUERTO                    | CIUDAD     | CIUDADESCONESTADO   | ESTADO       | ACRONIMOESTADO   |   CIUDADNUMHABITANTES | CIUDADTIMEZONE   |
|---------------:|:------------------------------------|:-----------|:--------------------|:-------------|:-----------------|----------------------:|:-----------------|
|          10136 | Abilene Regional                    | Abilene    | Abilene, TX         | Texas        | TX               |                121721 | America/Chicago  |
|          10141 | Aberdeen Regional                   | Aberdeen   | Aberdeen, SD        | South Dakota | SD               |                 28102 | America/Chicago  |
|          10155 | Waco Regional                       | Waco       | Waco, TX            | Texas        | TX               |                132356 | America/Chicago  |
|          10185 | Alexandria International            | Alexandria | Alexandria, LA      | Louisiana    | LA               |                 47889 | America/Chicago  |
|          10268 | Waterloo Regional                   | Waterloo   | Waterloo, IA        | Iowa         | IA               |                 68460 | America/Chicago  |
|          10279 | Rick Husband Amarillo International | Amarillo   | Amarillo, TX        | Texas        | TX               |                198645 | America/Chicago  |
|          10408 | Appleton International              | Appleton   | Appleton, WI        | Wisconsin    | WI               |                 74139 | America/Chicago  |
|          10409 | Watertown Regional                  | Watertown  | Watertown, SD       | South Dakota | SD               |                 22073 | America/Chicago  |
|          10423 | Austin - Bergstrom International    | Austin     | Austin, TX          | Texas        | TX               |                931830 | America/Chicago  |
|          10562 | Mobile Downtown                     | Mobile     | Mobile, AL          | Alabama      | AL               |                194288 | America/Chicago  |


Table: AVION
|   IDAVION | NOMBREMODELOAVION   | CODIGOMODELOAVION   | MATRICULAAVION   |
|----------:|:--------------------|:--------------------|:-----------------|
|         1 |                     |                     | N951WN           |
|         2 |                     |                     | N467WN           |
|         3 |                     |                     | N7885A           |
|         4 |                     |                     | N551WN           |
|         5 |                     |                     | N968WN           |
|         6 |                     |                     | N7856A           |
|         7 |                     |                     | N7735A           |
|         8 |                     |                     | N405WN           |
|         9 |                     |                     | N489WN           |
|        10 |                     |                     | N7708E           |


Table: FECHA
|   IDFECHA | DESCRIPCIONCOMPLETAFECHA   | NOMBREDIASEMANA   |   NUMDIAENMES | NOMBREMES   |   NUMMESENA��O | A��OMES      |   CUATRIMESTRE | A��OCUATRIMESTRE   | INDICADORDEFINDESEMANA   |   A��O |
|----------:|:---------------------------|:------------------|--------------:|:------------|---------------:|:-------------|---------------:|:-------------------|:-------------------------|-------:|
|         1 | 2020-01-01                 | Lunes             |             1 | Enero       |              1 | Enero/2020   |              1 | Q1/2020            | No                       |   2020 |
|         2 | 2020-02-01                 | Martes            |             1 | Febrero     |              2 | Febrero/2020 |              1 | Q1/2020            | No                       |   2020 |
|         3 | 2020-02-02                 | Mi��rcoles        |             2 | Febrero     |              2 | Febrero/2020 |              1 | Q1/2020            | No                       |   2020 |
|         4 | 2020-01-06                 | S��bado           |             6 | Enero       |              1 | Enero/2020   |              1 | Q1/2020            | Si                       |   2020 |
|         5 | 2020-01-07                 | Domingo           |             7 | Enero       |              1 | Enero/2020   |              1 | Q1/2020            | Si                       |   2020 |
|         6 | 2020-01-04                 | Jueves            |             4 | Enero       |              1 | Enero/2020   |              1 | Q1/2020            | No                       |   2020 |
|         7 | 2020-01-20                 | S��bado           |            20 | Enero       |              1 | Enero/2020   |              1 | Q1/2020            | Si                       |   2020 |
|         8 | 2020-01-05                 | Viernes           |             5 | Enero       |              1 | Enero/2020   |              1 | Q1/2020            | No                       |   2020 |
|         9 | 2020-01-02                 | Martes            |             2 | Enero       |              1 | Enero/2020   |              1 | Q1/2020            | No                       |   2020 |
|        10 | 2020-01-09                 | Martes            |             9 | Enero       |              1 | Enero/2020   |              1 | Q1/2020            | No                       |   2020 |


Table: HORA
|   IDHORA | HORAMINUTOS24HORAS   | HORAMINUTOSAMPM   | INDICARAMPM   |
|---------:|:---------------------|:------------------|:--------------|
|        2 | 11:46                | 11:46AM           | AM            |
|        5 | 9:16                 | 9:16AM            | AM            |
|        6 | 6:02                 | 6:02AM            | AM            |
|        9 | 12:25                | 12:25AM           | AM            |
|       10 | 7:40                 | 7:40AM            | AM            |
|       11 | 10:22                | 10:22AM           | AM            |
|       15 | 12:30                | 12:30AM           | AM            |
|       16 | 6:29                 | 6:29AM            | AM            |
|       19 | 10:45                | 10:45AM           | AM            |
|       21 | 12:56                | 12:56AM           | AM            |


Table: OPERADORA
|   IDOPERADORA | CODIGOOPERADORA   | NOMBREOPERADORA                                      |
|--------------:|:------------------|:-----------------------------------------------------|
|             1 | 02Q               | Titan Airways                                        |
|             2 | 04Q               | Tradewind Aviation                                   |
|             3 | 05Q               | Comlux Aviation, AG                                  |
|             4 | 06Q               | Master Top Linhas Aereas Ltd.                        |
|             5 | 07Q               | Flair Airlines Ltd.                                  |
|             6 | 09Q               | Swift Air, LLC d/b/a Eastern Air Lines d/b/a Eastern |
|             7 | 0BQ               | DCA                                                  |
|             8 | 0CQ               | ACM AIR CHARTER GmbH                                 |
|             9 | 0FQ               | Maine Aviation Aircraft Charter, LLC                 |
|            10 | 0GQ               | Inter Island Airways, d/b/a Inter Island Air         |


Table: VUELOS
|   IDHORASALIDAREAL |   IDFECHASALIDA |   IDAVION |   IDFECHALLEGADA |   IDHORALLEGADAREAL |   IDAEROLINEA |   IDAEROPUERTODESTINO |   IDAEROPUERTOORIGEN |   IDOPERADORA |   NUMEROVUELO |   TIEMPOREALVUELO |   TIEMPOESTIMADOVUELO |   TIEMPODERETRASOLLEGADA |   TIEMPODERETRASOSALIDA |   TIEMPOADELANTADOLLEGADA |
|-------------------:|----------------:|----------:|-----------------:|--------------------:|--------------:|----------------------:|---------------------:|--------------:|--------------:|------------------:|----------------------:|-------------------------:|------------------------:|--------------------------:|
|                  7 |              19 |      1696 |               19 |                 614 |           184 |                 11298 |                12892 |           184 |          2733 |               170 |                   176 |                        0 |                       0 |                         0 |
|                 10 |               4 |      1494 |                4 |                  42 |           184 |                 11298 |                12892 |           184 |           702 |               167 |                   184 |                        0 |                       0 |                         0 |
|                 47 |               5 |      1530 |                5 |                 260 |           184 |                 11298 |                12892 |           184 |          1953 |               177 |                   183 |                        0 |                       0 |                         0 |
|                 55 |               7 |      1745 |                7 |                 438 |           184 |                 11298 |                12892 |           184 |          1953 |               172 |                   183 |                        0 |                       0 |                         0 |
|                 55 |              21 |      1401 |               21 |                  99 |           184 |                 11298 |                12892 |           184 |          1953 |               181 |                   183 |                        0 |                       0 |                         0 |
|                 55 |              22 |      1880 |               22 |                 170 |           184 |                 11298 |                12892 |           184 |          1953 |               166 |                   183 |                        0 |                       0 |                         0 |
|                 55 |              28 |      1749 |               28 |                  78 |           184 |                 11298 |                12892 |           184 |          1953 |               173 |                   183 |                        0 |                       0 |                         0 |
|                 58 |              14 |      1627 |               14 |                 194 |           184 |                 11298 |                12892 |           184 |          2733 |               166 |                   176 |                        0 |                       0 |                         0 |
|                 58 |              15 |      1250 |               15 |                 222 |           184 |                 11298 |                12892 |           184 |          2733 |               167 |                   176 |                        0 |                       0 |                         0 |
|                 58 |              27 |      2086 |               27 |                 312 |           184 |                 11298 |                12892 |           184 |          2733 |               162 |                   176 |                        0 |                       0 |                         0 |

 


tables: name: AEROLINEA
data: AEROLINEA.csv
name: AEROPUERTO
data: AEROPUERTO.csv
name: AVION
data: AVION.csv
name: FECHA
data: FECHA.csv
name: HORA
data: HORA.csv
name: OPERADORA
data: OPERADORA.csv
name: VUELOS
data: VUELOS.csv
label: VUELOS
IDAEROLINEA
AEROLINEA
IDAEROLINEA
VUELOS
IDAEROPUERTODESTINO
AEROPUERTO
IDAEROPUERTO
VUELOS
IDAVION
AVION
IDAVION
VUELOS
IDFECHALLEGADA
FECHA
IDFECHA
VUELOS
IDHORALLEGADAREAL
HORA
IDHORA
VUELOS
IDOPERADORA
OPERADORA
IDOPERADORA
output: {
    "joins": [
        {
            "from_table": "VUELOS",
            "from_column": "IDAEROLINEA",
            "to_table": "AEROLINEA",
            "to_column": "IDAEROLINEA"
        },
        {
            "from_table": "VUELOS",
            "from_column": "IDAEROPUERTODESTINO",
            "to_table": "AEROPUERTO",
            "to_column": "IDAEROPUERTO"
        },
        {
            "from_table": "VUELOS",
            "from_column": "IDAVION",
            "to_table": "AVION",
            "to_column": "IDAVION"
        },
        {
            "from_table": "VUELOS",
            "from_column": "IDFECHALLEGADA",
            "to_table": "FECHA",
            "to_column": "IDFECHA"
        },
        {
            "from_table": "VUELOS",
            "from_column": "IDHORALLEGADAREAL",
            "to_table": "HORA",
            "to_column": "IDHORA"
        },
        {
            "from_table": "VUELOS",
            "from_column": "IDOPERADORA",
            "to_table": "OPERADORA",
            "to_column": "IDOPERADORA"
        }
    ]
}