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: Calculations
| Province                  | Province Abbre   |
|:--------------------------|:-----------------|
| ALBERTA                   | AB               |
| BRITISH COLUMBIA          | BC               |
| MANITOBA                  | MB               |
| NEW BRUNSWICK             | NB               |
| NEWFOUNDLAND AND LABRADOR | NL               |
| NORTHWEST TERRITORIES     | NT               |
| NOVA SCOTIA               | NS               |
| NUNAVUT                   | NU               |
| ONTARIO                   | ON               |
| PRINCE EDWARD ISLAND      | PE               |


Table: Electricity Generation
| selection              | province                  | scenario   | year                    |   Electricity Generation | unit   |
|:-----------------------|:--------------------------|:-----------|:------------------------|-------------------------:|:-------|
| ELECTRICITY GENERATION | NEWFOUNDLAND AND LABRADOR | EVOLVING   | 2005-01-01 00:00:00.000 |                  42314.7 | GW.h   |
| ELECTRICITY GENERATION | NEWFOUNDLAND AND LABRADOR | EVOLVING   | 2006-01-01 00:00:00.000 |                  43054.3 | GW.h   |
| ELECTRICITY GENERATION | NEWFOUNDLAND AND LABRADOR | EVOLVING   | 2007-01-01 00:00:00.000 |                  41833.7 | GW.h   |
| ELECTRICITY GENERATION | NEWFOUNDLAND AND LABRADOR | EVOLVING   | 2008-01-01 00:00:00.000 |                  43493.3 | GW.h   |
| ELECTRICITY GENERATION | NEWFOUNDLAND AND LABRADOR | EVOLVING   | 2009-01-01 00:00:00.000 |                  38399.2 | GW.h   |
| ELECTRICITY GENERATION | NEWFOUNDLAND AND LABRADOR | EVOLVING   | 2010-01-01 00:00:00.000 |                  41942   | GW.h   |
| ELECTRICITY GENERATION | NEWFOUNDLAND AND LABRADOR | EVOLVING   | 2011-01-01 00:00:00.000 |                  41720   | GW.h   |
| ELECTRICITY GENERATION | NEWFOUNDLAND AND LABRADOR | EVOLVING   | 2012-01-01 00:00:00.000 |                  43815.3 | GW.h   |
| ELECTRICITY GENERATION | NEWFOUNDLAND AND LABRADOR | EVOLVING   | 2013-01-01 00:00:00.000 |                  43257.8 | GW.h   |
| ELECTRICITY GENERATION | NEWFOUNDLAND AND LABRADOR | EVOLVING   | 2014-01-01 00:00:00.000 |                  41236.7 | GW.h   |


Table: Gas Production
| selection      | province                  | scenario   | year                    |   Gas Production | unit   |
|:---------------|:--------------------------|:-----------|:------------------------|-----------------:|:-------|
| GAS PRODUCTION | NEWFOUNDLAND AND LABRADOR | EVOLVING   | 2005-01-01 00:00:00.000 |                0 | Bcf/d  |
| GAS PRODUCTION | NEWFOUNDLAND AND LABRADOR | EVOLVING   | 2006-01-01 00:00:00.000 |                0 | Bcf/d  |
| GAS PRODUCTION | NEWFOUNDLAND AND LABRADOR | EVOLVING   | 2007-01-01 00:00:00.000 |                0 | Bcf/d  |
| GAS PRODUCTION | NEWFOUNDLAND AND LABRADOR | EVOLVING   | 2008-01-01 00:00:00.000 |                0 | Bcf/d  |
| GAS PRODUCTION | NEWFOUNDLAND AND LABRADOR | EVOLVING   | 2009-01-01 00:00:00.000 |                0 | Bcf/d  |
| GAS PRODUCTION | NEWFOUNDLAND AND LABRADOR | EVOLVING   | 2010-01-01 00:00:00.000 |                0 | Bcf/d  |
| GAS PRODUCTION | NEWFOUNDLAND AND LABRADOR | EVOLVING   | 2011-01-01 00:00:00.000 |                0 | Bcf/d  |
| GAS PRODUCTION | NEWFOUNDLAND AND LABRADOR | EVOLVING   | 2012-01-01 00:00:00.000 |                0 | Bcf/d  |
| GAS PRODUCTION | NEWFOUNDLAND AND LABRADOR | EVOLVING   | 2013-01-01 00:00:00.000 |                0 | Bcf/d  |
| GAS PRODUCTION | NEWFOUNDLAND AND LABRADOR | EVOLVING   | 2014-01-01 00:00:00.000 |                0 | Bcf/d  |


Table: Oil Production
| selection      | province             | scenario   | year                    |   Oil Production | unit   |
|:---------------|:---------------------|:-----------|:------------------------|-----------------:|:-------|
| OIL PRODUCTION | PRINCE EDWARD ISLAND | EVOLVING   | 2005-01-01 00:00:00.000 |                0 | Mb/d   |
| OIL PRODUCTION | PRINCE EDWARD ISLAND | EVOLVING   | 2006-01-01 00:00:00.000 |                0 | Mb/d   |
| OIL PRODUCTION | PRINCE EDWARD ISLAND | EVOLVING   | 2007-01-01 00:00:00.000 |                0 | Mb/d   |
| OIL PRODUCTION | PRINCE EDWARD ISLAND | EVOLVING   | 2008-01-01 00:00:00.000 |                0 | Mb/d   |
| OIL PRODUCTION | PRINCE EDWARD ISLAND | EVOLVING   | 2009-01-01 00:00:00.000 |                0 | Mb/d   |
| OIL PRODUCTION | PRINCE EDWARD ISLAND | EVOLVING   | 2010-01-01 00:00:00.000 |                0 | Mb/d   |
| OIL PRODUCTION | PRINCE EDWARD ISLAND | EVOLVING   | 2011-01-01 00:00:00.000 |                0 | Mb/d   |
| OIL PRODUCTION | PRINCE EDWARD ISLAND | EVOLVING   | 2012-01-01 00:00:00.000 |                0 | Mb/d   |
| OIL PRODUCTION | PRINCE EDWARD ISLAND | EVOLVING   | 2013-01-01 00:00:00.000 |                0 | Mb/d   |
| OIL PRODUCTION | PRINCE EDWARD ISLAND | EVOLVING   | 2014-01-01 00:00:00.000 |                0 | Mb/d   |


Table: Overall Energy Demand
| selection      | province                  | scenario   | year                    |   value | unit   |
|:---------------|:--------------------------|:-----------|:------------------------|--------:|:-------|
| GAS PRODUCTION | NEWFOUNDLAND AND LABRADOR | EVOLVING   | 2005-01-01 00:00:00.000 |       0 | Bcf/d  |
| GAS PRODUCTION | NEWFOUNDLAND AND LABRADOR | EVOLVING   | 2006-01-01 00:00:00.000 |       0 | Bcf/d  |
| GAS PRODUCTION | NEWFOUNDLAND AND LABRADOR | EVOLVING   | 2007-01-01 00:00:00.000 |       0 | Bcf/d  |
| GAS PRODUCTION | NEWFOUNDLAND AND LABRADOR | EVOLVING   | 2008-01-01 00:00:00.000 |       0 | Bcf/d  |
| GAS PRODUCTION | NEWFOUNDLAND AND LABRADOR | EVOLVING   | 2009-01-01 00:00:00.000 |       0 | Bcf/d  |
| GAS PRODUCTION | NEWFOUNDLAND AND LABRADOR | EVOLVING   | 2010-01-01 00:00:00.000 |       0 | Bcf/d  |
| GAS PRODUCTION | NEWFOUNDLAND AND LABRADOR | EVOLVING   | 2011-01-01 00:00:00.000 |       0 | Bcf/d  |
| GAS PRODUCTION | NEWFOUNDLAND AND LABRADOR | EVOLVING   | 2012-01-01 00:00:00.000 |       0 | Bcf/d  |
| GAS PRODUCTION | NEWFOUNDLAND AND LABRADOR | EVOLVING   | 2013-01-01 00:00:00.000 |       0 | Bcf/d  |
| GAS PRODUCTION | NEWFOUNDLAND AND LABRADOR | EVOLVING   | 2014-01-01 00:00:00.000 |       0 | Bcf/d  |


Table: Province Abbre
| Province                  | Province Abbre   |
|:--------------------------|:-----------------|
| ALBERTA                   | AB               |
| BRITISH COLUMBIA          | BC               |
| MANITOBA                  | MB               |
| NEW BRUNSWICK             | NB               |
| NEWFOUNDLAND AND LABRADOR | NL               |
| NORTHWEST TERRITORIES     | NT               |
| NOVA SCOTIA               | NS               |
| NUNAVUT                   | NU               |
| ONTARIO                   | ON               |
| PRINCE EDWARD ISLAND      | PE               |


Table: Scenario
| Scenario   |
|:-----------|
| EVOLVING   |
| REFERENCE  |


Table: Total Energy Demand
| selection    | province                  | scenario   | year                    |   Total Energy Demand | unit   |
|:-------------|:--------------------------|:-----------|:------------------------|----------------------:|:-------|
| TOTAL DEMAND | NEWFOUNDLAND AND LABRADOR | EVOLVING   | 2005-01-01 00:00:00.000 |               72.2829 | Mboe/d |
| TOTAL DEMAND | PRINCE EDWARD ISLAND      | EVOLVING   | 2005-01-01 00:00:00.000 |               11.8538 | Mboe/d |
| TOTAL DEMAND | NOVA SCOTIA               | EVOLVING   | 2005-01-01 00:00:00.000 |              102.766  | Mboe/d |
| TOTAL DEMAND | NEW BRUNSWICK             | EVOLVING   | 2005-01-01 00:00:00.000 |              113.135  | Mboe/d |
| TOTAL DEMAND | QUEBEC                    | EVOLVING   | 2005-01-01 00:00:00.000 |              826.159  | Mboe/d |
| TOTAL DEMAND | ONTARIO                   | EVOLVING   | 2005-01-01 00:00:00.000 |             1361.14   | Mboe/d |
| TOTAL DEMAND | MANITOBA                  | EVOLVING   | 2005-01-01 00:00:00.000 |              129.14   | Mboe/d |
| TOTAL DEMAND | SASKATCHEWAN              | EVOLVING   | 2005-01-01 00:00:00.000 |              238.886  | Mboe/d |
| TOTAL DEMAND | ALBERTA                   | EVOLVING   | 2005-01-01 00:00:00.000 |             1259.72   | Mboe/d |
| TOTAL DEMAND | BRITISH COLUMBIA          | EVOLVING   | 2005-01-01 00:00:00.000 |              562.822  | Mboe/d |


Table: Transport, Residential, Commercial and Industrial Demand
| region   | sector         | source      | scenario   | year                    |   Demand By Sector & Source | unit   |
|:---------|:---------------|:------------|:-----------|:------------------------|----------------------------:|:-------|
| CANADA   | TRANSPORTATION | COAL & COKE | REFERENCE  | 2005-01-01 00:00:00.000 |                           0 | Mboe/d |
| CANADA   | TRANSPORTATION | COAL & COKE | REFERENCE  | 2006-01-01 00:00:00.000 |                           0 | Mboe/d |
| CANADA   | TRANSPORTATION | COAL & COKE | REFERENCE  | 2007-01-01 00:00:00.000 |                           0 | Mboe/d |
| CANADA   | TRANSPORTATION | COAL & COKE | REFERENCE  | 2008-01-01 00:00:00.000 |                           0 | Mboe/d |
| CANADA   | TRANSPORTATION | COAL & COKE | REFERENCE  | 2009-01-01 00:00:00.000 |                           0 | Mboe/d |
| CANADA   | TRANSPORTATION | COAL & COKE | REFERENCE  | 2010-01-01 00:00:00.000 |                           0 | Mboe/d |
| CANADA   | TRANSPORTATION | COAL & COKE | REFERENCE  | 2011-01-01 00:00:00.000 |                           0 | Mboe/d |
| CANADA   | TRANSPORTATION | COAL & COKE | REFERENCE  | 2012-01-01 00:00:00.000 |                           0 | Mboe/d |
| CANADA   | TRANSPORTATION | COAL & COKE | REFERENCE  | 2013-01-01 00:00:00.000 |                           0 | Mboe/d |
| CANADA   | TRANSPORTATION | COAL & COKE | REFERENCE  | 2014-01-01 00:00:00.000 |                           0 | Mboe/d |


Table: Year
| year                    |
|:------------------------|
| 2005-01-01 00:00:00.000 |
| 2006-01-01 00:00:00.000 |
| 2007-01-01 00:00:00.000 |
| 2008-01-01 00:00:00.000 |
| 2009-01-01 00:00:00.000 |
| 2010-01-01 00:00:00.000 |
| 2011-01-01 00:00:00.000 |
| 2012-01-01 00:00:00.000 |
| 2013-01-01 00:00:00.000 |
| 2014-01-01 00:00:00.000 |

 


tables: name: Calculations
data: Calculations.csv
name: Electricity Generation
data: Electricity Generation.csv
name: Gas Production
data: Gas Production.csv
name: Oil Production
data: Oil Production.csv
name: Overall Energy Demand
data: Overall Energy Demand.csv
name: Province Abbre
data: Province Abbre.csv
name: Scenario
data: Scenario.csv
name: Total Energy Demand
data: Total Energy Demand.csv
name: Transport, Residential, Commercial and Industrial Demand
data: Transport, Residential, Commercial and Industrial Demand.csv
name: Year
data: Year.csv
label: Overall Energy Demand
province
Province Abbre
Province
Total Energy Demand
province
Province Abbre
Province
Electricity Generation
province
Province Abbre
Province
Oil Production
province
Province Abbre
Province
Gas Production
province
Province Abbre
Province
Overall Energy Demand
scenario
Scenario
Scenario
Total Energy Demand
scenario
Scenario
Scenario
Electricity Generation
scenario
Scenario
Scenario
Oil Production
scenario
Scenario
Scenario
Gas Production
scenario
Scenario
Scenario
Transport, Residential, Commercial and Industrial Demand
scenario
Scenario
Scenario
output: {
    "joins": [
        {
            "from_table": "Overall Energy Demand",
            "from_column": "province",
            "to_table": "Province Abbre",
            "to_column": "Province"
        },
        {
            "from_table": "Total Energy Demand",
            "from_column": "province",
            "to_table": "Province Abbre",
            "to_column": "Province"
        },
        {
            "from_table": "Electricity Generation",
            "from_column": "province",
            "to_table": "Province Abbre",
            "to_column": "Province"
        },
        {
            "from_table": "Oil Production",
            "from_column": "province",
            "to_table": "Province Abbre",
            "to_column": "Province"
        },
        {
            "from_table": "Gas Production",
            "from_column": "province",
            "to_table": "Province Abbre",
            "to_column": "Province"
        },
        {
            "from_table": "Overall Energy Demand",
            "from_column": "scenario",
            "to_table": "Scenario",
            "to_column": "Scenario"
        },
        {
            "from_table": "Total Energy Demand",
            "from_column": "scenario",
            "to_table": "Scenario",
            "to_column": "Scenario"
        },
        {
            "from_table": "Electricity Generation",
            "from_column": "scenario",
            "to_table": "Scenario",
            "to_column": "Scenario"
        },
        {
            "from_table": "Oil Production",
            "from_column": "scenario",
            "to_table": "Scenario",
            "to_column": "Scenario"
        },
        {
            "from_table": "Gas Production",
            "from_column": "scenario",
            "to_table": "Scenario",
            "to_column": "Scenario"
        },
        {
            "from_table": "Transport, Residential, Commercial and Industrial Demand",
            "from_column": "scenario",
            "to_table": "Scenario",
            "to_column": "Scenario"
        }
    ]
}