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: games
| Game Date               | Game Time               |    Game ID | Game Link                         | Game Type   |   Game Season | Game Venue     | Game Name                                              |   Total Goals |   Goals Spread |   Season Start |   Season End | Alt Venue   | Arena          | Game URL                                                      |
|:------------------------|:------------------------|-----------:|:----------------------------------|:------------|--------------:|:---------------|:-------------------------------------------------------|--------------:|---------------:|---------------:|-------------:|:------------|:---------------|:--------------------------------------------------------------|
| 1926-12-07 00:00:00.000 | 1899-12-30 17:00:00.000 | 1926020034 | /api/v1/game/1926020034/feed/live | R           |      19261927 | Montreal Forum | Montreal Maroons @ Montréal Canadiens 12/7/1926        |             5 |              1 |           1926 |         1927 | Centre Bell | Montreal Forum | https://statsapi.web.nhl.com/api/v1/game/1926020034/feed/live |
| 1927-01-27 00:00:00.000 | 1899-12-30 17:00:00.000 | 1926020119 | /api/v1/game/1926020119/feed/live | R           |      19261927 | Montreal Forum | New York Rangers @ Montréal Canadiens 1/27/1927        |             5 |              1 |           1926 |         1927 | Centre Bell | Montreal Forum | https://statsapi.web.nhl.com/api/v1/game/1926020119/feed/live |
| 1928-03-03 00:00:00.000 | 1899-12-30 17:00:00.000 | 1927020182 | /api/v1/game/1927020182/feed/live | R           |      19271928 | Montreal Forum | Montreal Maroons @ Montréal Canadiens 3/3/1928         |             5 |              1 |           1927 |         1928 | Centre Bell | Montreal Forum | https://statsapi.web.nhl.com/api/v1/game/1927020182/feed/live |
| 1928-12-13 00:00:00.000 | 1899-12-30 17:00:00.000 | 1928020051 | /api/v1/game/1928020051/feed/live | R           |      19281929 | Montreal Forum | New York Rangers @ Montréal Canadiens 12/13/1928       |             5 |              1 |           1928 |         1929 | Centre Bell | Montreal Forum | https://statsapi.web.nhl.com/api/v1/game/1928020051/feed/live |
| 1929-11-21 00:00:00.000 | 1899-12-30 17:00:00.000 | 1929020015 | /api/v1/game/1929020015/feed/live | R           |      19291930 | Montreal Forum | Toronto Maple Leafs @ Montréal Canadiens 11/21/1929    |             5 |              1 |           1929 |         1930 | Centre Bell | Montreal Forum | https://statsapi.web.nhl.com/api/v1/game/1929020015/feed/live |
| 1929-12-28 00:00:00.000 | 1899-12-30 17:00:00.000 | 1929020080 | /api/v1/game/1929020080/feed/live | R           |      19291930 | Montreal Forum | Boston Bruins @ Montréal Canadiens 12/28/1929          |             5 |              1 |           1929 |         1930 | Centre Bell | Montreal Forum | https://statsapi.web.nhl.com/api/v1/game/1929020080/feed/live |
| 1930-11-29 00:00:00.000 | 1899-12-30 17:00:00.000 | 1930020034 | /api/v1/game/1930020034/feed/live | R           |      19301931 | Montreal Forum | Boston Bruins @ Montréal Canadiens 11/29/1930          |             5 |              1 |           1930 |         1931 | Centre Bell | Montreal Forum | https://statsapi.web.nhl.com/api/v1/game/1930020034/feed/live |
| 1931-11-26 00:00:00.000 | 1899-12-30 17:00:00.000 | 1931020021 | /api/v1/game/1931020021/feed/live | R           |      19311932 | Montreal Forum | Toronto Maple Leafs @ Montréal Canadiens 11/26/1931    |             5 |              1 |           1931 |         1932 | Centre Bell | Montreal Forum | https://statsapi.web.nhl.com/api/v1/game/1931020021/feed/live |
| 1932-12-10 00:00:00.000 | 1899-12-30 17:00:00.000 | 1932020045 | /api/v1/game/1932020045/feed/live | R           |      19321933 | Montreal Forum | Ottawa Senators (1917) @ Montréal Canadiens 12/10/1932 |             5 |              1 |           1932 |         1933 | Centre Bell | Montreal Forum | https://statsapi.web.nhl.com/api/v1/game/1932020045/feed/live |
| 1934-01-09 00:00:00.000 | 1899-12-30 17:00:00.000 | 1933020099 | /api/v1/game/1933020099/feed/live | R           |      19331934 | Montreal Forum | Montreal Maroons @ Montréal Canadiens 1/9/1934         |             5 |              1 |           1933 |         1934 | Centre Bell | Montreal Forum | https://statsapi.web.nhl.com/api/v1/game/1933020099/feed/live |


Table: other teams
|   Team ID | Team Venue          |
|----------:|:--------------------|
|        27 | Glendale Arena      |
|        11 | Philips Arena       |
|        36 | The Arena           |
|      7222 | H-E-B Center        |
|      5824 | Vaillant Arena      |
|      5876 | Hallenstadion       |
|      3220 | Löfbergs Arena      |
|      2452 | Hartwall Arena      |
|      2490 | Tampere Ice Stadium |
|      3254 | Saab Arena          |


Table: players
|   player id | fullName        | link                   | firstName   | lastName    |   primaryNumber | birthDate               |   currentAge | birthCity      | birthStateProvince   | birthCountry   | nationality   | height   |   weight | active   | alternateCaptain   | captain   | rookie   | shootsCatches   | rosterStatus   |   Team ID | code   | Position   | Position Type   | Position Abbr   |
|------------:|:----------------|:-----------------------|:------------|:------------|----------------:|:------------------------|-------------:|:---------------|:---------------------|:---------------|:--------------|:---------|---------:|:---------|:-------------------|:----------|:---------|:----------------|:---------------|----------:|:-------|:-----------|:----------------|:----------------|
|     8476409 | Alan Quine      | /api/v1/people/8476409 | Alan        | Quine       |              10 | 1993-02-25 00:00:00.000 |           25 | Belleville     | ON                   | CAN            | CAN           | 6' 0"    |      203 | True     | False              | False     | False    | L               | Y              |         2 | C      | Center     | Forward         | C               |
|     8473504 | Cal Clutterbuck | /api/v1/people/8473504 | Cal         | Clutterbuck |              15 | 1987-11-18 00:00:00.000 |           30 | Welland        | ON                   | CAN            | CAN           | 5' 11"   |      216 | True     | False              | False     | False    | R               | Y              |         2 | R      | Right Wing | Forward         | RW              |
|     8474573 | Josh Bailey     | /api/v1/people/8474573 | Josh        | Bailey      |              12 | 1989-10-02 00:00:00.000 |           28 | Bowmanville    | ON                   | CAN            | CAN           | 6' 1"    |      203 | True     | False              | False     | False    | L               | Y              |         2 | R      | Right Wing | Forward         | RW              |
|     8475231 | Casey Cizikas   | /api/v1/people/8475231 | Casey       | Cizikas     |              53 | 1991-02-27 00:00:00.000 |           27 | Toronto        | ON                   | CAN            | CAN           | 5' 11"   |      200 | True     | False              | False     | False    | L               | Y              |         2 | C      | Center     | Forward         | C               |
|     8475180 | Peter Holland   | /api/v1/people/8475180 | Peter       | Holland     |              12 | 1991-01-14 00:00:00.000 |           27 | Toronto        | ON                   | CAN            | CAN           | 6' 2"    |      205 | True     | False              | False     | False    | L               | Y              |         3 | C      | Center     | Forward         | C               |
|     8475727 | Ryan Spooner    | /api/v1/people/8475727 | Ryan        | Spooner     |              23 | 1992-01-30 00:00:00.000 |           26 | Ottawa         | ON                   | CAN            | CAN           | 5' 10"   |      187 | True     | False              | False     | False    | L               | Y              |         3 | C      | Center     | Forward         | C               |
|     8476177 | Matt Read       | /api/v1/people/8476177 | Matt        | Read        |              24 | 1986-06-14 00:00:00.000 |           31 | Ilderton       | ON                   | CAN            | CAN           | 5' 10"   |      185 | True     | False              | False     | False    | R               | Y              |         4 | R      | Right Wing | Forward         | RW              |
|     8476872 | Scott Laughton  | /api/v1/people/8476872 | Scott       | Laughton    |              21 | 1994-05-30 00:00:00.000 |           23 | Oakville       | ON                   | CAN            | CAN           | 6' 1"    |      190 | True     | False              | False     | False    | L               | Y              |         4 | C      | Center     | Forward         | C               |
|     8478439 | Travis Konecny  | /api/v1/people/8478439 | Travis      | Konecny     |              11 | 1997-03-11 00:00:00.000 |           21 | London         | ON                   | CAN            | CAN           | 5' 10"   |      175 | True     | False              | False     | False    | R               | Y              |         4 | C      | Center     | Forward         | C               |
|     8475772 | Riley Sheahan   | /api/v1/people/8475772 | Riley       | Sheahan     |              15 | 1991-12-07 00:00:00.000 |           26 | St. Catharines | ON                   | CAN            | CAN           | 6' 3"    |      214 | True     | False              | False     | False    | L               | Y              |         5 | C      | Center     | Forward         | C               |


Table: scores
|    Game ID |   Record Wins |   Record Losses | Record OT   |   Score |   Team ID | Side   |
|-----------:|--------------:|----------------:|:------------|--------:|----------:|:-------|
| 1918020006 |             2 |               2 |             |       2 |         8 | Away   |
| 1918020018 |             7 |               4 |             |       2 |         8 | Away   |
| 1918030213 |             5 |               3 |             |       2 |         8 | Away   |
| 1920020007 |             0 |               4 |             |       2 |         8 | Away   |
| 1920020017 |             3 |               6 |             |       2 |         8 | Away   |
| 1921020002 |             0 |               1 |             |       2 |         8 | Away   |
| 1921020027 |             5 |               8 |             |       2 |         8 | Away   |
| 1922020001 |             0 |               1 |             |       2 |         8 | Away   |
| 1922020007 |             1 |               2 |             |       2 |         8 | Away   |
| 1922020016 |             3 |               3 |             |       2 |         8 | Away   |


Table: statistics
|   player id | Statistics Type   |   season | timeOnIce   |   assists |   goals |   pim |   games | powerPlayTimeOnIce   | evenTimeOnIce   |   penaltyMinutes | faceOffPct   | shortHandedTimeOnIce   |   points | shifts   | Team Name   | link               | League Name   | link.1              |   sequenceNumber | Season Sort        |
|------------:|:------------------|---------:|:------------|----------:|--------:|------:|--------:|:---------------------|:----------------|-----------------:|:-------------|:-----------------------|---------:|:---------|:------------|:-------------------|:--------------|:--------------------|-----------------:|:-------------------|
|     8477355 | yearByYear        | 20112012 |             |         8 |       2 |     4 |      31 |                      |                 |                4 |              |                        |       10 |          | USNTDP      | /api/v1/teams/null | USHL          | /api/v1/league/null |                1 | 8477355-20112012-1 |
|     8477355 | yearByYear        | 20122013 |             |        10 |       3 |     2 |      26 |                      |                 |                2 |              |                        |       13 |          | USNTDP      | /api/v1/teams/null | USHL          | /api/v1/league/null |                1 | 8477355-20122013-1 |
|     8476869 | yearByYear        | 20102011 |             |         5 |       1 |    14 |      36 |                      |                 |               14 |              |                        |        6 |          | USNTDP      | /api/v1/teams/null | USHL          | /api/v1/league/null |                1 | 8476869-20102011-1 |
|     8476869 | yearByYear        | 20112012 |             |         9 |       3 |    12 |      24 |                      |                 |               12 |              |                        |       12 |          | USNTDP      | /api/v1/teams/null | USHL          | /api/v1/league/null |                1 | 8476869-20112012-1 |
|     8478075 | yearByYear        | 20122013 |             |         7 |       8 |    28 |      38 |                      |                 |               28 |              |                        |       15 |          | USNTDP      | /api/v1/teams/null | USHL          | /api/v1/league/null |                1 | 8478075-20122013-1 |
|     8478075 | yearByYear        | 20132014 |             |        12 |       9 |     0 |      26 |                      |                 |                0 |              |                        |       21 |          | USNTDP      | /api/v1/teams/null | USHL          | /api/v1/league/null |                1 | 8478075-20132014-1 |
|     8476891 | yearByYear        | 20102011 |             |         9 |       1 |    28 |      36 |                      |                 |               28 |              |                        |       10 |          | USNTDP      | /api/v1/teams/null | USHL          | /api/v1/league/null |                1 | 8476891-20102011-1 |
|     8476891 | yearByYear        | 20112012 |             |        10 |       1 |     6 |      24 |                      |                 |                6 |              |                        |       11 |          | USNTDP      | /api/v1/teams/null | USHL          | /api/v1/league/null |                1 | 8476891-20112012-1 |
|     8479325 | yearByYear        | 20132014 |             |         6 |       4 |    56 |      34 |                      |                 |               56 |              |                        |       10 |          | USNTDP      | /api/v1/teams/null | USHL          | /api/v1/league/null |                1 | 8479325-20132014-1 |
|     8479325 | yearByYear        | 20142015 |             |        16 |       3 |    33 |      23 |                      |                 |               33 |              |                        |       19 |          | USNTDP      | /api/v1/teams/null | USHL          | /api/v1/league/null |                1 | 8479325-20142015-1 |


Table: teams
|   Team ID | Team Name           | Team Link        | Team Venue            | Venue City   | Team Time Zone   |   offset | Time Zone Abbr   | Team Abbr   | Team Short Name   | Team City    |   First Year of Play |   Division ID | Division     | Division Link        |   Conference ID | Conference   | Conference Link       | Team URL                          |
|----------:|:--------------------|:-----------------|:----------------------|:-------------|:-----------------|---------:|:-----------------|:------------|:------------------|:-------------|---------------------:|--------------:|:-------------|:---------------------|----------------:|:-------------|:----------------------|:----------------------------------|
|         1 | New Jersey Devils   | /api/v1/teams/1  | Prudential Center     | Newark       | America/New_York |       -4 | EDT              | NJD         | Devils            | New Jersey   |                 1982 |            18 | Metropolitan | /api/v1/divisions/18 |               6 | Eastern      | /api/v1/conferences/6 | http://www.truesince82.com        |
|         2 | New York Islanders  | /api/v1/teams/2  | Barclays Center       | Brooklyn     | America/New_York |       -4 | EDT              | NYI         | Islanders         | New York     |                 1972 |            18 | Metropolitan | /api/v1/divisions/18 |               6 | Eastern      | /api/v1/conferences/6 | http://www.newyorkislanders.com   |
|         3 | New York Rangers    | /api/v1/teams/3  | Madison Square Garden | New York     | America/New_York |       -4 | EDT              | NYR         | Rangers           | New York     |                 1926 |            18 | Metropolitan | /api/v1/divisions/18 |               6 | Eastern      | /api/v1/conferences/6 | http://www.newyorkrangers.com     |
|         4 | Philadelphia Flyers | /api/v1/teams/4  | Wells Fargo Center    | Philadelphia | America/New_York |       -4 | EDT              | PHI         | Flyers            | Philadelphia |                 1967 |            18 | Metropolitan | /api/v1/divisions/18 |               6 | Eastern      | /api/v1/conferences/6 | http://www.philadelphiaflyers.com |
|         5 | Pittsburgh Penguins | /api/v1/teams/5  | PPG Paints Arena      | Pittsburgh   | America/New_York |       -4 | EDT              | PIT         | Penguins          | Pittsburgh   |                 1967 |            18 | Metropolitan | /api/v1/divisions/18 |               6 | Eastern      | /api/v1/conferences/6 | http://www.pittsburghpenguins.com |
|         6 | Boston Bruins       | /api/v1/teams/6  | TD Garden             | Boston       | America/New_York |       -4 | EDT              | BOS         | Bruins            | Boston       |                 1924 |            17 | Atlantic     | /api/v1/divisions/17 |               6 | Eastern      | /api/v1/conferences/6 | http://www.bostonbruins.com       |
|         7 | Buffalo Sabres      | /api/v1/teams/7  | KeyBank Center        | Buffalo      | America/New_York |       -4 | EDT              | BUF         | Sabres            | Buffalo      |                 1970 |            17 | Atlantic     | /api/v1/divisions/17 |               6 | Eastern      | /api/v1/conferences/6 | http://www.sabres.com             |
|         8 | Montréal Canadiens  | /api/v1/teams/8  | Centre Bell           | Montreal     | America/Montreal |       -4 | EDT              | MTL         | Canadiens         | Montréal     |                 1909 |            17 | Atlantic     | /api/v1/divisions/17 |               6 | Eastern      | /api/v1/conferences/6 | http://www.canadiens.com          |
|         9 | Ottawa Senators     | /api/v1/teams/9  | Canadian Tire Centre  | Ottawa       | America/New_York |       -4 | EDT              | OTT         | Senators          | Ottawa       |                 1990 |            17 | Atlantic     | /api/v1/divisions/17 |               6 | Eastern      | /api/v1/conferences/6 | http://www.ottawasenators.com     |
|        10 | Toronto Maple Leafs | /api/v1/teams/10 | Air Canada Centre     | Toronto      | America/Toronto  |       -4 | EDT              | TOR         | Maple Leafs       | Toronto      |                 1917 |            17 | Atlantic     | /api/v1/divisions/17 |               6 | Eastern      | /api/v1/conferences/6 | http://www.mapleleafs.com         |

 


tables: name: games
data: games.csv
name: other teams
data: other teams.csv
name: players
data: players.csv
name: scores
data: scores.csv
name: statistics
data: statistics.csv
name: teams
data: teams.csv
label: scores
Team ID
teams
Team ID
players
Team ID
teams
Team ID
statistics
player id
players
player id
scores
Game ID
games
Game ID
output: {
    "joins": [
        {
            "from_table": "scores",
            "from_column": "Team ID",
            "to_table": "teams",
            "to_column": "Team ID"
        },
        {
            "from_table": "players",
            "from_column": "Team ID",
            "to_table": "teams",
            "to_column": "Team ID"
        },
        {
            "from_table": "statistics",
            "from_column": "player id",
            "to_table": "players",
            "to_column": "player id"
        },
        {
            "from_table": "scores",
            "from_column": "Game ID",
            "to_table": "games",
            "to_column": "Game ID"
        }
    ]
}