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 Key | Full Date Alternate Key   |   Day Number Of Week | English Day Name Of Week   | Spanish Day Name Of Week   | French Day Name Of Week   |   Day Number Of Month |   Day Number Of Year |   Week Number Of Year | English Month Name   | Spanish Month Name   | French Month Name   |   Month Number Of Year |   Calendar Quarter |   Calendar Year |   Calendar Semester |   Fiscal Quarter |   Fiscal Year |   Fiscal Semester |
|-----------:|:--------------------------|---------------------:|:---------------------------|:---------------------------|:--------------------------|----------------------:|---------------------:|----------------------:|:---------------------|:---------------------|:--------------------|-----------------------:|-------------------:|----------------:|--------------------:|-----------------:|--------------:|------------------:|
|   20200701 | 2020-07-01 00:00:00.000   |                    4 | Wednesday                  | Miércoles                  | Mercredi                  |                     1 |                  183 |                    27 | July                 | Julio                | Juillet             |                      7 |                  3 |            2020 |                   2 |                1 |          2021 |                 1 |
|   20200702 | 2020-07-02 00:00:00.000   |                    5 | Thursday                   | Jueves                     | Jeudi                     |                     2 |                  184 |                    27 | July                 | Julio                | Juillet             |                      7 |                  3 |            2020 |                   2 |                1 |          2021 |                 1 |
|   20200703 | 2020-07-03 00:00:00.000   |                    6 | Friday                     | Viernes                    | Vendredi                  |                     3 |                  185 |                    27 | July                 | Julio                | Juillet             |                      7 |                  3 |            2020 |                   2 |                1 |          2021 |                 1 |
|   20200704 | 2020-07-04 00:00:00.000   |                    7 | Saturday                   | Sábado                     | Samedi                    |                     4 |                  186 |                    27 | July                 | Julio                | Juillet             |                      7 |                  3 |            2020 |                   2 |                1 |          2021 |                 1 |
|   20200705 | 2020-07-05 00:00:00.000   |                    1 | Sunday                     | Domingo                    | Dimanche                  |                     5 |                  187 |                    28 | July                 | Julio                | Juillet             |                      7 |                  3 |            2020 |                   2 |                1 |          2021 |                 1 |
|   20200706 | 2020-07-06 00:00:00.000   |                    2 | Monday                     | Lunes                      | Lundi                     |                     6 |                  188 |                    28 | July                 | Julio                | Juillet             |                      7 |                  3 |            2020 |                   2 |                1 |          2021 |                 1 |
|   20200707 | 2020-07-07 00:00:00.000   |                    3 | Tuesday                    | Martes                     | Mardi                     |                     7 |                  189 |                    28 | July                 | Julio                | Juillet             |                      7 |                  3 |            2020 |                   2 |                1 |          2021 |                 1 |
|   20200708 | 2020-07-08 00:00:00.000   |                    4 | Wednesday                  | Miércoles                  | Mercredi                  |                     8 |                  190 |                    28 | July                 | Julio                | Juillet             |                      7 |                  3 |            2020 |                   2 |                1 |          2021 |                 1 |
|   20200709 | 2020-07-09 00:00:00.000   |                    5 | Thursday                   | Jueves                     | Jeudi                     |                     9 |                  191 |                    28 | July                 | Julio                | Juillet             |                      7 |                  3 |            2020 |                   2 |                1 |          2021 |                 1 |
|   20200710 | 2020-07-10 00:00:00.000   |                    6 | Friday                     | Viernes                    | Vendredi                  |                    10 |                  192 |                    28 | July                 | Julio                | Juillet             |                      7 |                  3 |            2020 |                   2 |                1 |          2021 |                 1 |


Table: Geography
|   Geography Key | City          | State Province Code   | State Province Name   | Country Region Code   | English Country Region Name   | Spanish Country Region Name   | French Country Region Name   |   Postal Code |   Sales Territory Key | Ip Address Locator   |
|----------------:|:--------------|:----------------------|:----------------------|:----------------------|:------------------------------|:------------------------------|:-----------------------------|--------------:|----------------------:|:---------------------|
|             292 | Alhambra      | CA                    | California            | US                    | United States                 | Estados Unidos                | États-Unis                   |         91801 |                     4 | 192.0.2.39           |
|             293 | Alpine        | CA                    | California            | US                    | United States                 | Estados Unidos                | États-Unis                   |         91901 |                     4 | 192.0.2.40           |
|             294 | Auburn        | CA                    | California            | US                    | United States                 | Estados Unidos                | États-Unis                   |         95603 |                     4 | 192.0.2.41           |
|             295 | Baldwin Park  | CA                    | California            | US                    | United States                 | Estados Unidos                | États-Unis                   |         91706 |                     4 | 192.0.2.42           |
|             296 | Barstow       | CA                    | California            | US                    | United States                 | Estados Unidos                | États-Unis                   |         92311 |                     4 | 192.0.2.43           |
|             297 | Bell Gardens  | CA                    | California            | US                    | United States                 | Estados Unidos                | États-Unis                   |         90201 |                     4 | 192.0.2.44           |
|             298 | Bellflower    | CA                    | California            | US                    | United States                 | Estados Unidos                | États-Unis                   |         90706 |                     4 | 192.0.2.45           |
|             299 | Berkeley      | CA                    | California            | US                    | United States                 | Estados Unidos                | États-Unis                   |         94704 |                     4 | 192.0.2.46           |
|             300 | Beverly Hills | CA                    | California            | US                    | United States                 | Estados Unidos                | États-Unis                   |         90210 |                     4 | 192.0.2.47           |
|             301 | Burbank       | CA                    | California            | US                    | United States                 | Estados Unidos                | États-Unis                   |         91502 |                     4 | 192.0.2.48           |


Table: Product
|   Product Key | Product Alternate Key   | Product Subcategory Key   | Weight Unit Measure Code   | Size Unit Measure Code   | English Product Name   | Spanish Product Name   | French Product Name   | Standard Cost   | Finished Goods Flag   | Color   |   Safety Stock Level |   Reorder Point | List Price   | Size   | Size Range   | Weight   |   Days To Manufacture | Product Line   | Dealer Price   | Class   | Style   | Model Name   | English Description   | French Description   | Chinese Description   | Arabic Description   | Hebrew Description   | Thai Description   | German Description   | Japanese Description   | Turkish Description   | Start Date              | End Date   | Status   |
|--------------:|:------------------------|:--------------------------|:---------------------------|:-------------------------|:-----------------------|:-----------------------|:----------------------|:----------------|:----------------------|:--------|---------------------:|----------------:|:-------------|:-------|:-------------|:---------|----------------------:|:---------------|:---------------|:--------|:--------|:-------------|:----------------------|:---------------------|:----------------------|:---------------------|:---------------------|:-------------------|:---------------------|:-----------------------|:----------------------|:------------------------|:-----------|:---------|
|             1 | AR-5381                 |                           |                            |                          | Adjustable Race        |                        |                       |                 | False                 | NA      |                 1000 |             750 |              |        | NA           |          |                     0 |                |                |         |         |              |                       |                      |                       |                      |                      |                    |                      |                        |                       | 2017-07-01 00:00:00.000 |            | Current  |
|             2 | BA-8327                 |                           |                            |                          | Bearing Ball           |                        |                       |                 | False                 | NA      |                 1000 |             750 |              |        | NA           |          |                     0 |                |                |         |         |              |                       |                      |                       |                      |                      |                    |                      |                        |                       | 2017-07-01 00:00:00.000 |            | Current  |
|            12 | CR-9981                 |                           |                            |                          | Crown Race             |                        |                       |                 | False                 | NA      |                 1000 |             750 |              |        | NA           |          |                     0 |                |                |         |         |              |                       |                      |                       |                      |                      |                    |                      |                        |                       | 2017-07-01 00:00:00.000 |            | Current  |
|            14 | DC-8732                 |                           |                            |                          | Decal 1                |                        |                       |                 | False                 | NA      |                 1000 |             750 |              |        | NA           |          |                     0 |                |                |         |         |              |                       |                      |                       |                      |                      |                    |                      |                        |                       | 2017-07-01 00:00:00.000 |            | Current  |
|            15 | DC-9824                 |                           |                            |                          | Decal 2                |                        |                       |                 | False                 | NA      |                 1000 |             750 |              |        | NA           |          |                     0 |                |                |         |         |              |                       |                      |                       |                      |                      |                    |                      |                        |                       | 2017-07-01 00:00:00.000 |            | Current  |
|            22 | FW-1000                 |                           |                            |                          | Flat Washer 1          |                        |                       |                 | False                 | NA      |                 1000 |             750 |              |        | NA           |          |                     0 |                |                |         |         |              |                       |                      |                       |                      |                      |                    |                      |                        |                       | 2017-07-01 00:00:00.000 |            | Current  |
|            23 | FW-1200                 |                           |                            |                          | Flat Washer 6          |                        |                       |                 | False                 | NA      |                 1000 |             750 |              |        | NA           |          |                     0 |                |                |         |         |              |                       |                      |                       |                      |                      |                    |                      |                        |                       | 2017-07-01 00:00:00.000 |            | Current  |
|            24 | FW-1400                 |                           |                            |                          | Flat Washer 2          |                        |                       |                 | False                 | NA      |                 1000 |             750 |              |        | NA           |          |                     0 |                |                |         |         |              |                       |                      |                       |                      |                      |                    |                      |                        |                       | 2017-07-01 00:00:00.000 |            | Current  |
|            25 | FW-3400                 |                           |                            |                          | Flat Washer 9          |                        |                       |                 | False                 | NA      |                 1000 |             750 |              |        | NA           |          |                     0 |                |                |         |         |              |                       |                      |                       |                      |                      |                    |                      |                        |                       | 2017-07-01 00:00:00.000 |            | Current  |
|            26 | FW-3800                 |                           |                            |                          | Flat Washer 4          |                        |                       |                 | False                 | NA      |                 1000 |             750 |              |        | NA           |          |                     0 |                |                |         |         |              |                       |                      |                       |                      |                      |                    |                      |                        |                       | 2017-07-01 00:00:00.000 |            | Current  |


Table: Reseller Sales
| Sales Order Number   |   Sales Order Line Number |   Reseller Key |   Product Key |   Order Date Key |   Due Date Key |   Ship Date Key |   Employee Key |   Promotion Key |   Currency Key |   Sales Territory Key |   Order Quantity |   Unit Price |   Extended Amount |   Unit Price Discount Pct |   Discount Amount |   Product Standard Cost |   Total Product Cost |   Sales Amount |   Tax Amount |   Freight Amount | Carrier Tracking Number   | Customer PONumber   |   Revision Number |
|:---------------------|--------------------------:|---------------:|--------------:|-----------------:|---------------:|----------------:|---------------:|----------------:|---------------:|----------------------:|-----------------:|-------------:|------------------:|--------------------------:|------------------:|------------------------:|---------------------:|---------------:|-------------:|-----------------:|:--------------------------|:--------------------|------------------:|
| SO46960              |                        16 |            259 |           343 |         20180808 |       20180818 |        20180815 |            282 |               1 |            100 |                     4 |                1 |      469.794 |           469.794 |                         0 |                 0 |                 486.707 |              486.707 |        469.794 |      37.5835 |          11.7449 | F05E-41EB-90              | PO16762181648       |                 1 |
| SO46970              |                         5 |            258 |           325 |         20180810 |       20180820 |        20180817 |            282 |               1 |            100 |                     4 |                1 |      469.794 |           469.794 |                         0 |                 0 |                 486.707 |              486.707 |        469.794 |      37.5835 |          11.7449 | 01AF-420A-B9              | PO15196114472       |                 1 |
| SO46970              |                        10 |            258 |           341 |         20180810 |       20180820 |        20180817 |            282 |               1 |            100 |                     4 |                1 |      469.794 |           469.794 |                         0 |                 0 |                 486.707 |              486.707 |        469.794 |      37.5835 |          11.7449 | 01AF-420A-B9              | PO15196114472       |                 1 |
| SO46970              |                        30 |            258 |           331 |         20180810 |       20180820 |        20180817 |            282 |               1 |            100 |                     4 |                1 |      469.794 |           469.794 |                         0 |                 0 |                 486.707 |              486.707 |        469.794 |      37.5835 |          11.7449 | 01AF-420A-B9              | PO15196114472       |                 1 |
| SO46988              |                        27 |             78 |           335 |         20180815 |       20180825 |        20180822 |            282 |               1 |            100 |                     4 |                1 |      469.794 |           469.794 |                         0 |                 0 |                 486.707 |              486.707 |        469.794 |      37.5835 |          11.7449 | 2D2E-4EC3-AC              | PO12499171502       |                 1 |
| SO46992              |                         3 |             97 |           323 |         20180816 |       20180826 |        20180823 |            282 |               1 |            100 |                     4 |                1 |      469.794 |           469.794 |                         0 |                 0 |                 486.707 |              486.707 |        469.794 |      37.5835 |          11.7449 | C958-4FD6-A0              | PO11745117547       |                 1 |
| SO46992              |                        25 |             97 |           333 |         20180816 |       20180826 |        20180823 |            282 |               1 |            100 |                     4 |                1 |      469.794 |           469.794 |                         0 |                 0 |                 486.707 |              486.707 |        469.794 |      37.5835 |          11.7449 | C958-4FD6-A0              | PO11745117547       |                 1 |
| SO46992              |                        37 |             97 |           325 |         20180816 |       20180826 |        20180823 |            282 |               1 |            100 |                     4 |                1 |      469.794 |           469.794 |                         0 |                 0 |                 486.707 |              486.707 |        469.794 |      37.5835 |          11.7449 | C958-4FD6-A0              | PO11745117547       |                 1 |
| SO47032              |                        13 |            313 |           323 |         20180825 |       20180904 |        20180901 |            282 |               1 |            100 |                     4 |                1 |      469.794 |           469.794 |                         0 |                 0 |                 486.707 |              486.707 |        469.794 |      37.5835 |          11.7449 | 090F-4070-AA              | PO4553172367        |                 1 |
| SO47035              |                         3 |            528 |           333 |         20180825 |       20180904 |        20180901 |            282 |               1 |            100 |                     4 |                1 |      469.794 |           469.794 |                         0 |                 0 |                 486.707 |              486.707 |        469.794 |      37.5835 |          11.7449 | 661B-492D-B3              | PO4698148803        |                 1 |


Table: Reseller
|   Reseller Key |   Geography Key | Reseller Alternate Key   | Phone        | Business Type        | Reseller Name            |   Number Employees | Order Frequency   |   Order Month |   First Order Year |   Last Order Year | Product Line   | Address Line1               | Address Line2   |   Annual Sales | Bank Name              | Min Payment Type   | Min Payment Amount   |   Annual Revenue |   Year Opened |
|---------------:|----------------:|:-------------------------|:-------------|:---------------------|:-------------------------|-------------------:|:------------------|--------------:|-------------------:|------------------:|:---------------|:----------------------------|:----------------|---------------:|:-----------------------|:-------------------|:---------------------|-----------------:|--------------:|
|              2 |             635 | AW00000002               | 170-555-0127 | Specialty Bike Shop  | Progressive Sports       |                 10 | A                 |             5 |               2012 |              2013 | Mountain       | 3207 S Grady Way            |                 |         800000 | International Security | 1                  |                      |            80000 |          1976 |
|             12 |              96 | AW00000012               | 112-555-0191 | Warehouse            | Bikes and Motorbikes     |                 49 | Q                 |             5 |               2012 |              2013 | Road           | 22580 Free Street           |                 |        1500000 | Primary Bank & Reserve |                    |                      |           150000 |          1996 |
|             18 |             474 | AW00000018               | 440-555-0132 | Warehouse            | Catalog Store            |                 55 | Q                 |             5 |               2011 |              2013 | Mountain       | 855 East Main Avenue        |                 |        3000000 | United Security        | 2                  |                      |           300000 |          2003 |
|             22 |             561 | AW00000022               | 121-555-0121 | Value Added Reseller | Travel Systems           |                 19 | S                 |             5 |               2011 |              2013 | Road           | 2505 Gateway Drive          |                 |         800000 | International Bank     | 1                  |                      |            80000 |          1979 |
|             28 |              95 | AW00000028               | 972-555-0163 | Value Added Reseller | Commuter Bicycle Store   |                 17 | S                 |             5 |               2013 |              2013 | Touring        | 2575 Bloor Street East      |                 |         800000 | Reserve Security       | 1                  |                      |            80000 |          1991 |
|             36 |             447 | AW00000036               | 415-555-0147 | Warehouse            | Exotic Bikes             |                 73 | Q                 |             5 |               2011 |              2013 | Road           | 6900 William Richardson Ct. |                 |        3000000 | International Bank     | 2                  |                      |           300000 |          2002 |
|             43 |             599 | AW00000043               | 482-555-0174 | Value Added Reseller | Frugal Bike Shop         |                 12 | S                 |             5 |               2012 |              2013 | Mountain       | 2575 West 2700 South        |                 |         800000 | International Bank     | 2                  |                      |            80000 |          1992 |
|             45 |             565 | AW00000045               | 333-555-0113 | Warehouse            | Every Bike Shop          |                 80 | Q                 |             5 |               2011 |              2013 | Road           | 2550 High Street            |                 |        3000000 | Primary International  |                    |                      |           300000 |          1991 |
|             56 |             547 | AW00000056               | 461-555-0118 | Specialty Bike Shop  | Latest Accessories Sales |                 44 | A                 |             5 |               2012 |              2013 | Road           | Gateway                     |                 |        1500000 | Reserve Security       |                    |                      |           150000 |          1992 |
|             62 |             569 | AW00000062               | 351-555-0130 | Specialty Bike Shop  | Manufacturers Inc        |                 42 | A                 |             5 |               2012 |              2013 | Road           | Po Box 08050                |                 |        1500000 | Guardian Bank          | 2                  |                      |           150000 |          1989 |


Table: Sales Territory
|   Sales Territory Key |   Sales Territory Alternate Key | Sales Territory Region   | Sales Territory Country   | Sales Territory Group   |
|----------------------:|--------------------------------:|:-------------------------|:--------------------------|:------------------------|
|                     1 |                               1 | Northwest                | United States             | North America           |
|                     2 |                               2 | Northeast                | United States             | North America           |
|                     3 |                               3 | Central                  | United States             | North America           |
|                     4 |                               4 | Southwest                | United States             | North America           |
|                     5 |                               5 | Southeast                | United States             | North America           |
|                     6 |                               6 | Canada                   | Canada                    | North America           |
|                     7 |                               7 | France                   | France                    | Europe                  |
|                     8 |                               8 | Germany                  | Germany                   | Europe                  |
|                     9 |                               9 | Australia                | Australia                 | Pacific                 |
|                    10 |                              10 | United Kingdom           | United Kingdom            | Europe                  |

 


tables: name: Date
data: Date.csv
name: Geography
data: Geography.csv
name: Product
data: Product.csv
name: Reseller Sales
data: Reseller Sales.csv
name: Reseller
data: Reseller.csv
name: Sales Territory
data: Sales Territory.csv
label: Geography
Sales Territory Key
Sales Territory
Sales Territory Key
Reseller Sales
Due Date Key
Date
Date Key
Reseller Sales
Reseller Key
Reseller
Reseller Key
Reseller Sales
Sales Territory Key
Sales Territory
Sales Territory Key
Reseller Sales
Product Key
Product
Product Key
output: {
    "joins": [
        {
            "from_table": "Geography",
            "from_column": "Sales Territory Key",
            "to_table": "Sales Territory",
            "to_column": "Sales Territory Key"
        },
        {
            "from_table": "Reseller Sales",
            "from_column": "Due Date Key",
            "to_table": "Date",
            "to_column": "Date Key"
        },
        {
            "from_table": "Reseller Sales",
            "from_column": "Reseller Key",
            "to_table": "Reseller",
            "to_column": "Reseller Key"
        },
        {
            "from_table": "Reseller Sales",
            "from_column": "Sales Territory Key",
            "to_table": "Sales Territory",
            "to_column": "Sales Territory Key"
        },
        {
            "from_table": "Reseller Sales",
            "from_column": "Product Key",
            "to_table": "Product",
            "to_column": "Product Key"
        }
    ]
}