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: Countries
| Country             |
|:--------------------|
| Afghanistan         |
| Albania             |
| Algeria             |
| Angola              |
| Antigua and Barbuda |
| Argentina           |
| Armenia             |
| Australia           |
| Austria             |
| Azerbaijan          |


Table: Date
| Date                    |
|:------------------------|
| 2010-01-01 00:00:00.000 |
| 2010-01-02 00:00:00.000 |
| 2010-01-03 00:00:00.000 |
| 2010-01-04 00:00:00.000 |
| 2010-01-05 00:00:00.000 |
| 2010-01-06 00:00:00.000 |
| 2010-01-07 00:00:00.000 |
| 2010-01-08 00:00:00.000 |
| 2010-01-09 00:00:00.000 |
| 2010-01-10 00:00:00.000 |


Table: Debt to GDP
| Country     |   Year | Date                    |   Government Debt to GDP | merged_d        |
|:------------|-------:|:------------------------|-------------------------:|:----------------|
| Afghanistan |   2010 | 2010-12-31 00:00:00.000 |                   0.077  | Afghanistan2010 |
| Albania     |   2010 | 2010-12-31 00:00:00.000 |                   0.5771 | Albania2010     |
| Algeria     |   2010 | 2010-12-31 00:00:00.000 |                   0.105  | Algeria2010     |
| Angola      |   2010 | 2010-12-31 00:00:00.000 |                   0.443  | Angola2010      |
| Argentina   |   2010 | 2010-12-31 00:00:00.000 |                   0.435  | Argentina2010   |
| Armenia     |   2010 | 2010-12-31 00:00:00.000 |                   0.356  | Armenia2010     |
| Australia   |   2010 | 2010-12-31 00:00:00.000 |                   0.205  | Australia2010   |
| Austria     |   2010 | 2010-12-31 00:00:00.000 |                   0.824  | Austria2010     |
| Azerbaijan  |   2010 | 2010-12-31 00:00:00.000 |                   0.125  | Azerbaijan2010  |
| Bahamas     |   2010 | 2010-12-31 00:00:00.000 |                   0.543  | Bahamas2010     |


Table: GNI
| Country             | Date                    |   GNI per capita, Atlas method (current US$) |   GNI Rank_column |   year | Category_column   | merged_G                |
|:--------------------|:------------------------|---------------------------------------------:|------------------:|-------:|:------------------|:------------------------|
| Afghanistan         | 2013-12-31 00:00:00.000 |                                          680 |               172 |   2013 | Emerging          | Afghanistan2013         |
| Albania             | 2013-12-31 00:00:00.000 |                                         4540 |               106 |   2013 | Emerging          | Albania2013             |
| Algeria             | 2013-12-31 00:00:00.000 |                                         5480 |               101 |   2013 | Emerging          | Algeria2013             |
| Angola              | 2013-12-31 00:00:00.000 |                                         4340 |               108 |   2013 | Emerging          | Angola2013              |
| Antigua and Barbuda | 2013-12-31 00:00:00.000 |                                        12020 |                63 |   2013 | Developing        | Antigua and Barbuda2013 |
| Argentina           | 2013-12-31 00:00:00.000 |                                        12770 |                59 |   2013 | Developing        | Argentina2013           |
| Armenia             | 2013-12-31 00:00:00.000 |                                         4120 |               115 |   2013 | Emerging          | Armenia2013             |
| Australia           | 2013-12-31 00:00:00.000 |                                        65870 |                 8 |   2013 | Advanced          | Australia2013           |
| Austria             | 2013-12-31 00:00:00.000 |                                        50700 |                16 |   2013 | Advanced          | Austria2013             |
| Azerbaijan          | 2013-12-31 00:00:00.000 |                                         7450 |                82 |   2013 | Developing        | Azerbaijan2013          |

 


tables: name: Countries
data: Countries.csv
name: Date
data: Date.csv
name: Debt to GDP
data: Debt to GDP.csv
name: GNI
data: GNI.csv
label: GNI
Country
Countries
Country
Debt to GDP
merged_d
GNI
merged_G
output: {
    "joins": [
        {
            "from_table": "GNI",
            "from_column": "Country",
            "to_table": "Countries",
            "to_column": "Country"
        },
        {
            "from_table": "Debt to GDP",
            "from_column": "merged_d",
            "to_table": "GNI",
            "to_column": "merged_G"
        }
    ]
}