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: Bottom N
|   Bottom N |
|-----------:|
|          0 |
|          1 |
|          2 |
|          3 |
|          4 |
|          5 |


Table: Date
| Date                    | Month Name   |   Month Number |   Day |   Year |
|:------------------------|:-------------|---------------:|------:|-------:|
| 2015-01-01 00:00:00.000 | January      |              1 |     1 |   2015 |
| 2015-01-02 00:00:00.000 | January      |              1 |     2 |   2015 |
| 2015-01-03 00:00:00.000 | January      |              1 |     3 |   2015 |
| 2015-01-04 00:00:00.000 | January      |              1 |     4 |   2015 |
| 2015-01-05 00:00:00.000 | January      |              1 |     5 |   2015 |
| 2015-01-06 00:00:00.000 | January      |              1 |     6 |   2015 |
| 2015-01-07 00:00:00.000 | January      |              1 |     7 |   2015 |
| 2015-01-08 00:00:00.000 | January      |              1 |     8 |   2015 |
| 2015-01-09 00:00:00.000 | January      |              1 |     9 |   2015 |
| 2015-01-10 00:00:00.000 | January      |              1 |    10 |   2015 |


Table: Dim Customers
|   Customer ID | Customer Name         | Customer Segment   | Country       | State or Province   | City          |   Postal Code |   Region ID |
|--------------:|:----------------------|:-------------------|:--------------|:--------------------|:--------------|--------------:|------------:|
|             3 | Bonnie Potter         | Corporate          | United States | Washington          | Anacortes     |         98221 |           4 |
|            24 | Edna Thomas           | Corporate          | United States | California          | Laguna Niguel |         92677 |           4 |
|            27 | Guy Gallagher         | Corporate          | United States | California          | Lakewood      |         90712 |           4 |
|            32 | Matthew Berman        | Corporate          | United States | Oregon              | Grants Pass   |         97526 |           4 |
|            33 | Ricky Hensley         | Corporate          | United States | Oregon              | Gresham       |         97030 |           4 |
|            52 | Lorraine Kelly        | Corporate          | United States | Washington          | Puyallup      |         98373 |           4 |
|            53 | Sidney Russell Austin | Corporate          | United States | Washington          | Redmond       |         98052 |           4 |
|            62 | Pam Gilbert           | Corporate          | United States | Texas               | Round Rock    |         78664 |           1 |
|            67 | Ellen McCormick       | Corporate          | United States | California          | Napa          |         94559 |           4 |
|            68 | Scott Bunn            | Corporate          | United States | New York            | New York City |         10177 |           2 |


Table: Dim Managers
| Manager   |   Region ID | Region   |
|:----------|------------:|:---------|
| Chris     |           1 | Central  |
| Erin      |           2 | East     |
| Sam       |           3 | South    |
| William   |           4 | West     |


Table: Dim Order Priority
| Order Priority   |   Order Priority ID |
|:-----------------|--------------------:|
| High             |                   1 |
| Not Specified    |                   2 |
| Critical         |                   3 |
| Medium           |                   4 |
| Low              |                   5 |
| Critical         |                   6 |


Table: Dim Products
|   Product ID | Product Name                                      | Product Sub-Category           | Product Category   | Product Container   |   Unit Price |   Product Base Margin |
|-------------:|:--------------------------------------------------|:-------------------------------|:-------------------|:--------------------|-------------:|----------------------:|
|            8 | Grip Seal Envelopes                               | Envelopes                      | Office Supplies    | Small Box           |         4.42 |                  0.38 |
|            9 | Tyvek ® Top-Opening Peel & Seel ® Envelopes, Gray | Envelopes                      | Office Supplies    | Small Box           |        35.94 |                  0.4  |
|           15 | Xerox 194                                         | Paper                          | Office Supplies    | Small Box           |        55.48 |                  0.37 |
|           18 | Hunt Boston® Vacuum Mount KS Pencil Sharpener     | Pens & Art Supplies            | Office Supplies    | Small Box           |        34.99 |                  0.59 |
|           22 | Storex DuraTech Recycled Plastic Frosted Binders  | Binders and Binder Accessories | Office Supplies    | Small Box           |         4.24 |                  0.35 |
|           27 | Xerox 1903                                        | Paper                          | Office Supplies    | Small Box           |         5.98 |                  0.36 |
|           28 | Durable Pressboard Binders                        | Binders and Binder Accessories | Office Supplies    | Small Box           |         3.8  |                  0.38 |
|           30 | Xerox 193                                         | Paper                          | Office Supplies    | Small Box           |         5.98 |                  0.36 |
|           32 | Avery 501                                         | Labels                         | Office Supplies    | Small Box           |         3.69 |                  0.38 |
|           34 | Dual Level, Single-Width Filing Carts             | Storage & Organization         | Office Supplies    | Small Box           |       155.06 |                  0.59 |


Table: Dim Returns
|   Order ID | Status   |
|-----------:|:---------|
|         65 | Returned |
|        612 | Returned |
|        614 | Returned |
|        678 | Returned |
|        710 | Returned |
|        740 | Returned |
|        775 | Returned |
|        833 | Returned |
|        902 | Returned |
|       3300 | Returned |


Table: Dim Ship Mode
| Ship Mode      |   Ship Mode ID |
|:---------------|---------------:|
| Express Air    |              1 |
| Delivery Truck |              2 |
| Regular Air    |              3 |


Table: Fact Orders
|   Discount |   Shipping Cost |   Customer ID | Order Date              | Ship Date               |   Profit |   Quantity |   Sales Amount |   Order ID |   Product ID |   Priority ID |   Ship Mode ID |   Region ID |   Days to Ship |
|-----------:|----------------:|--------------:|:------------------------|:------------------------|---------:|-----------:|---------------:|-----------:|-------------:|--------------:|---------------:|------------:|---------------:|
|       0.07 |            0.93 |           699 | 2015-06-06 00:00:00.000 | 2015-06-08 00:00:00.000 |  78.7532 |         59 |       155.831  |      55392 |            1 |             3 |              3 |           4 |              2 |
|       0.07 |            0.93 |           711 | 2015-06-06 00:00:00.000 | 2015-06-08 00:00:00.000 |  20.022  |         15 |        39.618  |      87978 |            1 |             3 |              3 |           2 |              2 |
|       0.06 |            7.29 |            11 | 2015-02-15 00:00:00.000 | 2015-02-17 00:00:00.000 |  81.3384 |         22 |       196.046  |      90192 |            3 |             3 |              3 |           2 |              2 |
|       0.09 |           19.99 |            14 | 2015-05-12 00:00:00.000 | 2015-05-14 00:00:00.000 | 428.074  |         16 |      1145.73   |      86838 |            4 |             4 |              3 |           1 |              2 |
|       0.05 |            2.5  |            16 | 2015-02-12 00:00:00.000 | 2015-02-14 00:00:00.000 | 579.95   |         10 |      1101.9    |      86836 |           11 |             1 |              3 |           2 |              2 |
|       0.07 |            9.44 |            19 | 2015-05-21 00:00:00.000 | 2015-05-23 00:00:00.000 |  74.8224 |         18 |       217.453  |      90032 |           13 |             2 |              3 |           4 |              2 |
|       0.07 |            9.44 |            21 | 2015-05-21 00:00:00.000 | 2015-05-23 00:00:00.000 | 295.133  |         71 |       857.73   |      42949 |           13 |             2 |              3 |           2 |              2 |
|       0.02 |            1.57 |            24 | 2015-01-28 00:00:00.000 | 2015-01-30 00:00:00.000 |   0.9576 |          1 |         1.6464 |      87651 |           16 |             1 |              3 |           4 |              2 |
|       0.01 |            1.57 |           593 | 2015-01-17 00:00:00.000 | 2015-01-19 00:00:00.000 |  11.6928 |         12 |        19.9584 |      86307 |           16 |             3 |              3 |           1 |              2 |
|       0.04 |            6.6  |            27 | 2015-05-02 00:00:00.000 | 2015-05-04 00:00:00.000 |  22.356  |         12 |        47.6928 |      87652 |           17 |             2 |              3 |           4 |              2 |


Table: Top N
|   Top N |
|--------:|
|       0 |
|       1 |
|       2 |
|       3 |
|       4 |
|       5 |

 


tables: name: Bottom N
data: Bottom N.csv
name: Date
data: Date.csv
name: Dim Customers
data: Dim Customers.csv
name: Dim Managers
data: Dim Managers.csv
name: Dim Order Priority
data: Dim Order Priority.csv
name: Dim Products
data: Dim Products.csv
name: Dim Returns
data: Dim Returns.csv
name: Dim Ship Mode
data: Dim Ship Mode.csv
name: Fact Orders
data: Fact Orders.csv
name: Top N
data: Top N.csv
label: Fact Orders
Customer ID
Dim Customers
Customer ID
Fact Orders
Product ID
Dim Products
Product ID
Fact Orders
Priority ID
Dim Order Priority
Order Priority ID
Fact Orders
Region ID
Dim Managers
Region ID
Fact Orders
Ship Mode ID
Dim Ship Mode
Ship Mode ID
Fact Orders
Order ID
Dim Returns
Order ID
output: {
    "joins": [
        {
            "from_table": "Fact Orders",
            "from_column": "Customer ID",
            "to_table": "Dim Customers",
            "to_column": "Customer ID"
        },
        {
            "from_table": "Fact Orders",
            "from_column": "Product ID",
            "to_table": "Dim Products",
            "to_column": "Product ID"
        },
        {
            "from_table": "Fact Orders",
            "from_column": "Priority ID",
            "to_table": "Dim Order Priority",
            "to_column": "Order Priority ID"
        },
        {
            "from_table": "Fact Orders",
            "from_column": "Region ID",
            "to_table": "Dim Managers",
            "to_column": "Region ID"
        },
        {
            "from_table": "Fact Orders",
            "from_column": "Ship Mode ID",
            "to_table": "Dim Ship Mode",
            "to_column": "Ship Mode ID"
        },
        {
            "from_table": "Fact Orders",
            "from_column": "Order ID",
            "to_table": "Dim Returns",
            "to_column": "Order ID"
        }
    ]
}