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                    |   Year |   MonthNum | Month   |   Quarter | MonthYear    |
|:------------------------|-------:|-----------:|:--------|----------:|:-------------|
| 2017-01-01 00:00:00.000 |   2017 |          1 | January |         1 | January-2017 |
| 2017-01-02 00:00:00.000 |   2017 |          1 | January |         1 | January-2017 |
| 2017-01-03 00:00:00.000 |   2017 |          1 | January |         1 | January-2017 |
| 2017-01-04 00:00:00.000 |   2017 |          1 | January |         1 | January-2017 |
| 2017-01-05 00:00:00.000 |   2017 |          1 | January |         1 | January-2017 |
| 2017-01-06 00:00:00.000 |   2017 |          1 | January |         1 | January-2017 |
| 2017-01-07 00:00:00.000 |   2017 |          1 | January |         1 | January-2017 |
| 2017-01-08 00:00:00.000 |   2017 |          1 | January |         1 | January-2017 |
| 2017-01-09 00:00:00.000 |   2017 |          1 | January |         1 | January-2017 |
| 2017-01-10 00:00:00.000 |   2017 |          1 | January |         1 | January-2017 |


Table: Incidents
|   case_number | date                    | time_24hr               | address              |   UCR1_CategoryID |   ucr_1_code | UCR2_CategoryID   |   ucr_2_code |   latitude |   longitude |   NeighborhoodID |
|--------------:|:------------------------|:------------------------|:---------------------|------------------:|-------------:|:------------------|-------------:|-----------:|------------:|-----------------:|
|      17000782 | 2017-01-03 00:00:00.000 | 1899-12-30 00:00:00.000 | 19 WOODLAND ST       |                 6 |          645 |                   |            0 |    41.7687 |    -72.7024 |                1 |
|      17000927 | 2017-01-09 00:00:00.000 | 1899-12-30 00:00:00.000 | 2319 MAIN ST         |                 6 |          645 |                   |            0 |    41.7862 |    -72.6743 |                9 |
|      17000897 | 2017-01-09 00:00:00.000 | 1899-12-30 00:00:00.000 | 89 WESTON ST         |                 6 |          645 |                   |            0 |    41.7868 |    -72.6641 |                8 |
|      17001010 | 2017-01-10 00:00:00.000 | 1899-12-30 00:00:00.000 | 99 SPRING ST         |                 6 |          645 |                   |            0 |    41.7708 |    -72.684  |                1 |
|      17001190 | 2017-01-12 00:00:00.000 | 1899-12-30 00:00:00.000 | 1040 ALBANY AV       |                 6 |          645 |                   |            0 |    41.7814 |    -72.6938 |               16 |
|      17001202 | 2017-01-12 00:00:00.000 | 1899-12-30 00:00:00.000 | 47 SUMNER ST         |                 6 |          645 |                   |            0 |    41.7709 |    -72.6903 |                1 |
|      17002234 | 2017-01-21 00:00:00.000 | 1899-12-30 00:00:00.000 | 101 BENTON ST        |                 6 |          645 |                   |            0 |    41.7468 |    -72.6785 |                2 |
|      17006381 | 2017-01-24 00:00:00.000 | 1899-12-30 00:00:00.000 | 89 WESTON ST         |                 6 |          645 |                   |            0 |    41.7868 |    -72.6641 |                8 |
|      17002457 | 2017-01-25 00:00:00.000 | 1899-12-30 00:00:00.000 | PARK ST & WOLCOTT ST |                 6 |          645 |                   |            0 |    41.758  |    -72.6851 |                7 |
|      17002448 | 2017-01-25 00:00:00.000 | 1899-12-30 00:00:00.000 | 55 NELSON ST         |                 6 |          645 |                   |            0 |    41.7873 |    -72.6763 |                9 |


Table: Neighborhood
| neighborhood     |   NeighborhoodID |
|:-----------------|-----------------:|
| ASYLUM HILL      |                1 |
| BARRY SQUARE     |                2 |
| BEHIND THE ROCKS |                3 |
| BLUE HILLS       |                4 |
| CLAY-ARSENAL     |                5 |
| DOWNTOWN         |                6 |
| FROG HOLLOW      |                7 |
| NORTH MEADOWS    |                8 |
| NORTHEAST        |                9 |
| PARKVILLE        |               10 |


Table: Time
|   ID | Time                    |   Hour |   Minute | 5 Min Lower Band   | 15 Min Lower Band   | 30 Min Lower Band   | 45 Min Lower Band   | 60 Min Lower Band   | 5 Min Upper Band   | 15 Min Upper Band   | 30 Min Upper Band   | 45 Min Upper Band   | 60 Min Upper Band   |
|-----:|:------------------------|-------:|---------:|:-------------------|:--------------------|:--------------------|:--------------------|:--------------------|:-------------------|:--------------------|:--------------------|:--------------------|:--------------------|
|    1 | 1899-12-30 00:01:00.000 |      0 |        1 | 00:00:00           | 00:00:00            | 00:00:00            | 00:00:00            | 00:00:00            | 00:05:00           | 00:15:00            | 00:30:00            | 00:45:00            | 01:00:00            |
|    2 | 1899-12-30 00:02:00.000 |      0 |        2 | 00:00:00           | 00:00:00            | 00:00:00            | 00:00:00            | 00:00:00            | 00:05:00           | 00:15:00            | 00:30:00            | 00:45:00            | 01:00:00            |
|    3 | 1899-12-30 00:03:00.000 |      0 |        3 | 00:00:00           | 00:00:00            | 00:00:00            | 00:00:00            | 00:00:00            | 00:05:00           | 00:15:00            | 00:30:00            | 00:45:00            | 01:00:00            |
|    4 | 1899-12-30 00:04:00.000 |      0 |        4 | 00:00:00           | 00:00:00            | 00:00:00            | 00:00:00            | 00:00:00            | 00:05:00           | 00:15:00            | 00:30:00            | 00:45:00            | 01:00:00            |
|    5 | 1899-12-30 00:05:00.000 |      0 |        5 | 00:05:00           | 00:00:00            | 00:00:00            | 00:00:00            | 00:00:00            | 00:05:00           | 00:15:00            | 00:30:00            | 00:45:00            | 01:00:00            |
|    6 | 1899-12-30 00:06:00.000 |      0 |        6 | 00:05:00           | 00:00:00            | 00:00:00            | 00:00:00            | 00:00:00            | 00:10:00           | 00:15:00            | 00:30:00            | 00:45:00            | 01:00:00            |
|    7 | 1899-12-30 00:07:00.000 |      0 |        7 | 00:05:00           | 00:00:00            | 00:00:00            | 00:00:00            | 00:00:00            | 00:10:00           | 00:15:00            | 00:30:00            | 00:45:00            | 01:00:00            |
|    8 | 1899-12-30 00:08:00.000 |      0 |        8 | 00:05:00           | 00:00:00            | 00:00:00            | 00:00:00            | 00:00:00            | 00:10:00           | 00:15:00            | 00:30:00            | 00:45:00            | 01:00:00            |
|    9 | 1899-12-30 00:09:00.000 |      0 |        9 | 00:05:00           | 00:00:00            | 00:00:00            | 00:00:00            | 00:00:00            | 00:10:00           | 00:15:00            | 00:30:00            | 00:45:00            | 01:00:00            |
|   10 | 1899-12-30 00:10:00.000 |      0 |       10 | 00:10:00           | 00:00:00            | 00:00:00            | 00:00:00            | 00:00:00            | 00:10:00           | 00:15:00            | 00:30:00            | 00:45:00            | 01:00:00            |


Table: UCR Category
|   UCR1_CategoryID | Category                     |
|------------------:|:-----------------------------|
|                 1 | HOMICIDE                     |
|                 3 | ROBBERY                      |
|                 4 | AGGRAVATED ASSAULT           |
|                 5 | BURGLARY                     |
|                 6 | LARCENY                      |
|                 7 | MOTOR VEHICLE THEFT          |
|                 8 | SIMPLE ASSAULT               |
|                 9 | FORGERY/COUNTERFEITING       |
|                10 | FRAUD/EMBEZZLEMENT/EXTORTION |
|                11 | STOLEN PROPERTY              |


Table: UCR Description
|   ucr_1_code | ucr_1_description      |
|-------------:|:-----------------------|
|          101 | MURDER-HANDGUN         |
|          104 | MURDER-KNIFE           |
|          105 | MURDER-OTHER           |
|          109 | MANSLAUGHTER 2         |
|          301 | ROBBERY-GUN *STREET*   |
|          302 | ROBBERY-KNIFE *STREET* |
|          303 | ROBBERY-WEAPON*STREET* |
|          304 | ROBBERY-HANDS *STREET* |
|          311 | ROBBERY-GUN *COMMER*   |
|          312 | ROBBERY-KNIFE *COMMER* |


Table: UCR2 Category
|   UCR2_CategoryID | Category                     |
|------------------:|:-----------------------------|
|                 1 | HOMICIDE                     |
|                 3 | ROBBERY                      |
|                 4 | AGGRAVATED ASSAULT           |
|                 5 | BURGLARY                     |
|                 6 | LARCENY                      |
|                 7 | MOTOR VEHICLE THEFT          |
|                 8 | SIMPLE ASSAULT               |
|                 9 | FORGERY/COUNTERFEITING       |
|                10 | FRAUD/EMBEZZLEMENT/EXTORTION |
|                11 | STOLEN PROPERTY              |


Table: UCR2 Description
|   ucr_2_code | ucr_2_description      |
|-------------:|:-----------------------|
|          304 | ROBBERY-HANDS *STREET* |
|          401 | ASSLT-1-GUN            |
|          402 | ASSLT-1-KNIFE          |
|          403 | ASSLT-1-WEAPON         |
|          404 | ASSLT-1-HANDS          |
|          411 | ASSLT-2-GUN            |
|          412 | ASSLT-2-KNIFE          |
|          413 | ASSLT-2-WEAPON         |
|          414 | ASSLT-2-HANDS          |
|          421 | ASSLT-PO-GUN           |

 


tables: name: Date
data: Date.csv
name: Incidents
data: Incidents.csv
name: Neighborhood
data: Neighborhood.csv
name: Time
data: Time.csv
name: UCR Category
data: UCR Category.csv
name: UCR Description
data: UCR Description.csv
name: UCR2 Category
data: UCR2 Category.csv
name: UCR2 Description
data: UCR2 Description.csv
label: Incidents
UCR1_CategoryID
UCR Category
UCR1_CategoryID
Incidents
ucr_1_code
UCR Description
ucr_1_code
Incidents
UCR2_CategoryID
UCR2 Category
UCR2_CategoryID
Incidents
ucr_2_code
UCR2 Description
ucr_2_code
Incidents
NeighborhoodID
Neighborhood
NeighborhoodID
output: {
    "joins": [
        {
            "from_table": "Incidents",
            "from_column": "UCR1_CategoryID",
            "to_table": "UCR Category",
            "to_column": "UCR1_CategoryID"
        },
        {
            "from_table": "Incidents",
            "from_column": "ucr_1_code",
            "to_table": "UCR Description",
            "to_column": "ucr_1_code"
        },
        {
            "from_table": "Incidents",
            "from_column": "UCR2_CategoryID",
            "to_table": "UCR2 Category",
            "to_column": "UCR2_CategoryID"
        },
        {
            "from_table": "Incidents",
            "from_column": "ucr_2_code",
            "to_table": "UCR2 Description",
            "to_column": "ucr_2_code"
        },
        {
            "from_table": "Incidents",
            "from_column": "NeighborhoodID",
            "to_table": "Neighborhood",
            "to_column": "NeighborhoodID"
        }
    ]
}