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                    |   MonthNo | MonthName   |   MonthID | Month   | Quarter   |   Year |
|:------------------------|----------:|:------------|----------:|:--------|:----------|-------:|
| 2000-07-01 00:00:00.000 |         7 | Jul         |    200007 | Jul-00  | Q3        |   2000 |
| 2000-07-02 00:00:00.000 |         7 | Jul         |    200007 | Jul-00  | Q3        |   2000 |
| 2000-07-03 00:00:00.000 |         7 | Jul         |    200007 | Jul-00  | Q3        |   2000 |
| 2000-07-04 00:00:00.000 |         7 | Jul         |    200007 | Jul-00  | Q3        |   2000 |
| 2000-07-05 00:00:00.000 |         7 | Jul         |    200007 | Jul-00  | Q3        |   2000 |
| 2000-07-06 00:00:00.000 |         7 | Jul         |    200007 | Jul-00  | Q3        |   2000 |
| 2000-07-07 00:00:00.000 |         7 | Jul         |    200007 | Jul-00  | Q3        |   2000 |
| 2000-07-08 00:00:00.000 |         7 | Jul         |    200007 | Jul-00  | Q3        |   2000 |
| 2000-07-09 00:00:00.000 |         7 | Jul         |    200007 | Jul-00  | Q3        |   2000 |
| 2000-07-10 00:00:00.000 |         7 | Jul         |    200007 | Jul-00  | Q3        |   2000 |


Table: Locations
|   Zip | City   | State   | Region   | District             | Country   |
|------:|:-------|:--------|:---------|:---------------------|:----------|
| 68274 |        | Oaxaca  |          | Oaxaca de Juarez     | Mexico    |
| 68275 |        | Oaxaca  |          | Oaxaca de Juarez     | Mexico    |
| 68276 |        | Oaxaca  |          | Oaxaca de Juarez     | Mexico    |
| 71512 |        | Oaxaca  |          | Ocotlan de Morelos   | Mexico    |
| 71513 |        | Oaxaca  |          | Ocotlan de Morelos   | Mexico    |
| 71515 |        | Oaxaca  |          | Ocotlan de Morelos   | Mexico    |
| 71565 |        | Oaxaca  |          | La Pe                | Mexico    |
| 71566 |        | Oaxaca  |          | La Pe                | Mexico    |
| 71750 |        | Oaxaca  |          | Pinotepa de Don Luis | Mexico    |
| 70960 |        | Oaxaca  |          | Pluma Hidalgo        | Mexico    |


Table: Manufacturer
|   ManufacturerID | Manufacturer   |
|-----------------:|:---------------|
|                1 | Abbas          |
|                2 | Aliqui         |
|                3 | Barba          |
|                4 | Currus         |
|                5 | Fama           |
|                6 | Leo            |
|                7 | VanArsdel      |
|                8 | Natura         |
|                9 | Palma          |
|               10 | Pirum          |


Table: Product
|   ProductID | Product       | Category   | Segment     |   ManufacturerID | Manufacturer   |
|------------:|:--------------|:-----------|:------------|-----------------:|:---------------|
|         536 | Maximus UC-01 | Urban      | Convenience |                7 | VanArsdel      |
|         537 | Maximus UC-02 | Urban      | Convenience |                7 | VanArsdel      |
|         538 | Maximus UC-03 | Urban      | Convenience |                7 | VanArsdel      |
|         539 | Maximus UC-04 | Urban      | Convenience |                7 | VanArsdel      |
|         540 | Maximus UC-05 | Urban      | Convenience |                7 | VanArsdel      |
|         541 | Maximus UC-06 | Urban      | Convenience |                7 | VanArsdel      |
|         542 | Maximus UC-07 | Urban      | Convenience |                7 | VanArsdel      |
|         543 | Maximus UC-08 | Urban      | Convenience |                7 | VanArsdel      |
|         544 | Maximus UC-09 | Urban      | Convenience |                7 | VanArsdel      |
|         545 | Maximus UC-10 | Urban      | Convenience |                7 | VanArsdel      |


Table: Sales
|   ProductID | Date                    |   Zip |   Units |   Revenue |
|------------:|:------------------------|------:|--------:|----------:|
|         786 | 2003-04-30 00:00:00.000 |  1106 |       1 |   57.6975 |
|         786 | 2003-04-30 00:00:00.000 |  1540 |       1 |   57.6975 |
|         786 | 2003-04-30 00:00:00.000 |  2886 |       1 |   57.6975 |
|         786 | 2003-04-30 00:00:00.000 |  8865 |       1 |   57.6975 |
|         786 | 2003-04-30 00:00:00.000 | 10923 |       1 |   57.6975 |
|         786 | 2003-04-30 00:00:00.000 | 16037 |       1 |   57.6975 |
|         786 | 2003-04-30 00:00:00.000 | 20724 |       1 |   57.6975 |
|         786 | 2003-04-30 00:00:00.000 | 24333 |       1 |   57.6975 |
|         786 | 2003-04-30 00:00:00.000 | 28704 |       1 |   57.6975 |
|         786 | 2003-04-30 00:00:00.000 | 29527 |       1 |   57.6975 |

 


tables: name: Date
data: Date.csv
name: Locations
data: Locations.csv
name: Manufacturer
data: Manufacturer.csv
name: Product
data: Product.csv
name: Sales
data: Sales.csv
label: Product
ManufacturerID
Manufacturer
ManufacturerID
Sales
ProductID
Product
ProductID
Sales
Zip
Locations
Zip
Sales
Date
Date
Date
output: {
    "joins": [
        {
            "from_table": "Product",
            "from_column": "ManufacturerID",
            "to_table": "Manufacturer",
            "to_column": "ManufacturerID"
        },
        {
            "from_table": "Sales",
            "from_column": "ProductID",
            "to_table": "Product",
            "to_column": "ProductID"
        },
        {
            "from_table": "Sales",
            "from_column": "Zip",
            "to_table": "Locations",
            "to_column": "Zip"
        },
        {
            "from_table": "Sales",
            "from_column": "Date",
            "to_table": "Date",
            "to_column": "Date"
        }
    ]
}