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: DIMCalendar
| Date                    |   Year |   Quarter Number | Quarter   |   Month | Month Name   |   Week Num |   Weekday | DoW   | IsWorkDay?   |   FiscalYear |   FiscalQuarter |   FiscalMonthNumber |   FiscalMonthOfQuarter |   FiscalWeekOfYear (4 5 4) | FiscalMonthName   | FiscalMonthYear         |   FiscalQuarterYear |   DayOfMonthNumber |   Early/End Month (sort) | Early/End Month (use)   | StartDate               | EndDate                 | Hung King's Day   | Quarantine   | Liberation Day   | Labor Day   | Holiday   | Week   |
|:------------------------|-------:|-----------------:|:----------|--------:|:-------------|-----------:|----------:|:------|:-------------|-------------:|----------------:|--------------------:|-----------------------:|---------------------------:|:------------------|:------------------------|--------------------:|-------------------:|-------------------------:|:------------------------|:------------------------|:------------------------|:------------------|:-------------|:-----------------|:------------|:----------|:-------|
| 2020-03-01 00:00:00.000 |   2020 |                1 | Q1        |       3 | Mar          |         10 |         1 | Sun   | WeekEnd      |         2020 |               1 |                   1 |                      1 |                         10 | Mar               | 2020-03-01 00:00:00.000 |               12020 |                  1 |                        1 | M1                      | 2020-03-01 00:00:00.000 | 2020-05-30 00:00:00.000 |                   |              |                  |             | WeekEnd   | W10    |
| 2020-03-02 00:00:00.000 |   2020 |                1 | Q1        |       3 | Mar          |         10 |         2 | Mon   | WorkDay      |         2020 |               1 |                   1 |                      1 |                         10 | Mar               | 2020-03-01 00:00:00.000 |               12020 |                  2 |                        1 | M1                      | 2020-03-01 00:00:00.000 | 2020-05-30 00:00:00.000 |                   |              |                  |             | WorkDay   | W10    |
| 2020-03-03 00:00:00.000 |   2020 |                1 | Q1        |       3 | Mar          |         10 |         3 | Tue   | WorkDay      |         2020 |               1 |                   1 |                      1 |                         10 | Mar               | 2020-03-01 00:00:00.000 |               12020 |                  3 |                        1 | M1                      | 2020-03-01 00:00:00.000 | 2020-05-30 00:00:00.000 |                   |              |                  |             | WorkDay   | W10    |
| 2020-03-04 00:00:00.000 |   2020 |                1 | Q1        |       3 | Mar          |         10 |         4 | Wed   | WorkDay      |         2020 |               1 |                   1 |                      1 |                         10 | Mar               | 2020-03-01 00:00:00.000 |               12020 |                  4 |                        1 | M1                      | 2020-03-01 00:00:00.000 | 2020-05-30 00:00:00.000 |                   |              |                  |             | WorkDay   | W10    |
| 2020-03-05 00:00:00.000 |   2020 |                1 | Q1        |       3 | Mar          |         10 |         5 | Thu   | WorkDay      |         2020 |               1 |                   1 |                      1 |                         10 | Mar               | 2020-03-01 00:00:00.000 |               12020 |                  5 |                        1 | M1                      | 2020-03-01 00:00:00.000 | 2020-05-30 00:00:00.000 |                   |              |                  |             | WorkDay   | W10    |
| 2020-03-06 00:00:00.000 |   2020 |                1 | Q1        |       3 | Mar          |         10 |         6 | Fri   | WorkDay      |         2020 |               1 |                   1 |                      1 |                         10 | Mar               | 2020-03-01 00:00:00.000 |               12020 |                  6 |                        1 | M1                      | 2020-03-01 00:00:00.000 | 2020-05-30 00:00:00.000 |                   |              |                  |             | WorkDay   | W10    |
| 2020-03-07 00:00:00.000 |   2020 |                1 | Q1        |       3 | Mar          |         10 |         7 | Sat   | WeekEnd      |         2020 |               1 |                   1 |                      1 |                         10 | Mar               | 2020-03-01 00:00:00.000 |               12020 |                  7 |                        1 | M1                      | 2020-03-01 00:00:00.000 | 2020-05-30 00:00:00.000 |                   |              |                  |             | WeekEnd   | W10    |
| 2020-03-08 00:00:00.000 |   2020 |                1 | Q1        |       3 | Mar          |         11 |         1 | Sun   | WeekEnd      |         2020 |               1 |                   1 |                      1 |                         11 | Mar               | 2020-03-01 00:00:00.000 |               12020 |                  8 |                        1 | M1                      | 2020-03-01 00:00:00.000 | 2020-05-30 00:00:00.000 |                   |              |                  |             | WeekEnd   | W11    |
| 2020-03-09 00:00:00.000 |   2020 |                1 | Q1        |       3 | Mar          |         11 |         2 | Mon   | WorkDay      |         2020 |               1 |                   1 |                      1 |                         11 | Mar               | 2020-03-01 00:00:00.000 |               12020 |                  9 |                        1 | M1                      | 2020-03-01 00:00:00.000 | 2020-05-30 00:00:00.000 |                   |              |                  |             | WorkDay   | W11    |
| 2020-03-10 00:00:00.000 |   2020 |                1 | Q1        |       3 | Mar          |         11 |         3 | Tue   | WorkDay      |         2020 |               1 |                   1 |                      1 |                         11 | Mar               | 2020-03-01 00:00:00.000 |               12020 |                 10 |                        1 | M1                      | 2020-03-01 00:00:00.000 | 2020-05-30 00:00:00.000 |                   |              |                  |             | WorkDay   | W11    |


Table: DIMMachine
|   VendingMachineID | MachineCode         | SeriesMachineID   | MachineStatus   |   RefID | Location Type   | Model   | Model Detail   |
|-------------------:|:--------------------|:------------------|:----------------|--------:|:----------------|:--------|:---------------|
|                  3 | TTVM720B22C170001   | TTVM720           | Lưu kho         |      61 | Other Location  | D720    | D720Side1      |
|                  5 | TTVM720B22C170003   | TTVM720           | Lưu kho         |      61 | Other Location  | D720    | D720Side1      |
|                  9 | TTVM720B22C170004   | TTVM720           | Lưu kho         |       6 | Other Location  | D720    | D720Side1      |
|                 23 | TTVM720B32S170001   | TTVM720           | Lưu kho         |       6 | Other Location  | D720    | D720Side1      |
|                114 | TTVM720B32S18000A9  | TTVM720           | Chờ khởi động   |     164 | Other Location  | D720    | D720Side1      |
|                115 | TTVM720B32S18000A10 | TTVM720           | Chờ khởi động   |     164 | Other Location  | D720    | D720Side1      |
|                116 | TTVM720B32S18000A11 | TTVM720           | Chờ khởi động   |     164 | Other Location  | D720    | D720Side1      |
|                117 | TTVM720B32S18000A12 | TTVM720           | Chờ khởi động   |     164 | Other Location  | D720    | D720Side1      |
|                118 | TTVM720B32S18000A13 | TTVM720           | Chờ khởi động   |     164 | Other Location  | D720    | D720Side1      |
|                119 | TTVM720B32S18000A14 | TTVM720           | Chờ khởi động   |     167 | Other Location  | D720    | D720Side1      |


Table: DIMPayment
|   PaymentTypeID | PaymentType   |
|----------------:|:--------------|
|               1 | Skillshub     |
|               3 | Cash          |
|               4 | Grab          |
|               6 | Momo          |
|               7 | Zalopay       |


Table: DIMPosition
|   PositionID | PositionDetail   |   Positon (Number) | Position   |
|-------------:|:-----------------|-------------------:|:-----------|
|            1 | A1               |                  1 | A          |
|            2 | A2               |                  2 | A          |
|            3 | A3               |                  3 | A          |
|            4 | A4               |                  4 | A          |
|            5 | A5               |                  5 | A          |
|            6 | A6               |                  6 | A          |
|            7 | A7               |                  7 | A          |
|            8 | A8               |                  8 | A          |
|            9 | A9               |                  9 | A          |
|           10 | A10              |                 10 | A          |


Table: DIMProduct
|   ProductID | Big Category   | Sub Category    | Product Category   | Product                                       |
|------------:|:---------------|:----------------|:-------------------|:----------------------------------------------|
|         114 | Food           | Snack - Candies | Candies            | Kẹo Alpenliebe 2Chew Hương Dâu 24.5G          |
|         391 | Food           | Instant         | Noodles            | Mì Ly Handy Hảo Hảo Tôm Chua Cay 67G          |
|         392 | Food           | Instant         | Noodles            | Mì Ly Modern Lẩu Thái Tôm                     |
|         407 | Food           | Snack - Candies | Candies            | Kẹo Alpenliebe 2Chew Hương Nho 24.5G          |
|         502 | Food           | Snack - Candies | Peanut             | Đậu Phộng Da Cá Nước Cốt Dừa 42G              |
|         546 | Food           | Snack - Candies | Snack              | Snack Rong Biển Taokaenoi Vị Truyền Thống 15G |
|         547 | Food           | Snack - Candies | Snack              | Snack Rong Biển Taokaenoi Vị Cay 15G          |
|         548 | Food           | Snack - Candies | Snack              | Snack Rong Biển Taokaenoi Vị Chua Cay 15G     |
|         583 | Food           | Instant         | Noodles            | Mì Ly Modern Bò Hầm Rau Thơm 65G              |
|         584 | Food           | Instant         | Noodles            | Mì Ly Modern Thịt Xào 65G                     |


Table: DIMProductPrice
|   ProductID |   UnitPrice |   ProductPrictID |
|------------:|------------:|-----------------:|
|          34 |       12000 |                1 |
|          35 |        8000 |                2 |
|          36 |       10000 |                3 |
|          39 |       12000 |                4 |
|          40 |       11000 |                5 |
|          42 |       10000 |                6 |
|          46 |       15000 |                7 |
|         114 |        6000 |                8 |
|         138 |       28000 |                9 |
|         152 |       10000 |               10 |


Table: DIMRefWarehouse
|   RefID | RefName                 | RefAddress                        | RefStreet         | RefWard          |   RefDistrict | RefCity     |     Lat |    Long | Area   |
|--------:|:------------------------|:----------------------------------|:------------------|:-----------------|--------------:|:------------|--------:|--------:|:-------|
|     117 | SkillsHubSFUJI          | KHO FUJI LANDMARK                 | Võ Văn Tần        | 6                |             3 | Hồ Chí Minh | 10.7784 | 106.692 | Center |
|     386 | SkillsHubSASBUILDING    | KHO AS BUILDING Q1                |                   | Nguyễn Thái Bình |             1 | Hồ Chí Minh | 10.7681 | 106.7   | Center |
|     499 | SkillsHubSBENTAUTHUY-Q1 | KHO BẾN TÀU THỦY Q1               | Phan Kế Bính      | Đa Kao           |             1 | Hồ Chí Minh | 10.7898 | 106.7   | Center |
|      59 | SkillsHubSBITEXCO       | KHO BITEXCO                       | Hải Triều         | Bến Nghé         |             1 | Hồ Chí Minh | 10.7721 | 106.705 | Center |
|     510 | SkillsHubSCOMMAS        | KHO COMMAS                        |                   | Phạm Ngũ Lão     |             1 | Hồ Chí Minh | 10.7677 | 106.688 | Center |
|     462 | SkillsHubSERNSTYOUNG    | KHO CTY TNHH Ernst&Young          | Hải Triều         | Bến Nghé         |             1 | Hồ Chí Minh | 10.7721 | 106.705 | Center |
|     312 | SkillsHubSVCG           | KHO CTY VĨNH CÁT GIA VCG          | Trần Hưng Đạo     | Cô Giang         |             1 | Hồ Chí Minh | 10.7662 | 106.694 | Center |
|     425 | SkillsHubSEVENTVMORE    | KHO EVENT TORO-VMORE              |                   | Bến Nghé         |             1 | Hồ Chí Minh | 10.7766 | 106.705 | Center |
|      56 | SkillsHubSMTB-1         | KHO FAMILYMART                    | Mạc Thị Bưởi      | Bến Nghé         |             1 | Hồ Chí Minh | 10.776  | 106.705 | Center |
|     176 | SkillsHubSIPT           | KHO INDOCHINA PARK TOWER (IPT) Q1 | Nguyễn Đình Chiểu | Đa Kao           |             1 | Hồ Chí Minh | 10.7921 | 106.702 | Center |


Table: DIMSupplier
|   SupplierID | SupplierCompany   |
|-------------:|:------------------|
|            2 | Công ty ABC 1     |
|            4 | Công ty ABC 22    |
|           31 | Công ty ABC 10    |
|           32 | Công ty ABC 23    |
|           39 | Công ty ABC 11    |
|           43 | Công ty ABC 20    |
|           45 | Công ty ABC 27    |
|           48 | Công ty ABC 28    |
|           52 | Công ty ABC 2     |
|           53 | Công ty ABC 8     |


Table: DIMTransactionStatus
|   TransactionStatusID | TransactionStatus   |
|----------------------:|:--------------------|
|                     1 | Thành công          |
|                     2 | Hủy                 |
|                     3 | Đã hoàn tiền        |


Table: DIMWarehouse
| WarehouseName     |   WarehouseID | WarehouseAddress                  |
|:------------------|--------------:|:----------------------------------|
| KHO QUẬN 03       |             6 | 56 Nguyễn Đình Chiểu, Quận 3, HCM |
| KHO ASCENT        |            74 |                                   |
| KHO HÀNG CẬN DATE |           507 |                                   |


Table: FACTImportGood
|   InventoryID |   WarehouseID |   SupplierID | ImportInventoryID            | ImportDate              |   OrderAmount | ImportTime              |
|--------------:|--------------:|-------------:|:-----------------------------|:------------------------|--------------:|:------------------------|
|         95065 |             6 |           39 | N.VietBISQ02.034.200528.0001 | 2020-05-28 00:00:00.000 |        9233   | 1899-12-30 09:14:00.000 |
|         95055 |             6 |          110 | N.VietBISQ02.104.200528.0001 | 2020-05-28 00:00:00.000 |       52000   | 1899-12-30 08:54:00.000 |
|         95024 |             6 |           62 | N.VietBISQ02.055.200527.0001 | 2020-05-27 00:00:00.000 |         140   | 1899-12-30 16:26:00.000 |
|         94962 |             6 |          104 | N.VietBISQ02.098.200527.0001 | 2020-05-27 00:00:00.000 |       11500   | 1899-12-30 12:52:00.000 |
|         94955 |             6 |           52 | N.VietBISQ02.046.200527.0004 | 2020-05-27 00:00:00.000 |       23829.7 | 1899-12-30 12:13:00.000 |
|         94951 |             6 |           84 | N.VietBISQ02.078.200527.0001 | 2020-05-27 00:00:00.000 |       47050   | 1899-12-30 11:51:00.000 |
|         94950 |             6 |           52 | N.VietBISQ02.046.200527.0003 | 2020-05-27 00:00:00.000 |       18715.5 | 1899-12-30 11:42:00.000 |
|         94947 |             6 |          116 | N.VietBISQ02.110.200527.0001 | 2020-05-27 00:00:00.000 |       11800   | 1899-12-30 11:23:00.000 |
|         94940 |             6 |            2 | N.VietBISQ02.001.200527.0001 | 2020-05-27 00:00:00.000 |        9438.2 | 1899-12-30 10:55:00.000 |
|         94935 |             6 |           52 | N.VietBISQ02.046.200527.0002 | 2020-05-27 00:00:00.000 |       16432.1 | 1899-12-30 10:33:00.000 |


Table: FACTMovingMachine
|   InventoryID |   WarehouseID |   RefWarehouseID | ExportDate              | VendingMachineID   |   OrderAmount | ExportTime              |
|--------------:|--------------:|-----------------:|:------------------------|:-------------------|--------------:|:------------------------|
|         95025 |             6 |               59 | 2020-05-27 00:00:00.000 | TTVMMYZF32S190013  |         11500 | 1899-12-30 16:31:00.000 |
|         94068 |             6 |               59 | 2020-05-19 00:00:00.000 | TTVMMYZF32S190013  |         11500 | 1899-12-30 13:50:00.000 |
|         95000 |             6 |               56 | 2020-05-27 00:00:00.000 | TTVMMYZF32S180001  |         11500 | 1899-12-30 14:21:00.000 |
|         94141 |             6 |               56 | 2020-05-20 00:00:00.000 | TTVMMYZF32S180001  |         11500 | 1899-12-30 10:27:00.000 |
|         94997 |             6 |               59 | 2020-05-27 00:00:00.000 | TTVMMYZF22S180001  |         11500 | 1899-12-30 14:19:00.000 |
|         94993 |             6 |              100 | 2020-05-27 00:00:00.000 | TTVMMYZF32S180011  |         11500 | 1899-12-30 14:17:00.000 |
|         94066 |             6 |              100 | 2020-05-19 00:00:00.000 | TTVMMYZF32S180011  |         11500 | 1899-12-30 13:50:00.000 |
|         94995 |             6 |              486 | 2020-05-27 00:00:00.000 | TTVMMYZF32S190010  |         11500 | 1899-12-30 14:17:00.000 |
|         94072 |             6 |              486 | 2020-05-19 00:00:00.000 | TTVMMYZF32S190010  |         11500 | 1899-12-30 13:51:00.000 |
|         94991 |             6 |               87 | 2020-05-27 00:00:00.000 | TTVMMYZF32S190015  |         11500 | 1899-12-30 14:15:00.000 |


Table: FACTPurchaseOrder
| OrderDate               | EstReceivingDate        | ReceivingTime   |   SupplierID | ImportInventoryID            |   OrderAmount | OrderTime               | EstReceivingTime        |
|:------------------------|:------------------------|:----------------|-------------:|:-----------------------------|--------------:|:------------------------|:------------------------|
| 2020-03-24 00:00:00.000 | 2020-03-25 00:00:00.000 | 8H30 - 17H      |           43 | N.VietBISQ02.038.200325.0001 |      21783.3  | 1899-12-30 00:00:00.000 | 1899-12-30 10:58:00.000 |
| 2020-03-20 00:00:00.000 | 2020-03-27 00:00:00.000 | 8H30 - 17H      |          110 | N.VietBISQ02.104.200327.0001 |      52000    | 1899-12-30 00:00:00.000 | 1899-12-30 15:41:00.000 |
| 2020-03-24 00:00:00.000 | 2020-03-25 00:00:00.000 | 8H30 - 17H      |          101 | N.VietBISQ02.095.200325.0001 |       8960    | 1899-12-30 00:00:00.000 | 1899-12-30 10:55:00.000 |
| 2020-03-16 00:00:00.000 | 2020-03-20 00:00:00.000 | 8H30 - 17H      |           94 | N.VietBISQ02.087.200326.0001 |       6000    | 1899-12-30 00:00:00.000 | 1899-12-30 11:34:00.000 |
| 2020-03-24 00:00:00.000 | 2020-03-25 00:00:00.000 | 8H30 - 17H      |           53 | N.VietBISQ02.047.200325.0001 |       7600    | 1899-12-30 00:00:00.000 | 1899-12-30 10:55:00.000 |
| 2020-03-24 00:00:00.000 | 2020-03-25 00:00:00.000 | 8H30 - 17H      |           54 | N.VietBISQ02.048.200326.0001 |       8494.3  | 1899-12-30 00:00:00.000 | 1899-12-30 11:06:00.000 |
| 2020-03-24 00:00:00.000 | 2020-03-24 00:00:00.000 | 8H30 - 17H      |           52 | N.VietBISQ02.046.200324.0002 |       2795.62 | 1899-12-30 00:00:00.000 | 1899-12-30 11:53:00.000 |
| 2020-03-27 00:00:00.000 | 2020-03-30 00:00:00.000 | 9h-16h          |          100 | N.VietBISQ02.094.200327.0001 |        160    | 1899-12-30 00:00:00.000 | 1899-12-30 10:43:00.000 |
| 2020-03-24 00:00:00.000 | 2020-03-25 00:00:00.000 | 8H30 - 17H      |           86 | N.VietBISQ02.080.200330.0001 |      12878.4  | 1899-12-30 00:00:00.000 | 1899-12-30 11:05:00.000 |
| 2020-03-27 00:00:00.000 | 2020-03-30 00:00:00.000 | 9h-16h          |           60 | N.VietBISQ02.060.200327.0001 |          1.14 | 1899-12-30 00:00:00.000 | 1899-12-30 11:45:00.000 |


Table: FACTSales
| SaleDate                |   SaleID |   TransactionStatusID | Note   |   UnitPrice |   Quantity | RefundedQuantity   | RefundedAmount   |   TotalSM |   ProductID |   VendingMachineID |   PaymentTypeID |   WarehouseID | SaleTime                |   Hour | UpdatedOn   |   PositionID | Time Frame         |   Time Frame (sort) |
|:------------------------|---------:|----------------------:|:-------|------------:|-----------:|:-------------------|:-----------------|----------:|------------:|-------------------:|----------------:|--------------:|:------------------------|-------:|:------------|-------------:|:-------------------|--------------------:|
| 2020-03-01 00:00:00.000 |   600510 |                     1 | NULL   |       10000 |          1 |                    |                  |     10000 |         243 |                264 |               3 |           355 | 1899-12-30 10:19:02.236 |     10 |             |           80 | Morning (7-10h)    |                   2 |
| 2020-03-01 00:00:00.000 |   600593 |                     1 | NULL   |       10000 |          1 |                    |                  |     10000 |         243 |                 47 |               3 |            55 | 1899-12-30 11:28:54.473 |     11 |             |           80 | Lunch (11-13h)     |                   3 |
| 2020-03-01 00:00:00.000 |   600621 |                     1 | NULL   |       10000 |          1 |                    |                  |     10000 |         243 |                 32 |               3 |            40 | 1899-12-30 11:47:59.246 |     11 |             |           80 | Lunch (11-13h)     |                   3 |
| 2020-03-01 00:00:00.000 |   600623 |                     1 | NULL   |       10000 |          1 |                    |                  |     10000 |         243 |                 47 |               3 |            55 | 1899-12-30 11:49:06.123 |     11 |             |           80 | Lunch (11-13h)     |                   3 |
| 2020-03-01 00:00:00.000 |   600690 |                     1 | NULL   |       10000 |          1 |                    |                  |     10000 |         243 |                286 |               3 |           394 | 1899-12-30 12:37:00.853 |     12 |             |           80 | Lunch (11-13h)     |                   3 |
| 2020-03-01 00:00:00.000 |   600712 |                     1 | NULL   |       10000 |          1 |                    |                  |     10000 |         243 |                270 |               3 |           364 | 1899-12-30 12:50:16.830 |     12 |             |           80 | Lunch (11-13h)     |                   3 |
| 2020-03-01 00:00:00.000 |   600787 |                     1 | NULL   |       10000 |          1 |                    |                  |     10000 |         243 |                266 |               3 |           357 | 1899-12-30 14:04:08.123 |     14 |             |           80 | Afternoon (14-16h) |                   4 |
| 2020-03-01 00:00:00.000 |   600863 |                     1 | NULL   |       10000 |          1 |                    |                  |     10000 |         243 |                266 |               3 |           357 | 1899-12-30 15:29:28.390 |     15 |             |           80 | Afternoon (14-16h) |                   4 |
| 2020-03-01 00:00:00.000 |   600896 |                     1 | NULL   |       10000 |          1 |                    |                  |     10000 |         243 |                289 |               3 |           400 | 1899-12-30 15:59:40.990 |     15 |             |           80 | Afternoon (14-16h) |                   4 |
| 2020-03-01 00:00:00.000 |   601024 |                     1 | NULL   |       10000 |          1 |                    |                  |     10000 |         243 |                204 |               3 |           271 | 1899-12-30 17:22:53.123 |     17 |             |           80 | Dinner (17-19h)    |                   5 |

 


tables: name: DIMCalendar
data: DIMCalendar.csv
name: DIMMachine
data: DIMMachine.csv
name: DIMPayment
data: DIMPayment.csv
name: DIMPosition
data: DIMPosition.csv
name: DIMProduct
data: DIMProduct.csv
name: DIMProductPrice
data: DIMProductPrice.csv
name: DIMRefWarehouse
data: DIMRefWarehouse.csv
name: DIMSupplier
data: DIMSupplier.csv
name: DIMTransactionStatus
data: DIMTransactionStatus.csv
name: DIMWarehouse
data: DIMWarehouse.csv
name: FACTImportGood
data: FACTImportGood.csv
name: FACTMovingMachine
data: FACTMovingMachine.csv
name: FACTPurchaseOrder
data: FACTPurchaseOrder.csv
name: FACTSales
data: FACTSales.csv
label: DIMProductPrice
ProductID
DIMProduct
ProductID
FACTSales
ProductID
DIMProduct
ProductID
FACTSales
PaymentTypeID
DIMPayment
PaymentTypeID
FACTImportGood
SupplierID
DIMSupplier
SupplierID
FACTMovingMachine
WarehouseID
DIMWarehouse
WarehouseID
FACTImportGood
WarehouseID
DIMWarehouse
WarehouseID
FACTPurchaseOrder
SupplierID
DIMSupplier
SupplierID
FACTSales
SaleDate
DIMCalendar
Date
FACTMovingMachine
ExportDate
DIMCalendar
Date
FACTImportGood
ImportDate
DIMCalendar
Date
FACTPurchaseOrder
OrderDate
DIMCalendar
Date
FACTMovingMachine
VendingMachineID
DIMMachine
MachineCode
DIMMachine
RefID
DIMRefWarehouse
RefID
FACTSales
VendingMachineID
DIMMachine
VendingMachineID
FACTSales
TransactionStatusID
DIMTransactionStatus
TransactionStatusID
FACTSales
PositionID
DIMPosition
PositionID
output: {
    "joins": [
        {
            "from_table": "DIMProductPrice",
            "from_column": "ProductID",
            "to_table": "DIMProduct",
            "to_column": "ProductID"
        },
        {
            "from_table": "FACTSales",
            "from_column": "ProductID",
            "to_table": "DIMProduct",
            "to_column": "ProductID"
        },
        {
            "from_table": "FACTSales",
            "from_column": "PaymentTypeID",
            "to_table": "DIMPayment",
            "to_column": "PaymentTypeID"
        },
        {
            "from_table": "FACTImportGood",
            "from_column": "SupplierID",
            "to_table": "DIMSupplier",
            "to_column": "SupplierID"
        },
        {
            "from_table": "FACTMovingMachine",
            "from_column": "WarehouseID",
            "to_table": "DIMWarehouse",
            "to_column": "WarehouseID"
        },
        {
            "from_table": "FACTImportGood",
            "from_column": "WarehouseID",
            "to_table": "DIMWarehouse",
            "to_column": "WarehouseID"
        },
        {
            "from_table": "FACTPurchaseOrder",
            "from_column": "SupplierID",
            "to_table": "DIMSupplier",
            "to_column": "SupplierID"
        },
        {
            "from_table": "FACTSales",
            "from_column": "SaleDate",
            "to_table": "DIMCalendar",
            "to_column": "Date"
        },
        {
            "from_table": "FACTMovingMachine",
            "from_column": "ExportDate",
            "to_table": "DIMCalendar",
            "to_column": "Date"
        },
        {
            "from_table": "FACTImportGood",
            "from_column": "ImportDate",
            "to_table": "DIMCalendar",
            "to_column": "Date"
        },
        {
            "from_table": "FACTPurchaseOrder",
            "from_column": "OrderDate",
            "to_table": "DIMCalendar",
            "to_column": "Date"
        },
        {
            "from_table": "FACTMovingMachine",
            "from_column": "VendingMachineID",
            "to_table": "DIMMachine",
            "to_column": "MachineCode"
        },
        {
            "from_table": "DIMMachine",
            "from_column": "RefID",
            "to_table": "DIMRefWarehouse",
            "to_column": "RefID"
        },
        {
            "from_table": "FACTSales",
            "from_column": "VendingMachineID",
            "to_table": "DIMMachine",
            "to_column": "VendingMachineID"
        },
        {
            "from_table": "FACTSales",
            "from_column": "TransactionStatusID",
            "to_table": "DIMTransactionStatus",
            "to_column": "TransactionStatusID"
        },
        {
            "from_table": "FACTSales",
            "from_column": "PositionID",
            "to_table": "DIMPosition",
            "to_column": "PositionID"
        }
    ]
}