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: %Measures
| %Measures   |
|:------------|
|             |


Table: Gameweeks
|   %event_id | event_name   | deadline_time           |   average_entry_score | finished   | data_checked   |   highest_scoring_entry |   highest_score | is_previous   | is_current   | is_next   | chip_plays                                                                                                                                                                                   |   most_selected_player_id |   most_transferred_in_player_id |   most_points_player_id | top_element_info          |   transfers_made |   gameweek_number | deadline_date           | deadline_time(2)        | cup_leagues_created   | h2h_ko_matches_created   |
|------------:|:-------------|:------------------------|----------------------:|:-----------|:---------------|------------------------:|----------------:|:--------------|:-------------|:----------|:---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|--------------------------:|--------------------------------:|------------------------:|:--------------------------|-----------------:|------------------:|:------------------------|:------------------------|:----------------------|:-------------------------|
|           1 | Gameweek 1   | 2021-08-13 17:30:00.000 |                    69 | True       | True           |                 5059647 |             150 | False         | False        | False     | [{'chip_name': 'bboost', 'num_played': 145658}, {'chip_name': '3xc', 'num_played': 225749}]                                                                                                  |                       275 |                               1 |                     277 | {'id': 277, 'points': 20} |                0 |                 1 | 2021-08-13 00:00:00.000 | 1899-12-30 17:30:00.000 | False                 | False                    |
|           2 | Gameweek 2   | 2021-08-21 10:00:00.000 |                    56 | True       | True           |                 6882931 |             146 | False         | False        | False     | [{'chip_name': 'bboost', 'num_played': 95038}, {'chip_name': 'freehit', 'num_played': 102410}, {'chip_name': 'wildcard', 'num_played': 277209}, {'chip_name': '3xc', 'num_played': 269514}]  |                       277 |                             272 |                     142 | {'id': 142, 'points': 18} |         12038724 |                 2 | 2021-08-21 00:00:00.000 | 1899-12-30 10:00:00.000 | False                 | False                    |
|           3 | Gameweek 3   | 2021-08-28 10:00:00.000 |                    54 | True       | True           |                 7516002 |             119 | False         | False        | False     | [{'chip_name': 'bboost', 'num_played': 94049}, {'chip_name': 'freehit', 'num_played': 117627}, {'chip_name': 'wildcard', 'num_played': 372083}, {'chip_name': '3xc', 'num_played': 138714}]  |                       277 |                             419 |                     268 | {'id': 268, 'points': 18} |         15553648 |                 3 | 2021-08-28 00:00:00.000 | 1899-12-30 10:00:00.000 | False                 | False                    |
|           4 | Gameweek 4   | 2021-09-11 10:00:00.000 |                    57 | True       | True           |                 7797969 |             120 | False         | False        | False     | [{'chip_name': 'bboost', 'num_played': 77204}, {'chip_name': 'freehit', 'num_played': 168976}, {'chip_name': 'wildcard', 'num_played': 1117718}, {'chip_name': '3xc', 'num_played': 157121}] |                       233 |                             579 |                     432 | {'id': 432, 'points': 13} |         28985870 |                 4 | 2021-09-11 00:00:00.000 | 1899-12-30 10:00:00.000 | False                 | False                    |
|           5 | Gameweek 5   | 2021-09-17 17:30:00.000 |                    55 | True       | True           |                 3139954 |             144 | False         | False        | False     | [{'chip_name': 'bboost', 'num_played': 49533}, {'chip_name': 'freehit', 'num_played': 127510}, {'chip_name': 'wildcard', 'num_played': 708431}, {'chip_name': '3xc', 'num_played': 104192}]  |                       233 |                             579 |                      44 | {'id': 44, 'points': 15}  |         18706283 |                 5 | 2021-09-17 00:00:00.000 | 1899-12-30 17:30:00.000 | False                 | False                    |
|           6 | Gameweek 6   | 2021-09-25 10:00:00.000 |                    43 | True       | True           |                 1367510 |             117 | False         | False        | False     | [{'chip_name': 'bboost', 'num_played': 76495}, {'chip_name': 'freehit', 'num_played': 98223}, {'chip_name': 'wildcard', 'num_played': 308300}, {'chip_name': '3xc', 'num_played': 134785}]   |                       233 |                             413 |                      36 | {'id': 36, 'points': 15}  |         13021763 |                 6 | 2021-09-25 00:00:00.000 | 1899-12-30 10:00:00.000 | False                 | False                    |
|           7 | Gameweek 7   | 2021-10-02 10:00:00.000 |                    38 | True       | True           |                 8298401 |             102 | False         | False        | False     | [{'chip_name': 'bboost', 'num_played': 58931}, {'chip_name': 'freehit', 'num_played': 89810}, {'chip_name': 'wildcard', 'num_played': 292085}, {'chip_name': '3xc', 'num_played': 75135}]    |                       233 |                             127 |                     190 | {'id': 190, 'points': 15} |         12625013 |                 7 | 2021-10-02 00:00:00.000 | 1899-12-30 10:00:00.000 | False                 | False                    |
|           8 | Gameweek 8   | 2021-10-16 10:00:00.000 |                    49 | True       | True           |                 8392863 |             122 | False         | False        | False     | [{'chip_name': 'bboost', 'num_played': 54764}, {'chip_name': 'freehit', 'num_played': 74544}, {'chip_name': 'wildcard', 'num_played': 274188}, {'chip_name': '3xc', 'num_played': 102108}]   |                       233 |                             256 |                     228 | {'id': 228, 'points': 20} |         12142633 |                 8 | 2021-10-16 00:00:00.000 | 1899-12-30 10:00:00.000 | False                 | False                    |
|           9 | Gameweek 9   | 2021-10-22 17:30:00.000 |                    64 | True       | True           |                 8103512 |             165 | False         | False        | False     | [{'chip_name': 'bboost', 'num_played': 46614}, {'chip_name': 'freehit', 'num_played': 85712}, {'chip_name': 'wildcard', 'num_played': 167651}, {'chip_name': '3xc', 'num_played': 49975}]    |                       233 |                             205 |                     138 | {'id': 138, 'points': 24} |         11147906 |                 9 | 2021-10-22 00:00:00.000 | 1899-12-30 17:30:00.000 | False                 | False                    |
|          10 | Gameweek 10  | 2021-10-30 10:00:00.000 |                    42 | True       | True           |                 8257657 |             116 | False         | False        | False     | [{'chip_name': 'bboost', 'num_played': 50931}, {'chip_name': 'freehit', 'num_played': 96697}, {'chip_name': 'wildcard', 'num_played': 189850}, {'chip_name': '3xc', 'num_played': 156449}]   |                       233 |                             138 |                     142 | {'id': 142, 'points': 21} |         12690241 |                10 | 2021-10-30 00:00:00.000 | 1899-12-30 10:00:00.000 | False                 | False                    |


Table: Mini Leagues GW Info
|   %manager_id |   GW |   GW_points |   benched_points |   gw_rank |   transfers |   hits |   total_points |   overall_rank |   team_value | Chips Used   | bulk_rank   |
|--------------:|-----:|------------:|-----------------:|----------:|------------:|-------:|---------------:|---------------:|-------------:|:-------------|:------------|
|       1174308 |    3 |          71 |                2 |    616314 |           1 |      0 |            273 |           2903 |        101.1 |              | Top 10k     |
|       1174308 |    5 |          66 |                3 |   1641766 |           1 |      0 |            413 |           1698 |        101.3 |              | Top 10k     |
|       1174308 |    7 |          48 |                8 |   1510840 |           1 |      0 |            508 |           3401 |        101.9 |              | Top 10k     |
|       1174308 |    9 |         105 |               19 |    226128 |           1 |      0 |            680 |            744 |        101.7 |              | Top 10k     |
|       1174308 |   11 |          65 |               27 |    337277 |           1 |      0 |            798 |           1145 |        102.7 |              | Top 10k     |
|       1174308 |   13 |          54 |                0 |   1968491 |           1 |      0 |            922 |           2356 |        103.8 |              | Top 10k     |
|       1174308 |   14 |          60 |                3 |   4502702 |           1 |      0 |            982 |           3810 |        104.1 |              | Top 10k     |
|       1174308 |   17 |          69 |                0 |    436330 |           1 |      0 |           1183 |           1065 |        104.5 |              | Top 10k     |
|       1174308 |   18 |          48 |                0 |   2708723 |           1 |      0 |           1231 |           2663 |        104.6 |              | Top 10k     |
|       1174308 |   22 |         100 |                3 |     43214 |           1 |      0 |           1503 |            657 |        104.2 |              | Top 10k     |


Table: Mini Leagues GW Picks
|      %manager_id |   GW |   %player_id |   field_position |   points_multiplier |   count_id |
|-----------------:|-----:|-------------:|-----------------:|--------------------:|-----------:|
|      1.17431e+06 |    1 |          237 |                2 |                   1 |        237 |
|      1.17431e+06 |    2 |          237 |                2 |                   1 |        237 |
|      1.17431e+06 |    3 |          237 |                2 |                   1 |        237 |
|      1.17431e+06 |    4 |          237 |                2 |                   1 |        237 |
|      1.17431e+06 |    6 |          237 |                2 |                   1 |        237 |
| 272984           |    1 |          237 |                2 |                   1 |        237 |
| 272984           |    2 |          237 |                2 |                   1 |        237 |
| 272984           |    3 |          237 |                2 |                   1 |        237 |
| 272984           |    4 |          237 |                2 |                   1 |        237 |
| 272984           |    6 |          237 |                2 |                   1 |        237 |


Table: Mini Leagues
|   Rank |   %manager_id | Manager                | Team Name           |   Total Points |
|-------:|--------------:|:-----------------------|:--------------------|---------------:|
|      1 |       1174308 | Tony Christensen       | Looping Louie       |           1838 |
|      2 |        272984 | Daniel Sætre           | Super XI            |           1832 |
|      3 |         49759 | Aksel Spence           | 11 Angry Men        |           1791 |
|      4 |       2015160 | Trym Leirvåg           | Nedrykk             |           1765 |
|      5 |       1767909 | Benjamin Buan          | Godt Trent          |           1752 |
|      6 |       3364390 | Anders Blesvik Gandrud | Gandrudpool         |           1738 |
|      7 |        125462 | Björn Jönsson          | Björns fuskbygge    |           1734 |
|      8 |         44922 | Jukka Markkanen        | Kalja tänne ja heti |           1728 |
|      9 |       1777548 | Are O. Pedersen        | Solkysten FC        |           1695 |
|     10 |        661771 | Kenneth Flaglien       | Ygir FC             |           1690 |


Table: Opponent Teams
|   team_code |   %opponent_team_id | team_name      | team_short_name   |   team_strength |   strength_overall_home |   strength_overall_away |   strength_attack_home |   strength_attack_away |   strength_defence_home |   strength_defence_away |   pulse_id |   spi.strength_offence |   spi.strength_defence |   spi.spi_strength | team_group   |
|------------:|--------------------:|:---------------|:------------------|----------------:|------------------------:|------------------------:|-----------------------:|-----------------------:|------------------------:|------------------------:|-----------:|-----------------------:|-----------------------:|-------------------:|:-------------|
|           3 |                   1 | Arsenal        | ARS               |               4 |                    1210 |                    1270 |                   1150 |                   1210 |                    1190 |                    1220 |          1 |                   2.21 |                   0.5  |              82.41 | Top6         |
|          43 |                  12 | Man City       | MCI               |               5 |                    1350 |                    1370 |                   1340 |                   1360 |                    1340 |                    1360 |         11 |                   2.95 |                   0.22 |              93.83 | Top6         |
|           7 |                   2 | Aston Villa    | AVL               |               3 |                    1130 |                    1160 |                   1140 |                   1110 |                    1090 |                    1090 |          2 |                   1.94 |                   0.72 |              73.29 | Promoted     |
|          94 |                   3 | Brentford      | BRE               |               2 |                    1060 |                    1070 |                   1120 |                   1150 |                    1080 |                    1120 |        130 |                   1.74 |                   0.89 |              65.56 | Others       |
|          14 |                  11 | Liverpool      | LIV               |               5 |                    1330 |                    1350 |                   1300 |                   1350 |                    1340 |                    1350 |         10 |                   3.02 |                   0.31 |              92.93 | Top6         |
|          36 |                   4 | Brighton       | BHA               |               3 |                    1130 |                    1130 |                   1160 |                   1160 |                    1100 |                    1120 |        131 |                   1.86 |                   0.59 |              75.1  | Others       |
|          90 |                   5 | Burnley        | BUR               |               2 |                    1060 |                    1050 |                   1080 |                   1130 |                    1060 |                    1100 |         43 |                   1.68 |                   0.78 |              66.97 | Others       |
|           8 |                   6 | Chelsea        | CHE               |               5 |                    1320 |                    1350 |                   1300 |                   1300 |                    1250 |                    1290 |          4 |                   2.41 |                   0.29 |              88.9  | Top6         |
|          31 |                   7 | Crystal Palace | CRY               |               3 |                    1090 |                    1100 |                   1110 |                   1160 |                    1080 |                    1160 |          6 |                   1.85 |                   0.74 |              71.16 | Others       |
|          11 |                   8 | Everton        | EVE               |               3 |                    1090 |                    1090 |                   1130 |                   1090 |                    1110 |                    1110 |          7 |                   1.81 |                   0.9  |              66.42 | Others       |


Table: Player Facts
|   %player_id |   %opponent_team_id | points   | is_home   | kickoff_time            | team_h_score   | team_a_score   | minutes_played   | goals_scored   | assists   | clean_sheets   | goals_conceded   | own_goals   | penalties_saved   | penalties_missed   | yellow_cards   | red_cards   | saves   | bonus   | bps   | influence   | creativity   | threat   | ict_index   | player_price   | transfers_balance   | selected   | transfers_in   | transfers_out   |   %team_id | %team_code   |   %fixture_id |   %fixture_code | event_name   |   difficulty |   %event_id | goal involvement   |   played_game |
|-------------:|--------------------:|:---------|:----------|:------------------------|:---------------|:---------------|:-----------------|:---------------|:----------|:---------------|:-----------------|:------------|:------------------|:-------------------|:---------------|:------------|:--------|:--------|:------|:------------|:-------------|:---------|:------------|:---------------|:--------------------|:-----------|:---------------|:----------------|-----------:|:-------------|--------------:|----------------:|:-------------|-------------:|------------:|:-------------------|--------------:|
|           10 |                  16 |          | True      | 2022-03-05 15:00:00.000 |                |                |                  |                |           |                |                  |             |                   |                    |                |             |         |         |       |             |              |          |             |                |                     |            |                |                 |          2 |              |           271 |         2210541 | Gameweek 28  |            2 |          28 |                    |             0 |
|           28 |                  16 |          | True      | 2022-03-05 15:00:00.000 |                |                |                  |                |           |                |                  |             |                   |                    |                |             |         |         |       |             |              |          |             |                |                     |            |                |                 |          2 |              |           271 |         2210541 | Gameweek 28  |            2 |          28 |                    |             0 |
|           29 |                  16 |          | True      | 2022-03-05 15:00:00.000 |                |                |                  |                |           |                |                  |             |                   |                    |                |             |         |         |       |             |              |          |             |                |                     |            |                |                 |          2 |              |           271 |         2210541 | Gameweek 28  |            2 |          28 |                    |             0 |
|           30 |                  16 |          | True      | 2022-03-05 15:00:00.000 |                |                |                  |                |           |                |                  |             |                   |                    |                |             |         |         |       |             |              |          |             |                |                     |            |                |                 |          2 |              |           271 |         2210541 | Gameweek 28  |            2 |          28 |                    |             0 |
|           31 |                  16 |          | True      | 2022-03-05 15:00:00.000 |                |                |                  |                |           |                |                  |             |                   |                    |                |             |         |         |       |             |              |          |             |                |                     |            |                |                 |          2 |              |           271 |         2210541 | Gameweek 28  |            2 |          28 |                    |             0 |
|           32 |                  16 |          | True      | 2022-03-05 15:00:00.000 |                |                |                  |                |           |                |                  |             |                   |                    |                |             |         |         |       |             |              |          |             |                |                     |            |                |                 |          2 |              |           271 |         2210541 | Gameweek 28  |            2 |          28 |                    |             0 |
|           34 |                  16 |          | True      | 2022-03-05 15:00:00.000 |                |                |                  |                |           |                |                  |             |                   |                    |                |             |         |         |       |             |              |          |             |                |                     |            |                |                 |          2 |              |           271 |         2210541 | Gameweek 28  |            2 |          28 |                    |             0 |
|           35 |                  16 |          | True      | 2022-03-05 15:00:00.000 |                |                |                  |                |           |                |                  |             |                   |                    |                |             |         |         |       |             |              |          |             |                |                     |            |                |                 |          2 |              |           271 |         2210541 | Gameweek 28  |            2 |          28 |                    |             0 |
|           36 |                  16 |          | True      | 2022-03-05 15:00:00.000 |                |                |                  |                |           |                |                  |             |                   |                    |                |             |         |         |       |             |              |          |             |                |                     |            |                |                 |          2 |              |           271 |         2210541 | Gameweek 28  |            2 |          28 |                    |             0 |
|           37 |                  16 |          | True      | 2022-03-05 15:00:00.000 |                |                |                  |                |           |                |                  |             |                   |                    |                |             |         |         |       |             |              |          |             |                |                     |            |                |                 |          2 |              |           271 |         2210541 | Gameweek 28  |            2 |          28 |                    |             0 |


Table: Player Season History
| season_name   |   %player_code | start_price   | end_price   |   total_points |   total_minutes |   goals_scored |   assists |   clean_sheets |   goals_conceded |   own_goals |   penalties_saved |   penalties_missed |   yellow_cards |   red_cards |   saves |   bonus |   goal_involvement |
|:--------------|---------------:|:--------------|:------------|---------------:|----------------:|---------------:|----------:|---------------:|-----------------:|------------:|------------------:|-------------------:|---------------:|------------:|--------:|--------:|-------------------:|
| 2020/21       |         115918 |               |             |              0 |               0 |              0 |         0 |              0 |                0 |           0 |                 0 |                  0 |              0 |           0 |       0 |       0 |                  0 |
| 2020/21       |          47431 |               |             |              0 |               0 |              0 |         0 |              0 |                0 |           0 |                 0 |                  0 |              0 |           0 |       0 |       0 |                  0 |
| 2020/21       |          98745 |               |             |              0 |               0 |              0 |         0 |              0 |                0 |           0 |                 0 |                  0 |              0 |           0 |       0 |       0 |                  0 |
| 2020/21       |         198849 |               |             |              0 |               0 |              0 |         0 |              0 |                0 |           0 |                 0 |                  0 |              0 |           0 |       0 |       0 |                  0 |
| 2020/21       |         233963 |               |             |              0 |               0 |              0 |         0 |              0 |                0 |           0 |                 0 |                  0 |              0 |           0 |       0 |       0 |                  0 |
| 2020/21       |         242166 |               |             |              0 |               0 |              0 |         0 |              0 |                0 |           0 |                 0 |                  0 |              0 |           0 |       0 |       0 |                  0 |
| 2020/21       |         462424 |               |             |              0 |               0 |              0 |         0 |              0 |                0 |           0 |                 0 |                  0 |              0 |           0 |       0 |       0 |                  0 |
| 2020/21       |          85242 |               |             |              0 |               0 |              0 |         0 |              0 |                0 |           0 |                 0 |                  0 |              0 |           0 |       0 |       0 |                  0 |
| 2020/21       |         108156 |               |             |              0 |               0 |              0 |         0 |              0 |                0 |           0 |                 0 |                  0 |              0 |           0 |       0 |       0 |                  0 |
| 2020/21       |         463748 |               |             |              0 |               0 |              0 |         0 |              0 |                0 |           0 |                 0 |                  0 |              0 |           0 |       0 |       0 |                  0 |


Table: Player Type
|   %player_type_id | position_name   | position_name_short   |   squad_select |   squad_min_play |   squad_max_play |   element_count |
|------------------:|:----------------|:----------------------|---------------:|-----------------:|-----------------:|----------------:|
|                 1 | Goalkeeper      | GKP                   |              2 |                1 |                1 |              83 |
|                 2 | Defender        | DEF                   |              5 |                3 |                5 |             240 |
|                 3 | Midfielder      | MID                   |              5 |                2 |                5 |             294 |
|                 4 | Forward         | FWD                   |              3 |                1 |                3 |              93 |


Table: Players
| chance_of_playing_this_round   |   %player_code |   cost_change_event |   cost_change_event_fall |   cost_change_start |   cost_change_start_fall |   %player_type_id | first_name   |   %player_id | news   | news_added   |   player_price | second_name    |   selected_by_percent | status   |   %team_id |   %team_code | web_name     | corners_and_indirect_freekicks_order   | direct_freekicks_order   | penalties_order   | position_name   | position_name_short   | Player name               | photo_url                                                                            |   transfers_in_event |   transfers_out_event | chance_of_playing_next_round   | PP90               |     PPMM |       VAPM |   PPG |   total_points |   total_minutes |
|:-------------------------------|---------------:|--------------------:|-------------------------:|--------------------:|-------------------------:|------------------:|:-------------|-------------:|:-------|:-------------|---------------:|:---------------|----------------------:|:---------|-----------:|-------------:|:-------------|:---------------------------------------|:-------------------------|:------------------|:----------------|:----------------------|:--------------------------|:-------------------------------------------------------------------------------------|---------------------:|----------------------:|:-------------------------------|:-------------------|---------:|-----------:|------:|---------------:|----------------:|
|                                |         437626 |                   0 |                        0 |                  -2 |                        2 |                 2 | Nuno         |          466 |        |              |            4.3 | Varela Tavares |                 0.004 | a        |          1 |            3 | Tavares      |                                        |                          |                   | Defender        | DEF                   | Nuno Varela Tavares       | https://resources.premierleague.com/premierleague/photos/players/110x140/p437626.png |                  129 |                   856 |                                | 4.5072697899838454 | 0.55814  |  0.0930233 |   2.4 |             31 |             619 |
|                                |         225321 |                   0 |                        0 |                   6 |                       -6 |                 1 | Aaron        |          559 |        |              |            5.1 | Ramsdale       |                 0.199 | a        |          1 |            3 | Ramsdale     |                                        |                          |                   | Goalkeeper      | GKP                   | Aaron Ramsdale            | https://resources.premierleague.com/premierleague/photos/players/110x140/p225321.png |                11949 |                 31546 |                                | 5.0265957446808507 | 0.980392 |  0.588235  |   5   |            105 |            1880 |
|                                |         220682 |                   0 |                        0 |                  -1 |                        1 |                 1 | Arthur       |          572 |        |              |            3.9 | Okonkwo        |                 0.007 | a        |          1 |            3 | Okonkwo      |                                        |                          |                   | Goalkeeper      | GKP                   | Arthur Okonkwo            | https://resources.premierleague.com/premierleague/photos/players/110x140/p220682.png |                 5423 |                  1015 |                                |                    | 0        | -0.512821  |   0   |              0 |               0 |
|                                |         450544 |                   0 |                        0 |                   0 |                        0 |                 3 | Charlie      |          664 |        |              |            4.5 | Patino         |                 0     | a        |          1 |            3 | Patino       |                                        |                          |                   | Midfielder      | MID                   | Charlie Patino            | https://resources.premierleague.com/premierleague/photos/players/110x140/p450544.png |                   99 |                    62 |                                |                    | 0        | -0.444444  |   0   |              0 |               0 |
|                                |         503301 |                   0 |                        0 |                   0 |                        0 |                 3 | Omari        |          692 |        |              |            4.5 | Hutchinson     |                 0     | a        |          1 |            3 | Hutchinson   |                                        |                          |                   | Midfielder      | MID                   | Omari Hutchinson          | https://resources.premierleague.com/premierleague/photos/players/110x140/p503301.png |                   17 |                    12 |                                |                    | 0        | -0.444444  |   0   |              0 |               0 |
|                                |         498046 |                   0 |                        0 |                   0 |                        0 |                 3 | Salah-Eddine |          693 |        |              |            4.5 | Oulad M'hand   |                 0     | a        |          1 |            3 | Oulad M'hand |                                        |                          |                   | Midfielder      | MID                   | Salah-Eddine Oulad M'hand | https://resources.premierleague.com/premierleague/photos/players/110x140/p498046.png |                   15 |                    11 |                                |                    | 0        | -0.444444  |   0   |              0 |               0 |
|                                |         444880 |                   0 |                        0 |                   0 |                        0 |                 4 | Mika         |          694 |        |              |            4.5 | Biereth        |                 0.001 | a        |          1 |            3 | Biereth      |                                        |                          |                   | Forward         | FWD                   | Mika Biereth              | https://resources.premierleague.com/premierleague/photos/players/110x140/p444880.png |                 1017 |                   558 |                                |                    | 0        | -0.444444  |   0   |              0 |               0 |
|                                |         490887 |                   0 |                        0 |                   0 |                        0 |                 2 | Zach         |          705 |        |              |            4   | Awe            |                 0     | a        |          1 |            3 | Awe          |                                        |                          |                   | Defender        | DEF                   | Zach Awe                  | https://resources.premierleague.com/premierleague/photos/players/110x140/p490887.png |                  158 |                    56 |                                |                    | 0        | -0.5       |   0   |              0 |               0 |
|                                |         123354 |                   0 |                        0 |                  -1 |                        1 |                 2 | Kortney      |           36 |        |              |            4.4 | Hause          |                 0.002 | a        |          2 |            7 | Hause        |                                        |                          |                   | Defender        | DEF                   | Kortney Hause             | https://resources.premierleague.com/premierleague/photos/players/110x140/p123354.png |                   97 |                   217 |                                | 4.5340050377833752 | 0.659091 |  0.204545  |   2.9 |             20 |             397 |
|                                |         248164 |                   0 |                        0 |                   0 |                        0 |                 1 | Viljami      |          596 |        |              |            4   | Sinisalo       |                 0.001 | a        |          2 |            7 | Sinisalo     |                                        |                          |                   | Goalkeeper      | GKP                   | Viljami Sinisalo          | https://resources.premierleague.com/premierleague/photos/players/110x140/p248164.png |                  101 |                    86 |                                |                    | 0        | -0.5       |   0   |              0 |               0 |


Table: Teams
|   team_code |   %team_id | team_name      | team_short_name   |   team_strength |   strength_overall_home |   strength_overall_away |   strength_attack_home |   strength_attack_away |   strength_defence_home |   strength_defence_away |   pulse_id |   spi.strength_offence |   spi.strength_defence |   spi.spi_strength | team_group   |
|------------:|-----------:|:---------------|:------------------|----------------:|------------------------:|------------------------:|-----------------------:|-----------------------:|------------------------:|------------------------:|-----------:|-----------------------:|-----------------------:|-------------------:|:-------------|
|           3 |          1 | Arsenal        | ARS               |               4 |                    1210 |                    1270 |                   1150 |                   1210 |                    1190 |                    1220 |          1 |                   2.21 |                   0.5  |              82.41 | Top6         |
|          43 |         12 | Man City       | MCI               |               5 |                    1350 |                    1370 |                   1340 |                   1360 |                    1340 |                    1360 |         11 |                   2.95 |                   0.22 |              93.83 | Top6         |
|           7 |          2 | Aston Villa    | AVL               |               3 |                    1130 |                    1160 |                   1140 |                   1110 |                    1090 |                    1090 |          2 |                   1.94 |                   0.72 |              73.29 | Promoted     |
|          94 |          3 | Brentford      | BRE               |               2 |                    1060 |                    1070 |                   1120 |                   1150 |                    1080 |                    1120 |        130 |                   1.74 |                   0.89 |              65.56 | Others       |
|          14 |         11 | Liverpool      | LIV               |               5 |                    1330 |                    1350 |                   1300 |                   1350 |                    1340 |                    1350 |         10 |                   3.02 |                   0.31 |              92.93 | Top6         |
|          36 |          4 | Brighton       | BHA               |               3 |                    1130 |                    1130 |                   1160 |                   1160 |                    1100 |                    1120 |        131 |                   1.86 |                   0.59 |              75.1  | Others       |
|          90 |          5 | Burnley        | BUR               |               2 |                    1060 |                    1050 |                   1080 |                   1130 |                    1060 |                    1100 |         43 |                   1.68 |                   0.78 |              66.97 | Others       |
|           8 |          6 | Chelsea        | CHE               |               5 |                    1320 |                    1350 |                   1300 |                   1300 |                    1250 |                    1290 |          4 |                   2.41 |                   0.29 |              88.9  | Top6         |
|          31 |          7 | Crystal Palace | CRY               |               3 |                    1090 |                    1100 |                   1110 |                   1160 |                    1080 |                    1160 |          6 |                   1.85 |                   0.74 |              71.16 | Others       |
|          11 |          8 | Everton        | EVE               |               3 |                    1090 |                    1090 |                   1130 |                   1090 |                    1110 |                    1110 |          7 |                   1.81 |                   0.9  |              66.42 | Others       |


Table: TopN
|   TopN |
|-------:|
|      0 |
|      5 |
|     10 |
|     15 |
|     20 |


Table: Understat Player
|   understat_id | player_name               |         xG |       xA |   shots |   key_passes |       npxG |    xGChain |   xGBuildup |      xGA |   %player_id |
|---------------:|:--------------------------|-----------:|---------:|--------:|-------------:|-----------:|-----------:|------------:|---------:|-------------:|
|           1250 | Mohamed Salah             | 19.3517    | 7.716    |      99 |           49 | 15.5458    | 26.3023    |   9.06661   | 27.0677  |          233 |
|            181 | Bernd Leno                |  0         | 0        |       0 |            0 |  0         |  0.0970277 |   0.0970277 |  0       |            1 |
|           6854 | Diogo Jota                | 13.8399    | 4.06945  |      63 |           28 | 13.8399    | 20.1505    |   5.79234   | 17.9094  |          240 |
|            838 | Sadio Mané                | 13.4381    | 4.34334  |      71 |           27 | 13.4381    | 21.6531    |   8.33774   | 17.7815  |          230 |
|            453 | Son Heung-Min             |  8.67394   | 5.2003   |      53 |           46 |  8.67394   | 16.56      |   5.9675    | 13.8742  |          359 |
|            318 | Pierre-Emerick Aubameyang |  6.89322   | 0.801416 |      34 |            9 |  5.37088   |  5.43936   |   0.963661  |  7.69464 |            4 |
|            618 | Raheem Sterling           | 11.3723    | 3.50343  |      45 |           30 |  9.08881   | 15.2519    |   7.02815   | 14.8757  |          255 |
|            847 | Cédric Soares             |  0.0405458 | 0.327754 |       2 |            4 |  0.0405458 |  1.22702   |   1.0184    |  0.3683  |            5 |
|            755 | Jamie Vardy               |  6.06394   | 1.18359  |      36 |           14 |  6.06394   |  7.67796   |   1.25946   |  7.24753 |          205 |
|           3277 | Alexandre Lacazette       |  5.9316    | 2.66957  |      32 |           24 |  4.40926   |  7.18837   |   2.59667   |  8.60117 |            6 |


Table: Understat Teams
| h_a   |       xG |      xGA |     npxG |    npxGA |   shots |   shots_against |   goals_scored |   goals_against |   xpts |     npxGD |   %team_id |
|:------|---------:|---------:|---------:|---------:|--------:|----------------:|---------------:|----------------:|-------:|----------:|-----------:|
| h     | 1.44499  | 0.980166 | 1.44499  | 0.980166 |       5 |               2 |              3 |               1 | 1.7799 |  0.464824 |          1 |
| h     | 3.4984   | 1.41088  | 2.62648  | 1.41088  |      14 |               7 |              3 |               1 | 2.6395 |  1.2156   |          1 |
| a     | 3.69008  | 1.31408  | 3.69008  | 0.55291  |      14 |               7 |              4 |               1 | 2.6983 |  3.13717  |          1 |
| h     | 1.52247  | 0.640726 | 1.52247  | 0.640726 |       3 |               4 |              2 |               1 | 2.0689 |  0.881744 |          1 |
| h     | 2.50961  | 1.10934  | 2.50961  | 1.10934  |      23 |               2 |              2 |               1 | 2.2782 |  1.40027  |          1 |
| h     | 0.431464 | 1.13312  | 0.431464 | 1.13312  |       2 |               8 |              1 |               1 | 0.6785 | -0.701656 |          2 |
| a     | 0.536077 | 0.89818  | 0.536077 | 0.89818  |      13 |               8 |              0 |               1 | 0.9174 | -0.362103 |          2 |
| a     | 0.454305 | 0.962129 | 0.454305 | 0.962129 |       6 |               5 |              2 |               1 | 0.7951 | -0.507824 |          2 |
| h     | 1.84818  | 0.982614 | 1.84818  | 0.982614 |       7 |              12 |              2 |               1 | 2.0334 |  0.865566 |          2 |
| a     | 0.140573 | 2.71181  | 0.140573 | 1.95064  |       4 |              15 |              0 |               1 | 0.0507 | -1.81007  |          2 |

 


tables: name: %Measures
data: %Measures.csv
name: Gameweeks
data: Gameweeks.csv
name: Mini Leagues GW Info
data: Mini Leagues GW Info.csv
name: Mini Leagues GW Picks
data: Mini Leagues GW Picks.csv
name: Mini Leagues
data: Mini Leagues.csv
name: Opponent Teams
data: Opponent Teams.csv
name: Player Facts
data: Player Facts.csv
name: Player Season History
data: Player Season History.csv
name: Player Type
data: Player Type.csv
name: Players
data: Players.csv
name: Teams
data: Teams.csv
name: TopN
data: TopN.csv
name: Understat Player
data: Understat Player.csv
name: Understat Teams
data: Understat Teams.csv
label: Player Season History
%player_code
Players
%player_code
Players
%player_type_id
Player Type
%player_type_id
Player Facts
%player_id
Players
%player_id
Player Facts
%team_id
Teams
%team_id
Player Facts
%opponent_team_id
Opponent Teams
%opponent_team_id
Player Facts
%event_id
Gameweeks
%event_id
Mini Leagues GW Picks
%manager_id
Mini Leagues
%manager_id
Mini Leagues GW Picks
%player_id
Players
%player_id
Mini Leagues GW Info
%manager_id
Mini Leagues
%manager_id
Understat Player
%player_id
Players
%player_id
Understat Teams
%team_id
Teams
%team_id
output: {
    "joins": [
        {
            "from_table": "Player Season History",
            "from_column": "%player_code",
            "to_table": "Players",
            "to_column": "%player_code"
        },
        {
            "from_table": "Players",
            "from_column": "%player_type_id",
            "to_table": "Player Type",
            "to_column": "%player_type_id"
        },
        {
            "from_table": "Player Facts",
            "from_column": "%player_id",
            "to_table": "Players",
            "to_column": "%player_id"
        },
        {
            "from_table": "Player Facts",
            "from_column": "%team_id",
            "to_table": "Teams",
            "to_column": "%team_id"
        },
        {
            "from_table": "Player Facts",
            "from_column": "%opponent_team_id",
            "to_table": "Opponent Teams",
            "to_column": "%opponent_team_id"
        },
        {
            "from_table": "Player Facts",
            "from_column": "%event_id",
            "to_table": "Gameweeks",
            "to_column": "%event_id"
        },
        {
            "from_table": "Mini Leagues GW Picks",
            "from_column": "%manager_id",
            "to_table": "Mini Leagues",
            "to_column": "%manager_id"
        },
        {
            "from_table": "Mini Leagues GW Picks",
            "from_column": "%player_id",
            "to_table": "Players",
            "to_column": "%player_id"
        },
        {
            "from_table": "Mini Leagues GW Info",
            "from_column": "%manager_id",
            "to_table": "Mini Leagues",
            "to_column": "%manager_id"
        },
        {
            "from_table": "Understat Player",
            "from_column": "%player_id",
            "to_table": "Players",
            "to_column": "%player_id"
        },
        {
            "from_table": "Understat Teams",
            "from_column": "%team_id",
            "to_table": "Teams",
            "to_column": "%team_id"
        }
    ]
}