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: Bida_assignment
| Order Date              | Ship Mode      | Segment   | City          | State            | Global Area   | Market   | Region   | Category        | Sub-Category   |   Sales |   Quantity |   Discount |   Profit |   Shipping Cost | Order Priority   |   Coustmer_id |   Shipping_id |   Product_id |
|:------------------------|:---------------|:----------|:--------------|:-----------------|:--------------|:---------|:---------|:----------------|:---------------|--------:|-----------:|-----------:|---------:|----------------:|:-----------------|--------------:|--------------:|-------------:|
| 2014-10-02 00:00:00.000 | Standard Class | Consumer  | Mexico City   | Distrito Federal | Mexico        | LATAM    | North    | Office Supplies | Labels         |   13.08 |          3 |          0 |     4.56 |            1.03 | Medium           |             1 |             1 |            1 |
| 2014-10-02 00:00:00.000 | Standard Class | Consumer  | Mexico City   | Distrito Federal | Mexico        | LATAM    | North    | Office Supplies | Labels         |   13.08 |          3 |          0 |     4.56 |            1.03 | Medium           |             1 |             1 |            1 |
| 2014-10-02 00:00:00.000 | Standard Class | Consumer  | Mexico City   | Distrito Federal | Mexico        | LATAM    | North    | Office Supplies | Labels         |   13.08 |          3 |          0 |     4.56 |            1.03 | Medium           |             1 |             1 |            1 |
| 2012-10-15 00:00:00.000 | Standard Class | Consumer  | Dos Quebradas | Risaralda        | Colombia      | LATAM    | South    | Office Supplies | Binders        |   35.44 |          4 |          0 |     4.96 |            1.37 | Medium           |             2 |             2 |            3 |
| 2012-10-15 00:00:00.000 | Standard Class | Consumer  | Dos Quebradas | Risaralda        | Colombia      | LATAM    | South    | Office Supplies | Binders        |   35.44 |          4 |          0 |     4.96 |            1.37 | Medium           |             2 |             2 |            3 |
| 2012-10-15 00:00:00.000 | Standard Class | Consumer  | Dos Quebradas | Risaralda        | Colombia      | LATAM    | South    | Office Supplies | Binders        |   35.44 |          4 |          0 |     4.96 |            1.37 | Medium           |             2 |             2 |            3 |
| 2012-10-15 00:00:00.000 | Standard Class | Consumer  | Dos Quebradas | Risaralda        | Colombia      | LATAM    | South    | Office Supplies | Binders        |   35.44 |          4 |          0 |     4.96 |            1.37 | Medium           |             2 |             3 |            3 |
| 2012-10-15 00:00:00.000 | Standard Class | Consumer  | Dos Quebradas | Risaralda        | Colombia      | LATAM    | South    | Office Supplies | Binders        |   35.44 |          4 |          0 |     4.96 |            1.37 | Medium           |             2 |             3 |            3 |
| 2012-10-15 00:00:00.000 | Standard Class | Consumer  | Dos Quebradas | Risaralda        | Colombia      | LATAM    | South    | Office Supplies | Binders        |   35.44 |          4 |          0 |     4.96 |            1.37 | Medium           |             2 |             3 |            3 |
| 2012-10-15 00:00:00.000 | Standard Class | Consumer  | Dos Quebradas | Risaralda        | Colombia      | LATAM    | South    | Office Supplies | Binders        |   35.44 |          4 |          0 |     4.96 |            1.37 | Medium           |             2 |             4 |            3 |


Table: Coustmer_details
| Region   |   Postal Code | Global Area   | State            | City          | Segment     | Customer Name   |   Coustmer_details_id |
|:---------|--------------:|:--------------|:-----------------|:--------------|:------------|:----------------|----------------------:|
| North    |            22 | Mexico        | Distrito Federal | Mexico City   | Consumer    | Sonia Cooley    |                     1 |
| South    |            33 | Colombia      | Risaralda        | Dos Quebradas | Consumer    | Kelly Williams  |                     2 |
| South    |            22 | Colombia      | Risaralda        | Dos Quebradas | Consumer    | Kelly Williams  |                     3 |
| South    |            22 | Colombia      | Risaralda        | Dos Quebradas | Consumer    | Kelly Williams  |                     4 |
| South    |            55 | Brazil        | S?o Paulo        | S?o Paulo     | Consumer    | Darren Powers   |                     5 |
| South    |             5 | Brazil        | S?o Paulo        | S?o Paulo     | Consumer    | Darren Powers   |                     6 |
| South    |           555 | Brazil        | S?o Paulo        | S?o Paulo     | Consumer    | Darren Powers   |                     7 |
| South    |           666 | Brazil        | S?o Paulo        | S?o Paulo     | Consumer    | Darren Powers   |                     8 |
| Central  |             3 | Nicaragua     | Managua          | Managua       | Consumer    | Tim Brockman    |                     9 |
| Central  |          3222 | Nicaragua     | Managua          | Managua       | Home Office | Paul Knutson    |                    10 |


Table: Dim_coustmer
| Coustmer_name   |   Coustmer_id |
|:----------------|--------------:|
| Sonia Cooley    |             1 |
| Kelly Williams  |             2 |
| Kelly Williams  |             3 |
| Kelly Williams  |             4 |
| Darren Powers   |             5 |
| Darren Powers   |             6 |
| Darren Powers   |             7 |
| Darren Powers   |             8 |
| Tim Brockman    |             9 |
| Paul Knutson    |            10 |


Table: Dim_Product
| Product Name                              | Sub-Category   | Category        |   Product_id |
|:------------------------------------------|:---------------|:----------------|-------------:|
| Hon File Folder Labels, Adjustable        | Labels         | Office Supplies |            1 |
| Tenex Clock, Durable                      | Furnishings    | Furniture       |            2 |
| Cardinal Binder, Clear                    | Binders        | Office Supplies |            3 |
| Sanford Canvas, Water Color               | Art            | Office Supplies |            4 |
| GlobeWeis Mailers, with clear poly window | Envelopes      | Office Supplies |            5 |
| Konica Card Printer, Red                  | Machines       | Technology      |            6 |
| Enermax Router, Erganomic                 | Accessories    | Technology      |            7 |
| Wilson Jones Hole Reinforcements, Durable | Binders        | Office Supplies |            8 |
| Hon Steel Folding Chair, Black            | Chairs         | Furniture       |            9 |
| Kraft Mailers, Security-Tint              | Envelopes      | Office Supplies |           10 |


Table: Dim_Sales report
| Product Name                              |   Sales |   Quantity |   Discount |   Profit |   product_id |
|:------------------------------------------|--------:|-----------:|-----------:|---------:|-------------:|
| Hon File Folder Labels, Adjustable        |   13.08 |          3 |          0 |     4.56 |            1 |
| Tenex Clock, Durable                      |  252.16 |          8 |          0 |    90.72 |            2 |
| Cardinal Binder, Clear                    |   35.44 |          4 |          0 |     4.96 |            3 |
| Sanford Canvas, Water Color               |   71.6  |          2 |          0 |    11.44 |            4 |
| GlobeWeis Mailers, with clear poly window |   56.12 |          2 |          0 |    21.32 |            5 |
| Konica Card Printer, Red                  |  344.64 |          3 |          0 |   165.42 |            6 |
| Enermax Router, Erganomic                 |  341.52 |          2 |          0 |    13.64 |            7 |
| Wilson Jones Hole Reinforcements, Durable |   12.06 |          3 |          0 |     3.48 |            8 |
| Hon Steel Folding Chair, Black            |  210.64 |          4 |          0 |    50.48 |            9 |
| Kraft Mailers, Security-Tint              |   80.1  |          3 |          0 |    37.62 |           10 |


Table: Dim_shipping
| Ship Mode      | Ship Date               | Order Date              | Customer Name   |   Postal Code |   Shipping Cost | Order Priority   |   Shipping_id |
|:---------------|:------------------------|:------------------------|:----------------|--------------:|----------------:|:-----------------|--------------:|
| Standard Class | 2014-10-06 00:00:00.000 | 2014-10-02 00:00:00.000 | Sonia Cooley    |            22 |            1.03 | Medium           |             1 |
| Standard Class | 2012-10-20 00:00:00.000 | 2012-10-15 00:00:00.000 | Kelly Williams  |            33 |           13.45 | Medium           |             2 |
| Standard Class | 2012-10-20 00:00:00.000 | 2012-10-15 00:00:00.000 | Kelly Williams  |            22 |            1.37 | Medium           |             3 |
| Standard Class | 2012-10-20 00:00:00.000 | 2012-10-15 00:00:00.000 | Kelly Williams  |            22 |            3.79 | Medium           |             4 |
| Standard Class | 2013-10-01 00:00:00.000 | 2013-09-27 00:00:00.000 | Darren Powers   |            55 |            4.11 | Medium           |             5 |
| Standard Class | 2013-10-01 00:00:00.000 | 2013-09-27 00:00:00.000 | Darren Powers   |             5 |           26.2  | Medium           |             6 |
| Standard Class | 2013-10-01 00:00:00.000 | 2013-09-27 00:00:00.000 | Darren Powers   |           555 |           17.34 | Medium           |             7 |
| Standard Class | 2013-10-01 00:00:00.000 | 2013-09-27 00:00:00.000 | Darren Powers   |           666 |            1.13 | Medium           |             8 |
| Standard Class | 2013-03-12 00:00:00.000 | 2013-03-05 00:00:00.000 | Tim Brockman    |             3 |           16.07 | Medium           |             9 |
| Standard Class | 2014-10-01 00:00:00.000 | 2014-09-24 00:00:00.000 | Paul Knutson    |          3222 |            8.86 | Low              |            10 |

 


tables: name: Bida_assignment
data: Bida_assignment.csv
name: Coustmer_details
data: Coustmer_details.csv
name: Dim_coustmer
data: Dim_coustmer.csv
name: Dim_Product
data: Dim_Product.csv
name: Dim_Sales report
data: Dim_Sales report.csv
name: Dim_shipping
data: Dim_shipping.csv
label: Bida_assignment
Sales
Dim_Sales report
Sales
Bida_assignment
Shipping Cost
Dim_shipping
Shipping Cost
Dim_Sales report
Product Name
Dim_Product
Product Name
Bida_assignment
Coustmer_id
Dim_coustmer
Coustmer_id
Dim_coustmer
Coustmer_id
Coustmer_details
Coustmer_details_id
output: {
    "joins": [
        {
            "from_table": "Bida_assignment",
            "from_column": "Sales",
            "to_table": "Dim_Sales report",
            "to_column": "Sales"
        },
        {
            "from_table": "Bida_assignment",
            "from_column": "Shipping Cost",
            "to_table": "Dim_shipping",
            "to_column": "Shipping Cost"
        },
        {
            "from_table": "Dim_Sales report",
            "from_column": "Product Name",
            "to_table": "Dim_Product",
            "to_column": "Product Name"
        },
        {
            "from_table": "Bida_assignment",
            "from_column": "Coustmer_id",
            "to_table": "Dim_coustmer",
            "to_column": "Coustmer_id"
        },
        {
            "from_table": "Dim_coustmer",
            "from_column": "Coustmer_id",
            "to_table": "Coustmer_details",
            "to_column": "Coustmer_details_id"
        }
    ]
}