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: computed_insight_success_of_active_sellers
| merchantid               |   listedproducts |   totalunitssold |   meanunitssoldperproduct |   rating |   merchantratingscount |   meanproductprices |   meanretailprices |   averagediscount |   meandiscount |   meanproductratingscount | totalurgencycount   | urgencytextrate   |
|:-------------------------|-----------------:|-----------------:|--------------------------:|---------:|-----------------------:|--------------------:|-------------------:|------------------:|---------------:|--------------------------:|:--------------------|:------------------|
| 5e8d923d20c9b7545017f1f9 |                1 |              100 |                       100 |    2.941 |                     17 |               11    |                 50 |                78 |             78 |                         9 |                     |                   |
| 5e6cb9806bab2075b2b64d15 |                1 |              100 |                       100 |    3     |                      3 |               12    |                 11 |                -9 |             -9 |                         1 |                     |                   |
| 5e8c98966642021100f8db13 |                1 |              100 |                       100 |    3.034 |                     29 |               12    |                 75 |                84 |             84 |                        28 |                     |                   |
| 5e537a4038654d5bb8db71b4 |                1 |              100 |                       100 |    3.039 |                    231 |                5    |                  5 |                 0 |              0 |                         6 |                     |                   |
| 5e61cd4b97cc101bd3066216 |                1 |              100 |                       100 |    3.25  |                     64 |               20    |                 17 |               -17 |            -17 |                        60 |                     |                   |
| 5e64b92e00ff3743cf8f3c3d |                1 |              100 |                       100 |    3.299 |                     67 |               20    |                 17 |               -17 |            -17 |                        15 |                     |                   |
| 5e9c44cdf5b57cfb27118f62 |                1 |              100 |                       100 |    3.338 |                    269 |                3.66 |                 26 |                86 |             86 |                        10 |                     |                   |
| 5dc818ca030a154e48a3a8af |                1 |              100 |                       100 |    3.367 |                    572 |               16    |                 14 |               -14 |            -14 |                        27 |                     |                   |
| 5e675a4b48763f1940d6ab3b |                1 |              100 |                       100 |    3.418 |                     79 |               16    |                 22 |                28 |             28 |                        72 |                     |                   |
| 5dea1af2efc6ec06d5c16dd3 |                1 |              100 |                       100 |    3.423 |                     71 |                2    |                  4 |                50 |             50 |                        30 |                     |                   |


Table: Date
| Date                    |   Year |   Year Quarter Number | Year Quarter   | Quarter   | Year Month   |   Year Month Number | Month   |   Month Number |   Day of Week Number | Day of Week   | Fiscal Year   |   Fiscal Year Number | Fiscal Year Quarter   |   Fiscal Year Quarter Number | Fiscal Quarter   | IsWorking   |   Working Day Value | Holiday Name   | DateWithTransactions   | End of Month            |
|:------------------------|-------:|----------------------:|:---------------|:----------|:-------------|--------------------:|:--------|---------------:|---------------------:|:--------------|:--------------|---------------------:|:----------------------|-----------------------------:|:-----------------|:------------|--------------------:|:---------------|:-----------------------|:------------------------|
| 2020-07-01 00:00:00.000 |   2020 |                  8082 | Q3-2020        | Q3        | Jul 2020     |               24246 | Jul     |              7 |                    4 | Wed           | FY 2020       |                 2020 | FQ3-2020              |                         8082 | FQ3              | True        |                   1 |                | True                   | 2020-07-31 00:00:00.000 |
| 2020-07-02 00:00:00.000 |   2020 |                  8082 | Q3-2020        | Q3        | Jul 2020     |               24246 | Jul     |              7 |                    5 | Thu           | FY 2020       |                 2020 | FQ3-2020              |                         8082 | FQ3              | True        |                   1 |                | True                   | 2020-07-31 00:00:00.000 |
| 2020-07-03 00:00:00.000 |   2020 |                  8082 | Q3-2020        | Q3        | Jul 2020     |               24246 | Jul     |              7 |                    6 | Fri           | FY 2020       |                 2020 | FQ3-2020              |                         8082 | FQ3              | True        |                   1 |                | True                   | 2020-07-31 00:00:00.000 |
| 2020-07-06 00:00:00.000 |   2020 |                  8082 | Q3-2020        | Q3        | Jul 2020     |               24246 | Jul     |              7 |                    2 | Mon           | FY 2020       |                 2020 | FQ3-2020              |                         8082 | FQ3              | True        |                   1 |                | True                   | 2020-07-31 00:00:00.000 |
| 2020-07-07 00:00:00.000 |   2020 |                  8082 | Q3-2020        | Q3        | Jul 2020     |               24246 | Jul     |              7 |                    3 | Tue           | FY 2020       |                 2020 | FQ3-2020              |                         8082 | FQ3              | True        |                   1 |                | True                   | 2020-07-31 00:00:00.000 |
| 2020-07-08 00:00:00.000 |   2020 |                  8082 | Q3-2020        | Q3        | Jul 2020     |               24246 | Jul     |              7 |                    4 | Wed           | FY 2020       |                 2020 | FQ3-2020              |                         8082 | FQ3              | True        |                   1 |                | True                   | 2020-07-31 00:00:00.000 |
| 2020-07-09 00:00:00.000 |   2020 |                  8082 | Q3-2020        | Q3        | Jul 2020     |               24246 | Jul     |              7 |                    5 | Thu           | FY 2020       |                 2020 | FQ3-2020              |                         8082 | FQ3              | True        |                   1 |                | True                   | 2020-07-31 00:00:00.000 |
| 2020-07-10 00:00:00.000 |   2020 |                  8082 | Q3-2020        | Q3        | Jul 2020     |               24246 | Jul     |              7 |                    6 | Fri           | FY 2020       |                 2020 | FQ3-2020              |                         8082 | FQ3              | True        |                   1 |                | True                   | 2020-07-31 00:00:00.000 |
| 2020-07-13 00:00:00.000 |   2020 |                  8082 | Q3-2020        | Q3        | Jul 2020     |               24246 | Jul     |              7 |                    2 | Mon           | FY 2020       |                 2020 | FQ3-2020              |                         8082 | FQ3              | True        |                   1 |                | True                   | 2020-07-31 00:00:00.000 |
| 2020-07-14 00:00:00.000 |   2020 |                  8082 | Q3-2020        | Q3        | Jul 2020     |               24246 | Jul     |              7 |                    3 | Tue           | FY 2020       |                 2020 | FQ3-2020              |                         8082 | FQ3              | True        |                   1 |                | True                   | 2020-07-31 00:00:00.000 |


Table: DateAutoTemplate
| Date                    |   Year |   Year Quarter Number | Year Quarter   | Quarter   | Year Month   |   Year Month Number | Month   |   Month Number |   Day of Week Number | Day of Week   | Fiscal Year   |   Fiscal Year Number | Fiscal Year Quarter   |   Fiscal Year Quarter Number | Fiscal Quarter   | IsWorking   |   Working Day Value | Holiday Name   | DateWithTransactions   |
|:------------------------|-------:|----------------------:|:---------------|:----------|:-------------|--------------------:|:--------|---------------:|---------------------:|:--------------|:--------------|---------------------:|:----------------------|-----------------------------:|:-----------------|:------------|--------------------:|:---------------|:-----------------------|
| 2020-07-01 00:00:00.000 |   2020 |                  8082 | Q3-2020        | Q3        | Jul 2020     |               24246 | Jul     |              7 |                    4 | Wed           | FY 2020       |                 2020 | FQ3-2020              |                         8082 | FQ3              | True        |                   1 |                | True                   |
| 2020-07-02 00:00:00.000 |   2020 |                  8082 | Q3-2020        | Q3        | Jul 2020     |               24246 | Jul     |              7 |                    5 | Thu           | FY 2020       |                 2020 | FQ3-2020              |                         8082 | FQ3              | True        |                   1 |                | True                   |
| 2020-07-03 00:00:00.000 |   2020 |                  8082 | Q3-2020        | Q3        | Jul 2020     |               24246 | Jul     |              7 |                    6 | Fri           | FY 2020       |                 2020 | FQ3-2020              |                         8082 | FQ3              | True        |                   1 |                | True                   |
| 2020-07-06 00:00:00.000 |   2020 |                  8082 | Q3-2020        | Q3        | Jul 2020     |               24246 | Jul     |              7 |                    2 | Mon           | FY 2020       |                 2020 | FQ3-2020              |                         8082 | FQ3              | True        |                   1 |                | True                   |
| 2020-07-07 00:00:00.000 |   2020 |                  8082 | Q3-2020        | Q3        | Jul 2020     |               24246 | Jul     |              7 |                    3 | Tue           | FY 2020       |                 2020 | FQ3-2020              |                         8082 | FQ3              | True        |                   1 |                | True                   |
| 2020-07-08 00:00:00.000 |   2020 |                  8082 | Q3-2020        | Q3        | Jul 2020     |               24246 | Jul     |              7 |                    4 | Wed           | FY 2020       |                 2020 | FQ3-2020              |                         8082 | FQ3              | True        |                   1 |                | True                   |
| 2020-07-09 00:00:00.000 |   2020 |                  8082 | Q3-2020        | Q3        | Jul 2020     |               24246 | Jul     |              7 |                    5 | Thu           | FY 2020       |                 2020 | FQ3-2020              |                         8082 | FQ3              | True        |                   1 |                | True                   |
| 2020-07-10 00:00:00.000 |   2020 |                  8082 | Q3-2020        | Q3        | Jul 2020     |               24246 | Jul     |              7 |                    6 | Fri           | FY 2020       |                 2020 | FQ3-2020              |                         8082 | FQ3              | True        |                   1 |                | True                   |
| 2020-07-13 00:00:00.000 |   2020 |                  8082 | Q3-2020        | Q3        | Jul 2020     |               24246 | Jul     |              7 |                    2 | Mon           | FY 2020       |                 2020 | FQ3-2020              |                         8082 | FQ3              | True        |                   1 |                | True                   |
| 2020-07-14 00:00:00.000 |   2020 |                  8082 | Q3-2020        | Q3        | Jul 2020     |               24246 | Jul     |              7 |                    3 | Tue           | FY 2020       |                 2020 | FQ3-2020              |                         8082 | FQ3              | True        |                   1 |                | True                   |


Table: Holidays
| Holiday Date            | Holiday Name     |
|:------------------------|:-----------------|
| 2018-01-01 00:00:00.000 | New Year's Day   |
| 2019-01-01 00:00:00.000 | New Year's Day   |
| 2020-01-01 00:00:00.000 | New Year's Day   |
| 2021-01-01 00:00:00.000 | New Year's Day   |
| 2022-01-01 00:00:00.000 | New Year's Day   |
| 2018-07-04 00:00:00.000 | Independence Day |
| 2019-07-04 00:00:00.000 | Independence Day |
| 2020-07-04 00:00:00.000 | Independence Day |
| 2021-07-04 00:00:00.000 | Independence Day |
| 2022-07-04 00:00:00.000 | Independence Day |


Table: HolidaysDefinition
| ISO Country   |   MonthNumber |   DayNumber |   WeekDayNumber |   OffsetWeek |   OffsetDays | HolidayName      |   SubstituteHoliday |   ConflictPriority |   FirstYear |   LastYear |
|:--------------|--------------:|------------:|----------------:|-------------:|-------------:|:-----------------|--------------------:|-------------------:|------------:|-----------:|
| US            |             1 |           1 |               0 |            0 |            0 | New Year's Day   |                   0 |                100 |           0 |          0 |
| US            |             7 |           4 |               0 |            0 |            0 | Independence Day |                   0 |                100 |           0 |          0 |
| US            |            11 |          11 |               0 |            0 |            0 | Veterans Day     |                   0 |                100 |           0 |          0 |
| US            |            12 |          25 |               0 |            0 |            0 | Christmas Day    |                   0 |                100 |           0 |          0 |
| AT            |             1 |           1 |               0 |            0 |            0 | New Year's Day   |                   0 |                100 |           0 |          0 |
| AT            |             1 |           6 |               0 |            0 |            0 | Epiphany         |                   0 |                100 |           0 |          0 |
| AT            |            99 |           1 |               0 |            0 |            0 | Easter Monday    |                   0 |                 50 |           0 |          0 |
| AT            |             5 |           1 |               0 |            0 |            0 | Labour Day       |                   0 |                100 |           0 |          0 |
| AT            |            99 |          39 |               0 |            0 |            0 | Ascension Day    |                   0 |                 50 |           0 |          0 |
| AT            |            99 |          50 |               0 |            0 |            0 | Whit Monday      |                   0 |                 50 |           0 |          0 |


Table: Merchannt
| merchant_id              |   merchant_rating |   merchant_rating_count | Merchant Name   | merchant_title   | merchant_profile_picture   |   merchant_has_profile_picture |
|:-------------------------|------------------:|------------------------:|:----------------|:-----------------|:---------------------------|-------------------------------:|
| 595097d6a26f6e070cb878d1 |           4.12852 |                     568 | zgrdejia        | zgrdejia         |                            |                              0 |
| 56458aa03a698c35c9050988 |           3.89967 |                   17752 | sarahouse       | SaraHouse        |                            |                              0 |
| 5952a218e81e8a4c30b5bbbc |           3.95681 |                    9470 | mayuhiao        | mayuhiao         |                            |                              0 |
| 5de0981739adf2a3406bed18 |           3.72917 |                     288 | liuyaling66058  | liuyaling66058   |                            |                              0 |
| 5528e31e43a8db0c29241cd1 |           4.08118 |                    8500 | socrazyear      | so crazy ear     |                            |                              0 |
| 5bd29797d32ed5241007af46 |           3.88146 |                    3771 | hzruanyf        | hzruanyf         |                            |                              0 |
| 590d6c356815062709f1b06c |           4.20404 |                     941 | junzhangxiezi   | junzhangxiezi    |                            |                              0 |
| 5c74e493a0e25750b550e2a1 |           4.08968 |                   14095 | bebebebeworld   | bebebebe world   |                            |                              0 |
| 59b0dcac50df61071d239b12 |           3.97338 |                    1653 | yongxiastore    | yongxiastore     |                            |                              0 |
| 589ae185ad330a4feb2b6dd5 |           4.29875 |                   68339 | sweatmoly       | Sweat moly       |                            |                              0 |


Table: Parameter
| Parameter                | Parameter Fields                         |   Parameter Order |
|:-------------------------|:-----------------------------------------|------------------:|
| Sales Amount             | 'Calculations'[Total Revenue]            |                 0 |
| Gross Profit             | 'Calculations'[Gross Profit]             |                 1 |
| MOM Sales Amount         | 'Calculations'[MOM Sales Amount]         |                 2 |
| MOM % Sales Amount       | 'Calculations'[MOM % Sales Amount]       |                 3 |
| MOM Total Gross Profit   | 'Calculations'[MOM Total Gross Profit]   |                 4 |
| MOM % Total Gross Profit | 'Calculations'[MOM % Total Gross Profit] |                 5 |


Table: Price
|   Price |
|--------:|
|       0 |
|       1 |
|       2 |
|       3 |
|       4 |
|       5 |
|       6 |
|       7 |
|       8 |
|       9 |


Table: Product
| product_id               | product_picture                                                              | product_url                                     | product_color   | Product Size   | Origin Country   |
|:-------------------------|:-----------------------------------------------------------------------------|:------------------------------------------------|:----------------|:---------------|:-----------------|
| 574ff29cb4b28660d9f94d3f | https://contestimg.wish.com/api/webimage/574ff29cb4b28660d9f94d3f-medium.jpg | https://www.wish.com/c/574ff29cb4b28660d9f94d3f | black           | S              | CN               |
| 5a4b9eba2b0a1c3062666033 | https://contestimg.wish.com/api/webimage/5a4b9eba2b0a1c3062666033-medium.jpg | https://www.wish.com/c/5a4b9eba2b0a1c3062666033 | black           | S              | CN               |
| 5ad6b4271e520e4c8fffe172 | https://contestimg.wish.com/api/webimage/5ad6b4271e520e4c8fffe172-medium.jpg | https://www.wish.com/c/5ad6b4271e520e4c8fffe172 | black           | S              | CN               |
| 5cde56ea6bbbd86b1cbab4a8 | https://contestimg.wish.com/api/webimage/5cde56ea6bbbd86b1cbab4a8-medium.jpg | https://www.wish.com/c/5cde56ea6bbbd86b1cbab4a8 | black           | S              | CN               |
| 5cc2d24035b846634f67558a | https://contestimg.wish.com/api/webimage/5cc2d24035b846634f67558a-medium.jpg | https://www.wish.com/c/5cc2d24035b846634f67558a | black           | S              | CN               |
| 5b1f9afe694fab75ca9fa8ea | https://contestimg.wish.com/api/webimage/5b1f9afe694fab75ca9fa8ea-medium.jpg | https://www.wish.com/c/5b1f9afe694fab75ca9fa8ea | black           | S              | CN               |
| 5eaba913c039171aeb0732f8 | https://contestimg.wish.com/api/webimage/5eaba913c039171aeb0732f8-medium.jpg | https://www.wish.com/c/5eaba913c039171aeb0732f8 | black           | S              | CN               |
| 5b62adee423ee1752a512ca9 | https://contestimg.wish.com/api/webimage/5b62adee423ee1752a512ca9-medium.jpg | https://www.wish.com/c/5b62adee423ee1752a512ca9 | black           | S              | CN               |
| 5e0481bf1705212493a2f8e5 | https://contestimg.wish.com/api/webimage/5e0481bf1705212493a2f8e5-medium.jpg | https://www.wish.com/c/5e0481bf1705212493a2f8e5 | black           | S              | CN               |
| 5b9f1a4bd143a816d746677a | https://contestimg.wish.com/api/webimage/5b9f1a4bd143a816d746677a-medium.jpg | https://www.wish.com/c/5b9f1a4bd143a816d746677a | black           | S              | CN               |


Table: Rating
| Parameter   | Parameter Fields            |   Parameter Order |
|:------------|:----------------------------|------------------:|
| ★★★★★       | 'Transactions(fact)'[★★★★★] |                 0 |
| ★★★★☆       | 'Transactions(fact)'[★★★★☆] |                 1 |
| ★★★☆☆       | 'Transactions(fact)'[★★★☆☆] |                 2 |
| ★★☆☆☆       | 'Transactions(fact)'[★★☆☆☆] |                 3 |
| ★☆☆☆☆       | 'Transactions(fact)'[★☆☆☆☆] |                 4 |


Table: Reviews
|   Reviews |
|----------:|
|         1 |
|         2 |
|         3 |
|         4 |
|         5 |


Table: shipping option
| Shipping Option      |
|:---------------------|
| Livraison standard   |
| Standard Shipping    |
| Ekspresowa wysyłka   |
| Envio Padrão         |
| الشحن القياسي        |
| Expediere Standard   |
| Envío normal         |
| Стандартная доставка |
| Standardversand      |
| การส่งสินค้ามาตรฐาน     |


Table: Transactions(fact)
| title                                                                                                                                                                                                                                                                         | title_orig                                                                                                                                                                                                                                                                       |   price |   Retail Price |   Units Sold |   uses_ad_boosts |   rating |   rating_count |   ★★★★★ |   ★★★★☆ |   ★★★☆☆ |   ★★☆☆☆ |   ★☆☆☆☆ |   badges_count |   badge_local_product |   badge_product_quality |   badge_fast_shipping | tags                                                                                                                                                                                                                                                                                                                                        |   product_variation_inventory | shipping_option_name   |   shipping_option_price |   shipping_is_express |   countries_shipped_to |   inventory total | has_urgency_banner   | merchant_id              | product_id               |   Index | Date                    |   Cost per Unit | Short Title                         |
|:------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|--------:|---------------:|-------------:|-----------------:|---------:|---------------:|--------:|--------:|--------:|--------:|--------:|---------------:|----------------------:|------------------------:|----------------------:|:--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------------------:|:-----------------------|------------------------:|----------------------:|-----------------------:|------------------:|:---------------------|:-------------------------|:-------------------------|--------:|:------------------------|----------------:|:------------------------------------|
| Summer Women Fashion Sleeveless Shirt Bohemian Casual Printed Loose Sling  V Neck Blouse  Tank Top Vest                                                                                                                                                                       | Summer Women Fashion Sleeveless Shirt Bohemian Casual Printed Loose Sling  V Neck Blouse  Tank Top Vest                                                                                                                                                                          |       8 |              7 |         1000 |                0 |     3.6  |            141 |      64 |      22 |      19 |       7 |      29 |              0 |                     0 |                       0 |                     0 | blouse,Summer,Vest,Plus Size,Tank,Necks,Shirt,Tops,Women's Fashion,tank top,boho,Fashion,printed,sleeveless,bohemian,Casual,Women                                                                                                                                                                                                           |                            50 | Livraison standard     |                       3 |                     0 |                     24 |                50 | 1                    | 5bd29797d32ed5241007af46 | 5e9810834500da4e8d0c2376 |       6 | 2021-08-20 00:00:00.000 |            4.9  | Summer Women Fashion Sleeveless Shi |
| Maillot de bain sexy sud-africain imprimé doré licou bikini taille haute deux pièces maillots de bain femmes maillot de bain bikini ensemble                                                                                                                                  | Sexy Swimsuit South African Golden Print Halter Bikini High Waist Two Pieces Swimwear Women Bathing Suit Bikini Set                                                                                                                                                              |       8 |              7 |         5000 |                0 |     4.14 |           2737 |    1582 |     524 |     278 |     137 |     216 |              0 |                     0 |                       0 |                     0 | bathing suit,Bikinis Set,Womens Swimsuit,Waist,Halter,golden,southafrican,Sexy Swimwear,Swimwear,Swimsuit,high waist,Bikini,Fashion,Two Pieces,Suits,Print,sexy,Women,Women's Fashion,High Waisted Bikini,Swimming                                                                                                                          |                            50 | Livraison standard     |                       3 |                     0 |                     36 |                50 | 1                    | 589ae185ad330a4feb2b6dd5 | 599e9345064610593dba223e |      12 | 2020-10-11 00:00:00.000 |            6.44 | Maillot de bain sexy sud-africain i |
| Legging Capri femme en jean 3/4 Legging d'été Jegging Pantalon skinny imprimé papillon                                                                                                                                                                                        | Women's Capri Leggings In Jeans 3/4 Summer Leggings Jeggings Skinny Butterfly Printed Jegging Pants                                                                                                                                                                              |       8 |              7 |        10000 |                0 |     3.71 |           2747 |    1253 |     470 |     390 |     233 |     401 |              0 |                     0 |                       0 |                     0 | butterfly,caprisforwomen,skinngjean,Plus Size,Casual pants,Summer,pants,yoga pants,Leggings,jeggingsjeansforwomen,summerpant,jeggingsforwomen,printed,leggingsamptight,Jeans,Women Fashion                                                                                                                                                  |                            50 | Livraison standard     |                       3 |                     0 |                     43 |                50 |                      | 57b03628c676b3573ba2a081 | 5cef6f0d2b18ce107dff9f21 |     266 | 2020-11-09 00:00:00.000 |            7.35 | Legging Capri femme en jean 3/4 Leg |
| 2019 nouveau mode d'été sans manches en dentelle patchwork débardeur ourlet irrégulier Cami débardeur                                                                                                                                                                         | 2019 New Summer Fashion Sleeveless Lace Patchwork Tank Top Irregular Hem Cami Tank Top                                                                                                                                                                                           |       8 |              7 |        20000 |                0 |     3.63 |           2058 |     902 |     319 |     324 |     191 |     322 |              0 |                     0 |                       0 |                     0 | Summer,Plus Size,tunic,Lace,Tank,Tops,Loose,camisoles for women,tank top,Fashion,sleeveless,sexy,Casual,Women Fashion                                                                                                                                                                                                                       |                            50 | Livraison standard     |                       3 |                     0 |                     43 |                50 | 1                    | 57b03628c676b3573ba2a081 | 5cb6c6e841ec3b10cad8e77f |     267 | 2021-02-18 00:00:00.000 |            4.55 | 2019 nouveau mode d'été sans manche |
| Women Fashion Jumpsuit Short Romper V Neck Summer Playsuit Spaghetti Strap Halter Cute Beach Shorts Casual Solid Cami Rompers for Women                                                                                                                                       | Women Fashion Jumpsuit Short Romper V Neck Summer Playsuit Spaghetti Strap Halter Cute Beach Shorts Casual Solid Cami Rompers for Women                                                                                                                                          |       8 |              7 |          100 |                1 |     3.37 |             19 |       9 |       2 |       1 |       1 |       6 |              0 |                     0 |                       0 |                     0 | Summer,Plus Size,camishort,Halter,cute,Spaghetti,Necks,Spaghetti Strap,beach wear,playsuit,Casual,Women's Fashion,Shorts,playsuitoutfitsclothing,Fashion,Summer Fashion,Women,Beach,Rompers,Women Fashion,jumpsuit                                                                                                                          |                            50 | Livraison standard     |                       3 |                     0 |                     41 |                50 | 1                    | 561df3a23a698c711e5e5efa | 5e82bd24239e991c07f02bf7 |     377 | 2020-03-02 00:00:00.000 |            7.49 | Women Fashion Jumpsuit Short Romper |
| Mode féminine été bretelles spaghetti imprimé floral nouer devant mini robe robe sexy                                                                                                                                                                                         | Women's Summer Fashion Spaghetti Strap Floral Print Tie Front Mini Dress Sexy Dress                                                                                                                                                                                              |       8 |              7 |         5000 |                1 |     3.71 |            346 |     148 |      68 |      53 |      34 |      43 |              0 |                     0 |                       0 |                     0 | suspenders,Summer,Plus Size,Floral print,Sexy Dress,Mini,Dress,slim,Mini dress,Floral,Women's Fashion,Fashion,sexy,Print,sleeveless,Spaghetti,Casual                                                                                                                                                                                        |                            50 | Livraison standard     |                       3 |                     0 |                     50 |                50 |                      | 571b38e66c39b141b1ad43e1 | 5e9ea82f6171be39047899cd |     401 | 2021-05-25 00:00:00.000 |            7.98 | Mode féminine été bretelles spaghet |
| NOUVEAU Red Bull Summer Mens Casual Shorts Pants Loose Cotton Movement Dry Rapidly Fitness Shorts                                                                                                                                                                             | NEW Red Bull Summer Mens Casual Shorts Pants Loose Cotton Movement Dry Quickly Fitness Shorts                                                                                                                                                                                    |       8 |              7 |           50 |                1 |     3.43 |              7 |       3 |       0 |       2 |       1 |       1 |              0 |                     0 |                       0 |                     0 | Summer,Shorts,pants,Fitness,Short pants,runningpant,Men's Fashion,Casual,Red,Cotton                                                                                                                                                                                                                                                         |                            50 | Livraison standard     |                       3 |                     0 |                     15 |                50 |                      | 5d9163dcbffbb14190a52df7 | 5dc23f82bcc20f001e5a73e0 |     409 | 2020-03-27 00:00:00.000 |            8.12 | NOUVEAU Red Bull Summer Mens Casual |
| Été Nouveau 2020 Mode Femmes Mince Longue Robe Plus La Taille Dégradé Imprimé Sans Manches Doux et Confortable Robe Plage Spaghetti Strap Robe Élégante Robe                                                                                                                  | Summer New 2020 Fashion Women's Slim Long Dress Plus Size Gradient Printed Sleeveless Soft and Comfortable Dress Beach Spaghetti Strap Dress Elegant Dress                                                                                                                       |       8 |              7 |         1000 |                0 |     3.4  |             94 |      34 |      14 |      18 |      12 |      16 |              0 |                     0 |                       0 |                     0 | slim long,slim dress,Fashion,Summer,Dresses,Beach,Dress,summer dress,long dress,Women's Fashion,slim,Spaghetti Strap,Elegant,beach dress,Plus Size,printed,Sleeveless dress,sleeveless,maxi dress,Spaghetti,Women                                                                                                                           |                            50 | Livraison standard     |                       3 |                     0 |                     37 |                50 | 1                    | 58b011e82e27bf506cee1ace | 5eb763e728a61a40806afbff |     411 | 2019-05-18 00:00:00.000 |            4.97 | Été Nouveau 2020 Mode Femmes Mince  |
| Chemise en mousseline de soie pour femmes sans manches lâche T-shirts grande taille S-5XL                                                                                                                                                                                     | Women's Fashion Chiffon Shirt Sleeveless Loose Tops T Shirt Plus Size S-5XL                                                                                                                                                                                                      |       8 |              7 |        10000 |                1 |     3.7  |           2441 |    1070 |     460 |     373 |     181 |     357 |              0 |                     0 |                       0 |                     0 | Summer,Vest,Plus Size,Shirt,chiffon,Tops,Women's Fashion,Fashion,off shoulder,sleeveless,Casual                                                                                                                                                                                                                                             |                            50 | Livraison standard     |                       3 |                     0 |                     41 |                50 | 1                    | 566012f6769a5629aefca555 | 5bcd4a045d689f171be1655b |     419 | 2020-09-25 00:00:00.000 |            5.6  | Chemise en mousseline de soie pour  |
| S-8XL 2018 New Women Summer Casual Shirt Beach Wear Sexy V-neck Off Shoulder Long Vest Tunic Dress with Pockets Sleeveless A-line Loose Beach Wear Ruffles T-Shirt Dress Cotton Mini Dress Ladies Fashion Solid Color Button Down Knee Length Plissé Plus Size Tank Top Dress | S-8XL 2018 New Women Summer Casual Shirt Beach Wear Sexy V-neck Off Shoulder Long Vest Tunic Dress with Pockets Sleeveless A-line Loose Beach Wear Ruffles T-Shirt Dresses Cotton Mini Dress Ladies Fashion Solid Color Button Down Knee Length Pleated Plus Size Tank Top Dress |       8 |              7 |        20000 |                0 |     3.92 |           3080 |    1542 |     573 |     448 |     212 |     305 |              0 |                     0 |                       0 |                     0 | Summer,Vest,Fashion,Mini,Pleated,tank top,beach dress,Party Dress,Sexy Dress,Casual,Cotton,Shirt,Tops,summer dress,Sleeveless dress,Ladies,sleeveless,Women,Beach,Tunic dress,Plus Size,ruffle,Dress,V-neck,Mini dress,Women's Fashion,pocketdres,sexy,casual dress,tunic,Tank,button,T Shirts,Cotton Dress,knee,Ladies Fashion,loose dress |                            50 | Livraison standard     |                       3 |                     0 |                     20 |                50 |                      | 5800a8bb50d8ab5aaee15f20 | 5b42cb780cb47619a7f6bbc2 |     483 | 2020-04-11 00:00:00.000 |            5.46 | S-8XL 2018 New Women Summer Casual  |


Table: unique_categories
| tag                |
|:-------------------|
| 2 piece dress sets |
| 2 Piece Swimsuit   |
| 2014menshort       |
| 2014summermenshort |
| 2018fashion        |
| 2in1short          |
| 2in1sportsjogging  |
| 2piecebathingsuit  |
| 2piecesbikini      |
| 2pieceset          |


Table: unique_categories_sorted_by_count
|   count | tag            |
|--------:|:---------------|
|       1 | flamingotshirt |
|       1 | fivepant       |
|       1 | fitnessvestmen |
|       1 | fitnessshort   |
|       1 | fitnessset     |
|       1 | fitnesspantie  |
|       1 | fitnesspant    |
|       1 | fishermanshat  |
|       1 | finger ring    |
|       1 | femaletshirt   |

 


tables: name: computed_insight_success_of_active_sellers
data: computed_insight_success_of_active_sellers.csv
name: Date
data: Date.csv
name: DateAutoTemplate
data: DateAutoTemplate.csv
name: Holidays
data: Holidays.csv
name: HolidaysDefinition
data: HolidaysDefinition.csv
name: Merchannt
data: Merchannt.csv
name: Parameter
data: Parameter.csv
name: Price
data: Price.csv
name: Product
data: Product.csv
name: Rating
data: Rating.csv
name: Reviews
data: Reviews.csv
name: shipping option
data: shipping option.csv
name: Transactions(fact)
data: Transactions(fact).csv
name: unique_categories
data: unique_categories.csv
name: unique_categories_sorted_by_count
data: unique_categories_sorted_by_count.csv
label: Transactions(fact)
merchant_id
computed_insight_success_of_active_sellers
merchantid
unique_categories_sorted_by_count
tag
unique_categories
tag
Transactions(fact)
product_id
Product
product_id
Transactions(fact)
merchant_id
Merchannt
merchant_id
Transactions(fact)
shipping_option_name
shipping option
Shipping Option
output: {
    "joins": [
        {
            "from_table": "Transactions(fact)",
            "from_column": "merchant_id",
            "to_table": "computed_insight_success_of_active_sellers",
            "to_column": "merchantid"
        },
        {
            "from_table": "unique_categories_sorted_by_count",
            "from_column": "tag",
            "to_table": "unique_categories",
            "to_column": "tag"
        },
        {
            "from_table": "Transactions(fact)",
            "from_column": "product_id",
            "to_table": "Product",
            "to_column": "product_id"
        },
        {
            "from_table": "Transactions(fact)",
            "from_column": "merchant_id",
            "to_table": "Merchannt",
            "to_column": "merchant_id"
        },
        {
            "from_table": "Transactions(fact)",
            "from_column": "shipping_option_name",
            "to_table": "shipping option",
            "to_column": "Shipping Option"
        }
    ]
}