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: Actuals
| Fiscal Year   | Area   | Subsidiary   | Rev Sum Division   | Std Rptg Mid Reported Subsegment   | Forecast Planning Level   |   Period |      Sales |
|:--------------|:-------|:-------------|:-------------------|:-----------------------------------|:--------------------------|---------:|-----------:|
| FY18          | WE     | Denmark      | Biztalk Server     | EPG Commercial                     | EA Recurring              |        1 |   4556.6   |
| FY18          | WE     | Denmark      | Biztalk Server     | EPG Commercial                     | EA Recurring              |        4 |    957.64  |
| FY18          | WE     | Denmark      | Biztalk Server     | EPG Commercial                     | EA Recurring              |        5 |    123.001 |
| FY18          | WE     | Denmark      | Biztalk Server     | EPG Commercial                     | EA Recurring              |        7 |    581.81  |
| FY18          | WE     | Denmark      | Biztalk Server     | EPG Commercial                     | EA Recurring              |        9 |  10720.8   |
| FY18          | WE     | Denmark      | Biztalk Server     | EPG Commercial                     | EA Recurring              |       10 |  52935.5   |
| FY18          | WE     | Denmark      | Biztalk Server     | EPG Commercial                     | EA Recurring              |       11 | 298196     |
| FY18          | WE     | Denmark      | Biztalk Server     | EPG Commercial                     | EA Recurring              |       12 |  19537.1   |
| FY18          | WE     | Denmark      | Developer Tools    | EPG Commercial                     | EA Recurring              |        1 | 137250     |
| FY18          | WE     | Denmark      | Developer Tools    | EPG Commercial                     | EA Recurring              |        2 |   9703.92  |


Table: Geography
| Area   | Country     | Location               |
|:-------|:------------|:-----------------------|
| WE     | Austria     | Vienna, Austria        |
| WE     | WE HQ       | Paris, France          |
| WE     | Belgium     | Brussels, Belgium      |
| WE     | Denmark     | Copenhagen, Denmark    |
| WE     | Finland     | Helsinki, Finland      |
| WE     | Ireland     | Dublin, Ireland        |
| WE     | Italy       | Milan, Italy           |
| WE     | Netherlands | Amsterdam, Netherlands |
| WE     | Norway      | Oslo, Norway           |
| WE     | Portugal    | Lisbon, Portugal       |


Table: KPI
| Column   |
|----------|


Table: Period
| MS Sales Month          | MonthName   | Quarter   |   Period | MonthNumber   |
|:------------------------|:------------|:----------|---------:|:--------------|
| 2017-07-01 00:00:00.000 | July        | FY18-Q1   |        1 | 2017-07       |
| 2017-08-01 00:00:00.000 | August      | FY18-Q1   |        2 | 2017-08       |
| 2017-09-01 00:00:00.000 | September   | FY18-Q1   |        3 | 2017-09       |
| 2017-10-01 00:00:00.000 | October     | FY18-Q2   |        4 | 2017-10       |
| 2017-11-01 00:00:00.000 | November    | FY18-Q2   |        5 | 2017-11       |
| 2017-12-01 00:00:00.000 | December    | FY18-Q2   |        6 | 2017-12       |
| 2018-01-01 00:00:00.000 | January     | FY18-Q3   |        7 | 2018-01       |
| 2018-02-01 00:00:00.000 | February    | FY18-Q3   |        8 | 2018-02       |
| 2018-03-01 00:00:00.000 | March       | FY18-Q3   |        9 | 2018-03       |
| 2018-04-01 00:00:00.000 | April       | FY18-Q4   |       10 | 2018-04       |


Table: Plan
| Fiscal Year   |   Period | Area   | Country   | Std Rptg Mid Reported Subsegment   | Rev Sum Division                 | Forecast Planning Level   |     Budget Sales |   Forecast Sales |
|:--------------|---------:|:-------|:----------|:-----------------------------------|:---------------------------------|:--------------------------|-----------------:|-----------------:|
| FY18          |       12 | WE     | Denmark   | EPG Public Sector                  | SQL Server Premium               | EA Add-On                 |      3.92125e+06 |                0 |
| FY18          |       12 | WE     | Denmark   | EPG Public Sector                  | Exchange Server & CAL            | EA Add-On                 | 467874           |                0 |
| FY18          |       12 | WE     | Denmark   | EPG Public Sector                  | Windows Client                   | EA Add-On                 | 424509           |                0 |
| FY18          |       12 | WE     | Denmark   | EPG Public Sector                  | Windows Server Premium           | EA Add-On                 | 420034           |                0 |
| FY18          |       12 | WE     | Denmark   | EPG Public Sector                  | S&T CAL Suites - Core CAL        | EA Add-On                 | 396562           |                0 |
| FY18          |       12 | WE     | Denmark   | EPG Public Sector                  | System Center Server             | EA Add-On                 | 371503           |                0 |
| FY18          |        6 | WE     | Denmark   | EPG Public Sector                  | Biztalk Server                   | EA Add-On                 | 365035           |                0 |
| FY18          |       12 | WE     | Denmark   | EPG Public Sector                  | Windows Server & Solutions & CAL | EA Add-On                 | 322891           |                0 |
| FY18          |       12 | WE     | Denmark   | EPG Public Sector                  | Developer Tools                  | EA Add-On                 | 297093           |                0 |
| FY18          |       12 | WE     | Denmark   | EPG Public Sector                  | IW CAL Suites - Core CAL         | EA Add-On                 | 247153           |                0 |


Table: PricingLevel
| Forecast Planning Level     | Pricing Level   | Detailed Pricing Level   | Annuity vs.Non An   |
|:----------------------------|:----------------|:-------------------------|:--------------------|
| EA Add-On                   | 01.New          | EA Add-On                | Annuity             |
| EA New                      | 01.New          | EA New                   | Annuity             |
| EA Recurring                | 03.Recurring    | EA Recurring             | Annuity             |
| EA Renewal                  | 02.Renewal      | EA Renewal               | Annuity             |
| FPP/MLP                     | 01.New          | Other Non Annuity        | Non Annuity         |
| VL Annuity Non-Recur w/o EA | 01.New          | Other Non Annuity        | Non Annuity         |
| VL Annuity Recur w/o EA     | 03.Recurring    | Other Annuity            | Annuity             |
| VL Non-Annuity              | 01.New          | Other Non Annuity        | Non Annuity         |
| 3rd Party Hosting           | 01.New          | Other Non Annuity        | Non Annuity         |
| Online Services             | 01.New          | Other Non Annuity        | Non Annuity         |


Table: Product
| Rev Sum Division          | Business                   | BG   | BG 2     |
|:--------------------------|:---------------------------|:-----|:---------|
| PC Hardware               | SDA SMSG                   | WWLD | 01. WWLD |
| MDOP-Client               | Windows Client             | WWLD | 01. WWLD |
| Windows Client            | Windows Client             | WWLD | 01. WWLD |
| Windows Legalization      | Windows Client             | WWLD | 01. WWLD |
| Windows Intune - Client   | Windows Client             | WWLD | 01. WWLD |
| Windows Client (Non-SMSG) | Windows Client (Local OEM) | WWLD | 01. WWLD |
| Windows Live Display      | Windows Live               | WWLD | 01. WWLD |
| Windows Live Subs & Trans | Windows Live               | WWLD | 01. WWLD |
| Developer Tools           | Developer Tools            | STB  | 02. STB  |
| Biztalk Server            | Other Server & Tools       | STB  | 02. STB  |


Table: SubSegment
| Std Rptg Mid Reported Subsegment   | SubSegment   |
|:-----------------------------------|:-------------|
| EPG Commercial                     | Comm         |
| EPG Public Sector                  | PS           |

 


tables: name: Actuals
data: Actuals.csv
name: Geography
data: Geography.csv
name: KPI
data: KPI.csv
name: Period
data: Period.csv
name: Plan
data: Plan.csv
name: PricingLevel
data: PricingLevel.csv
name: Product
data: Product.csv
name: SubSegment
data: SubSegment.csv
label: Actuals
Rev Sum Division
Product
Rev Sum Division
Plan
Rev Sum Division
Product
Rev Sum Division
Actuals
Std Rptg Mid Reported Subsegment
SubSegment
Std Rptg Mid Reported Subsegment
Plan
Std Rptg Mid Reported Subsegment
SubSegment
Std Rptg Mid Reported Subsegment
Actuals
Forecast Planning Level
PricingLevel
Forecast Planning Level
Plan
Forecast Planning Level
PricingLevel
Forecast Planning Level
Actuals
Period
Period
Period
Plan
Period
Period
Period
Plan
Country
Geography
Country
Actuals
Subsidiary
Geography
Country
output: {
    "joins": [
        {
            "from_table": "Actuals",
            "from_column": "Rev Sum Division",
            "to_table": "Product",
            "to_column": "Rev Sum Division"
        },
        {
            "from_table": "Plan",
            "from_column": "Rev Sum Division",
            "to_table": "Product",
            "to_column": "Rev Sum Division"
        },
        {
            "from_table": "Actuals",
            "from_column": "Std Rptg Mid Reported Subsegment",
            "to_table": "SubSegment",
            "to_column": "Std Rptg Mid Reported Subsegment"
        },
        {
            "from_table": "Plan",
            "from_column": "Std Rptg Mid Reported Subsegment",
            "to_table": "SubSegment",
            "to_column": "Std Rptg Mid Reported Subsegment"
        },
        {
            "from_table": "Actuals",
            "from_column": "Forecast Planning Level",
            "to_table": "PricingLevel",
            "to_column": "Forecast Planning Level"
        },
        {
            "from_table": "Plan",
            "from_column": "Forecast Planning Level",
            "to_table": "PricingLevel",
            "to_column": "Forecast Planning Level"
        },
        {
            "from_table": "Actuals",
            "from_column": "Period",
            "to_table": "Period",
            "to_column": "Period"
        },
        {
            "from_table": "Plan",
            "from_column": "Period",
            "to_table": "Period",
            "to_column": "Period"
        },
        {
            "from_table": "Plan",
            "from_column": "Country",
            "to_table": "Geography",
            "to_column": "Country"
        },
        {
            "from_table": "Actuals",
            "from_column": "Subsidiary",
            "to_table": "Geography",
            "to_column": "Country"
        }
    ]
}