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: SalesLT Address
|   AddressID | AddressLine1                | AddressLine2   | City          | StateProvince   | CountryRegion   |   PostalCode |
|------------:|:----------------------------|:---------------|:--------------|:----------------|:----------------|-------------:|
|         988 | 482505 Warm Springs Blvd.   |                | Fremont       | California      | United States   |        94536 |
|         989 | 39933 Mission Oaks Blvd     |                | Camarillo     | California      | United States   |        93010 |
|         991 | 60025 Bollinger Canyon Road |                | San Ramon     | California      | United States   |        94583 |
|         992 | 9992 Whipple Rd             |                | Union City    | California      | United States   |        94587 |
|         993 | Corporate Office            |                | El Segundo    | California      | United States   |        90245 |
|         994 | 25001 Montague Expressway   |                | Milpitas      | California      | United States   |        95035 |
|         995 | 4460 Newport Center Drive   |                | Newport Beach | California      | United States   |        92625 |
|         997 | 70259 West Sunnyview Ave    |                | Visalia       | California      | United States   |        93291 |
|         998 | 60750 San Clemente          |                | Hayward       | California      | United States   |        94541 |
|         999 | Receiving                   |                | Fullerton     | California      | United States   |        92831 |


Table: SalesLT Customer
|   CustomerID | NameStyle   | Title   | FirstName   | MiddleName   | LastName   | Suffix   | CompanyName                        | SalesPerson              | EmailAddress                | Phone        | CustomerName    |
|-------------:|:------------|:--------|:------------|:-------------|:-----------|:---------|:-----------------------------------|:-------------------------|:----------------------------|:-------------|:----------------|
|            2 | False       | Mr.     | Keith       |              | Harris     |          | Progressive Sports                 | adventure-works\david8   | keith0@adventure-works.com  | 170-555-0127 | Harris,Keith    |
|            5 | False       | Mr.     | Lucy        |              | Harrington |          | Metropolitan Sports Supply         | adventure-works\shu0     | lucy0@adventure-works.com   | 828-555-0186 | Harrington,Lucy |
|           23 | False       | Mr.     | Kerim       |              | Hanif      |          | Bike World                         | adventure-works\shu0     | kerim0@adventure-works.com  | 216-555-0122 | Hanif,Kerim     |
|           24 | False       | Mr.     | Kevin       |              | Liu        |          | Eastside Department Store          | adventure-works\linda3   | kevin5@adventure-works.com  | 926-555-0164 | Liu,Kevin       |
|           29 | False       | Mr.     | Bryan       |              | Hamilton   |          | Cross-Country Riding Supplies      | adventure-works\josé1    | bryan2@adventure-works.com  | 344-555-0144 | Hamilton,Bryan  |
|           37 | False       | Mr.     | Jim         |              | Geist      |          | Two Bike Shops                     | adventure-works\pamela0  | jim1@adventure-works.com    | 724-555-0161 | Geist,Jim       |
|           40 | False       | Mr.     | Darren      |              | Gehring    |          | Journey Sporting Goods             | adventure-works\jillian0 | darren0@adventure-works.com | 417-555-0182 | Gehring,Darren  |
|           42 | False       | Mr.     | Jeremy      |              | Los        |          | Healthy Activity Store             | adventure-works\linda3   | jeremy0@adventure-works.com | 911-555-0165 | Los,Jeremy      |
|           55 | False       | Mr.     | Eric        |              | Lang       |          | Kickstands and Accessories Company | adventure-works\pamela0  | eric6@adventure-works.com   | 932-555-0163 | Lang,Eric       |
|           56 | False       | Mr.     | Brian       |              | Groth      |          | Latest Accessories Sales           | adventure-works\david8   | brian5@adventure-works.com  | 461-555-0118 | Groth,Brian     |


Table: SalesLT CustomerAddress
|   CustomerID |   AddressID | AddressType   |
|-------------:|------------:|:--------------|
|        29485 |        1086 | Main Office   |
|        29486 |         621 | Main Office   |
|        29489 |        1069 | Main Office   |
|        29490 |         887 | Main Office   |
|        29492 |         618 | Main Office   |
|        29494 |         537 | Main Office   |
|        29496 |        1072 | Main Office   |
|        29497 |         889 | Main Office   |
|        29499 |         527 | Main Office   |
|        29502 |         893 | Main Office   |


Table: SalesLT Product
|   ProductID | ProductName                 | ProductNumber   | Color   |   StandardCost |   ListPrice | Size   | Weight   |   ProductCategoryID |   ProductModelID | SellStartDate           | SellEndDate             | DiscontinuedDate   | Category   |
|------------:|:----------------------------|:----------------|:--------|---------------:|------------:|:-------|:---------|--------------------:|-----------------:|:------------------------|:------------------------|:-------------------|:-----------|
|         707 | Sport-100 Helmet, Red       | HL-U509-R       | Red     |        13.0863 |       34.99 |        |          |                  35 |               33 | 2005-07-01 00:00:00.000 |                         |                    | Helmets    |
|         708 | Sport-100 Helmet, Black     | HL-U509         | Black   |        13.0863 |       34.99 |        |          |                  35 |               33 | 2005-07-01 00:00:00.000 |                         |                    | Helmets    |
|         709 | Mountain Bike Socks, M      | SO-B909-M       | White   |         3.3963 |        9.5  | M      |          |                  27 |               18 | 2005-07-01 00:00:00.000 | 2006-06-30 00:00:00.000 |                    | Socks      |
|         710 | Mountain Bike Socks, L      | SO-B909-L       | White   |         3.3963 |        9.5  | L      |          |                  27 |               18 | 2005-07-01 00:00:00.000 | 2006-06-30 00:00:00.000 |                    | Socks      |
|         711 | Sport-100 Helmet, Blue      | HL-U509-B       | Blue    |        13.0863 |       34.99 |        |          |                  35 |               33 | 2005-07-01 00:00:00.000 |                         |                    | Helmets    |
|         712 | AWC Logo Cap                | CA-1098         | Multi   |         6.9223 |        8.99 |        |          |                  23 |                2 | 2005-07-01 00:00:00.000 |                         |                    | Caps       |
|         713 | Long-Sleeve Logo Jersey, S  | LJ-0192-S       | Multi   |        38.4923 |       49.99 | S      |          |                  25 |               11 | 2005-07-01 00:00:00.000 |                         |                    | Jerseys    |
|         714 | Long-Sleeve Logo Jersey, M  | LJ-0192-M       | Multi   |        38.4923 |       49.99 | M      |          |                  25 |               11 | 2005-07-01 00:00:00.000 |                         |                    | Jerseys    |
|         715 | Long-Sleeve Logo Jersey, L  | LJ-0192-L       | Multi   |        38.4923 |       49.99 | L      |          |                  25 |               11 | 2005-07-01 00:00:00.000 |                         |                    | Jerseys    |
|         716 | Long-Sleeve Logo Jersey, XL | LJ-0192-X       | Multi   |        38.4923 |       49.99 | XL     |          |                  25 |               11 | 2005-07-01 00:00:00.000 |                         |                    | Jerseys    |


Table: SalesLT ProductCategory
|   ProductCategoryID | ParentProductCategoryID   | Name            |
|--------------------:|:--------------------------|:----------------|
|                   1 |                           | Bikes           |
|                   2 |                           | Components      |
|                   3 |                           | Clothing        |
|                   4 |                           | Accessories     |
|                   5 | 1                         | Mountain Bikes  |
|                   6 | 1                         | Road Bikes      |
|                   7 | 1                         | Touring Bikes   |
|                   8 | 2                         | Handlebars      |
|                   9 | 2                         | Bottom Brackets |
|                  10 | 2                         | Brakes          |


Table: SalesLT ProductDescription
|   ProductDescriptionID | Description                                                                                                                                                            |
|-----------------------:|:-----------------------------------------------------------------------------------------------------------------------------------------------------------------------|
|                      3 | Chromoly steel.                                                                                                                                                        |
|                      4 | Aluminum alloy cups; large diameter spindle.                                                                                                                           |
|                      5 | Aluminum alloy cups and a hollow axle.                                                                                                                                 |
|                      8 | Suitable for any type of riding, on or off-road. Fits any budget. Smooth-shifting with a comfortable ride.                                                             |
|                     64 | This bike delivers a high-level of performance on a budget. It is responsive and maneuverable, and offers peace-of-mind when you decide to go off-road.                |
|                     88 | For true trail addicts.  An extremely durable bike that will go anywhere and keep you in control on challenging terrain - without breaking your budget.                |
|                    128 | Serious back-country riding. Perfect for all levels of competition. Uses the same HL Frame as the Mountain-100.                                                        |
|                    168 | Top-of-the-line competition mountain bike. Performance-enhancing options include the innovative HL Frame, super-smooth front suspension, and traction for all terrain. |
|                    170 | Suitable for any type of off-road trip. Fits any budget.                                                                                                               |
|                    209 | Entry level adult bike; offers a comfortable ride cross-country or down the block. Quick-release hubs and rims.                                                        |


Table: SalesLT ProductModel
|   ProductModelID | Name               | CatalogDescription   |
|-----------------:|:-------------------|:---------------------|
|                1 | Classic Vest       |                      |
|                2 | Cycling Cap        |                      |
|                3 | Full-Finger Gloves |                      |
|                4 | Half-Finger Gloves |                      |
|                5 | HL Mountain Frame  |                      |
|                6 | HL Road Frame      |                      |
|                7 | HL Touring Frame   |                      |
|                8 | LL Mountain Frame  |                      |
|                9 | LL Road Frame      |                      |
|               10 | LL Touring Frame   |                      |


Table: SalesLT ProductModelProductDescription
|   ProductModelID |   ProductDescriptionID | Culture   |
|-----------------:|-----------------------:|:----------|
|                1 |                   1199 | en        |
|                2 |                   1210 | en        |
|                3 |                   1195 | en        |
|                4 |                   1194 | en        |
|                5 |                    647 | en        |
|                6 |                   1090 | en        |
|                7 |                   1182 | en        |
|                8 |                    637 | en        |
|                9 |                   1020 | en        |
|               10 |                   1146 | en        |


Table: SalesLT SalesOrderDetail
|   SalesOrderID |   SalesOrderDetailID |   OrderQty |   ProductID |   UnitPrice |   UnitPriceDiscount |   SOD_LineTotal_$ales |
|---------------:|---------------------:|-----------:|------------:|------------:|--------------------:|----------------------:|
|          71774 |               110562 |          1 |         836 |     356.898 |                   0 |               356.898 |
|          71774 |               110563 |          1 |         822 |     356.898 |                   0 |               356.898 |
|          71776 |               110567 |          1 |         907 |      63.9   |                   0 |                63.9   |
|          71780 |               110616 |          4 |         905 |     218.454 |                   0 |               873.816 |
|          71780 |               110617 |          2 |         983 |     461.694 |                   0 |               923.388 |
|          71780 |               110619 |          2 |         748 |     818.7   |                   0 |              1637.4   |
|          71780 |               110620 |          1 |         990 |     323.994 |                   0 |               323.994 |
|          71780 |               110621 |          1 |         926 |     149.874 |                   0 |               149.874 |
|          71780 |               110622 |          1 |         743 |     809.76  |                   0 |               809.76  |
|          71780 |               110623 |          4 |         782 |    1376.99  |                   0 |              5507.98  |


Table: SalesLT SalesOrderHeader
|   SalesOrderID |   RevisionNumber | OrderDate               | DueDate                 | ShipDate                |   Status | OnlineOrderFlag   | SalesOrderNumber   | PurchaseOrderNumber   | AccountNumber   |   CustomerID |   ShipToAddressID |   BillToAddressID | ShipMethod        | CreditCardApprovalCode   |   SOH_Subtotal_$ales |    TaxAmt |   Freight |    TotalDue | Comment   |
|---------------:|-----------------:|:------------------------|:------------------------|:------------------------|---------:|:------------------|:-------------------|:----------------------|:----------------|-------------:|------------------:|------------------:|:------------------|:-------------------------|---------------------:|----------:|----------:|------------:|:----------|
|          71774 |                2 | 2008-06-01 00:00:00.000 | 2008-06-13 00:00:00.000 | 2008-06-08 00:00:00.000 |        5 | False             | SO71774            | PO348186287           | 10-4020-000609  |        29847 |              1092 |              1092 | CARGO TRANSPORT 5 |                          |              880.348 |   70.4279 |   22.0087 |    972.785  |           |
|          71776 |                2 | 2008-06-01 00:00:00.000 | 2008-06-13 00:00:00.000 | 2008-06-08 00:00:00.000 |        5 | False             | SO71776            | PO19952192051         | 10-4020-000106  |        30072 |               640 |               640 | CARGO TRANSPORT 5 |                          |               78.81  |    6.3048 |    1.9703 |     87.0851 |           |
|          71780 |                2 | 2008-06-01 00:00:00.000 | 2008-06-13 00:00:00.000 | 2008-06-08 00:00:00.000 |        5 | False             | SO71780            | PO19604173239         | 10-4020-000340  |        30113 |               653 |               653 | CARGO TRANSPORT 5 |                          |            38418.7   | 3073.5    |  960.467  |  42452.7    |           |
|          71782 |                2 | 2008-06-01 00:00:00.000 | 2008-06-13 00:00:00.000 | 2008-06-08 00:00:00.000 |        5 | False             | SO71782            | PO19372114749         | 10-4020-000582  |        29485 |              1086 |              1086 | CARGO TRANSPORT 5 |                          |            39785.3   | 3182.83   |  994.633  |  43962.8    |           |
|          71783 |                2 | 2008-06-01 00:00:00.000 | 2008-06-13 00:00:00.000 | 2008-06-08 00:00:00.000 |        5 | False             | SO71783            | PO19343113609         | 10-4020-000024  |        29957 |               992 |               992 | CARGO TRANSPORT 5 |                          |            83858.4   | 6708.67   | 2096.46   |  92663.6    |           |
|          71784 |                2 | 2008-06-01 00:00:00.000 | 2008-06-13 00:00:00.000 | 2008-06-08 00:00:00.000 |        5 | False             | SO71784            | PO19285135919         | 10-4020-000448  |        29736 |               659 |               659 | CARGO TRANSPORT 5 |                          |           108562     | 8684.95   | 2714.05   | 119961      |           |
|          71796 |                2 | 2008-06-01 00:00:00.000 | 2008-06-13 00:00:00.000 | 2008-06-08 00:00:00.000 |        5 | False             | SO71796            | PO17052159664         | 10-4020-000420  |        29660 |              1058 |              1058 | CARGO TRANSPORT 5 |                          |            57634.6   | 4610.77   | 1440.87   |  63686.3    |           |
|          71797 |                2 | 2008-06-01 00:00:00.000 | 2008-06-13 00:00:00.000 | 2008-06-08 00:00:00.000 |        5 | False             | SO71797            | PO16501134889         | 10-4020-000142  |        29796 |               642 |               642 | CARGO TRANSPORT 5 |                          |            78029.7   | 6242.38   | 1950.74   |  86222.8    |           |
|          71815 |                2 | 2008-06-01 00:00:00.000 | 2008-06-13 00:00:00.000 | 2008-06-08 00:00:00.000 |        5 | False             | SO71815            | PO13021155785         | 10-4020-000276  |        30089 |              1034 |              1034 | CARGO TRANSPORT 5 |                          |             1141.58  |   91.3263 |   28.5395 |   1261.44   |           |
|          71816 |                2 | 2008-06-01 00:00:00.000 | 2008-06-13 00:00:00.000 | 2008-06-08 00:00:00.000 |        5 | False             | SO71816            | PO12992180445         | 10-4020-000295  |        30027 |              1038 |              1038 | CARGO TRANSPORT 5 |                          |             3398.17  |  271.853  |   84.9541 |   3754.97   |           |

 


tables: name: SalesLT Address
data: SalesLT Address.csv
name: SalesLT Customer
data: SalesLT Customer.csv
name: SalesLT CustomerAddress
data: SalesLT CustomerAddress.csv
name: SalesLT Product
data: SalesLT Product.csv
name: SalesLT ProductCategory
data: SalesLT ProductCategory.csv
name: SalesLT ProductDescription
data: SalesLT ProductDescription.csv
name: SalesLT ProductModel
data: SalesLT ProductModel.csv
name: SalesLT ProductModelProductDescription
data: SalesLT ProductModelProductDescription.csv
name: SalesLT SalesOrderDetail
data: SalesLT SalesOrderDetail.csv
name: SalesLT SalesOrderHeader
data: SalesLT SalesOrderHeader.csv
label: SalesLT CustomerAddress
AddressID
SalesLT Address
AddressID
SalesLT SalesOrderHeader
BillToAddressID
SalesLT Address
AddressID
SalesLT CustomerAddress
CustomerID
SalesLT Customer
CustomerID
SalesLT Product
ProductCategoryID
SalesLT ProductCategory
ProductCategoryID
SalesLT Product
ProductModelID
SalesLT ProductModel
ProductModelID
SalesLT SalesOrderDetail
ProductID
SalesLT Product
ProductID
SalesLT ProductModelProductDescription
ProductDescriptionID
SalesLT ProductDescription
ProductDescriptionID
SalesLT ProductModelProductDescription
ProductModelID
SalesLT ProductModel
ProductModelID
SalesLT SalesOrderDetail
SalesOrderID
SalesLT SalesOrderHeader
SalesOrderID
output: {
    "joins": [
        {
            "from_table": "SalesLT CustomerAddress",
            "from_column": "AddressID",
            "to_table": "SalesLT Address",
            "to_column": "AddressID"
        },
        {
            "from_table": "SalesLT SalesOrderHeader",
            "from_column": "BillToAddressID",
            "to_table": "SalesLT Address",
            "to_column": "AddressID"
        },
        {
            "from_table": "SalesLT CustomerAddress",
            "from_column": "CustomerID",
            "to_table": "SalesLT Customer",
            "to_column": "CustomerID"
        },
        {
            "from_table": "SalesLT Product",
            "from_column": "ProductCategoryID",
            "to_table": "SalesLT ProductCategory",
            "to_column": "ProductCategoryID"
        },
        {
            "from_table": "SalesLT Product",
            "from_column": "ProductModelID",
            "to_table": "SalesLT ProductModel",
            "to_column": "ProductModelID"
        },
        {
            "from_table": "SalesLT SalesOrderDetail",
            "from_column": "ProductID",
            "to_table": "SalesLT Product",
            "to_column": "ProductID"
        },
        {
            "from_table": "SalesLT ProductModelProductDescription",
            "from_column": "ProductDescriptionID",
            "to_table": "SalesLT ProductDescription",
            "to_column": "ProductDescriptionID"
        },
        {
            "from_table": "SalesLT ProductModelProductDescription",
            "from_column": "ProductModelID",
            "to_table": "SalesLT ProductModel",
            "to_column": "ProductModelID"
        },
        {
            "from_table": "SalesLT SalesOrderDetail",
            "from_column": "SalesOrderID",
            "to_table": "SalesLT SalesOrderHeader",
            "to_column": "SalesOrderID"
        }
    ]
}