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: Airports
| Airports   | Type        |
|:-----------|:------------|
| Columbus   | Origin      |
| Atlanta    | Destination |
| Dallas     | Origin      |
| Fort Worth | Destination |
| Columbus   | Destination |
| Cleveland  | Origin      |
| Cincinatti | Destination |


Table: BadgeID
|   BadgeID |
|----------:|
|       456 |
|       321 |
|       765 |


Table: Calendar
| Date                    |   Weeknum |
|:------------------------|----------:|
| 2017-07-16 00:00:00.000 |        29 |
| 2017-07-17 00:00:00.000 |        29 |
| 2017-07-18 00:00:00.000 |        29 |
| 2017-07-19 00:00:00.000 |        29 |
| 2017-07-20 00:00:00.000 |        29 |
| 2017-07-21 00:00:00.000 |        29 |
| 2017-07-22 00:00:00.000 |        29 |
| 2017-07-23 00:00:00.000 |        30 |
| 2017-07-24 00:00:00.000 |        30 |
| 2017-07-25 00:00:00.000 |        30 |


Table: Changes Contracts
| Contract ID   |   Contract Number |   Original Contract Value |   Cost of Changes |
|:--------------|------------------:|--------------------------:|------------------:|
| A             |                 1 |                        10 |                 1 |
| A             |                 1 |                        10 |                 2 |
| A             |                 1 |                        10 |                 4 |
| B             |                 2 |                        30 |                 2 |
| B             |                 2 |                        30 |                 1 |
| B             |                 2 |                        30 |                 1 |
| C             |                 3 |                        22 |                 2 |
| D             |                 4 |                        40 |                 3 |
| E             |                 5 |                        21 |                 4 |


Table: Columns
| Date                    | Time                    |   Cost Price |   Brokerage Fee |   Selling Price |
|:------------------------|:------------------------|-------------:|----------------:|----------------:|
| 2010-01-01 00:00:00.000 | 1899-12-30 09:00:00.000 |        89.35 |            0.63 |           95.63 |
| 2010-01-01 00:00:00.000 | 1899-12-30 12:00:00.000 |         3.44 |            0.68 |            4.03 |


Table: Contract Management
| ID   | Project Name   |   Original Contract Value |   Contract Number |
|:-----|:---------------|--------------------------:|------------------:|
| A    | ABC            |                        10 |                 1 |
| B    | DEF            |                        30 |                 2 |
| C    | GHI            |                        22 |                 3 |
| D    | JKL            |                        40 |                 4 |
| E    | MNO            |                        21 |                 5 |


Table: Customers
| Customer   | Product   |   Amount |
|:-----------|:----------|---------:|
| Customer1  | Red       |       10 |
| Customer1  | Blue      |       20 |
| Customer1  | Green     |       30 |
| Customer2  | Red       |        5 |
| Customer3  | Blue      |        8 |
| Customer4  | Green     |       10 |
| Customer5  | Red       |       15 |
| Customer5  | Blue      |        1 |
| Customer6  | Blue      |        2 |
| Customer6  | Green     |        6 |


Table: CustomersTable
| Customer   |   CustomerValue |
|:-----------|----------------:|
| Customer1  |             111 |
| Customer2  |               1 |
| Customer3  |              10 |
| Customer4  |             100 |
| Customer5  |              11 |
| Customer6  |             110 |


Table: Dates
| Dates                   | OpenTickets   |   Column1 |
|:------------------------|:--------------|----------:|
| 2015-02-10 00:00:00.000 | 2             |         1 |
| 2015-02-11 00:00:00.000 | 1             |         2 |
| 2015-02-12 00:00:00.000 |               |         3 |
| 2015-02-13 00:00:00.000 |               |         4 |
| 2017-02-11 00:00:00.000 | 1             |         5 |
| 2017-02-12 00:00:00.000 | 1             |         6 |
| 2017-02-13 00:00:00.000 | 1             |         7 |
| 2017-05-19 00:00:00.000 | 1             |         8 |
| 2017-05-20 00:00:00.000 | 2             |         9 |
| 2017-05-21 00:00:00.000 | 2             |        10 |


Table: DateTable
| Date                    |
|:------------------------|
| 1899-01-01 00:00:00.000 |
| 1899-01-02 00:00:00.000 |
| 1899-01-03 00:00:00.000 |
| 1899-01-04 00:00:00.000 |
| 1899-01-05 00:00:00.000 |
| 1899-01-06 00:00:00.000 |
| 1899-01-07 00:00:00.000 |
| 1899-01-08 00:00:00.000 |
| 1899-01-09 00:00:00.000 |
| 1899-01-10 00:00:00.000 |


Table: Distinct
|   OrderID | Date                    |
|----------:|:------------------------|
|         1 | 2017-05-15 00:00:00.000 |
|         1 | 2017-06-16 00:00:00.000 |
|         1 | 2017-07-18 00:00:00.000 |
|         2 | 2017-05-15 00:00:00.000 |
|         2 | 2017-08-18 00:00:00.000 |
|         3 | 2017-05-15 00:00:00.000 |


Table: Examinations
|   ExaminationID |   Req_id |
|----------------:|---------:|
|          233313 |        1 |
|          233455 |        1 |
|          233123 |        1 |
|          333421 |        1 |
|          445531 |        2 |
|          234553 |        2 |
|          993030 |        2 |
|          837782 |        3 |
|          474875 |        3 |
|          677793 |        4 |


Table: Failures
|   Equipment | Error   |   Location |
|------------:|:--------|-----------:|
|       12345 | True    |        147 |
|       14725 | True    |        148 |
|       15689 | False   |        147 |
|       12547 | True    |        149 |
|       13254 | False   |        150 |
|       13564 | True    |        165 |


Table: Images
| Image                                                               |
|:--------------------------------------------------------------------|
| http://cheasy-o.weebly.com/uploads/9/4/7/9/9479443/8949871_orig.jpg |


Table: Inventory
|   Part # | Inventory Class   | Stock Out   |   Column |
|---------:|:------------------|:------------|---------:|
|        1 | A                 | N           | 0.428571 |
|        1 | A                 | N           | 0.428571 |
|        1 | A                 | Y           | 0.428571 |
|        1 | A                 | Y           | 0.428571 |
|        1 | A                 | N           | 0.428571 |
|        2 | B                 | Y           | 1.42857  |
|        2 | B                 | N           | 1.42857  |


Table: JournalDetailView
|   ProjectNO |   Amounts |
|------------:|----------:|
|           1 |         2 |
|           1 |         5 |
|           2 |        10 |
|           2 |         1 |
|           2 |         1 |
|           3 |         5 |


Table: json
| Source.Name   | Name   | Value.debug   | Value.window   | Value.image   | Value.text   |
|:--------------|:-------|:--------------|:---------------|:--------------|:-------------|
| json1.json    | widget | on            | [Record]       | [Record]      | [Record]     |
| json2.json    | widget | on            | [Record]       | [Record]      | [Record]     |


Table: Materials
| Materials   |
|:------------|
| ABC123      |
| XYZ789      |
| PGN561      |


Table: MaterialTypes
| MaterialType   |   Account |   %Distribution |
|:---------------|----------:|----------------:|
| ABC123         |  41500001 |             1   |
| XYZ789         |  41500007 |             0.3 |
| XYZ789         |  41500008 |             0.7 |
| PGN561         |  41500023 |             0.6 |
| PGN561         |  41500024 |             0.4 |


Table: MatrixFun
|   Year | Month   | Quarter   |   Sec Sales |   Volume |
|-------:|:--------|:----------|------------:|---------:|
|   2013 | Jan     | Q1        |           1 |        1 |
|   2013 | Feb     | Q1        |           1 |        1 |
|   2013 | Mar     | Q1        |           1 |        1 |
|   2013 | Apr     | Q2        |           1 |        1 |
|   2013 | May     | Q2        |           1 |        1 |
|   2013 | Jun     | Q2        |           1 |        1 |
|   2013 | Jul     | Q3        |           1 |        1 |
|   2013 | Aug     | Q3        |           1 |        1 |
|   2013 | Sep     | Q3        |           1 |        1 |
|   2013 | Oct     | Q4        |           1 |        1 |


Table: Measures 1
| Measure   |
|:----------|
| Sec Sales |
| Volume    |


Table: Metric
| METRIQUE   |   TO_NUMBER | Date                    | Hour                    |
|:-----------|------------:|:------------------------|:------------------------|
| MoyenneCPU |        1.77 | 2007-06-28 00:00:00.000 | 1899-12-30 13:00:00.000 |
| MoyenneCPU |        1.86 | 2007-06-28 00:00:00.000 | 1899-12-30 14:00:00.000 |
| MoyenneCPU |        1.97 | 2007-06-28 00:00:00.000 | 1899-12-30 15:00:00.000 |
| MoyenneCPU |        1.66 | 2007-06-28 00:00:00.000 | 1899-12-30 16:00:00.000 |
| MoyenneCPU |        1.49 | 2007-06-28 00:00:00.000 | 1899-12-30 17:00:00.000 |
| MoyenneCPU |        1.64 | 2007-06-28 00:00:00.000 | 1899-12-30 18:00:00.000 |
| MoyenneCPU |        1.53 | 2007-06-28 00:00:00.000 | 1899-12-30 19:00:00.000 |
| MoyenneCPU |        1.46 | 2007-06-28 00:00:00.000 | 1899-12-30 20:00:00.000 |
| MoyenneCPU |        1.23 | 2007-06-28 00:00:00.000 | 1899-12-30 21:00:00.000 |


Table: Names
|   BadgeID | Name    |
|----------:|:--------|
|       321 | Joe     |
|       456 | Melissa |
|       765 | Steve   |


Table: Numbers (2)
|   Number |   Column |
|---------:|---------:|
|  1524.44 |  1524.45 |
| -3645    | -3645.01 |


Table: Numbers
|   Number |
|---------:|
|       10 |
|       20 |
|       30 |
|       40 |
|       50 |
|       60 |
|       70 |
|       80 |
|       90 |
|      100 |


Table: Opportunities
|   OpportunityID |   Revenue | Company   | Department   |
|----------------:|----------:|:----------|:-------------|
|               1 |     10000 | Company1  | Dept1        |
|               2 |     10000 | Company2  | Dept1        |
|               3 |     10000 | Company3  | Dept1        |
|               4 |     10000 | Company4  | Dept1        |
|               5 |     10000 | Company5  | Dept1        |
|               6 |     10000 | Company6  | Dept2        |
|               7 |     10000 | Company6  | Dept2        |
|               8 |     10000 | Company7  | Dept3        |


Table: OrderIDs
| ORDERID             | Red   | Blue   | White   |   Total |   Column |
|:--------------------|:------|:-------|:--------|--------:|---------:|
| 7/1/2017BobJean     | 1     | 2      |         |       2 |        1 |
| 7/1/2017GaryJean    |       |        | 1       |       1 |        1 |
| 7/1/2017PatrickJean |       | 1      | 2       |       2 |        1 |
| 7/1/2017SteveSally  |       |        | 1       |       1 |        1 |
| 7/1/2017BrianJean   | 1     | 2      |         |       2 |        1 |
| 7/2/2017MonicaSally | 1     |        | 2       |       2 |        1 |
| 7/2/2017ClareJean   | 2     |        |         |       1 |        1 |
| 7/2/2017HannahSally |       | 1      |         |       1 |        1 |
| 7/2/2017RickJean    | 1     | 1      | 1       |       3 |        1 |
| 7/2/2017LoriSally   |       | 2      | 1       |       2 |        1 |


Table: OrderNumber
|   OrderNumber |   ItemCountExpected |   ItemRecieved |
|--------------:|--------------------:|---------------:|
|           123 |                   5 |              1 |
|           123 |                   5 |              1 |
|           123 |                   5 |              1 |
|           113 |                   3 |              1 |
|           113 |                   3 |              1 |
|           113 |                   3 |              1 |


Table: Products
| Product   |   Value |
|:----------|--------:|
| Red       |       1 |
| Blue      |      10 |
| Green     |     100 |


Table: ProductsCustomers
|   ProductNo |   CustomerNo |
|------------:|-------------:|
|           1 |            1 |
|           2 |            1 |
|           3 |            1 |
|           4 |            2 |
|           5 |            2 |
|           6 |            3 |
|           7 |            4 |
|           8 |            5 |
|           9 |            6 |
|          10 |            7 |


Table: Projects
|   ProjectNO |   Revenue |
|------------:|----------:|
|           1 |        10 |
|           2 |        15 |
|           3 |        20 |


Table: Sales
| ORDERDATE               | CUSTOMER   | CASHIER   | ItemDesc    |   Quantity |   Unit Price |   Total Price | ORDERID             |
|:------------------------|:-----------|:----------|:------------|-----------:|-------------:|--------------:|:--------------------|
| 2017-07-01 00:00:00.000 | Bob        | Jean      | Red shirt   |          1 |           12 |            12 | 7/1/2017BobJean     |
| 2017-07-01 00:00:00.000 | Bob        | Jean      | Blue shirt  |          2 |           12 |            24 | 7/1/2017BobJean     |
| 2017-07-01 00:00:00.000 | Gary       | Jean      | White shirt |          1 |           12 |            12 | 7/1/2017GaryJean    |
| 2017-07-01 00:00:00.000 | Patrick    | Jean      | White shirt |          2 |           12 |            24 | 7/1/2017PatrickJean |
| 2017-07-01 00:00:00.000 | Patrick    | Jean      | Blue shirt  |          1 |           12 |            12 | 7/1/2017PatrickJean |
| 2017-07-01 00:00:00.000 | Steve      | Sally     | White shirt |          1 |           12 |            12 | 7/1/2017SteveSally  |
| 2017-07-01 00:00:00.000 | Brian      | Jean      | Blue shirt  |          2 |           12 |            24 | 7/1/2017BrianJean   |
| 2017-07-01 00:00:00.000 | Brian      | Jean      | Red shirt   |          1 |           12 |            12 | 7/1/2017BrianJean   |
| 2017-07-02 00:00:00.000 | Monica     | Sally     | White shirt |          2 |           12 |            24 | 7/2/2017MonicaSally |
| 2017-07-02 00:00:00.000 | Monica     | Sally     | Red shirt   |          1 |           12 |            12 | 7/2/2017MonicaSally |


Table: SalesOrders
|   SALES ORDER NUMBER |
|---------------------:|
|                10000 |
|                10001 |
|                10002 |
|                10003 |


Table: Shirts
| ItemDesc    |   Column |
|:------------|---------:|
| Red shirt   |        7 |
| Blue shirt  |       12 |
| White shirt |        9 |


Table: Stuff
| ItemDesc    |
|:------------|
| Red shirt   |
| Blue shirt  |
| White shirt |
| close       |
| open        |


Table: Table1
|   Revenue2016 |   DeliverUnits2016 |   PriceErosion |   ForecastRevenue2017 | Custom   |
|--------------:|-------------------:|---------------:|----------------------:|:---------|
|          1000 |                 10 |           0.97 |                  2000 | 1000 10  |


Table: Table2
|   Table2 |
|---------:|
|     -2   |
|     -1.9 |
|     -1.8 |
|     -1.7 |
|     -1.6 |
|     -1.5 |
|     -1.4 |
|     -1.3 |
|     -1.2 |
|     -1.1 |


Table: Table3
|   Sales $ ACTUAL |   Sales $ BUDGET |   Sales $ PRIOR YEAR |   Sales $ BUDGET_1 |   Sales $ PRIOR YEAR_2 |   Sales $ ACTUAL_3 |   Sales $ BUDGET_4 |   Sales $ PRIOR YEAR_5 |   Sales $ BUDGET_6 |   Sales $ PRIOR YEAR_7 |   EBITDAR - $ ACTUAL |   EBITDAR - $ BUDGET |   EBITDAR - $ PRIOR YEAR |   EBITDAR - $ BUDGET_1 |   EBITDAR - $ PRIOR YEAR_2 |   EBITDAR - $ ACTUAL_3 |   EBITDAR - $ BUDGET_4 |   EBITDAR - $ PRIOR YEAR_5 |   EBITDAR - $ BUDGET_6 |   EBITDAR - $ PRIOR YEAR_7 |   EBITDAR % sales ACTUAL |   EBITDAR % sales BUDGET |   EBITDAR % sales PRIOR YEAR |   EBITDAR % sales BUDGET_1 |   EBITDAR % sales PRIOR YEAR_2 |   EBITDAR % sales ACTUAL_3 |   EBITDAR % sales BUDGET_4 |   EBITDAR % sales PRIOR YEAR_5 |   EBITDAR % sales BUDGET_6 |   EBITDAR % sales PRIOR YEAR_7 |   TWC % Sales ACTUAL |   TWC % Sales BUDGET |   TWC % Sales PRIOR YEAR |   TWC % Sales BUDGET_1 |   TWC % Sales PRIOR YEAR_2 |   TWC % Sales ACTUAL_3 |   TWC % Sales BUDGET_4 |   TWC % Sales PRIOR YEAR_5 |   TWC % Sales BUDGET_6 |   TWC % Sales PRIOR YEAR_7 |   DSO ACTUAL |   DSO BUDGET |   DSO PRIOR YEAR |   DSO BUDGET_1 |   DSO PRIOR YEAR_2 |   DSO ACTUAL_3 |   DSO BUDGET_4 |   DSO PRIOR YEAR_5 |   DSO BUDGET_6 |   DSO PRIOR YEAR_7 |   DIO ACTUAL |   DIO BUDGET |   DIO PRIOR YEAR |   DIO BUDGET_1 |   DIO PRIOR YEAR_2 |   DIO ACTUAL_3 |   DIO BUDGET_4 |   DIO PRIOR YEAR_5 |   DIO BUDGET_6 |   DIO PRIOR YEAR_7 |   DPO ACTUAL |   DPO BUDGET |   DPO PRIOR YEAR |   DPO BUDGET_1 |   DPO PRIOR YEAR_2 |   DPO ACTUAL_3 |   DPO BUDGET_4 |   DPO PRIOR YEAR_5 |   DPO BUDGET_6 |   DPO PRIOR YEAR_7 |   WC Days ACTUAL |   WC Days BUDGET |   WC Days PRIOR YEAR |   WC Days BUDGET_1 |   WC Days PRIOR YEAR_2 |   WC Days ACTUAL_3 |   WC Days BUDGET_4 |   WC Days PRIOR YEAR_5 |   WC Days BUDGET_6 |   WC Days PRIOR YEAR_7 |   Operating Cash Flow ACTUAL |   Operating Cash Flow BUDGET |   Operating Cash Flow PRIOR YEAR |   Operating Cash Flow BUDGET_1 |   Operating Cash Flow PRIOR YEAR_2 |   Operating Cash Flow ACTUAL_3 |   Operating Cash Flow BUDGET_4 |   Operating Cash Flow PRIOR YEAR_5 |   Operating Cash Flow BUDGET_6 |   Operating Cash Flow PRIOR YEAR_7 |   CapEX Paid ACTUAL |   CapEX Paid BUDGET |   CapEX Paid PRIOR YEAR |   CapEX Paid BUDGET_1 |   CapEX Paid PRIOR YEAR_2 |   CapEX Paid ACTUAL_3 |   CapEX Paid BUDGET_4 |   CapEX Paid PRIOR YEAR_5 |   CapEX Paid BUDGET_6 |   CapEX Paid PRIOR YEAR_7 |   Free Cash Flow ACTUAL |   Free Cash Flow BUDGET |   Free Cash Flow PRIOR YEAR |   Free Cash Flow BUDGET_1 |   Free Cash Flow PRIOR YEAR_2 |   Free Cash Flow ACTUAL_3 |   Free Cash Flow BUDGET_4 |   Free Cash Flow PRIOR YEAR_5 |   Free Cash Flow BUDGET_6 |   Free Cash Flow PRIOR YEAR_7 |
|-----------------:|-----------------:|---------------------:|-------------------:|-----------------------:|-------------------:|-------------------:|-----------------------:|-------------------:|-----------------------:|---------------------:|---------------------:|-------------------------:|-----------------------:|---------------------------:|-----------------------:|-----------------------:|---------------------------:|-----------------------:|---------------------------:|-------------------------:|-------------------------:|-----------------------------:|---------------------------:|-------------------------------:|---------------------------:|---------------------------:|-------------------------------:|---------------------------:|-------------------------------:|---------------------:|---------------------:|-------------------------:|-----------------------:|---------------------------:|-----------------------:|-----------------------:|---------------------------:|-----------------------:|---------------------------:|-------------:|-------------:|-----------------:|---------------:|-------------------:|---------------:|---------------:|-------------------:|---------------:|-------------------:|-------------:|-------------:|-----------------:|---------------:|-------------------:|---------------:|---------------:|-------------------:|---------------:|-------------------:|-------------:|-------------:|-----------------:|---------------:|-------------------:|---------------:|---------------:|-------------------:|---------------:|-------------------:|-----------------:|-----------------:|---------------------:|-------------------:|-----------------------:|-------------------:|-------------------:|-----------------------:|-------------------:|-----------------------:|-----------------------------:|-----------------------------:|---------------------------------:|-------------------------------:|-----------------------------------:|-------------------------------:|-------------------------------:|-----------------------------------:|-------------------------------:|-----------------------------------:|--------------------:|--------------------:|------------------------:|----------------------:|--------------------------:|----------------------:|----------------------:|--------------------------:|----------------------:|--------------------------:|------------------------:|------------------------:|----------------------------:|--------------------------:|------------------------------:|--------------------------:|--------------------------:|------------------------------:|--------------------------:|------------------------------:|
|                0 |                0 |                    0 |                  0 |                      0 |                  0 |                  0 |                      0 |                  0 |                      0 |                    0 |                    0 |                        0 |                      0 |                          0 |                      0 |                      0 |                          0 |                      0 |                          0 |                        0 |                        0 |                            0 |                          0 |                              0 |                          0 |                          0 |                              0 |                          0 |                              0 |                    0 |                    0 |                        0 |                      0 |                          0 |                      0 |                      0 |                          0 |                      0 |                          0 |            0 |            0 |                0 |              0 |                  0 |              0 |              0 |                  0 |              0 |                  0 |            0 |            0 |                0 |              0 |                  0 |              0 |              0 |                  0 |              0 |                  0 |            0 |            0 |                0 |              0 |                  0 |              0 |              0 |                  0 |              0 |                  0 |                0 |                0 |                    0 |                  0 |                      0 |                  0 |                  0 |                      0 |                  0 |                      0 |                            0 |                            0 |                                0 |                              0 |                                  0 |                              0 |                              0 |                                  0 |                              0 |                                  0 |                   0 |                   0 |                       0 |                     0 |                         0 |                     0 |                     0 |                         0 |                     0 |                         0 |                       0 |                       0 |                           0 |                         0 |                             0 |                         0 |                         0 |                             0 |                         0 |                             0 |


Table: Tickets
| create_ticket           | close_ticket_date       | status   |
|:------------------------|:------------------------|:---------|
| 2015-02-10 00:00:00.000 | 2015-02-10 00:00:00.000 | close    |
| 2015-02-10 00:00:00.000 | 2015-02-11 00:00:00.000 | close    |
| 2017-02-11 00:00:00.000 | 2017-06-17 00:00:00.000 | close    |
| 2017-05-20 00:00:00.000 |                         | open     |


Table: Values
| Date                    |   Value |   Weeknum |
|:------------------------|--------:|----------:|
| 2017-07-16 00:00:00.000 |       1 |        29 |
| 2017-07-17 00:00:00.000 |       2 |        29 |
| 2017-07-18 00:00:00.000 |       3 |        29 |
| 2017-07-19 00:00:00.000 |       4 |        29 |
| 2017-07-20 00:00:00.000 |       5 |        29 |
| 2017-07-21 00:00:00.000 |       6 |        29 |
| 2017-07-22 00:00:00.000 |       7 |        29 |
| 2017-07-23 00:00:00.000 |       8 |        30 |
| 2017-07-24 00:00:00.000 |       9 |        30 |
| 2017-07-25 00:00:00.000 |      10 |        30 |


Table: WorkOrders
|   WorkOrder | MaterialType   |   Amount |
|------------:|:---------------|---------:|
|     1000001 | XYZ789         |       10 |
|     1000002 | ABC123         |        9 |
|     1000003 | XYZ789         |       20 |
|     1000004 | ABC123         |        3 |
|     1000005 | PGN561         |       20 |

 


tables: name: Airports
data: Airports.csv
name: BadgeID
data: BadgeID.csv
name: Calendar
data: Calendar.csv
name: Changes Contracts
data: Changes Contracts.csv
name: Columns
data: Columns.csv
name: Contract Management
data: Contract Management.csv
name: Customers
data: Customers.csv
name: CustomersTable
data: CustomersTable.csv
name: Dates
data: Dates.csv
name: DateTable
data: DateTable.csv
name: Distinct
data: Distinct.csv
name: Examinations
data: Examinations.csv
name: Failures
data: Failures.csv
name: Images
data: Images.csv
name: Inventory
data: Inventory.csv
name: JournalDetailView
data: JournalDetailView.csv
name: json
data: json.csv
name: Materials
data: Materials.csv
name: MaterialTypes
data: MaterialTypes.csv
name: MatrixFun
data: MatrixFun.csv
name: Measures 1
data: Measures 1.csv
name: Metric
data: Metric.csv
name: Names
data: Names.csv
name: Numbers (2)
data: Numbers (2).csv
name: Numbers
data: Numbers.csv
name: Opportunities
data: Opportunities.csv
name: OrderIDs
data: OrderIDs.csv
name: OrderNumber
data: OrderNumber.csv
name: Products
data: Products.csv
name: ProductsCustomers
data: ProductsCustomers.csv
name: Projects
data: Projects.csv
name: Sales
data: Sales.csv
name: SalesOrders
data: SalesOrders.csv
name: Shirts
data: Shirts.csv
name: Stuff
data: Stuff.csv
name: Table1
data: Table1.csv
name: Table2
data: Table2.csv
name: Table3
data: Table3.csv
name: Tickets
data: Tickets.csv
name: Values
data: Values.csv
name: WorkOrders
data: WorkOrders.csv
label: Sales
ORDERID
OrderIDs
ORDERID
Sales
ItemDesc
Shirts
ItemDesc
Calendar
Date
Values
Date
Changes Contracts
Contract Number
Contract Management
Contract Number
MaterialTypes
MaterialType
Materials
Materials
WorkOrders
MaterialType
Materials
Materials
JournalDetailView
ProjectNO
Projects
ProjectNO
Names
BadgeID
BadgeID
BadgeID
Customers
Product
Products
Product
Customers
Customer
CustomersTable
Customer
output: {
    "joins": [
        {
            "from_table": "Sales",
            "from_column": "ORDERID",
            "to_table": "OrderIDs",
            "to_column": "ORDERID"
        },
        {
            "from_table": "Sales",
            "from_column": "ItemDesc",
            "to_table": "Shirts",
            "to_column": "ItemDesc"
        },
        {
            "from_table": "Calendar",
            "from_column": "Date",
            "to_table": "Values",
            "to_column": "Date"
        },
        {
            "from_table": "Changes Contracts",
            "from_column": "Contract Number",
            "to_table": "Contract Management",
            "to_column": "Contract Number"
        },
        {
            "from_table": "MaterialTypes",
            "from_column": "MaterialType",
            "to_table": "Materials",
            "to_column": "Materials"
        },
        {
            "from_table": "WorkOrders",
            "from_column": "MaterialType",
            "to_table": "Materials",
            "to_column": "Materials"
        },
        {
            "from_table": "JournalDetailView",
            "from_column": "ProjectNO",
            "to_table": "Projects",
            "to_column": "ProjectNO"
        },
        {
            "from_table": "Names",
            "from_column": "BadgeID",
            "to_table": "BadgeID",
            "to_column": "BadgeID"
        },
        {
            "from_table": "Customers",
            "from_column": "Product",
            "to_table": "Products",
            "to_column": "Product"
        },
        {
            "from_table": "Customers",
            "from_column": "Customer",
            "to_table": "CustomersTable",
            "to_column": "Customer"
        }
    ]
}