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: All Senators
|   Likes |   Replies |   Retweets |   Total Interactions | Tweet                                                                                                                                                                                                                                                                   | Date                    | Timestamp               | IsSenator   | Full Name     | IsWinner   |
|--------:|----------:|-----------:|---------------------:|:------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:------------------------|:------------------------|:------------|:--------------|:-----------|
|    2246 |       142 |        765 |                 3153 | Este Jueves estaremos en Edinburg con nuestros amigos @tigresdelnorte, @aatw1969 y Little Joe y la Familia - Acompañanos! http://betofortexas.com/los-tigres http://remezcla.com/music/beto-orourke-los-tigres-del-norte/ …                                             | 2018-10-17 00:00:00.000 | 2018-10-17 18:51:16.000 | True        | Beto O'Rourke | False      |
|   17987 |      1267 |       8328 |                27582 | Last night's debate showed that there is a clear choice in this election. Watch the recap video, RT to share it, and join us in running a campaign that is for everyone, everywhere, every single day.pic.twitter.com/KxfEZ0aq1i                                        | 2018-10-17 00:00:00.000 | 2018-10-17 16:05:31.000 | True        | Beto O'Rourke | False      |
|   29255 |       886 |       5724 |                35865 | A bumper sticker for Walt and Sandra in San Antoniopic.twitter.com/vXYOZIhf2e                                                                                                                                                                                           | 2018-10-17 00:00:00.000 | 2018-10-17 15:42:27.000 | True        | Beto O'Rourke | False      |
|    7154 |       311 |       1436 |                 8901 | TEXAS!!! #TeamBeto #TexasDebatepic.twitter.com/CFIROXkF0J                                                                                                                                                                                                               | 2018-10-17 00:00:00.000 | 2018-10-17 02:30:24.000 | True        | Beto O'Rourke | False      |
|   27451 |       826 |      13641 |                41918 | This is the election of our lifetime. We have the opportunity to inspire Texas, our country, and the world. RT to share Beto's closing statement. #TeamBeto #TexasDebatepic.twitter.com/MYmaIFtq4p                                                                      | 2018-10-17 00:00:00.000 | 2018-10-17 02:25:06.000 | True        | Beto O'Rourke | False      |
|   11040 |       264 |       4116 |                15420 | Cruz mentioned pre-existing conditions but he has AGAIN and AGAIN and AGAIN tried to rollback protections for those with pre-existing conditions. #TeamBeto #TexasDebate                                                                                                | 2018-10-17 00:00:00.000 | 2018-10-17 02:15:42.000 | True        | Beto O'Rourke | False      |
|   21663 |       505 |       5283 |                27451 | Every single one of us deserves to be treated with dignity and respect. #TeamBeto #TexasDebatepic.twitter.com/ftnrb9w6sr                                                                                                                                                | 2018-10-17 00:00:00.000 | 2018-10-17 02:10:15.000 | True        | Beto O'Rourke | False      |
|    1657 |       102 |        511 |                 2270 | "Toda persona en los Estados Unidos merece ser tratada con dignidad y respeto." -Beto #TeamBeto #TexasDebate                                                                                                                                                            | 2018-10-17 00:00:00.000 | 2018-10-17 02:04:58.000 | True        | Beto O'Rourke | False      |
|    7734 |       258 |       2819 |                10811 | The tariffs the president has levied, and the trade wars he has entered this country into, are hurting the state of Texas. They’re hurting our farmers, our ranchers, our manufacturers. #TexasDebate #TeamBetopic.twitter.com/48Jgctj9yR                               | 2018-10-17 00:00:00.000 | 2018-10-17 02:02:56.000 | True        | Beto O'Rourke | False      |
|    4762 |       201 |       2058 |                 7021 | This is exactly what Senator Cruz said about children being taken from their parents: “When you see reporters, when you see Democrats saying don’t separate kids from their parents, what they’re really saying is don’t arrest illegal aliens.” #TeamBeto #TexasDebate | 2018-10-17 00:00:00.000 | 2018-10-17 01:56:09.000 | True        | Beto O'Rourke | False      |


Table: Date
| Date                    |
|:------------------------|
| 2018-10-06 00:00:00.000 |
| 2018-10-07 00:00:00.000 |
| 2018-10-08 00:00:00.000 |
| 2018-10-09 00:00:00.000 |
| 2018-10-10 00:00:00.000 |
| 2018-10-11 00:00:00.000 |
| 2018-10-12 00:00:00.000 |
| 2018-10-13 00:00:00.000 |
| 2018-10-14 00:00:00.000 |
| 2018-10-15 00:00:00.000 |


Table: Senator List
| Candidate        | Party   | State       | First Name   | Last Name   |
|:-----------------|:--------|:------------|:-------------|:------------|
| Martha McSally   | (R)     | Arizona     | Martha       | McSally     |
| Kyrsten Sinema   | (D)     | Arizona     | Kyrsten      | Sinema      |
| Dianne Feinstein | (D)     | California  | Dianne       | Feinstein   |
| Kevin de Leόn    | (D)     | California  | Kevin        | de Leon     |
| Chris Murphy     | (D)     | Connecticut | Chris        | Murphy      |
| Matthew Corey    | (R)     | Connecticut | Matthew      | Corey       |
| Tom Carper       | (D)     | Delaware    | Tom          | Carper      |
| Rob Arlett       | (R)     | Delaware    | Rob          | Arlett      |
| Rick Scott       | (R)     | Florida     | Rick         | Scott       |
| Bill Nelson      | (D)     | Florida     | Bill         | Nelson      |


Table: Winners List
| State         | Winner           |
|:--------------|:-----------------|
| Arizona       | Kyrsten Sinema   |
| California    | Dianne Feinstein |
| Connecticut   | Chris Murphy     |
| Delaware      | Tom Carper       |
| Florida       | Rick Scott       |
| Hawaii        | Mazie Hirono     |
| Indiana       | Mike Braun       |
| Massachusetts | Elizabeth Warren |
| Maryland      | Ben Cardin       |
| Maine         | Angus King       |

 


tables: name: All Senators
data: All Senators.csv
name: Date
data: Date.csv
name: Senator List
data: Senator List.csv
name: Winners List
data: Winners List.csv
label: All Senators
Full Name
Senator List
Candidate
Senator List
State
Winners List
State
output: {
    "joins": [
        {
            "from_table": "All Senators",
            "from_column": "Full Name",
            "to_table": "Senator List",
            "to_column": "Candidate"
        },
        {
            "from_table": "Senator List",
            "from_column": "State",
            "to_table": "Winners List",
            "to_column": "State"
        }
    ]
}