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: Commits
| id                                                | repositoryId                     | repositoryOwner   | repositoryName      | resourcePath                    | pushedAt             | isFork   | description   | ownerId          | type   | topics   | contributor    | location                  |   contributions |
|:--------------------------------------------------|:---------------------------------|:------------------|:--------------------|:--------------------------------|:---------------------|:---------|:--------------|:-----------------|:-------|:---------|:---------------|:--------------------------|----------------:|
| MDQ6VXNlcjE0NjA5-MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | joshholmes        | laravelphotogallery | /joshholmes/laravelphotogallery | 2015-10-03T19:47:17Z | False    |               | MDQ6VXNlcjE0NjA5 | user   | [List]   | jonathantorres | Oakland Park, FL          |               1 |
| MDQ6VXNlcjE0NjA5-MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | joshholmes        | laravelphotogallery | /joshholmes/laravelphotogallery | 2015-10-03T19:47:17Z | False    |               | MDQ6VXNlcjE0NjA5 | user   | [List]   | sileence       | United Kingdom            |               1 |
| MDQ6VXNlcjE0NjA5-MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | joshholmes        | laravelphotogallery | /joshholmes/laravelphotogallery | 2015-10-03T19:47:17Z | False    |               | MDQ6VXNlcjE0NjA5 | user   | [List]   | mikaelmattsson | Gothenburg, Sweden        |               1 |
| MDQ6VXNlcjE0NjA5-MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | joshholmes        | laravelphotogallery | /joshholmes/laravelphotogallery | 2015-10-03T19:47:17Z | False    |               | MDQ6VXNlcjE0NjA5 | user   | [List]   | tonglil        | New York City / Vancouver |               1 |
| MDQ6VXNlcjE0NjA5-MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | joshholmes        | laravelphotogallery | /joshholmes/laravelphotogallery | 2015-10-03T19:47:17Z | False    |               | MDQ6VXNlcjE0NjA5 | user   | [List]   | Phyxsius       | Battlefield, MO           |               1 |
| MDQ6VXNlcjE0NjA5-MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | joshholmes        | laravelphotogallery | /joshholmes/laravelphotogallery | 2015-10-03T19:47:17Z | False    |               | MDQ6VXNlcjE0NjA5 | user   | [List]   | martinssipenko | Riga, Latvia              |               1 |
| MDQ6VXNlcjE0NjA5-MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | joshholmes        | laravelphotogallery | /joshholmes/laravelphotogallery | 2015-10-03T19:47:17Z | False    |               | MDQ6VXNlcjE0NjA5 | user   | [List]   | pespantelis    | Athens, Greece            |               1 |
| MDQ6VXNlcjE0NjA5-MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | joshholmes        | laravelphotogallery | /joshholmes/laravelphotogallery | 2015-10-03T19:47:17Z | False    |               | MDQ6VXNlcjE0NjA5 | user   | [List]   | nWidart        | Namur, Belgium            |               1 |
| MDQ6VXNlcjE0NjA5-MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | joshholmes        | laravelphotogallery | /joshholmes/laravelphotogallery | 2015-10-03T19:47:17Z | False    |               | MDQ6VXNlcjE0NjA5 | user   | [List]   | RomainLanz     | Suisse                    |               1 |
| MDQ6VXNlcjE0NjA5-MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | joshholmes        | laravelphotogallery | /joshholmes/laravelphotogallery | 2015-10-03T19:47:17Z | False    |               | MDQ6VXNlcjE0NjA5 | user   | [List]   | phaza          | Norway                    |               1 |


Table: Contributions
| id                                                | ownerId          | repositoryId                     | repositoryOwner   | repositoryName      | resourcePath                    | pushedAt             | type   | isFork   | description   | topics   | contributor    | location                  |   contributions |
|:--------------------------------------------------|:-----------------|:---------------------------------|:------------------|:--------------------|:--------------------------------|:---------------------|:-------|:---------|:--------------|:---------|:---------------|:--------------------------|----------------:|
| MDQ6VXNlcjE0NjA5-MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | MDQ6VXNlcjE0NjA5 | MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | joshholmes        | laravelphotogallery | /joshholmes/laravelphotogallery | 2015-10-03T19:47:17Z | user   | False    |               | [List]   | jonathantorres | Oakland Park, FL          |               1 |
| MDQ6VXNlcjE0NjA5-MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | MDQ6VXNlcjE0NjA5 | MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | joshholmes        | laravelphotogallery | /joshholmes/laravelphotogallery | 2015-10-03T19:47:17Z | user   | False    |               | [List]   | sileence       | United Kingdom            |               1 |
| MDQ6VXNlcjE0NjA5-MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | MDQ6VXNlcjE0NjA5 | MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | joshholmes        | laravelphotogallery | /joshholmes/laravelphotogallery | 2015-10-03T19:47:17Z | user   | False    |               | [List]   | mikaelmattsson | Gothenburg, Sweden        |               1 |
| MDQ6VXNlcjE0NjA5-MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | MDQ6VXNlcjE0NjA5 | MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | joshholmes        | laravelphotogallery | /joshholmes/laravelphotogallery | 2015-10-03T19:47:17Z | user   | False    |               | [List]   | tonglil        | New York City / Vancouver |               1 |
| MDQ6VXNlcjE0NjA5-MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | MDQ6VXNlcjE0NjA5 | MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | joshholmes        | laravelphotogallery | /joshholmes/laravelphotogallery | 2015-10-03T19:47:17Z | user   | False    |               | [List]   | Phyxsius       | Battlefield, MO           |               1 |
| MDQ6VXNlcjE0NjA5-MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | MDQ6VXNlcjE0NjA5 | MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | joshholmes        | laravelphotogallery | /joshholmes/laravelphotogallery | 2015-10-03T19:47:17Z | user   | False    |               | [List]   | martinssipenko | Riga, Latvia              |               1 |
| MDQ6VXNlcjE0NjA5-MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | MDQ6VXNlcjE0NjA5 | MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | joshholmes        | laravelphotogallery | /joshholmes/laravelphotogallery | 2015-10-03T19:47:17Z | user   | False    |               | [List]   | pespantelis    | Athens, Greece            |               1 |
| MDQ6VXNlcjE0NjA5-MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | MDQ6VXNlcjE0NjA5 | MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | joshholmes        | laravelphotogallery | /joshholmes/laravelphotogallery | 2015-10-03T19:47:17Z | user   | False    |               | [List]   | nWidart        | Namur, Belgium            |               1 |
| MDQ6VXNlcjE0NjA5-MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | MDQ6VXNlcjE0NjA5 | MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | joshholmes        | laravelphotogallery | /joshholmes/laravelphotogallery | 2015-10-03T19:47:17Z | user   | False    |               | [List]   | RomainLanz     | Suisse                    |               1 |
| MDQ6VXNlcjE0NjA5-MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | MDQ6VXNlcjE0NjA5 | MDEwOlJlcG9zaXRvcnk0MTkzMzI2OQ== | joshholmes        | laravelphotogallery | /joshholmes/laravelphotogallery | 2015-10-03T19:47:17Z | user   | False    |               | [List]   | phaza          | Norway                    |               1 |


Table: Repositories
| repositoryId                     | repositoryOwner   | repositoryName         | type   | isFork   | description   |
|:---------------------------------|:------------------|:-----------------------|:-------|:---------|:--------------|
| MDEwOlJlcG9zaXRvcnkxMDgwNTI0NzM= | cicorias          | react-auth             | user   | False    |               |
| MDEwOlJlcG9zaXRvcnkxMDYzMjM5MzU= | cicorias          | demofunction           | user   | False    |               |
| MDEwOlJlcG9zaXRvcnkxMDYzMjAyMjU= | cicorias          | demoweb                | user   | False    |               |
| MDEwOlJlcG9zaXRvcnk5ODM1MjU0OQ== | cicorias          | paho.mqtt.m2mqtt       | user   | True     |               |
| MDEwOlJlcG9zaXRvcnk5NTk4MDA3Ng== | cicorias          | ng-book2               | user   | False    |               |
| MDEwOlJlcG9zaXRvcnk5NjI1NDY2NA== | cicorias          | ghpages1               | user   | False    |               |
| MDEwOlJlcG9zaXRvcnk3MDg3MzU1NA== | cicorias          | ethereum-arm-templates | user   | True     |               |
| MDEwOlJlcG9zaXRvcnk5MTYzMTEyNw== | cicorias          | lexwip                 | user   | False    |               |
| MDEwOlJlcG9zaXRvcnk5MTkzMTczMg== | cicorias          | dumpenv                | user   | False    |               |
| MDEwOlJlcG9zaXRvcnkxMDIwMzI1Nzk= | cicorias          | aad-ethereum-explorer  | user   | True     |               |


Table: Topics
| repositoryId                     | topics   |
|:---------------------------------|:---------|
| MDEwOlJlcG9zaXRvcnk4NTA5NzA4OA== |          |
| MDEwOlJlcG9zaXRvcnkxMDM5MjU0NDM= |          |
| MDEwOlJlcG9zaXRvcnkxMDM1ODc1MzI= |          |
| MDEwOlJlcG9zaXRvcnkxMDI2MzQ4MjM= |          |
| MDEwOlJlcG9zaXRvcnk5MTM2NzcwNw== |          |
| MDEwOlJlcG9zaXRvcnk5NjY3OTUwNw== |          |
| MDEwOlJlcG9zaXRvcnk3OTgwNTg2MQ== |          |
| MDEwOlJlcG9zaXRvcnk5NjY3OTU1MA== |          |
| MDEwOlJlcG9zaXRvcnk3Njk1ODQxMA== |          |
| MDEwOlJlcG9zaXRvcnkxMDMzMjAxNDM= |          |


Table: Users
| contributor   | location   |
|:--------------|:-----------|
| Maliac11      |            |
| claurendine   |            |
| kevinhartman  |            |
| rabee333      |            |
| rozele        |            |
| olgaliak      |            |
| amiturgman    |            |
| xinyiou       |            |
| itye-msft     |            |
| aribornstein  |            |

 


tables: name: Commits
data: Commits.csv
name: Contributions
data: Contributions.csv
name: Repositories
data: Repositories.csv
name: Topics
data: Topics.csv
name: Users
data: Users.csv
label: Commits
contributor
Users
contributor
Repositories
repositoryOwner
Users
contributor
Contributions
repositoryOwner
Users
contributor
Topics
repositoryId
Repositories
repositoryId
output: {
    "joins": [
        {
            "from_table": "Commits",
            "from_column": "contributor",
            "to_table": "Users",
            "to_column": "contributor"
        },
        {
            "from_table": "Repositories",
            "from_column": "repositoryOwner",
            "to_table": "Users",
            "to_column": "contributor"
        },
        {
            "from_table": "Contributions",
            "from_column": "repositoryOwner",
            "to_table": "Users",
            "to_column": "contributor"
        },
        {
            "from_table": "Topics",
            "from_column": "repositoryId",
            "to_table": "Repositories",
            "to_column": "repositoryId"
        }
    ]
}