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: Date
| Date                    |
|:------------------------|
| 2008-01-01 00:00:00.000 |
| 2008-01-02 00:00:00.000 |
| 2008-01-03 00:00:00.000 |
| 2008-01-04 00:00:00.000 |
| 2008-01-05 00:00:00.000 |
| 2008-01-06 00:00:00.000 |
| 2008-01-07 00:00:00.000 |
| 2008-01-08 00:00:00.000 |
| 2008-01-09 00:00:00.000 |
| 2008-01-10 00:00:00.000 |


Table: Distinct Formations
| Distinct_Formations   |
|:----------------------|
| 4-4-2                 |
| 3-4-3                 |
| 3-5-2                 |
| 4-5-1                 |
| 4-3-3                 |
| 5-3-2                 |
| 5-4-1                 |
| 3-3-3-1               |
| 4-2-1-3               |
| 4-1-4-1               |


Table: Formula
| Column   |
|----------|


Table: latest_teamplayers
| team_name             | team_player             | player_number   |   player_number_order | Player Legend             |
|:----------------------|:------------------------|:----------------|----------------------:|:--------------------------|
| KRC Genk              | Marco Bizot             | player_1        |                     1 | 1_Marco Bizot             |
| SV Werder Bremen      | Felix Wiedwald          | player_1        |                     1 | 1_Felix Wiedwald          |
| DSC Arminia Bielefeld | Dennis Eilhoff          | player_1        |                     1 | 1_Dennis Eilhoff          |
| Hertha BSC Berlin     | Rune Almenning Jarstein | player_1        |                     1 | 1_Rune Almenning Jarstein |
| RC Recreativo         | Asier Riesgo            | player_1        |                     1 | 1_Asier Riesgo            |
| Eintracht Frankfurt   | Lucas Hradecky          | player_1        |                     1 | 1_Lucas Hradecky          |
| 1. FC KÃ¶ln           | Thomas Kessler          | player_1        |                     1 | 1_Thomas Kessler          |
| VfL Wolfsburg         | Koen Casteels           | player_1        |                     1 | 1_Koen Casteels           |
| FC Luzern             | David Zibung            | player_1        |                     1 | 1_David Zibung            |
| Hannover 96           | Ron-Robert Zieler       | player_1        |                     1 | 1_Ron-Robert Zieler       |


Table: latest_teamplayers_order
| player_number   |   player_number_order |
|:----------------|----------------------:|
| player_1        |                     1 |
| player_2        |                     2 |
| player_3        |                     3 |
| player_4        |                     4 |
| player_5        |                     5 |
| player_6        |                     6 |
| player_7        |                     7 |
| player_8        |                     8 |
| player_9        |                     9 |
| player_10       |                    10 |


Table: match_dashboard_away
|   match_api_id | match_date              | Season    | country   |   home_team_goals_difference |   away_team_goals_difference |   games_won_home_team |   games_won_away_team |   games_against_won |   games_against_lost |   B365_Win |   B365_Draw |   B365_Defeat |   BW_Win |   BW_Draw |   BW_Defeat | label   |   home_team_overall_rating |   away_team_overall_rating | league_name     | home_team_long_name        | away_team_long_name        | home_formation   | away_formation   |
|---------------:|:------------------------|:----------|:----------|-----------------------------:|-----------------------------:|----------------------:|----------------------:|--------------------:|---------------------:|-----------:|------------:|--------------:|---------:|----------:|------------:|:--------|---------------------------:|---------------------------:|:----------------|:---------------------------|:---------------------------|:-----------------|:-----------------|
|         530243 | 2008-11-16 00:00:00.000 | 2008/2009 | Spain     |                           -1 |                            1 |                     2 |                     3 |                   0 |                    0 |   0.490373 |    0.275474 |      0.234153 | 0.464891 |  0.283293 |    0.251816 | Win     |                        793 |                        797 | Spain LIGA BBVA | Real Betis BalompiÃ©       | Racing Santander           | 4-2-3-1          | 4-2-3-1          |
|         530258 | 2008-11-23 00:00:00.000 | 2008/2009 | Spain     |                           -4 |                           -4 |                     2 |                     1 |                   0 |                    0 |   0.46896  |    0.284218 |      0.246821 | 0.481636 |  0.276904 |    0.24146  | Win     |                        805 |                        784 | Spain LIGA BBVA | RC Deportivo de La CoruÃ±a | Athletic Club de Bilbao    | 4-2-3-1          | 4-2-3-1          |
|         530330 | 2008-11-30 00:00:00.000 | 2008/2009 | Spain     |                           -2 |                           -6 |                     3 |                     0 |                   0 |                    0 |   0.424837 |    0.287582 |      0.287582 | 0.441943 |  0.287614 |    0.270443 | Win     |                        749 |                        774 | Spain LIGA BBVA | MÃ¡laga CF                 | CA Osasuna                 | 4-2-3-1          | 4-2-3-1          |
|         530332 | 2008-11-30 00:00:00.000 | 2008/2009 | Spain     |                           -6 |                            0 |                     1 |                     0 |                   0 |                    0 |   0.50786  |    0.26844  |      0.2237   | 0.490552 |  0.288102 |    0.221347 | Win     |                        777 |                        766 | Spain LIGA BBVA | Athletic Club de Bilbao    | CD Numancia                | 4-2-3-1          | 4-2-3-1          |
|         530333 | 2008-12-07 00:00:00.000 | 2008/2009 | Spain     |                           -2 |                            0 |                     3 |                     4 |                   0 |                    0 |   0.490373 |    0.275474 |      0.234153 | 0.47734  |  0.27073  |    0.25193  | Win     |                        826 |                        753 | Spain LIGA BBVA | RC Deportivo de La CoruÃ±a | MÃ¡laga CF                 | 4-2-3-1          | 4-2-3-1          |
|         530347 | 2008-12-14 00:00:00.000 | 2008/2009 | Spain     |                            2 |                            0 |                     6 |                     4 |                   0 |                    0 |   0.447368 |    0.276316 |      0.276316 | 0.413081 |  0.283993 |    0.302926 | Win     |                        803 |                        826 | Spain LIGA BBVA | Real Valladolid            | RC Deportivo de La CoruÃ±a | 4-2-3-1          | 4-2-3-1          |
|         530352 | 2008-12-14 00:00:00.000 | 2008/2009 | Spain     |                           -2 |                           -1 |                     4 |                     1 |                   0 |                    0 |   0.481137 |    0.284308 |      0.234554 | 0.503124 |  0.278653 |    0.218223 | Win     |                        755 |                        767 | Spain LIGA BBVA | MÃ¡laga CF                 | CD Numancia                | 4-2-3-1          | 4-2-3-1          |
|         530354 | 2008-12-21 00:00:00.000 | 2008/2009 | Spain     |                           -1 |                           -9 |                     4 |                     1 |                   0 |                    0 |   0.40931  |    0.313804 |      0.276886 | 0.394139 |  0.318077 |    0.287784 | Win     |                        733 |                        805 | Spain LIGA BBVA | Real Sporting de GijÃ³n    | UD AlmerÃ­a                 | 4-2-3-1          | 4-2-3-1          |
|         530361 | 2008-12-21 00:00:00.000 | 2008/2009 | Spain     |                           -3 |                            4 |                     1 |                     6 |                   0 |                    0 |   0.37816  |    0.278059 |      0.343782 | 0.362951 |  0.288057 |    0.348992 | Win     |                        770 |                        803 | Spain LIGA BBVA | CD Numancia                | Real Valladolid            | 4-2-3-1          | 4-2-3-1          |
|         530372 | 2009-01-04 00:00:00.000 | 2008/2009 | Spain     |                          -10 |                            0 |                     1 |                     4 |                   0 |                    0 |   0.398695 |    0.286336 |      0.314969 | 0.378211 |  0.297609 |    0.324181 | Win     |                        807 |                        793 | Spain LIGA BBVA | UD AlmerÃ­a                 | Real Betis BalompiÃ©       | 4-2-3-1          | 4-2-3-1          |


Table: match_dashboard_home
|   match_api_id | match_date              | Season    | country   |   home_team_goals_difference |   away_team_goals_difference |   games_won_home_team |   games_won_away_team |   games_against_won |   games_against_lost |   B365_Win |   B365_Draw |   B365_Defeat |   BW_Win |   BW_Draw |   BW_Defeat | label   |   home_team_overall_rating |   away_team_overall_rating | league_name     | home_team_long_name        | away_team_long_name        | home_formation   | away_formation   |
|---------------:|:------------------------|:----------|:----------|-----------------------------:|-----------------------------:|----------------------:|----------------------:|--------------------:|---------------------:|-----------:|------------:|--------------:|---------:|----------:|------------:|:--------|---------------------------:|---------------------------:|:----------------|:---------------------------|:---------------------------|:-----------------|:-----------------|
|         530243 | 2008-11-16 00:00:00.000 | 2008/2009 | Spain     |                           -1 |                            1 |                     2 |                     3 |                   0 |                    0 |   0.490373 |    0.275474 |      0.234153 | 0.464891 |  0.283293 |    0.251816 | Win     |                        793 |                        797 | Spain LIGA BBVA | Real Betis BalompiÃ©       | Racing Santander           | 4-2-3-1          | 4-2-3-1          |
|         530258 | 2008-11-23 00:00:00.000 | 2008/2009 | Spain     |                           -4 |                           -4 |                     2 |                     1 |                   0 |                    0 |   0.46896  |    0.284218 |      0.246821 | 0.481636 |  0.276904 |    0.24146  | Win     |                        805 |                        784 | Spain LIGA BBVA | RC Deportivo de La CoruÃ±a | Athletic Club de Bilbao    | 4-2-3-1          | 4-2-3-1          |
|         530330 | 2008-11-30 00:00:00.000 | 2008/2009 | Spain     |                           -2 |                           -6 |                     3 |                     0 |                   0 |                    0 |   0.424837 |    0.287582 |      0.287582 | 0.441943 |  0.287614 |    0.270443 | Win     |                        749 |                        774 | Spain LIGA BBVA | MÃ¡laga CF                 | CA Osasuna                 | 4-2-3-1          | 4-2-3-1          |
|         530332 | 2008-11-30 00:00:00.000 | 2008/2009 | Spain     |                           -6 |                            0 |                     1 |                     0 |                   0 |                    0 |   0.50786  |    0.26844  |      0.2237   | 0.490552 |  0.288102 |    0.221347 | Win     |                        777 |                        766 | Spain LIGA BBVA | Athletic Club de Bilbao    | CD Numancia                | 4-2-3-1          | 4-2-3-1          |
|         530333 | 2008-12-07 00:00:00.000 | 2008/2009 | Spain     |                           -2 |                            0 |                     3 |                     4 |                   0 |                    0 |   0.490373 |    0.275474 |      0.234153 | 0.47734  |  0.27073  |    0.25193  | Win     |                        826 |                        753 | Spain LIGA BBVA | RC Deportivo de La CoruÃ±a | MÃ¡laga CF                 | 4-2-3-1          | 4-2-3-1          |
|         530347 | 2008-12-14 00:00:00.000 | 2008/2009 | Spain     |                            2 |                            0 |                     6 |                     4 |                   0 |                    0 |   0.447368 |    0.276316 |      0.276316 | 0.413081 |  0.283993 |    0.302926 | Win     |                        803 |                        826 | Spain LIGA BBVA | Real Valladolid            | RC Deportivo de La CoruÃ±a | 4-2-3-1          | 4-2-3-1          |
|         530352 | 2008-12-14 00:00:00.000 | 2008/2009 | Spain     |                           -2 |                           -1 |                     4 |                     1 |                   0 |                    0 |   0.481137 |    0.284308 |      0.234554 | 0.503124 |  0.278653 |    0.218223 | Win     |                        755 |                        767 | Spain LIGA BBVA | MÃ¡laga CF                 | CD Numancia                | 4-2-3-1          | 4-2-3-1          |
|         530354 | 2008-12-21 00:00:00.000 | 2008/2009 | Spain     |                           -1 |                           -9 |                     4 |                     1 |                   0 |                    0 |   0.40931  |    0.313804 |      0.276886 | 0.394139 |  0.318077 |    0.287784 | Win     |                        733 |                        805 | Spain LIGA BBVA | Real Sporting de GijÃ³n    | UD AlmerÃ­a                 | 4-2-3-1          | 4-2-3-1          |
|         530361 | 2008-12-21 00:00:00.000 | 2008/2009 | Spain     |                           -3 |                            4 |                     1 |                     6 |                   0 |                    0 |   0.37816  |    0.278059 |      0.343782 | 0.362951 |  0.288057 |    0.348992 | Win     |                        770 |                        803 | Spain LIGA BBVA | CD Numancia                | Real Valladolid            | 4-2-3-1          | 4-2-3-1          |
|         530372 | 2009-01-04 00:00:00.000 | 2008/2009 | Spain     |                          -10 |                            0 |                     1 |                     4 |                   0 |                    0 |   0.398695 |    0.286336 |      0.314969 | 0.378211 |  0.297609 |    0.324181 | Win     |                        807 |                        793 | Spain LIGA BBVA | UD AlmerÃ­a                 | Real Betis BalompiÃ©       | 4-2-3-1          | 4-2-3-1          |


Table: match_teamplayers
|   match_api_id | country   | league                 |   home_team_goal |   away_team_goal | home_team_long_name   |   home_team_api_id | away_team_long_name   |   away_team_api_id |   home_team_goals_difference |   away_team_goals_difference |   games_against_won |   games_against_lost | label   |   home_player_X1 |   home_player_Y1 |   home_player_X2 |   home_player_Y2 |   home_player_X3 |   home_player_Y3 |   home_player_X4 |   home_player_Y4 |   home_player_X5 |   home_player_Y5 |   home_player_X6 |   home_player_Y6 |   home_player_X7 |   home_player_Y7 |   home_player_X8 |   home_player_Y8 |   home_player_X9 |   home_player_Y9 |   home_player_X10 |   home_player_Y10 |   home_player_X11 |   home_player_Y11 |   away_player_X1 |   away_player_Y1 |   away_player_X2 |   away_player_Y2 |   away_player_X3 |   away_player_Y3 |   away_player_X4 |   away_player_Y4 |   away_player_X5 |   away_player_Y5 |   away_player_X6 |   away_player_Y6 |   away_player_X7 |   away_player_Y7 |   away_player_X8 |   away_player_Y8 |   away_player_X9 |   away_player_Y9 |   away_player_X10 |   away_player_Y10 |   away_player_X11 |   away_player_Y11 | home_player_1       | home_player_2      | home_player_3   | home_player_4     | home_player_5      | home_player_6   | home_player_7     | home_player_8           | home_player_9         | home_player_10      | home_player_11    | away_player_1       | away_player_2     | away_player_3           | away_player_4    | away_player_5         | away_player_6       | away_player_7          | away_player_8    | away_player_9         | away_player_10           | away_player_11    | date                    | season    |
|---------------:|:----------|:-----------------------|-----------------:|-----------------:|:----------------------|-------------------:|:----------------------|-------------------:|-----------------------------:|-----------------------------:|--------------------:|---------------------:|:--------|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|------------------:|------------------:|------------------:|------------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|------------------:|------------------:|------------------:|------------------:|:--------------------|:-------------------|:----------------|:------------------|:-------------------|:----------------|:------------------|:------------------------|:----------------------|:--------------------|:------------------|:--------------------|:------------------|:------------------------|:-----------------|:----------------------|:--------------------|:-----------------------|:-----------------|:----------------------|:-------------------------|:------------------|:------------------------|:----------|
|        1224134 | Belgium   | Belgium Jupiler League |                1 |                1 | KSV Cercle Brugge     |               9984 | Oud-Heverlee Leuven   |               1773 |                           -3 |                           10 |                   1 |                    1 | Draw    |                1 |                1 |                2 |                3 |                4 |                3 |                6 |                3 |                8 |                3 |                2 |                7 |                4 |                7 |                6 |                7 |                8 |                7 |                 4 |                10 |                 6 |                10 |                1 |                1 |                2 |                3 |                4 |                3 |                6 |                3 |                8 |                3 |                2 |                7 |                4 |                7 |                6 |                7 |                8 |                7 |                 4 |                10 |                 6 |                10 | Bram Verbist        | Bernt Evens        | Hans Cornelis   | Stef Wils         | Arnar Vidarsson    | Tim Smolders    | Lucas van Eenoo   | Karel van Roose         | Mushaga Bakenga       | Rudy                | Eidur Gudjohnsen  | Logan Bailly        | Robson            | Koen Weuts              | Ludovic Buysens  | Gunther Vanaudenaerde | Kenneth van Goethem | Karel Geraerts         | Evariste Ngolok  | Stefan Gislason       | Ebrahima Ibou Sawaneh    | Derick Chuka Ogbu | 2012-12-08 00:00:00.000 | 2012/2013 |
|        1224158 | Belgium   | Belgium Jupiler League |                1 |                1 | Waasland-Beveren      |               8475 | KRC Genk              |               9987 |                           -5 |                            2 |                   0 |                    0 | Draw    |                1 |                1 |                2 |                3 |                4 |                3 |                6 |                3 |                8 |                3 |                2 |                7 |                4 |                7 |                6 |                7 |                8 |                7 |                 4 |                10 |                 6 |                10 |                1 |                1 |                2 |                3 |                4 |                3 |                6 |                3 |                8 |                3 |                2 |                7 |                4 |                7 |                6 |                7 |                8 |                7 |                 4 |                10 |                 6 |                10 | Colin Coosemans     | Karim Belhocine    | Gal Shish       | Cedric D'Ulivo    | Siebe Blondelle    | Bas Sibum       | Jonny Rowell      | Daniel Cruz             | Christophe Lepoint    | Barak Badash        | Wesley Sonck      | Kristof van Hout    | Kalidou Koulibaly | Brian Hamalainen        | Anele Ngcongca   | Jose Nadson           | Khaleem Hyland      | Julien Gorius          | Thomas Buffel    | Benjamin De Ceulaer   | Jelle Vossen             | Elyaniv Barda     | 2012-12-26 00:00:00.000 | 2012/2013 |
|        1224031 | Belgium   | Belgium Jupiler League |                1 |                1 | KRC Genk              |               9987 | Waasland-Beveren      |               8475 |                            6 |                           -7 |                   0 |                    0 | Draw    |                1 |                1 |                2 |                3 |                4 |                3 |                6 |                3 |                8 |                3 |                2 |                7 |                4 |                7 |                6 |                7 |                8 |                7 |                 4 |                10 |                 6 |                10 |                1 |                1 |                2 |                3 |                4 |                3 |                6 |                3 |                8 |                3 |                2 |                7 |                4 |                7 |                6 |                7 |                8 |                7 |                 4 |                10 |                 6 |                10 | Kristof van Hout    | Dani Fernandez     | Jeroen Simaeys  | Kalidou Koulibaly | Brian Hamalainen   | Thomas Buffel   | Khaleem Hyland    | Julien Gorius           | Steven Joseph-Monrose | Benjamin De Ceulaer | Jelle Vossen      | Michael Clepkens    | Cedric D'Ulivo    | Kristof Lardenoit       | Karim Belhocine  | Gal Shish             | Benoit Ladriere     | Bas Sibum              | Rachid Farssi    | Augusto Da Silva      | Vito Plut                | Barak Badash      | 2012-09-15 00:00:00.000 | 2012/2013 |
|        1224029 | Belgium   | Belgium Jupiler League |                1 |                1 | Lierse SK             |               9989 | Oud-Heverlee Leuven   |               1773 |                            0 |                           -6 |                   1 |                    0 | Draw    |                1 |                1 |                2 |                3 |                4 |                3 |                6 |                3 |                8 |                3 |                2 |                7 |                4 |                7 |                6 |                7 |                8 |                7 |                 4 |                10 |                 6 |                10 |                1 |                1 |                2 |                3 |                4 |                3 |                6 |                3 |                8 |                3 |                2 |                7 |                4 |                7 |                6 |                7 |                8 |                7 |                 4 |                10 |                 6 |                10 | Matz Sels           | Miguel Dachelet    | Karim Saidi     | Ahmed Saied Okka  | Ahmed Samir Farag  | Dolly Menga     | Thomas Wils       | Rachid Bourabia         | Hussein Yasser        | Mohamed El Gabbas   | Kostadin Hazurov  | Logan Bailly        | Ludovic Buysens   | Jonas De Roeck          | Wim Raymaekers   | Kenny Thompson        | Evariste Ngolok     | Stefan Gislason        | Karel Geraerts   | Kenneth van Goethem   | Thomas Guimaraes Azevedo | Derick Chuka Ogbu | 2012-09-01 00:00:00.000 | 2012/2013 |
|        1032739 | Belgium   | Belgium Jupiler League |                1 |                1 | Lierse SK             |               9989 | Sporting Lokeren      |               9994 |                           -2 |                           -1 |                   0 |                    0 | Draw    |                1 |                1 |                2 |                3 |                4 |                3 |                6 |                3 |                8 |                3 |                2 |                7 |                4 |                7 |                6 |                7 |                8 |                7 |                 4 |                10 |                 6 |                10 |                1 |                1 |                2 |                3 |                4 |                3 |                6 |                3 |                8 |                3 |                2 |                7 |                4 |                7 |                6 |                7 |                8 |                7 |                 4 |                10 |                 6 |                10 | Eiji Kawashima      | Gonzague Vandooren | Boban Grncarov  | Kenny Thompson    | Thomas Wils        | Karim Saidi     | Milos Maric       | Joerie Dequevy          | Daylon Claasen        | Ibrahim Ayew        | Mohamed El Gabbas | Boubacar Barry Copa | Ibrahima Gueye    | Tshilola Tshinyama Tiko | Jeremy Taravel   | Derrick Tshimanga     | Ivan Leko           | Koen Persoons          | Killan Overmeire | Benjamin De Ceulaer   | Benjamin Mokulu Tembe    | Nill De Pauw      | 2011-09-10 00:00:00.000 | 2011/2012 |
|        1032895 | Belgium   | Belgium Jupiler League |                1 |                1 | Sint-Truidense VV     |               9997 | Lierse SK             |               9989 |                          -12 |                           -2 |                   2 |                    0 | Draw    |                1 |                1 |                2 |                3 |                4 |                3 |                6 |                3 |                8 |                3 |                2 |                7 |                4 |                7 |                6 |                7 |                8 |                7 |                 4 |                10 |                 6 |                10 |                1 |                1 |                2 |                3 |                4 |                3 |                6 |                3 |                8 |                3 |                2 |                7 |                4 |                7 |                6 |                7 |                8 |                7 |                 4 |                10 |                 6 |                10 | Davino Verhulst     | Vincent Euvrard    | Ludovic Buysens | Sascha Kotysch    | Dimitri Daeselaire | Wim Mennes      | Gregory Dufer     | Giel Deferm             | Nils Schouterden      | Giuseppe Rossini    | Dolly Menga       | Eiji Kawashima      | Kris De Wree      | Karim Saidi             | Siboniso Pa Gaxa | Frederik Frans        | Milos Maric         | Daylon Claasen         | Thomas Wils      | Wesley Sonck          | Hussein Yasser           | Sofian Bidaoui    | 2012-02-18 00:00:00.000 | 2011/2012 |
|        1032898 | Belgium   | Belgium Jupiler League |                1 |                1 | Sporting Lokeren      |               9994 | KAA Gent              |               9991 |                            2 |                            4 |                   1 |                    2 | Draw    |                1 |                1 |                2 |                3 |                4 |                3 |                6 |                3 |                8 |                3 |                2 |                7 |                4 |                7 |                6 |                7 |                8 |                7 |                 4 |                10 |                 6 |                10 |                1 |                1 |                2 |                3 |                4 |                3 |                6 |                3 |                8 |                3 |                2 |                7 |                4 |                7 |                6 |                7 |                8 |                7 |                 4 |                10 |                 6 |                10 | Jugoslav Lazic      | Jeremy Taravel     | Mijat Maric     | Giorgos Galitsios | Laurens De Bock    | Koen Persoons   | Ivan Leko         | Benjamin De Ceulaer     | Jore Trompet          | Hamdi Harbaoui      | Nill De Pauw      | Sergio Padt         | Melli             | Cesar Arzo              | Rafinha          | Remi Mareval          | Jesper Joergensen   | Hannes van der Bruggen | Mikkel Diskerud  | Christian Bruels      | Ilombe Mboyo             | Yaya Soumahoro    | 2012-02-18 00:00:00.000 | 2011/2012 |
|        1032753 | Belgium   | Belgium Jupiler League |                1 |                1 | Oud-Heverlee Leuven   |               1773 | KRC Genk              |               9987 |                            0 |                            5 |                   0 |                    0 | Draw    |                1 |                1 |                2 |                3 |                4 |                3 |                6 |                3 |                8 |                3 |                2 |                7 |                4 |                7 |                6 |                7 |                8 |                7 |                 4 |                10 |                 6 |                10 |                1 |                1 |                2 |                3 |                4 |                3 |                6 |                3 |                8 |                3 |                2 |                7 |                4 |                7 |                6 |                7 |                8 |                7 |                 4 |                10 |                 6 |                10 | Yves Lenaerts       | Nicky Hayen        | Frederik Boi    | Wim Raymaekers    | Koen Weuts         | Karel Geraerts  | Floribert Ngalula | Maxime Annys            | Jordan Remacle        | Bjorn Ruytinx       | Derick Chuka Ogbu | Laszlo Koteles      | Jeroen Simaeys    | David Hubert            | Anele Ngcongca   | Jose Nadson           | Thomas Buffel       | Daniel Tozser          | Daniel Pudil     | Elyaniv Barda         | Jelle Vossen             | Kennedy Ugoala    | 2011-09-24 00:00:00.000 | 2011/2012 |
|         665322 | Belgium   | Belgium Jupiler League |                1 |                1 | Sporting Lokeren      |               9994 | SV Zulte-Waregem      |              10000 |                            0 |                           -3 |                   0 |                    0 | Draw    |                1 |                1 |                2 |                3 |                4 |                3 |                6 |                3 |                8 |                3 |                2 |                7 |                4 |                7 |                6 |                7 |                8 |                7 |                 4 |                10 |                 6 |                10 |                1 |                1 |                2 |                3 |                4 |                3 |                6 |                3 |                8 |                3 |                2 |                7 |                4 |                7 |                6 |                7 |                8 |                7 |                 4 |                10 |                 6 |                10 | Boubacar Barry Copa | Olivier Doll       | Frederic Dupre  | Ibrahima Gueye    | Hassan El Mouataz  | Marcel MBayo,25 | Mario Carevic     | Tshilola Tshinyama Tiko | Sulejman Smajic       | Tomislav Sokota     | Nill De Pauw      | Sammy Bossuyt       | Steve Colpaert    | Stijn Minne             | Bart Buysse      | Jeremy Taravel        | Stijn Meert         | Karel D'Haene          | Kevin Roelandts  | Franck Berrier        | Chris Makiese            | Khaleem Hyland    | 2009-08-01 00:00:00.000 | 2009/2010 |
|         665430 | Belgium   | Belgium Jupiler League |                1 |                1 | Sporting Lokeren      |               9994 | KSV Cercle Brugge     |               9984 |                          -10 |                           -5 |                   0 |                    0 | Draw    |                1 |                1 |                2 |                3 |                4 |                3 |                6 |                3 |                8 |                3 |                2 |                7 |                4 |                7 |                6 |                7 |                8 |                7 |                 4 |                10 |                 6 |                10 |                1 |                1 |                2 |                3 |                4 |                3 |                6 |                3 |                8 |                3 |                2 |                7 |                4 |                7 |                6 |                7 |                8 |                7 |                 4 |                10 |                 6 |                10 | Boubacar Barry Copa | Avi Strool         | Yoav Ziv        | Ibrahima Gueye    | Hassan El Mouataz  | Mario Carevic   | Killan Overmeire  | Sulejman Smajic         | Tomislav Sokota       | Dawid Janczyk       | Nill De Pauw      | Jo Coppens          | Denis Viane       | Anthony Portier         | Hans Cornelis    | Frederik Boi          | Oleg Iachtchouk     | Sergiy Serebrennikov   | Jelle Vossen     | Vusumuzi Prince Nyoni | Honour Gombami           | Dominic Foley     | 2009-10-17 00:00:00.000 | 2009/2010 |


Table: Player
| player_name        |
|:-------------------|
| Aaron Appindangoye |
| Aaron Cresswell    |
| Aaron Doran        |
| Aaron Galindo      |
| Aaron Hughes       |
| Aaron Hunt         |
| Aaron Kuhl         |
| Aaron Lennon       |
| Aaron Lennox       |
| Aaron Meijers      |


Table: players_dashboard
| player_name      |   player_fifa_api_id | birthday                |   height |   weight | date                    |   overall_rating |   potential | preferred_foot   | attacking_work_rate   | defensive_work_rate   |   crossing |   finishing |   heading_accuracy |   short_passing |   volleys |   dribbling |   curve |   free_kick_accuracy |   long_passing |   ball_control |   acceleration |   sprint_speed |   agility |   reactions |   balance |   shot_power |   jumping |   stamina |   strength |   long_shots |   aggression |   interceptions |   positioning |   vision |   penalties |   marking |   standing_tackle |   sliding_tackle |   gk_diving |   gk_handling |   gk_kicking |   gk_positioning |   gk_reflexes |   age |
|:-----------------|---------------------:|:------------------------|---------:|---------:|:------------------------|-----------------:|------------:|:-----------------|:----------------------|:----------------------|-----------:|------------:|-------------------:|----------------:|----------:|------------:|--------:|---------------------:|---------------:|---------------:|---------------:|---------------:|----------:|------------:|----------:|-------------:|----------:|----------:|-----------:|-------------:|-------------:|----------------:|--------------:|---------:|------------:|----------:|------------------:|-----------------:|------------:|--------------:|-------------:|-----------------:|--------------:|------:|
| Arnaud De Greef  |               203214 | 1992-04-12 00:00:00.000 |   182.88 |      176 | 2012-02-22 00:00:00.000 |               61 |          72 | right            | medium                | medium                |         52 |          48 |                 62 |              56 |        42 |          45 |      54 |                   44 |             54 |             57 |             66 |             68 |        67 |          63 |        65 |           63 |        86 |        58 |         71 |           52 |           64 |              62 |            46 |       43 |          45 |        59 |                63 |               62 |           9 |             9 |            9 |                7 |             8 |    19 |
| Arnaud De Greef  |               203214 | 1992-04-12 00:00:00.000 |   182.88 |      176 | 2011-08-30 00:00:00.000 |               63 |          72 | right            | medium                | medium                |         48 |          48 |                 62 |              55 |        42 |          43 |      54 |                   44 |             53 |             57 |             64 |             68 |        66 |          62 |        65 |           63 |        84 |        56 |         71 |           52 |           63 |              62 |            46 |       42 |          45 |        58 |                64 |               62 |           9 |             9 |            9 |                7 |             8 |    19 |
| Arnaud De Greef  |               203214 | 1992-04-12 00:00:00.000 |   182.88 |      176 | 2007-02-22 00:00:00.000 |               63 |          72 | right            | medium                | medium                |         48 |          48 |                 62 |              55 |        42 |          43 |      54 |                   44 |             53 |             57 |             64 |             68 |        66 |          62 |        65 |           63 |        84 |        56 |         71 |           52 |           63 |              62 |            46 |       42 |          45 |        58 |                64 |               62 |           9 |             9 |            9 |                7 |             8 |    14 |
| Christian Maggio |               149184 | 1982-02-11 00:00:00.000 |   182.88 |      174 | 2016-05-05 00:00:00.000 |               75 |          75 | right            | medium                | medium                |         79 |          67 |                 77 |              76 |        79 |          73 |      72 |                   55 |             74 |             78 |             78 |             79 |        74 |          76 |        67 |           78 |        91 |        79 |         78 |           71 |           73 |              67 |            74 |       58 |          57 |        65 |                77 |               77 |           9 |             5 |            9 |               11 |             9 |    34 |
| Christian Maggio |               149184 | 1982-02-11 00:00:00.000 |   182.88 |      174 | 2016-04-21 00:00:00.000 |               75 |          75 | right            | medium                | medium                |         79 |          67 |                 77 |              76 |        79 |          73 |      72 |                   55 |             74 |             78 |             78 |             79 |        74 |          76 |        67 |           78 |        91 |        79 |         78 |           71 |           73 |              67 |            74 |       58 |          57 |        65 |                77 |               77 |           9 |             5 |            9 |               11 |             9 |    34 |
| Christian Maggio |               149184 | 1982-02-11 00:00:00.000 |   182.88 |      174 | 2016-02-04 00:00:00.000 |               75 |          75 | right            | medium                | medium                |         79 |          67 |                 77 |              76 |        79 |          73 |      72 |                   55 |             74 |             78 |             78 |             79 |        74 |          76 |        67 |           78 |        91 |        79 |         78 |           71 |           77 |              67 |            74 |       58 |          57 |        65 |                77 |               77 |           9 |             5 |            9 |               11 |             9 |    34 |
| Christian Maggio |               149184 | 1982-02-11 00:00:00.000 |   182.88 |      174 | 2015-11-26 00:00:00.000 |               76 |          76 | right            | medium                | medium                |         79 |          67 |                 77 |              76 |        79 |          73 |      72 |                   55 |             74 |             78 |             78 |             79 |        74 |          76 |        67 |           78 |        91 |        84 |         78 |           71 |           77 |              67 |            74 |       58 |          57 |        65 |                77 |               77 |           9 |             5 |            9 |               11 |             9 |    33 |
| Christian Maggio |               149184 | 1982-02-11 00:00:00.000 |   182.88 |      174 | 2015-09-21 00:00:00.000 |               76 |          76 | right            | medium                | medium                |         79 |          67 |                 77 |              76 |        79 |          73 |      72 |                   55 |             74 |             78 |             78 |             79 |        74 |          76 |        67 |           78 |        91 |        89 |         78 |           71 |           77 |              67 |            74 |       58 |          57 |        65 |                77 |               77 |           9 |             5 |            9 |               11 |             9 |    33 |
| Christian Maggio |               149184 | 1982-02-11 00:00:00.000 |   182.88 |      174 | 2014-04-18 00:00:00.000 |               77 |          77 | right            | medium                | medium                |         78 |          70 |                 80 |              79 |        80 |          75 |      72 |                   55 |             76 |             78 |             79 |             85 |        74 |          76 |        67 |           80 |        91 |        88 |         78 |           74 |           77 |              68 |            74 |       68 |          57 |        68 |                78 |               76 |           9 |             5 |            9 |               11 |             9 |    32 |
| Christian Maggio |               149184 | 1982-02-11 00:00:00.000 |   182.88 |      174 | 2014-01-31 00:00:00.000 |               77 |          77 | right            | medium                | medium                |         78 |          70 |                 80 |              79 |        80 |          75 |      72 |                   55 |             76 |             78 |             79 |             85 |        74 |          77 |        67 |           80 |        91 |        88 |         78 |           74 |           77 |              68 |            74 |       68 |          57 |        68 |                78 |               76 |           9 |             5 |            9 |               11 |             9 |    31 |

 


tables: name: Date
data: Date.csv
name: Distinct Formations
data: Distinct Formations.csv
name: Formula
data: Formula.csv
name: latest_teamplayers
data: latest_teamplayers.csv
name: latest_teamplayers_order
data: latest_teamplayers_order.csv
name: match_dashboard_away
data: match_dashboard_away.csv
name: match_dashboard_home
data: match_dashboard_home.csv
name: match_teamplayers
data: match_teamplayers.csv
name: Player
data: Player.csv
name: players_dashboard
data: players_dashboard.csv
label: match_dashboard_home
home_formation
Distinct Formations
Distinct_Formations
match_dashboard_away
away_formation
Distinct Formations
Distinct_Formations
latest_teamplayers
player_number_order
latest_teamplayers_order
player_number_order
latest_teamplayers
team_player
players_dashboard
player_name
output: {
    "joins": [
        {
            "from_table": "match_dashboard_home",
            "from_column": "home_formation",
            "to_table": "Distinct Formations",
            "to_column": "Distinct_Formations"
        },
        {
            "from_table": "match_dashboard_away",
            "from_column": "away_formation",
            "to_table": "Distinct Formations",
            "to_column": "Distinct_Formations"
        },
        {
            "from_table": "latest_teamplayers",
            "from_column": "player_number_order",
            "to_table": "latest_teamplayers_order",
            "to_column": "player_number_order"
        },
        {
            "from_table": "latest_teamplayers",
            "from_column": "team_player",
            "to_table": "players_dashboard",
            "to_column": "player_name"
        }
    ]
}