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: Actors Bridge
| Title                    | Actors                |
|:-------------------------|:----------------------|
| The Shawshank Redemption | Tim Robbins           |
| The Shawshank Redemption | Morgan Freeman        |
| The Shawshank Redemption | Bob Gunton            |
| The Shawshank Redemption | William Sadler        |
| The Godfather            | Marlon Brando         |
| The Godfather            | Al Pacino             |
| The Godfather            | James Caan            |
| The Godfather            | Richard S. Castellano |
| The Godfather: Part II   | Al Pacino             |
| The Godfather: Part II   | Robert Duvall         |


Table: Actors
| Actors                |
|:----------------------|
| Tim Robbins           |
| Morgan Freeman        |
| Bob Gunton            |
| William Sadler        |
| Marlon Brando         |
| Al Pacino             |
| James Caan            |
| Richard S. Castellano |
| Robert Duvall         |
| Diane Keaton          |


Table: Country Bridge
| Title                                         | Country   |
|:----------------------------------------------|:----------|
| The Shawshank Redemption                      | USA       |
| The Godfather                                 | USA       |
| The Godfather: Part II                        | USA       |
| The Dark Knight                               | USA       |
| 12 Angry Men                                  | USA       |
| Schindler's List                              | USA       |
| Pulp Fiction                                  | USA       |
| The Lord of the Rings: The Return of the King | USA       |
| The Good, the Bad and the Ugly                | USA       |
| Fight Club                                    | USA       |


Table: Country
| Country      |
|:-------------|
| USA          |
| UK           |
| New Zealand  |
| Italy        |
| Spain        |
| West Germany |
| Germany      |
| Japan        |
| Brazil       |
| France       |


Table: Director Bridge
| Title                                         | Director             |
|:----------------------------------------------|:---------------------|
| The Shawshank Redemption                      | Frank Darabont       |
| The Godfather                                 | Francis Ford Coppola |
| The Godfather: Part II                        | Francis Ford Coppola |
| The Dark Knight                               | Christopher Nolan    |
| 12 Angry Men                                  | Sidney Lumet         |
| Schindler's List                              | Steven Spielberg     |
| Pulp Fiction                                  | Quentin Tarantino    |
| The Lord of the Rings: The Return of the King | Peter Jackson        |
| The Good, the Bad and the Ugly                | Sergio Leone         |
| Fight Club                                    | David Fincher        |


Table: Director
| Director             |
|:---------------------|
| Frank Darabont       |
| Francis Ford Coppola |
| Christopher Nolan    |
| Sidney Lumet         |
| Steven Spielberg     |
| Quentin Tarantino    |
| Peter Jackson        |
| Sergio Leone         |
| David Fincher        |
| Irvin Kershner       |


Table: Genre Bridge
| Title                                             | Genre   |
|:--------------------------------------------------|:--------|
| The Shawshank Redemption                          | Drama   |
| The Godfather                                     | Drama   |
| The Godfather: Part II                            | Drama   |
| The Dark Knight                                   | Drama   |
| 12 Angry Men                                      | Drama   |
| Schindler's List                                  | Drama   |
| Pulp Fiction                                      | Drama   |
| The Lord of the Rings: The Return of the King     | Drama   |
| Fight Club                                        | Drama   |
| The Lord of the Rings: The Fellowship of the Ring | Drama   |


Table: Genre
| Genre     |
|:----------|
| Crime     |
| Drama     |
| Action    |
| Biography |
| History   |
| Adventure |
| Fantasy   |
| Western   |
| Comedy    |
| Sci-Fi    |


Table: TopMovies
|   Rank | Title                                          |   Year | Actors                                                             | Awards                                                    | Country   | Director                        | Genre                      |   imdbRating |   imdbVotes | Language   | Metascore   | Plot                                                                                                                                                                                                                                           | Poster                                                                                                                                          | Rated    | Released                |   Runtime | Writer                                                                                                                                                            |
|-------:|:-----------------------------------------------|-------:|:-------------------------------------------------------------------|:----------------------------------------------------------|:----------|:--------------------------------|:---------------------------|-------------:|------------:|:-----------|:------------|:-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:------------------------------------------------------------------------------------------------------------------------------------------------|:---------|:------------------------|----------:|:------------------------------------------------------------------------------------------------------------------------------------------------------------------|
|      1 | The Shawshank Redemption                       |   1994 | Tim Robbins, Morgan Freeman, Bob Gunton, William Sadler            | Nominated for 7 Oscars. Another 19 wins & 30 nominations. | USA       | Frank Darabont                  | Crime, Drama               |          9.3 |     1725904 | English    | 80          | Two imprisoned men bond over a number of years, finding solace and eventual redemption through acts of common decency.                                                                                                                         | https://images-na.ssl-images-amazon.com/images/M/MV5BODU4MjU4NjIwNl5BMl5BanBnXkFtZTgwMDU2MjEyMDE@._V1_SX300.jpg                                 | R        | 1994-10-14 00:00:00.000 |       142 | Stephen King (short story "Rita Hayworth and Shawshank Redemption"), Frank Darabont (screenplay)                                                                  |
|      5 | 12 Angry Men                                   |   1957 | Martin Balsam, John Fiedler, Lee J. Cobb, E.G. Marshall            | Nominated for 3 Oscars. Another 16 wins & 8 nominations.  | USA       | Sidney Lumet                    | Crime, Drama               |          8.9 |      462820 | English    |             | A jury holdout attempts to prevent a miscarriage of justice by forcing his colleagues to reconsider the evidence.                                                                                                                              | https://images-na.ssl-images-amazon.com/images/M/MV5BODQwOTc5MDM2N15BMl5BanBnXkFtZTcwODQxNTEzNA@@._V1_SX300.jpg                                 | APPROVED | 1957-04-01 00:00:00.000 |        96 | Reginald Rose (story), Reginald Rose (screenplay)                                                                                                                 |
|     12 | Star Wars: Episode V - The Empire Strikes Back |   1980 | Mark Hamill, Harrison Ford, Carrie Fisher, Billy Dee Williams      | Won 1 Oscar. Another 19 wins & 18 nominations.            | USA       | Irvin Kershner                  | Action, Adventure, Fantasy |          8.8 |      855007 | English    | 80          | After the rebels have been brutally overpowered by the Empire on their newly established base, Luke Skywalker takes advanced Jedi training with Master Yoda, while his friends are pursued by Darth Vader as part of his plan to capture Luke. | https://images-na.ssl-images-amazon.com/images/M/MV5BYmViY2M2MTYtY2MzOS00YjQ1LWIzYmEtOTBiNjhlMGM0NjZjXkEyXkFqcGdeQXVyNDYyMDk5MTU@._V1_SX300.jpg | PG       | 1980-06-20 00:00:00.000 |       124 | Leigh Brackett (screenplay), Lawrence Kasdan (screenplay), George Lucas (story by)                                                                                |
|     13 | Forrest Gump                                   |   1994 | Tom Hanks, Rebecca Williams, Sally Field, Michael Conner Humphreys | Won 6 Oscars. Another 39 wins & 65 nominations.           | USA       | Robert Zemeckis                 | Comedy, Drama              |          8.8 |     1291467 | English    | 82          | Forrest Gump, while not intelligent, has accidentally been present at many historic moments, but his true love, Jenny Curran, eludes him.                                                                                                      | https://images-na.ssl-images-amazon.com/images/M/MV5BYThjM2MwZGMtMzg3Ny00NGRkLWE4M2EtYTBiNWMzOTY0YTI4XkEyXkFqcGdeQXVyNDYyMDk5MTU@._V1_SX300.jpg | PG-13    | 1994-07-06 00:00:00.000 |       142 | Winston Groom (novel), Eric Roth (screenplay)                                                                                                                     |
|     16 | One Flew Over the Cuckoo's Nest                |   1975 | Michael Berryman, Peter Brocco, Dean R. Brooks, Alonzo Brown       | Won 5 Oscars. Another 30 wins & 13 nominations.           | USA       | Milos Forman                    | Drama                      |          8.7 |      695341 | English    | 79          | A criminal pleads insanity after getting into trouble again and once in the mental institution rebels against the oppressive nurse and rallies up the scared patients.                                                                         | https://images-na.ssl-images-amazon.com/images/M/MV5BYmJkODkwOTItZThjZC00MTE0LWIxNzQtYTM3MmQwMGI1OWFiXkEyXkFqcGdeQXVyNjUwNzk3NDc@._V1_SX300.jpg | R        | 1975-11-19 00:00:00.000 |       133 | Lawrence Hauben (screenplay), Bo Goldman (screenplay), Ken Kesey (based on the novel by), Dale Wasserman (the play version: "One Flew Over the Cuckoo's Nest" by) |
|     18 | The Matrix                                     |   1999 | Keanu Reeves, Laurence Fishburne, Carrie-Anne Moss, Hugo Weaving   | Won 4 Oscars. Another 33 wins & 43 nominations.           | USA       | Lana Wachowski, Lilly Wachowski | Action, Sci-Fi             |          8.7 |     1244275 | English    | 73          | A computer hacker learns from mysterious rebels about the true nature of his reality and his role in the war against its controllers.                                                                                                          | https://images-na.ssl-images-amazon.com/images/M/MV5BMDMyMmQ5YzgtYWMxOC00OTU0LWIwZjEtZWUwYTY5MjVkZjhhXkEyXkFqcGdeQXVyNDYyMDk5MTU@._V1_SX300.jpg | R        | 1999-03-31 00:00:00.000 |       136 | Lilly Wachowski, Lana Wachowski                                                                                                                                   |
|     20 | Star Wars: Episode IV - A New Hope             |   1977 | Mark Hamill, Harrison Ford, Carrie Fisher, Peter Cushing           | Won 6 Oscars. Another 48 wins & 28 nominations.           | USA       | George Lucas                    | Action, Adventure, Fantasy |          8.7 |      933758 | English    | 92          | Luke Skywalker joins forces with a Jedi Knight, a cocky pilot, a wookiee and two droids to save the galaxy from the Empire's world-destroying battle-station, while also attempting to rescue Princess Leia from the evil Darth Vader.         | https://images-na.ssl-images-amazon.com/images/M/MV5BZGEzZTExMDEtNjg4OC00NjQxLTk5NTUtNjRkNjA3MmYwZjg1XkEyXkFqcGdeQXVyMTQxNzMzNDI@._V1_SX300.jpg | PG       | 1977-05-25 00:00:00.000 |       121 | George Lucas                                                                                                                                                      |
|     22 | Se7en                                          |   1995 | Morgan Freeman, Andrew Kevin Walker, Daniel Zacapa, Brad Pitt      | Nominated for 1 Oscar. Another 25 wins & 34 nominations.  | USA       | David Fincher                   | Crime, Drama, Mystery      |          8.6 |     1047788 | English    | 65          | Two detectives, a rookie and a veteran, hunt a serial killer who uses the seven deadly sins as his modus operandi.                                                                                                                             | https://images-na.ssl-images-amazon.com/images/M/MV5BMTQwNTU3MTE4NF5BMl5BanBnXkFtZTcwOTgxNDM2Mg@@._V1_SX300.jpg                                 | R        | 1995-09-22 00:00:00.000 |       127 | Andrew Kevin Walker                                                                                                                                               |
|     23 | The Silence of the Lambs                       |   1991 | Jodie Foster, Lawrence A. Bonney, Kasi Lemmons, Lawrence T. Wrentz | Won 5 Oscars. Another 48 wins & 34 nominations.           | USA       | Jonathan Demme                  | Crime, Drama, Thriller     |          8.6 |      907862 | English    | 84          | A young F.B.I. cadet must confide in an incarcerated and manipulative killer to receive his help on catching another serial killer who skins his victims.                                                                                      | https://images-na.ssl-images-amazon.com/images/M/MV5BMTQ2NzkzMDI4OF5BMl5BanBnXkFtZTcwMDA0NzE1NA@@._V1_SX300.jpg                                 | R        | 1991-02-14 00:00:00.000 |       118 | Thomas Harris (novel), Ted Tally (screenplay)                                                                                                                     |
|     24 | It's a Wonderful Life                          |   1946 | James Stewart, Donna Reed, Lionel Barrymore, Thomas Mitchell       | Nominated for 5 Oscars. Another 6 wins & 1 nomination.    | USA       | Frank Capra                     | Drama, Family, Fantasy     |          8.6 |      282600 | English    |             | An angel helps a compassionate but despairingly frustrated businessman by showing what life would have been like if he never existed.                                                                                                          | https://images-na.ssl-images-amazon.com/images/M/MV5BMTMzMzY5NDc4M15BMl5BanBnXkFtZTcwMzc4NjIxNw@@._V1_SX300.jpg                                 | PG       | 1947-01-07 00:00:00.000 |       130 | Frances Goodrich (screenplay), Albert Hackett (screenplay), Frank Capra (screenplay), Jo Swerling (additional scenes), Philip Van Doren Stern (story)             |

 


tables: name: Actors Bridge
data: Actors Bridge.csv
name: Actors
data: Actors.csv
name: Country Bridge
data: Country Bridge.csv
name: Country
data: Country.csv
name: Director Bridge
data: Director Bridge.csv
name: Director
data: Director.csv
name: Genre Bridge
data: Genre Bridge.csv
name: Genre
data: Genre.csv
name: TopMovies
data: TopMovies.csv
label: Actors Bridge
Title
TopMovies
Title
Country Bridge
Title
TopMovies
Title
Director Bridge
Title
TopMovies
Title
Genre Bridge
Title
TopMovies
Title
Actors Bridge
Actors
Actors
Actors
Country Bridge
Country
Country
Country
Director Bridge
Director
Director
Director
Genre Bridge
Genre
Genre
Genre
output: {
    "joins": [
        {
            "from_table": "Actors Bridge",
            "from_column": "Title",
            "to_table": "TopMovies",
            "to_column": "Title"
        },
        {
            "from_table": "Country Bridge",
            "from_column": "Title",
            "to_table": "TopMovies",
            "to_column": "Title"
        },
        {
            "from_table": "Director Bridge",
            "from_column": "Title",
            "to_table": "TopMovies",
            "to_column": "Title"
        },
        {
            "from_table": "Genre Bridge",
            "from_column": "Title",
            "to_table": "TopMovies",
            "to_column": "Title"
        },
        {
            "from_table": "Actors Bridge",
            "from_column": "Actors",
            "to_table": "Actors",
            "to_column": "Actors"
        },
        {
            "from_table": "Country Bridge",
            "from_column": "Country",
            "to_table": "Country",
            "to_column": "Country"
        },
        {
            "from_table": "Director Bridge",
            "from_column": "Director",
            "to_table": "Director",
            "to_column": "Director"
        },
        {
            "from_table": "Genre Bridge",
            "from_column": "Genre",
            "to_table": "Genre",
            "to_column": "Genre"
        }
    ]
}