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: 2013 PT2
| Player          |   Played |   1st |   2nd |   3rd |   Bubble |   Cashes |   July |   August |   September |   October |   November |   December |   Points |
|:----------------|---------:|------:|------:|------:|---------:|---------:|-------:|---------:|------------:|----------:|-----------:|-----------:|---------:|
| Ben Hodgson     |       23 |     1 |     2 |     6 |        4 |       12 |     23 |       33 |          27 |        28 |         33 |         15 |      159 |
| Billy The Kid   |       24 |     4 |     2 |     1 |        1 |        7 |     30 |       39 |           9 |        23 |         16 |         21 |      138 |
| Wayne Tindale   |       24 |     4 |     1 |     1 |        2 |        7 |     18 |       25 |          27 |        39 |          6 |         23 |      138 |
| Hutch Senior    |       19 |     2 |     3 |     2 |        0 |        9 |     20 |       49 |          28 |        13 |          6 |         12 |      128 |
| Trevor Johnson  |       18 |     1 |     1 |     3 |        4 |        6 |     13 |       27 |          11 |        17 |         20 |         16 |      104 |
| Paul Hutch      |       13 |     3 |     3 |     0 |        0 |        6 |      0 |        0 |          16 |        44 |         34 |          6 |      100 |
| Pam Wright      |       17 |     1 |     2 |     1 |        2 |        4 |      7 |       46 |          11 |         4 |         15 |          3 |       86 |
| Adrian Cousins  |       17 |     2 |     1 |     1 |        1 |        4 |      1 |        2 |          19 |        36 |         13 |          8 |       79 |
| Chris Parkinson |       17 |     1 |     2 |     1 |        1 |        5 |      3 |        2 |          19 |        21 |         11 |         17 |       73 |
| Brian Wright    |       18 |     0 |     2 |     1 |        0 |        3 |     14 |       21 |          17 |        11 |          5 |          5 |       73 |


Table: H2H
| Column1   | Player106   | Player21   | Player13   | Player28   | Player25   | Player7   | Player4   | Player26   | Player23   | Player94   | Player41   | Player12   | Player24   | Player31   | Player20   | Player27   | Player55   | Player19   | Player47   | Player14   | Player15   | Player16   | Player71   | Player72   | Player11   |
|:----------|:------------|:-----------|:-----------|:-----------|:-----------|:----------|:----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|
| Player106 |             |            | 2 / 1      | 0 / 1      |            | 1 / 0     |           |            |            |            |            | 1 / 1      | 0 / 1      | 0 / 1      |            |            |            |            |            |            | 0 / 1      |            |            |            |            |
| Player21  |             |            | 1 / 0      |            | 0 / 1      |           |           | 0 / 1      | 2 / 0      |            |            |            |            |            |            |            |            |            |            |            |            |            | 1 / 0      | 0 / 1      |            |
| Player13  | 1 / 2       | 0 / 1      |            |            | 1 / 1      | 1 / 1     |           | 2 / 0      | 2 / 0      | 1 / 2      | 0 / 1      | 4 / 2      | 1 / 2      |            | 1 / 0      | 0 / 1      |            | 1 / 2      | 1 / 2      | 1 / 3      |            | 0 / 1      | 1 / 2      |            | 3 / 5      |
| Player28  | 1 / 0       |            |            |            |            | 0 / 1     |           |            |            | 0 / 1      |            |            | 1 / 0      |            |            |            |            |            |            | 1 / 0      |            |            |            | 0 / 1      | 1 / 0      |
| Player25  |             | 1 / 0      | 1 / 1      |            |            | 0 / 1     |           | 0 / 1      |            |            |            | 1 / 4      |            |            |            |            |            | 3 / 1      |            | 1 / 2      |            | 0 / 3      | 0 / 1      |            | 0 / 1      |
| Player7   | 0 / 1       |            | 1 / 1      | 1 / 0      | 1 / 0      |           |           |            | 1 / 1      | 1 / 0      |            | 1 / 2      | 0 / 1      |            |            | 1 / 0      | 1 / 0      | 1 / 0      |            |            |            |            | 0 / 1      |            | 2 / 0      |
| Player4   |             |            |            |            |            |           |           |            |            |            |            |            |            |            |            |            |            |            |            | 0 / 1      |            |            |            |            |            |
| Player26  |             | 1 / 0      | 0 / 2      |            | 1 / 0      |           |           |            |            |            |            | 1 / 0      |            |            | 0 / 1      |            |            | 1 / 1      |            |            |            | 1 / 0      | 1 / 0      |            |            |
| Player23  |             | 0 / 2      | 0 / 2      |            |            | 1 / 1     |           |            |            |            |            | 0 / 1      | 1 / 0      |            |            | 1 / 2      |            |            |            |            | 0 / 1      | 1 / 1      |            |            | 0 / 2      |
| Player94  |             |            | 2 / 1      | 1 / 0      |            | 0 / 1     |           |            |            |            | 1 / 0      | 0 / 1      | 0 / 1      |            | 1 / 0      | 1 / 0      |            |            | 1 / 0      |            |            |            | 1 / 0      |            | 1 / 0      |


Table: Latest
| Player   | LatestTournament        |
|:---------|:------------------------|
| Player71 | 2019-04-11 00:00:00.000 |
| Player13 | 2019-04-11 00:00:00.000 |
| Player24 | 2019-03-28 00:00:00.000 |
| Player17 | 2016-10-20 00:00:00.000 |
| Player1  | 2014-07-03 00:00:00.000 |
| Player16 | 2019-03-14 00:00:00.000 |
| Player28 | 2016-04-21 00:00:00.000 |
| Player47 | 2018-06-14 00:00:00.000 |
| Player18 | 2019-03-21 00:00:00.000 |
| Player27 | 2017-09-07 00:00:00.000 |


Table: LatestValues
| Player   | Tournament              |   Consecutive |
|:---------|:------------------------|--------------:|
| Player71 | 2019-04-11 00:00:00.000 |             2 |
| Player13 | 2019-04-11 00:00:00.000 |             2 |
| Player24 | 2019-03-28 00:00:00.000 |            -2 |
| Player17 | 2016-10-20 00:00:00.000 |            -4 |
| Player1  | 2014-07-03 00:00:00.000 |             2 |
| Player16 | 2019-03-14 00:00:00.000 |            -2 |
| Player28 | 2016-04-21 00:00:00.000 |            -3 |
| Player47 | 2018-06-14 00:00:00.000 |            -4 |
| Player18 | 2019-03-21 00:00:00.000 |            -4 |
| Player27 | 2017-09-07 00:00:00.000 |            -1 |


Table: LeagueFinishes
| Player    | Season   |   SeasonPoints | Type    |   Season1st |   Season2nd |   Season3rd |
|:----------|:---------|---------------:|:--------|------------:|------------:|------------:|
| Player9   | 2014 PT1 |              2 | Regular |           0 |           0 |           0 |
| Player97  | 2014 PT1 |              2 | Regular |           0 |           0 |           0 |
| Player55  | 2014 PT1 |              2 | Regular |           0 |           0 |           0 |
| Player4   | 2014 PT1 |              2 | Regular |           0 |           0 |           0 |
| Player32  | 2014 PT1 |              2 | Regular |           0 |           0 |           0 |
| Player87  | 2014 PT1 |              2 | Regular |           0 |           0 |           0 |
| Player16  | 2014 PT2 |              2 | Bounty  |           0 |           0 |           0 |
| Player12  | 2015 PT1 |              2 | Bounty  |           0 |           0 |           0 |
| Player79  | 2015 PT1 |              2 | Regular |           0 |           0 |           0 |
| Player109 | 2015 PT2 |              2 | Bounty  |           0 |           0 |           0 |


Table: LeagueFinishes_1
| Player   | Season   |   Points |   Rank |
|:---------|:---------|---------:|-------:|
| Player18 | 2014 PT1 |  27      |     20 |
| Player19 | 2014 PT1 |  98.0001 |      6 |
| Player28 | 2014 PT1 |  99.0001 |      3 |
| Player12 | 2014 PT1 |  71.0001 |     12 |
| Player16 | 2014 PT1 |  42.0001 |     17 |
| Player9  | 2014 PT1 |   2      |     39 |
| Player24 | 2014 PT1 |  82      |      9 |
| Player27 | 2014 PT1 |  93.0002 |      7 |
| Player7  | 2014 PT1 |  90.0002 |      8 |
| Player71 | 2014 PT1 |  68.0001 |     14 |


Table: Players
| Player    |
|:----------|
| Player1   |
| Player10  |
| Player100 |
| Player101 |
| Player102 |
| Player103 |
| Player104 |
| Player105 |
| Player106 |
| Player107 |


Table: Points
| Result   |   Points |
|:---------|---------:|
| 1st      |       16 |
| 1st (L)  |       15 |
| 2nd      |       12 |
| 2nd (L)  |       11 |
| 3rd      |        9 |
| 3rd (L)  |        8 |
| 4th      |        7 |
| 4th (L)  |        6 |
| 5th      |        5 |
| 5th (L)  |        4 |


Table: Results
| Tournament              | Player   | Result   |   Points |   Final Table |   First Out |   Bubble |   Late |   1st |   2nd |   3rd |   Cash |   Played |   Jan |   Feb |   Mar |   Apr |   May |   Jun |   Jul |   Aug |   Sep |   Oct |   Nov |   Dec | Finish   |   FinishSort |   Year |   Month | ConsecutiveWins   | TournamentType   |   PointsPerMonth | Year-Month   | BestConsecFT            | ConsecTop7   | Top7   |   Consecutive | Current   |   Position |
|:------------------------|:---------|:---------|---------:|--------------:|------------:|---------:|-------:|------:|------:|------:|-------:|---------:|------:|------:|------:|------:|------:|------:|------:|------:|------:|------:|------:|------:|:---------|-------------:|-------:|--------:|:------------------|:-----------------|-----------------:|:-------------|:------------------------|:-------------|:-------|--------------:|:----------|-----------:|
| 2014-01-09 00:00:00.000 | Player18 | LOW      |        2 |             0 |           0 |        0 |      0 |     0 |     0 |     0 |      0 |        1 |     2 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |          |            0 |   2014 |       1 |                   | Regular          |          28.0001 | 2014-Jan     | 2014-01-16 00:00:00.000 |              | N      |            -1 |           |        999 |
| 2014-01-09 00:00:00.000 | Player19 | LOW      |        2 |             0 |           0 |        0 |      0 |     0 |     0 |     0 |      0 |        1 |     2 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |          |            0 |   2014 |       1 |                   | Regular          |          26.0001 | 2014-Jan     | 2014-01-16 00:00:00.000 |              | N      |            -1 |           |        999 |
| 2014-01-16 00:00:00.000 | Player28 | LOW      |        2 |             0 |           0 |        0 |      0 |     0 |     0 |     0 |      0 |        1 |     2 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |          |            0 |   2014 |       1 |                   | Regular          |          17      | 2014-Jan     | 2014-01-23 00:00:00.000 |              | N      |            -1 |           |        999 |
| 2014-01-16 00:00:00.000 | Player12 | LOW      |        2 |             0 |           0 |        0 |      0 |     0 |     0 |     0 |      0 |        1 |     2 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |          |            0 |   2014 |       1 |                   | Regular          |          32.0001 | 2014-Jan     | 2014-01-23 00:00:00.000 |              | N      |            -1 |           |        999 |
| 2014-01-16 00:00:00.000 | Player16 | LOW      |        2 |             0 |           0 |        0 |      0 |     0 |     0 |     0 |      0 |        1 |     2 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |          |            0 |   2014 |       1 |                   | Regular          |           8      | 2014-Jan     | 2014-01-23 00:00:00.000 |              | N      |            -1 |           |        999 |
| 2014-01-16 00:00:00.000 | Player9  | LOW      |        2 |             0 |           0 |        0 |      0 |     0 |     0 |     0 |      0 |        1 |     2 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |          |            0 |   2014 |       1 |                   | Regular          |           2      | 2014-Jan     | 2015-02-19 00:00:00.000 |              | N      |            -1 |           |        999 |
| 2014-01-23 00:00:00.000 | Player24 | LOW      |        2 |             0 |           0 |        0 |      0 |     0 |     0 |     0 |      0 |        1 |     2 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |          |            0 |   2014 |       1 |                   | Regular          |          34      | 2014-Jan     | 2014-01-30 00:00:00.000 |              | N      |            -1 |           |        999 |
| 2014-01-23 00:00:00.000 | Player27 | LOW      |        2 |             0 |           0 |        0 |      0 |     0 |     0 |     0 |      0 |        1 |     2 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |          |            0 |   2014 |       1 |                   | Regular          |          15      | 2014-Jan     | 2014-01-30 00:00:00.000 |              | N      |            -1 |           |        999 |
| 2014-01-30 00:00:00.000 | Player28 | LOW      |        2 |             0 |           0 |        0 |      0 |     0 |     0 |     0 |      0 |        1 |     2 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |          |            0 |   2014 |       1 |                   | Regular          |          17      | 2014-Jan     | 2014-02-06 00:00:00.000 |              | N      |            -1 |           |        999 |
| 2014-01-30 00:00:00.000 | Player12 | LOW      |        2 |             0 |           0 |        0 |      0 |     0 |     0 |     0 |      0 |        1 |     2 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |          |            0 |   2014 |       1 |                   | Regular          |          32.0001 | 2014-Jan     | 2014-02-13 00:00:00.000 |              | N      |            -1 |           |        999 |


Table: Seasons
| Season   | First Week              | Last Week               | Grand Final             |
|:---------|:------------------------|:------------------------|:------------------------|
| 2018 PT1 | 2018-01-11 00:00:00.000 | 2018-06-21 00:00:00.000 | 2018-07-05 00:00:00.000 |
| 2018 PT2 | 2018-07-12 00:00:00.000 | 2018-12-27 00:00:00.000 | 2019-01-03 00:00:00.000 |
| 2017 PT2 | 2017-07-13 00:00:00.000 | 2017-12-21 00:00:00.000 | 2018-01-04 00:00:00.000 |
| 2017 PT1 | 2017-01-12 00:00:00.000 | 2017-06-29 00:00:00.000 | 2017-07-06 00:00:00.000 |
| 2016 PT2 | 2016-07-14 00:00:00.000 | 2016-12-29 00:00:00.000 | 2017-01-05 00:00:00.000 |
| 2016 PT1 | 2016-01-14 00:00:00.000 | 2016-06-30 00:00:00.000 | 2016-07-07 00:00:00.000 |
| 2015 PT2 | 2015-07-09 00:00:00.000 | 2015-12-17 00:00:00.000 | 2016-01-07 00:00:00.000 |
| 2015 PT1 | 2015-01-15 00:00:00.000 | 2015-06-25 00:00:00.000 | 2015-07-02 00:00:00.000 |
| 2014 PT2 | 2014-07-10 00:00:00.000 | 2014-12-18 00:00:00.000 | 2015-01-08 00:00:00.000 |
| 2014 PT1 | 2014-01-09 00:00:00.000 | 2014-06-26 00:00:00.000 | 2014-07-03 00:00:00.000 |


Table: Tnmt
| Week                    |   Paid | Type    |   NumberOfPlayers | Season   | 1st      | 2nd      | H2H                    |
|:------------------------|-------:|:--------|------------------:|:---------|:---------|:---------|:-----------------------|
| 2014-01-16 00:00:00.000 |      4 | Regular |                17 | 2014 PT1 | Player19 | Player24 | Player19 beat Player24 |
| 2014-01-23 00:00:00.000 |      4 | Regular |                16 | 2014 PT1 | Player12 | Player7  | Player12 beat Player7  |
| 2014-01-30 00:00:00.000 |      4 | Regular |                16 | 2014 PT1 | Player83 | Player7  | Player83 beat Player7  |
| 2014-02-06 00:00:00.000 |      4 | Regular |                18 | 2014 PT1 | Player94 | Player13 | Player94 beat Player13 |
| 2014-02-13 00:00:00.000 |      4 | Regular |                17 | 2014 PT1 | Player27 | Player12 | Player27 beat Player12 |
| 2014-02-20 00:00:00.000 |      4 | Regular |                18 | 2014 PT1 | Player16 | Player14 | Player16 beat Player14 |
| 2014-02-27 00:00:00.000 |      4 | Regular |                21 | 2014 PT1 | Player13 | Player19 | Player13 beat Player19 |
| 2014-03-06 00:00:00.000 |      4 | Regular |                20 | 2014 PT1 | Player7  | Player11 | Player7 beat Player11  |
| 2014-03-13 00:00:00.000 |      4 | Regular |                21 | 2014 PT1 | Player27 | Player13 | Player27 beat Player13 |
| 2014-03-20 00:00:00.000 |      4 | Regular |                17 | 2014 PT1 | Player46 | Player13 | Player46 beat Player13 |


Table: Tournament_Type
| Type        |
|:------------|
| Regular     |
| Bounty      |
| Grand Final |


Table: WholeCareer
| Player    |   Points |   Played |   Late |   1st |   2nd |   3rd |   Bubble |   First Out |   AVG Pts |   Final Table |   Cash |    Cash % |     FT % |   FT-Cash % | Played (L)   |   Best |   Worst |
|:----------|---------:|---------:|-------:|------:|------:|------:|---------:|------------:|----------:|--------------:|-------:|----------:|---------:|------------:|:-------------|-------:|--------:|
| Player8   |  30      |       14 |      7 |     0 |     0 |     0 |        0 |           5 |   1.64286 |             3 |      1 | 0.0714286 | 0.214286 |    0.333333 | 14 (7)       |      1 |      -7 |
| Player9   | 113      |       15 |      3 |     4 |     2 |     0 |        0 |           0 |   6.73336 |             8 |      8 | 0.533333  | 0.533333 |    1        | 15 (3)       |      4 |      -5 |
| Player57  |  13      |        5 |      4 |     0 |     0 |     0 |        0 |           0 |   2.4     |             2 |      1 | 0.2       | 0.4      |    0.5      | 5 (4)        |      1 |      -2 |
| Player96  |   6      |        4 |      2 |     0 |     0 |     0 |        0 |           1 |   1       |             0 |      0 | 0         | 0        |    0        | 4 (2)        |     -1 |      -4 |
| Player49  |  11      |        4 |      4 |     0 |     0 |     1 |        0 |           0 |   2.75    |             1 |      1 | 0.25      | 0.25     |    1        | 4 (4)        |      1 |      -2 |
| Player103 |   3      |        2 |      1 |     0 |     0 |     0 |        0 |           0 |   1       |             0 |      0 | 0         | 0        |    0        | 2 (1)        |     -1 |      -2 |
| Player10  |  16      |        6 |      5 |     0 |     0 |     0 |        0 |           1 |   2.5     |             3 |      1 | 0.166667  | 0.5      |    0.333333 | 6 (5)        |      3 |      -2 |
| Player90  |  29.0001 |        4 |      0 |     1 |     0 |     0 |        0 |           0 |   6.25002 |             3 |      2 | 0.5       | 0.75     |    0.666667 | 4 (0)        |      3 |      -1 |
| Player105 |  22      |        4 |      0 |     0 |     0 |     1 |        0 |           0 |   4.5     |             3 |      2 | 0.5       | 0.75     |    0.666667 | 4 (0)        |      2 |      -1 |
| Player97  |   2      |        1 |      0 |     0 |     0 |     0 |        0 |           0 |   1       |             0 |      0 | 0         | 0        |    0        | 1 (0)        |     -1 |      -1 |

 


tables: name: 2013 PT2
data: 2013 PT2.csv
name: H2H
data: H2H.csv
name: Latest
data: Latest.csv
name: LatestValues
data: LatestValues.csv
name: LeagueFinishes
data: LeagueFinishes.csv
name: LeagueFinishes_1
data: LeagueFinishes_1.csv
name: Players
data: Players.csv
name: Points
data: Points.csv
name: Results
data: Results.csv
name: Seasons
data: Seasons.csv
name: Tnmt
data: Tnmt.csv
name: Tournament_Type
data: Tournament_Type.csv
name: WholeCareer
data: WholeCareer.csv
label: Results
Player
Players
Player
Results
Result
Points
Result
Tnmt
Type
Tournament_Type
Type
Results
Tournament
Tnmt
Week
Tnmt
Season
Seasons
Season
2013 PT2
Player
Players
Player
output: {
    "joins": [
        {
            "from_table": "Results",
            "from_column": "Player",
            "to_table": "Players",
            "to_column": "Player"
        },
        {
            "from_table": "Results",
            "from_column": "Result",
            "to_table": "Points",
            "to_column": "Result"
        },
        {
            "from_table": "Tnmt",
            "from_column": "Type",
            "to_table": "Tournament_Type",
            "to_column": "Type"
        },
        {
            "from_table": "Results",
            "from_column": "Tournament",
            "to_table": "Tnmt",
            "to_column": "Week"
        },
        {
            "from_table": "Tnmt",
            "from_column": "Season",
            "to_table": "Seasons",
            "to_column": "Season"
        },
        {
            "from_table": "2013 PT2",
            "from_column": "Player",
            "to_table": "Players",
            "to_column": "Player"
        }
    ]
}