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: Currency
|   CurrencyKey | Currency Code   | Currency          |
|--------------:|:----------------|:------------------|
|             1 | USD             | US Dollar         |
|             2 | AMD             | Armenian Dram     |
|             3 | AUD             | Australian Dollar |
|             4 | THB             | Thai Baht         |
|             5 | CAD             | Canadian Dollar   |
|             6 | DKK             | Danish Krone      |
|             7 | EUR             | EURO              |
|             8 | HKD             | Hong Kong Dollar  |
|             9 | INR             | Indian Rupee      |
|            10 | ROL             | Romanian Leu      |


Table: Customer
|   CustomerKey |   GeographyKey |   Customer Code | Title   | Name              | Birth Date              | Marital Status   | Gender   |   Yearly Income |   Total Children |   Children At Home | Education       | Occupation     | House Ownership   |   Cars Owned | Continent     | City          | State      | Country       | Date First Purchase     | Customer Type   | Company Name   |
|--------------:|---------------:|----------------:|:--------|:------------------|:------------------------|:-----------------|:---------|----------------:|-----------------:|-------------------:|:----------------|:---------------|:------------------|-------------:|:--------------|:--------------|:-----------|:--------------|:------------------------|:----------------|:---------------|
|            25 |            470 |           11024 |         | Xie, Russell      | 1978-09-17 00:00:00.000 | M                | M        |           60000 |                0 |                  0 | Partial College | Skilled Manual | House Owner       |            2 | North America | Concord       | California | United States | 2003-12-29 00:00:00.000 | Person          |                |
|            37 |            516 |           11036 |         | Russell, Jennifer | 1978-12-18 00:00:00.000 | M                | F        |           60000 |                0 |                  0 | Partial College | Skilled Manual | House Owner       |            2 | North America | National City | California | United States | 2003-07-26 00:00:00.000 | Person          |                |
|            42 |            633 |           11041 |         | Carter, Amanda    | 1977-10-16 00:00:00.000 | M                | F        |           60000 |                0 |                  0 | Partial College | Skilled Manual | House Owner       |            2 | North America | Glendale      | California | United States | 2003-07-18 00:00:00.000 | Person          |                |
|            44 |            633 |           11043 |         | Simmons, Nathan   | 1976-02-24 00:00:00.000 | M                | M        |           60000 |                0 |                  0 | Partial College | Skilled Manual | House Owner       |            2 | North America | Glendale      | California | United States | 2003-11-09 00:00:00.000 | Person          |                |
|           929 |            625 |           11928 |         | Morris, Isabella  | 1978-09-07 00:00:00.000 | M                | F        |           60000 |                0 |                  0 | Partial College | Skilled Manual | House Owner       |            2 | North America | El Cajon      | California | United States | 2003-12-02 00:00:00.000 | Person          |                |
|           939 |            472 |           11938 |         | Alexander, Seth   | 1977-09-21 00:00:00.000 | M                | M        |           60000 |                0 |                  0 | Partial College | Skilled Manual | House Owner       |            2 | North America | Daly City     | California | United States | 2003-09-08 00:00:00.000 | Person          |                |
|           955 |            633 |           11954 |         | Garcia, Joseph    | 1975-08-17 00:00:00.000 | M                | M        |           60000 |                0 |                  0 | Partial College | Skilled Manual | House Owner       |            2 | North America | Glendale      | California | United States | 2002-05-04 00:00:00.000 | Person          |                |
|           956 |            633 |           11955 |         | Green, Gabriel    | 1975-04-05 00:00:00.000 | S                | M        |           60000 |                0 |                  0 | Partial College | Skilled Manual | House Owner       |            2 | North America | Glendale      | California | United States | 2002-05-01 00:00:00.000 | Person          |                |
|          2031 |            619 |           13030 |         | Lopez, Sophia     | 1977-07-13 00:00:00.000 | S                | F        |           60000 |                0 |                  0 | Partial College | Skilled Manual | House Owner       |            2 | North America | Coronado      | California | United States | 2004-03-12 00:00:00.000 | Person          |                |
|          2987 |            552 |           13986 |         | Anderson, Chloe   | 1979-10-25 00:00:00.000 | M                | F        |           60000 |                0 |                  0 | Partial College | Skilled Manual | House Owner       |            2 | North America | Spring Valley | California | United States | 2002-07-11 00:00:00.000 | Person          |                |


Table: Date
| Date                    |   DateKey |   Calendar Year Number | Calendar Year   |   Calendar Year Quarter Number | Calendar Year Quarter   |   Calendar Year Month Number | Calendar Year Month   |   Month Number | Month   |   Day of Week Number | Day of Week   |   Fiscal Year Number | Fiscal Year   |   Fiscal Quarter Number | Fiscal Quarter   |   Fiscal Year Quarter Number | Fiscal Year Quarter   |   Fiscal Month Number | Fiscal Month   | Working Day   |   Is Holiday | Holiday Name   | Europe Season   | North America Season   | Asia Season   |
|:------------------------|----------:|-----------------------:|:----------------|-------------------------------:|:------------------------|-----------------------------:|:----------------------|---------------:|:--------|---------------------:|:--------------|---------------------:|:--------------|------------------------:|:-----------------|-----------------------------:|:----------------------|----------------------:|:---------------|:--------------|-------------:|:---------------|:----------------|:-----------------------|:--------------|
| 2005-07-01 00:00:00.000 |  20050701 |                   2005 | CY 2005         |                          20053 | Q3-2005                 |                       200507 | July 2005             |              7 | July    |                    6 | Friday        |                 2006 | FY 2006       |                       1 | Q1               |                        20061 | Q1-2006               |                     1 | July           | WorkDay       |            0 | None           | Back to School  | Back to School         | None          |
| 2005-07-04 00:00:00.000 |  20050704 |                   2005 | CY 2005         |                          20053 | Q3-2005                 |                       200507 | July 2005             |              7 | July    |                    2 | Monday        |                 2006 | FY 2006       |                       1 | Q1               |                        20061 | Q1-2006               |                     1 | July           | WorkDay       |            0 | None           | Back to School  | Back to School         | None          |
| 2005-07-05 00:00:00.000 |  20050705 |                   2005 | CY 2005         |                          20053 | Q3-2005                 |                       200507 | July 2005             |              7 | July    |                    3 | Tuesday       |                 2006 | FY 2006       |                       1 | Q1               |                        20061 | Q1-2006               |                     1 | July           | WorkDay       |            0 | None           | Back to School  | Back to School         | None          |
| 2005-07-06 00:00:00.000 |  20050706 |                   2005 | CY 2005         |                          20053 | Q3-2005                 |                       200507 | July 2005             |              7 | July    |                    4 | Wednesday     |                 2006 | FY 2006       |                       1 | Q1               |                        20061 | Q1-2006               |                     1 | July           | WorkDay       |            0 | None           | Back to School  | Back to School         | None          |
| 2005-07-07 00:00:00.000 |  20050707 |                   2005 | CY 2005         |                          20053 | Q3-2005                 |                       200507 | July 2005             |              7 | July    |                    5 | Thursday      |                 2006 | FY 2006       |                       1 | Q1               |                        20061 | Q1-2006               |                     1 | July           | WorkDay       |            0 | None           | Back to School  | Back to School         | None          |
| 2005-07-08 00:00:00.000 |  20050708 |                   2005 | CY 2005         |                          20053 | Q3-2005                 |                       200507 | July 2005             |              7 | July    |                    6 | Friday        |                 2006 | FY 2006       |                       1 | Q1               |                        20061 | Q1-2006               |                     1 | July           | WorkDay       |            0 | None           | Back to School  | Back to School         | None          |
| 2005-07-11 00:00:00.000 |  20050711 |                   2005 | CY 2005         |                          20053 | Q3-2005                 |                       200507 | July 2005             |              7 | July    |                    2 | Monday        |                 2006 | FY 2006       |                       1 | Q1               |                        20061 | Q1-2006               |                     1 | July           | WorkDay       |            0 | None           | Back to School  | Back to School         | None          |
| 2005-07-12 00:00:00.000 |  20050712 |                   2005 | CY 2005         |                          20053 | Q3-2005                 |                       200507 | July 2005             |              7 | July    |                    3 | Tuesday       |                 2006 | FY 2006       |                       1 | Q1               |                        20061 | Q1-2006               |                     1 | July           | WorkDay       |            0 | None           | Back to School  | Back to School         | None          |
| 2005-07-13 00:00:00.000 |  20050713 |                   2005 | CY 2005         |                          20053 | Q3-2005                 |                       200507 | July 2005             |              7 | July    |                    4 | Wednesday     |                 2006 | FY 2006       |                       1 | Q1               |                        20061 | Q1-2006               |                     1 | July           | WorkDay       |            0 | None           | Back to School  | Back to School         | None          |
| 2005-07-14 00:00:00.000 |  20050714 |                   2005 | CY 2005         |                          20053 | Q3-2005                 |                       200507 | July 2005             |              7 | July    |                    5 | Thursday      |                 2006 | FY 2006       |                       1 | Q1               |                        20061 | Q1-2006               |                     1 | July           | WorkDay       |            0 | None           | Back to School  | Back to School         | None          |


Table: Product Category
|   ProductCategoryKey |   Category Code | Category                      |
|---------------------:|----------------:|:------------------------------|
|                    1 |               1 | Audio                         |
|                    2 |               2 | TV and Video                  |
|                    3 |               3 | Computers                     |
|                    4 |               4 | Cameras and camcorders        |
|                    5 |               5 | Cell phones                   |
|                    6 |               6 | Music, Movies and Audio Books |
|                    7 |               7 | Games and Toys                |
|                    8 |               8 | Home Appliances               |


Table: Product Subcategory
|   ProductSubcategoryKey |   Subcategory Code | Subcategory          |   ProductCategoryKey |
|------------------------:|-------------------:|:---------------------|---------------------:|
|                       1 |                101 | MP4&MP3              |                    1 |
|                       2 |                102 | Recorder             |                    1 |
|                       3 |                103 | Radio                |                    1 |
|                       4 |                104 | Recording Pen        |                    1 |
|                       5 |                105 | Headphones           |                    1 |
|                       6 |                106 | Bluetooth Headphones |                    1 |
|                       7 |                107 | Speakers             |                    1 |
|                       8 |                108 | Audio Accessories    |                    1 |
|                       9 |                201 | Televisions          |                    2 |
|                      10 |                202 | VCD & DVD            |                    2 |


Table: Product
|   ProductKey |   Product Code | Product Name                                            | Product Description                             |   ProductSubcategoryKey | Manufacturer   | Brand         | Class   | Style          | Color   | Size   | Weight   | Weight Unit Measure   |   Stock Type Code | Stock Type   |   Unit Cost |   Unit Price | Available Date          | Status   |
|-------------:|---------------:|:--------------------------------------------------------|:------------------------------------------------|------------------------:|:---------------|:--------------|:--------|:---------------|:--------|:-------|:---------|:----------------------|------------------:|:-------------|------------:|-------------:|:------------------------|:---------|
|         1722 |         702016 | MGS Zoo Tycoon 2: End range Species Expansion Pack E105 | Zoo Tycoon 2: Endangered Species Expansion Pack |                      39 | Tailspin Toys  | Tailspin Toys | Economy | Product0702016 | Silver  |        |          |                       |                 3 | Low          |       28.55 |       56     | 2006-05-12 00:00:00.000 | On       |
|         1723 |         702017 | MGS Age of Empires III: The Asian Dynasties E106        | Age of Empires III: The Asian Dynasties         |                      39 | Tailspin Toys  | Tailspin Toys | Economy | Product0702017 | Pink    |        |          |                       |                 3 | Low          |       28.55 |       56     | 2007-04-05 00:00:00.000 | On       |
|         1724 |         702018 | MGS Fable: The Lost Chapters E107                       | Fable: The Lost Chapters                        |                      39 | Tailspin Toys  | Tailspin Toys | Economy | Product0702018 | Silver  |        |          |                       |                 3 | Low          |       28.55 |       56     | 2007-04-05 00:00:00.000 | On       |
|         1725 |         702019 | MGS Dungeon Siege II E105                               | Dungeon Siege II                                |                      39 | Tailspin Toys  | Tailspin Toys | Economy | Product0702019 | Silver  |        |          |                       |                 3 | Low          |       28.55 |       56     | 2009-01-02 00:00:00.000 | On       |
|         1726 |         702020 | MGS Zoo Tycoon 2 E108                                   | Zoo Tycoon 2                                    |                      39 | Tailspin Toys  | Tailspin Toys | Economy | Product0702020 | Silver  |        |          |                       |                 3 | Low          |       28.55 |       56     | 2009-01-03 00:00:00.000 | On       |
|         1727 |         702021 | MGS Rise of Nations: Gold Edition M300                  | Rise of Nations: Gold Edition                   |                      39 | Tailspin Toys  | Tailspin Toys | Economy | Product0702021 | Pink    |        |          |                       |                 3 | Low          |       25.75 |       56     | 2005-01-04 00:00:00.000 | On       |
|         1733 |         702027 | MGS Halo: Combat Evolved E109                           | Halo: Combat Evolved                            |                      39 | Tailspin Toys  | Tailspin Toys | Economy | Product0702027 | Silver  |        |          |                       |                 3 | Low          |       11.62 |       22.788 | 2005-01-02 00:00:00.000 | On       |
|         1734 |         702028 | MGS Zoo Tycoon Complete Collection E110                 | Zoo Tycoon Complete Collection                  |                      39 | Tailspin Toys  | Tailspin Toys | Economy | Product0702028 | Blue    |        |          |                       |                 3 | Low          |       14.28 |       28     | 2005-01-03 00:00:00.000 | On       |
|         1735 |         702029 | MGS Flight Simulator 2004: A Century of Flight E111     | Flight Simulator 2004: A Century of Flight      |                      39 | Tailspin Toys  | Tailspin Toys | Economy | Product0702029 | Black   |        |          |                       |                 3 | Low          |       14.28 |       28     | 2005-01-04 00:00:00.000 | On       |
|         1736 |         702030 | MGS Rise of Nations E112                                | Rise of Nations                                 |                      39 | Tailspin Toys  | Tailspin Toys | Economy | Product0702030 | White   |        |          |                       |                 3 | Low          |       14.28 |       28     | 2007-04-05 00:00:00.000 | On       |


Table: Promotion
|   PromotionKey |   Promotion Code | Promotion                              |   Discount | Promotion Type    | Promotion Category   | Start Date              | End Date                |
|---------------:|-----------------:|:---------------------------------------|-----------:|:------------------|:---------------------|:------------------------|:------------------------|
|              1 |                1 | No Discount                            |       0    | No Discount       | No Discount          | 2003-01-01 00:00:00.000 | 2010-12-31 00:00:00.000 |
|              2 |                2 | North America Spring Promotion         |       0.05 | Seasonal Discount | Store                | 2007-01-01 00:00:00.000 | 2007-03-31 00:00:00.000 |
|              3 |                3 | North America Back-to-School Promotion |       0.1  | Seasonal Discount | Store                | 2007-07-01 00:00:00.000 | 2007-09-30 00:00:00.000 |
|              4 |                4 | North America Holiday Promotion        |       0.2  | Seasonal Discount | Store                | 2007-11-01 00:00:00.000 | 2007-12-31 00:00:00.000 |
|              5 |                5 | Asian Holiday Promotion                |       0.15 | Seasonal Discount | Store                | 2007-11-01 00:00:00.000 | 2008-01-31 00:00:00.000 |
|              6 |                6 | Asian Spring Promotion                 |       0.2  | Seasonal Discount | Store                | 2007-02-01 00:00:00.000 | 2007-04-30 00:00:00.000 |
|              7 |                7 | Asian Summer Promotion                 |       0.1  | Seasonal Discount | Store                | 2007-05-01 00:00:00.000 | 2007-06-30 00:00:00.000 |
|              8 |                8 | European Spring Promotion              |       0.07 | Seasonal Discount | Store                | 2007-02-01 00:00:00.000 | 2007-04-30 00:00:00.000 |
|              9 |                9 | European Back-to-Scholl Promotion      |       0.1  | Seasonal Discount | Store                | 2007-08-01 00:00:00.000 | 2007-09-30 00:00:00.000 |
|             10 |               10 | European Holiday Promotion             |       0.2  | Seasonal Discount | Store                | 2007-10-01 00:00:00.000 | 2008-01-31 00:00:00.000 |


Table: Sales
|   StoreKey |   ProductKey |   PromotionKey |   CurrencyKey |   CustomerKey |   OrderDateKey |   DueDateKey |   DeliveryDateKey | Order Date              | Due Date                | Delivery Date           |   Quantity |   Unit Price |   Unit Discount |   Unit Cost |   Net Price |
|-----------:|-------------:|---------------:|--------------:|--------------:|---------------:|-------------:|------------------:|:------------------------|:------------------------|:------------------------|-----------:|-------------:|----------------:|------------:|------------:|
|        199 |         1316 |              1 |             1 |         18768 |       20070502 |     20070515 |          20070510 | 2007-05-02 00:00:00.000 | 2007-05-15 00:00:00.000 | 2007-05-10 00:00:00.000 |          1 |         9.99 |               0 |        5.09 |        9.99 |
|        199 |         1316 |              1 |             1 |         18768 |       20070502 |     20070508 |          20070511 | 2007-05-02 00:00:00.000 | 2007-05-08 00:00:00.000 | 2007-05-11 00:00:00.000 |          1 |         9.99 |               0 |        5.09 |        9.99 |
|        199 |         1316 |              1 |             1 |         18768 |       20070502 |     20070509 |          20070512 | 2007-05-02 00:00:00.000 | 2007-05-09 00:00:00.000 | 2007-05-12 00:00:00.000 |          1 |         9.99 |               0 |        5.09 |        9.99 |
|        199 |         1316 |              1 |             1 |         18768 |       20070502 |     20070511 |          20070514 | 2007-05-02 00:00:00.000 | 2007-05-11 00:00:00.000 | 2007-05-14 00:00:00.000 |          1 |         9.99 |               0 |        5.09 |        9.99 |
|        306 |         2505 |              1 |             1 |         19041 |       20070701 |     20070709 |          20070710 | 2007-07-01 00:00:00.000 | 2007-07-09 00:00:00.000 | 2007-07-10 00:00:00.000 |          1 |         9.99 |               0 |        5.09 |        9.99 |
|        306 |         2505 |              1 |             1 |         19041 |       20070701 |     20070710 |          20070711 | 2007-07-01 00:00:00.000 | 2007-07-10 00:00:00.000 | 2007-07-11 00:00:00.000 |          1 |         9.99 |               0 |        5.09 |        9.99 |
|        306 |         2505 |              1 |             1 |         19041 |       20070701 |     20070711 |          20070712 | 2007-07-01 00:00:00.000 | 2007-07-11 00:00:00.000 | 2007-07-12 00:00:00.000 |          1 |         9.99 |               0 |        5.09 |        9.99 |
|        306 |         2505 |              1 |             1 |         19041 |       20070701 |     20070712 |          20070713 | 2007-07-01 00:00:00.000 | 2007-07-12 00:00:00.000 | 2007-07-13 00:00:00.000 |          1 |         9.99 |               0 |        5.09 |        9.99 |
|        306 |         2505 |              1 |             1 |         19041 |       20070701 |     20070714 |          20070708 | 2007-07-01 00:00:00.000 | 2007-07-14 00:00:00.000 | 2007-07-08 00:00:00.000 |          1 |         9.99 |               0 |        5.09 |        9.99 |
|        306 |         2505 |              1 |             1 |         19041 |       20070701 |     20070707 |          20070709 | 2007-07-01 00:00:00.000 | 2007-07-07 00:00:00.000 | 2007-07-09 00:00:00.000 |          1 |         9.99 |               0 |        5.09 |        9.99 |


Table: States
| Product type   |   Sales amount |   Bad |   Satisfactory |   Good |
|:---------------|---------------:|------:|---------------:|-------:|
| Computer       |          83322 | 63641 |         150898 | 271339 |
| TV             |         441990 | 86564 |         157876 | 214702 |
| Smartphone     |         139578 | 73312 |         187915 | 275727 |
| Tablet         |         417332 | 30659 |         196944 | 224880 |
| Earphone       |         282323 | 13212 |         110113 | 276710 |
| Smartwatch     |         245687 | 79164 |         137380 | 288827 |
| Speakers       |         432646 | 58114 |         100943 | 284346 |
| Camera         |         250810 | 24140 |         142268 | 244616 |
| Game Console   |         144345 | 80624 |         135906 | 292021 |


Table: Store
|   StoreKey |   GeographyKey |   Store Manager | Store Type   | Store Name                 | Status   | Open Date               | Close Date   |   Zip Code |   Zip Code Extension | Continent     | City       | State      | Country       | Close Reason   |   Employees |   Selling Area | Last Remodel Date       |
|-----------:|---------------:|----------------:|:-------------|:---------------------------|:---------|:------------------------|:-------------|-----------:|---------------------:|:--------------|:-----------|:-----------|:--------------|:---------------|------------:|---------------:|:------------------------|
|          4 |            424 |              37 | Store        | Contoso Bellevue Store     | On       | 2004-03-01 00:00:00.000 |              |      97001 |                97004 | North America | Bellevue   | Washington | United States |                |          19 |            455 | 2009-06-16 00:00:00.000 |
|         88 |            453 |             106 | Store        | Contoso Cedar Park Store   | On       | 2004-10-26 00:00:00.000 |              |      70001 |                77011 | North America | Cedar Park | Texas      | United States |                |          19 |            455 | 2009-06-18 00:00:00.000 |
|         17 |            551 |             135 | Store        | Contoso Spokane Store      | On       | 2004-03-26 00:00:00.000 |              |      97001 |                97017 | North America | Spokane    | Washington | United States |                |          25 |            700 | 2009-06-17 00:00:00.000 |
|          6 |            575 |              39 | Store        | Contoso Yakima Store       | On       | 2005-05-15 00:00:00.000 |              |      97001 |                97006 | North America | Yakima     | Washington | United States |                |          47 |           1125 | 2009-06-16 00:00:00.000 |
|         79 |            579 |              97 | Store        | Contoso Baytown Store      | On       | 2004-01-17 00:00:00.000 |              |      70001 |                77005 | North America | Baytown    | Texas      | United States |                |          26 |            680 | 2009-06-16 00:00:00.000 |
|         16 |            627 |              49 | Store        | Contoso Everett Store      | On       | 2004-01-25 00:00:00.000 |              |      97001 |                97016 | North America | Everett    | Washington | United States |                |          17 |            462 | 2009-06-16 00:00:00.000 |
|          5 |            677 |              38 | Store        | Contoso Redmond Store      | On       | 2004-04-02 00:00:00.000 |              |      97001 |                97005 | North America | Redmond    | Washington | United States |                |          33 |            560 | 2009-06-17 00:00:00.000 |
|         15 |            678 |              48 | Store        | Contoso Renton Store       | On       | 2004-02-24 00:00:00.000 |              |      97001 |                97015 | North America | Renton     | Washington | United States |                |          22 |            500 | 2009-06-17 00:00:00.000 |
|          2 |            693 |              35 | Store        | Contoso Seattle No.2 Store | On       | 2004-02-14 00:00:00.000 |              |      97001 |                97002 | North America | Seattle    | Washington | United States |                |          25 |            700 | 2009-06-17 00:00:00.000 |
|         43 |            786 |              72 | Store        | Contoso Appleton Store     | On       | 2003-09-04 00:00:00.000 |              |      54001 |                54003 | North America | Appleton   | Wisconsin  | United States |                |          33 |            560 | 2009-06-18 00:00:00.000 |

 


tables: name: Currency
data: Currency.csv
name: Customer
data: Customer.csv
name: Date
data: Date.csv
name: Product Category
data: Product Category.csv
name: Product Subcategory
data: Product Subcategory.csv
name: Product
data: Product.csv
name: Promotion
data: Promotion.csv
name: Sales
data: Sales.csv
name: States
data: States.csv
name: Store
data: Store.csv
label: Product
ProductSubcategoryKey
Product Subcategory
ProductSubcategoryKey
Product Subcategory
ProductCategoryKey
Product Category
ProductCategoryKey
Sales
StoreKey
Store
StoreKey
Sales
PromotionKey
Promotion
PromotionKey
Sales
ProductKey
Product
ProductKey
Sales
CurrencyKey
Currency
CurrencyKey
Sales
OrderDateKey
Date
DateKey
Sales
CustomerKey
Customer
CustomerKey
output: {
    "joins": [
        {
            "from_table": "Product",
            "from_column": "ProductSubcategoryKey",
            "to_table": "Product Subcategory",
            "to_column": "ProductSubcategoryKey"
        },
        {
            "from_table": "Product Subcategory",
            "from_column": "ProductCategoryKey",
            "to_table": "Product Category",
            "to_column": "ProductCategoryKey"
        },
        {
            "from_table": "Sales",
            "from_column": "StoreKey",
            "to_table": "Store",
            "to_column": "StoreKey"
        },
        {
            "from_table": "Sales",
            "from_column": "PromotionKey",
            "to_table": "Promotion",
            "to_column": "PromotionKey"
        },
        {
            "from_table": "Sales",
            "from_column": "ProductKey",
            "to_table": "Product",
            "to_column": "ProductKey"
        },
        {
            "from_table": "Sales",
            "from_column": "CurrencyKey",
            "to_table": "Currency",
            "to_column": "CurrencyKey"
        },
        {
            "from_table": "Sales",
            "from_column": "OrderDateKey",
            "to_table": "Date",
            "to_column": "DateKey"
        },
        {
            "from_table": "Sales",
            "from_column": "CustomerKey",
            "to_table": "Customer",
            "to_column": "CustomerKey"
        }
    ]
}