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: ActivityCoordinate
| Activity             |      X |      Y |
|:---------------------|-------:|-------:|
| Dessert              |  0     |  5     |
| Education            |  1.806 |  4.662 |
| Entertainment        |  3.368 |  3.695 |
| Exercise             |  4.476 |  2.229 |
| Food                 |  4.979 |  0.461 |
| Game                 |  4.809 | -1.368 |
| Housework            |  3.99  | -3.013 |
| Meeting              |  2.632 | -4.251 |
| Offline Conversation |  0.919 | -4.915 |
| Personal Care        | -0.919 | -4.915 |


Table: ActivityTop
| Time                    | Activity   |
|:------------------------|:-----------|
| 1899-12-30 00:00:00.000 | Sleeping   |
| 1899-12-30 00:15:00.000 | Sleeping   |
| 1899-12-30 00:30:00.000 | Sleeping   |
| 1899-12-30 00:45:00.000 | Sleeping   |
| 1899-12-30 01:00:00.000 | Sleeping   |
| 1899-12-30 01:15:00.000 | Sleeping   |
| 1899-12-30 01:30:00.000 | Sleeping   |
| 1899-12-30 01:45:00.000 | Sleeping   |
| 1899-12-30 02:00:00.000 | Sleeping   |
| 1899-12-30 02:15:00.000 | Sleeping   |


Table: ActivityTopGainPain
| Time                    | Activity   | Pain   | Gain   |
|:------------------------|:-----------|:-------|:-------|
| 1899-12-30 00:00:00.000 | Sleeping   |        |        |
| 1899-12-30 00:00:00.000 | Sleeping   |        |        |
| 1899-12-30 00:00:00.000 | Sleeping   |        |        |
| 1899-12-30 00:00:00.000 | Sleeping   |        |        |
| 1899-12-30 00:00:00.000 | Sleeping   |        |        |
| 1899-12-30 00:00:00.000 | Sleeping   |        |        |
| 1899-12-30 00:00:00.000 | Sleeping   |        |        |
| 1899-12-30 00:15:00.000 | Sleeping   |        |        |
| 1899-12-30 00:15:00.000 | Sleeping   |        |        |
| 1899-12-30 00:15:00.000 | Sleeping   |        |        |


Table: OfflineCoordinate
| Activity             |      X |      Y |
|:---------------------|-------:|-------:|
| Dessert              |  0     |  5     |
| Education            |  1.806 |  4.662 |
| Entertainment        |  3.368 |  3.695 |
| Exercise             |  4.476 |  2.229 |
| Food                 |  4.979 |  0.461 |
| Game                 |  4.809 | -1.368 |
| Housework            |  3.99  | -3.013 |
| Meeting              |  2.632 | -4.251 |
| Offline Conversation |  0.919 | -4.915 |
| Personal Care        | -0.919 | -4.915 |


Table: StudentTimeline
| Student   | Time                    | Activity   | Pain   | Gain   |      X |     Y |
|:----------|:------------------------|:-----------|:-------|:-------|-------:|------:|
| S05       | 1899-12-30 01:00:00.000 | Sleeping   |        |        | -3.279 | 3.777 |
| S05       | 1899-12-30 01:15:00.000 | Sleeping   |        |        | -3.361 | 3.72  |
| S05       | 1899-12-30 01:30:00.000 | Sleeping   |        |        | -3.474 | 3.526 |
| S05       | 1899-12-30 01:45:00.000 | Sleeping   |        |        | -3.333 | 3.635 |
| S05       | 1899-12-30 02:00:00.000 | Sleeping   |        |        | -3.297 | 3.871 |
| S05       | 1899-12-30 02:15:00.000 | Sleeping   |        |        | -3.204 | 3.644 |
| S05       | 1899-12-30 02:30:00.000 | Sleeping   |        |        | -3.321 | 3.782 |
| S05       | 1899-12-30 02:45:00.000 | Sleeping   |        |        | -3.217 | 3.866 |
| S05       | 1899-12-30 03:00:00.000 | Sleeping   |        |        | -3.298 | 3.775 |
| S05       | 1899-12-30 03:15:00.000 | Sleeping   |        |        | -3.549 | 3.693 |

 


tables: name: ActivityCoordinate
data: ActivityCoordinate.csv
name: ActivityTop
data: ActivityTop.csv
name: ActivityTopGainPain
data: ActivityTopGainPain.csv
name: OfflineCoordinate
data: OfflineCoordinate.csv
name: StudentTimeline
data: StudentTimeline.csv
label: StudentTimeline
Activity
ActivityCoordinate
Activity
StudentTimeline
Time
ActivityTop
Time
ActivityTopGainPain
Time
ActivityTop
Time
output: {
    "joins": [
        {
            "from_table": "StudentTimeline",
            "from_column": "Activity",
            "to_table": "ActivityCoordinate",
            "to_column": "Activity"
        },
        {
            "from_table": "StudentTimeline",
            "from_column": "Time",
            "to_table": "ActivityTop",
            "to_column": "Time"
        },
        {
            "from_table": "ActivityTopGainPain",
            "from_column": "Time",
            "to_table": "ActivityTop",
            "to_column": "Time"
        }
    ]
}