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: Chart of Account V2
|   STDC Key Index |   Standard Class Key |   Report Type Index | Report Type   |   STDC 0 Index | STDC 0   | STDC 1                    | STDC 2                                 |   STDC 1 BP3 Index | STDC 1 BP3              |   STDC 2 BP3 Index | STDC 3                         | STDC 4             | SDTC 5                                     | STDC 6                                    | Non Cash   | Tax Flag   | STDC 1 BP3 Short Name   | STDC 2 BP3                      | STDC 2 BP3 Short Name   |   STDC 1 GB Index | STDC 1 GB        |   STDC 2 GB Index | STDC 2 GB        |
|-----------------:|---------------------:|--------------------:|:--------------|---------------:|:---------|:--------------------------|:---------------------------------------|-------------------:|:------------------------|-------------------:|:-------------------------------|:-------------------|:-------------------------------------------|:------------------------------------------|:-----------|:-----------|:------------------------|:--------------------------------|:------------------------|------------------:|:-----------------|------------------:|:-----------------|
|              434 |               358111 |                   1 | P&L           |              2 | Expenses | 300000|EXPENSES - GENERAL | 330000|Purchases Of Goods And Services |                  9 | Administrative expenses |                 11 | 358000|Marketing And Promotion | 358100|ADVERTISING | 358110|ADVERTISING-NEWSPAPER               | 358111|NEWSPAPER PLACEMENT                | No         | No         | Adm expenses            | Purchases of goods and services | Purchases of G&S        |                 3 | Purchases of G&S |                 3 | Purchases of G&S |
|              435 |               358115 |                   1 | P&L           |              2 | Expenses | 300000|EXPENSES - GENERAL | 330000|Purchases Of Goods And Services |                  9 | Administrative expenses |                 11 | 358000|Marketing And Promotion | 358100|ADVERTISING | 358110|ADVERTISING-NEWSPAPER               | 358115|SHOW CIRCUIT                       | No         | No         | Adm expenses            | Purchases of goods and services | Purchases of G&S        |                 3 | Purchases of G&S |                 3 | Purchases of G&S |
|              436 |               358121 |                   1 | P&L           |              2 | Expenses | 300000|EXPENSES - GENERAL | 330000|Purchases Of Goods And Services |                  9 | Administrative expenses |                 11 | 358000|Marketing And Promotion | 358100|ADVERTISING | 358120|ADVERTISING - RADIO                 | 358121|RADIO PLACEMENT                    | No         | No         | Adm expenses            | Purchases of goods and services | Purchases of G&S        |                 3 | Purchases of G&S |                 3 | Purchases of G&S |
|              437 |               358131 |                   1 | P&L           |              2 | Expenses | 300000|EXPENSES - GENERAL | 330000|Purchases Of Goods And Services |                  9 | Administrative expenses |                 11 | 358000|Marketing And Promotion | 358100|ADVERTISING | 358130|ADVERTISING - TELEVISION            | 358131|TELEVISION PLACEMENT               | No         | No         | Adm expenses            | Purchases of goods and services | Purchases of G&S        |                 3 | Purchases of G&S |                 3 | Purchases of G&S |
|              438 |               358141 |                   1 | P&L           |              2 | Expenses | 300000|EXPENSES - GENERAL | 330000|Purchases Of Goods And Services |                  9 | Administrative expenses |                 11 | 358000|Marketing And Promotion | 358100|ADVERTISING | 358140|ADVERTISING - MAGAZINES/JOURNALS    | 358141|MAGAZINES/JOURNALS PLACEMENT       | No         | No         | Adm expenses            | Purchases of goods and services | Purchases of G&S        |                 3 | Purchases of G&S |                 3 | Purchases of G&S |
|              439 |               358151 |                   1 | P&L           |              2 | Expenses | 300000|EXPENSES - GENERAL | 330000|Purchases Of Goods And Services |                  9 | Administrative expenses |                 11 | 358000|Marketing And Promotion | 358100|ADVERTISING | 358150|ADVERTISING - WEB/MULTIMEDIA        | 358151|WEB/MULTIMEDIA PLACEMENT           | No         | No         | Adm expenses            | Purchases of goods and services | Purchases of G&S        |                 3 | Purchases of G&S |                 3 | Purchases of G&S |
|              440 |               358161 |                   1 | P&L           |              2 | Expenses | 300000|EXPENSES - GENERAL | 330000|Purchases Of Goods And Services |                  9 | Administrative expenses |                 11 | 358000|Marketing And Promotion | 358100|ADVERTISING | 358160|ADVERTISING - OUTDOOR SIGNS/BANNERS | 358161|OUTDOOR SIGNS/BANNERS PLACEMENT    | No         | No         | Adm expenses            | Purchases of goods and services | Purchases of G&S        |                 3 | Purchases of G&S |                 3 | Purchases of G&S |
|              441 |               358171 |                   1 | P&L           |              2 | Expenses | 300000|EXPENSES - GENERAL | 330000|Purchases Of Goods And Services |                  9 | Administrative expenses |                 11 | 358000|Marketing And Promotion | 358100|ADVERTISING | 358170|ADVERTISING - DESIGN/PRODUCTION     | 358171|NEWSPAPERS - DESIGN AND PRODUCTION | No         | No         | Adm expenses            | Purchases of goods and services | Purchases of G&S        |                 3 | Purchases of G&S |                 3 | Purchases of G&S |
|              442 |               358172 |                   1 | P&L           |              2 | Expenses | 300000|EXPENSES - GENERAL | 330000|Purchases Of Goods And Services |                  9 | Administrative expenses |                 11 | 358000|Marketing And Promotion | 358100|ADVERTISING | 358170|ADVERTISING - DESIGN/PRODUCTION     | 358172|RADIO - DESIGN AND PRODUCTION      | No         | No         | Adm expenses            | Purchases of goods and services | Purchases of G&S        |                 3 | Purchases of G&S |                 3 | Purchases of G&S |
|              443 |               358173 |                   1 | P&L           |              2 | Expenses | 300000|EXPENSES - GENERAL | 330000|Purchases Of Goods And Services |                  9 | Administrative expenses |                 11 | 358000|Marketing And Promotion | 358100|ADVERTISING | 358170|ADVERTISING - DESIGN/PRODUCTION     | 358173|TELEVISION - DESIGN AND PRODUCTION | No         | No         | Adm expenses            | Purchases of goods and services | Purchases of G&S        |                 3 | Purchases of G&S |                 3 | Purchases of G&S |


Table: Comments
| Date                    | FinancialMonthNameShort   | FinancialYear   | Comment                                                                                                            | Comment LF                                                                                                         |   Standard Class Key |   STDC 1 BP3 Index | STDC 1 BP3                   |   Comment # | Comment marker   |
|:------------------------|:--------------------------|:----------------|:-------------------------------------------------------------------------------------------------------------------|:-------------------------------------------------------------------------------------------------------------------|---------------------:|-------------------:|:-----------------------------|------------:|:-----------------|
| 2021-08-01 00:00:00.000 | Aug                       | 2020-21         | Excellent FCF performance is a result of our new cash colletion initiative.                                        | Excellent FCF performance is a result of our new cash colletion initiative.                                        |               122111 |                  1 | Grants and subsidies revenue |           1 | ①                |
|                         |                           |                 | We hired Chuck Norris 😉                                                                                           | We hired Chuck Norris 😉                                                                                           |                      |                    |                              |             |                  |
| 2021-08-01 00:00:00.000 | Aug                       | 2020-21         | CAPEX lower than planned because we decided not to buy the new Xlertiax equipment but rather just fix the old one. | CAPEX lower than planned because we decided not to buy the new Xlertiax equipment but rather just fix the old one. |               131111 |                  3 | Sale of goods and services   |           2 | ②                |
| 2021-08-01 00:00:00.000 | Aug                       | 2020-21         | EBITDA +8M above plan due to decreased COGS. We changed the supplier of latex.                                     | EBITDA +8M above plan due to decreased COGS. We changed the supplier of latex.                                     |               212521 |                  8 | Employee Expenses            |           3 | ③                |
| 2021-08-01 00:00:00.000 | Aug                       | 2020-21         | Increased EBIT follows the result in EBITDA.                                                                       | Increased EBIT follows the result in EBITDA.                                                                       |               311111 |                  9 | Administrative expenses      |           4 | ④                |


Table: Cost Centre V2
| Cost Centre Key   |   Organisation ID | Division ID   | Division Name      | Sub-Division ID   | Sub-Division Name Output     |   Program ID | Program Name        | Region ID   |   Sub-Program ID | Sub-Program Name           |   Cost Centre ID | Cost Centre Name              | Funding Type   |   COFOG-A Name | CHA   | Region Name   | Cost Centre Key and Name                | Division Name Short   | Sub-Division Name Output Short Name   |   Division Name Alt Index | Division Name Alt   | Funding Type Group   |
|:------------------|------------------:|:--------------|:-------------------|:------------------|:-----------------------------|-------------:|:--------------------|:------------|-----------------:|:---------------------------|-----------------:|:------------------------------|:---------------|---------------:|:------|:--------------|:----------------------------------------|:----------------------|:--------------------------------------|--------------------------:|:--------------------|:---------------------|
| 50FP9D101         |                50 | F             | Parks and Wildlife | P                 | Park and Wildlife Operations |            9 | WILDLIFE OPERATIONS | D           |                1 | WILDLIFE OPERATIONS        |                1 | MGT DARWIN                    | Internal       |            541 | No    | Darwin        | 50FP9D101-MGT DARWIN                    | Par and Wi            | Par and Wi Op                         |                        10 | Parks and Wildlife  | NTG Funding          |
| 50FP9D102         |                50 | F             | Parks and Wildlife | P                 | Park and Wildlife Operations |            9 | WILDLIFE OPERATIONS | D           |                1 | WILDLIFE OPERATIONS        |                2 | OPERATIONS                    | Internal       |            541 | No    | Darwin        | 50FP9D102-OPERATIONS                    | Par and Wi            | Par and Wi Op                         |                        10 | Parks and Wildlife  | NTG Funding          |
| 50FP9D201         |                50 | F             | Parks and Wildlife | P                 | Park and Wildlife Operations |            9 | WILDLIFE OPERATIONS | D           |                2 | CROC MANAGEMENT            |                1 | CROC MANAGEMENT               | Internal       |            541 | No    | Darwin        | 50FP9D201-CROC MANAGEMENT               | Par and Wi            | Par and Wi Op                         |                        10 | Parks and Wildlife  | NTG Funding          |
| 50FP9D301         |                50 | F             | Parks and Wildlife | P                 | Park and Wildlife Operations |            9 | WILDLIFE OPERATIONS | D           |                3 | NATIVE WILDLIFE MANAGEMENT |                1 | NATIVE WILDLIFE MGT           | Internal       |            541 | No    | Darwin        | 50FP9D301-NATIVE WILDLIFE MGT           | Par and Wi            | Par and Wi Op                         |                        10 | Parks and Wildlife  | NTG Funding          |
| 50FP9D302         |                50 | F             | Parks and Wildlife | P                 | Park and Wildlife Operations |            9 | WILDLIFE OPERATIONS | D           |                3 | NATIVE WILDLIFE MANAGEMENT |                2 | EXOTIC WILDLIFE MGT           | Internal       |            541 | No    | Darwin        | 50FP9D302-EXOTIC WILDLIFE MGT           | Par and Wi            | Par and Wi Op                         |                        10 | Parks and Wildlife  | NTG Funding          |
| 50FP9D401         |                50 | F             | Parks and Wildlife | P                 | Park and Wildlife Operations |            9 | WILDLIFE OPERATIONS | D           |                4 | SNAKE CALL OUT             |                1 | SNAKE CALL OUT                | Internal       |            541 | No    | Darwin        | 50FP9D401-SNAKE CALL OUT                | Par and Wi            | Par and Wi Op                         |                        10 | Parks and Wildlife  | NTG Funding          |
| 50FP4D701         |                50 | F             | Parks and Wildlife | P                 | Park and Wildlife Operations |            4 | TOP END DISTRICT    | D           |                7 | CHANNEL POINT              |                1 | CHANNEL POINT-OPERATIONAL MGT | Internal       |            541 | No    | Darwin        | 50FP4D701-CHANNEL POINT-OPERATIONAL MGT | Par and Wi            | Par and Wi Op                         |                        10 | Parks and Wildlife  | NTG Funding          |
| 50FP3D302         |                50 | F             | Parks and Wildlife | P                 | Park and Wildlife Operations |            3 | DARWIN DISTRICT     | D           |                3 | BERRY SPRINGS              |                2 | BERRY SPRINGS - FEP           | Internal       |            541 | No    | Darwin        | 50FP3D302-BERRY SPRINGS - FEP           | Par and Wi            | Par and Wi Op                         |                        10 | Parks and Wildlife  | NTG Funding          |
| 50FP3D304         |                50 | F             | Parks and Wildlife | P                 | Park and Wildlife Operations |            3 | DARWIN DISTRICT     | D           |                3 | BERRY SPRINGS              |                4 | BERRY SPRINGS  - FERAL MGT    | Internal       |            541 | No    | Darwin        | 50FP3D304-BERRY SPRINGS  - FERAL MGT    | Par and Wi            | Par and Wi Op                         |                        10 | Parks and Wildlife  | NTG Funding          |
| 50FP3D305         |                50 | F             | Parks and Wildlife | P                 | Park and Wildlife Operations |            3 | DARWIN DISTRICT     | D           |                3 | BERRY SPRINGS              |                5 | BERRY SPRINGS  - WEEDS MGT    | Internal       |            541 | No    | Darwin        | 50FP3D305-BERRY SPRINGS  - WEEDS MGT    | Par and Wi            | Par and Wi Op                         |                        10 | Parks and Wildlife  | NTG Funding          |


Table: CurrencyMetric
| Currency metric   | Metric prefix   |   Currency metric ID |
|:------------------|:----------------|---------------------:|
| In ones           | o               |                    1 |
| In thousands      | k               |                    2 |
| In millions       | m               |                    3 |
| In billions       | b               |                    4 |


Table: Date
| Date                    |   FinancialMonthNumber | FinancialMonthNameShort   | FinancialQuarter   | FinancialYear   |
|:------------------------|-----------------------:|:--------------------------|:-------------------|:----------------|
| 2019-07-01 00:00:00.000 |                      1 | Jul                       | Q1                 | 2019-20         |
| 2019-07-02 00:00:00.000 |                      1 | Jul                       | Q1                 | 2019-20         |
| 2019-07-03 00:00:00.000 |                      1 | Jul                       | Q1                 | 2019-20         |
| 2019-07-04 00:00:00.000 |                      1 | Jul                       | Q1                 | 2019-20         |
| 2019-07-05 00:00:00.000 |                      1 | Jul                       | Q1                 | 2019-20         |
| 2019-07-06 00:00:00.000 |                      1 | Jul                       | Q1                 | 2019-20         |
| 2019-07-07 00:00:00.000 |                      1 | Jul                       | Q1                 | 2019-20         |
| 2019-07-08 00:00:00.000 |                      1 | Jul                       | Q1                 | 2019-20         |
| 2019-07-09 00:00:00.000 |                      1 | Jul                       | Q1                 | 2019-20         |
| 2019-07-10 00:00:00.000 |                      1 | Jul                       | Q1                 | 2019-20         |


Table: FinancialData
| Cost Centre Key   |   Standard Class Key | Description        | Scenario   | Date                    |   Amount |
|:------------------|---------------------:|:-------------------|:-----------|:------------------------|---------:|
| 504F2T101         |               339491 | PABX NETWORK VOICE | BU         | 2020-07-01 00:00:00.000 |      100 |
| 505D3D112         |               339491 | PABX NETWORK VOICE | BU         | 2020-07-01 00:00:00.000 |      100 |
| 505C1D104         |               339491 | PABX NETWORK VOICE | BU         | 2020-07-01 00:00:00.000 |      100 |
| 504E1D101         |               339491 | PABX NETWORK VOICE | BU         | 2020-07-01 00:00:00.000 |      100 |
| 505C1D111         |               339491 | PABX NETWORK VOICE | BU         | 2020-07-01 00:00:00.000 |      100 |
| 505C1D112         |               339491 | PABX NETWORK VOICE | BU         | 2020-07-01 00:00:00.000 |      100 |
| 504F2D110         |               339491 | PABX NETWORK VOICE | BU         | 2020-07-01 00:00:00.000 |      100 |
| 502J1A101         |               339491 | PABX NETWORK VOICE | BU         | 2020-07-01 00:00:00.000 |      100 |
| 504E2D101         |               339491 | PABX NETWORK VOICE | BU         | 2020-07-01 00:00:00.000 |      100 |
| 504C1K101         |               339491 | PABX NETWORK VOICE | BU         | 2020-07-01 00:00:00.000 |      100 |


Table: Key Measures - Harsh



Table: PeriodCalculation
| Period Calculation   |   CalcID |
|:---------------------|---------:|
| MTD                  |        1 |
| YTD                  |        2 |
| FY                   |        3 |


Table: Scenario
| Scenario   |
|:-----------|
| AC         |
| FC         |
| BU         |


Table: TimeStamp
| TimeStamp               |
|:------------------------|
| 2021-11-23 13:44:07.350 |

 


tables: name: Chart of Account V2
data: Chart of Account V2.csv
name: Comments
data: Comments.csv
name: Cost Centre V2
data: Cost Centre V2.csv
name: CurrencyMetric
data: CurrencyMetric.csv
name: Date
data: Date.csv
name: FinancialData
data: FinancialData.csv
name: Key Measures - Harsh
data: Key Measures - Harsh.csv
name: PeriodCalculation
data: PeriodCalculation.csv
name: Scenario
data: Scenario.csv
name: TimeStamp
data: TimeStamp.csv
label: FinancialData
Date
Date
Date
FinancialData
Standard Class Key
Chart of Account V2
Standard Class Key
FinancialData
Cost Centre Key
Cost Centre V2
Cost Centre Key
FinancialData
Scenario
Scenario
Scenario
Comments
Date
Date
Date
Comments
Standard Class Key
Chart of Account V2
Standard Class Key
output: {
    "joins": [
        {
            "from_table": "FinancialData",
            "from_column": "Date",
            "to_table": "Date",
            "to_column": "Date"
        },
        {
            "from_table": "FinancialData",
            "from_column": "Standard Class Key",
            "to_table": "Chart of Account V2",
            "to_column": "Standard Class Key"
        },
        {
            "from_table": "FinancialData",
            "from_column": "Cost Centre Key",
            "to_table": "Cost Centre V2",
            "to_column": "Cost Centre Key"
        },
        {
            "from_table": "FinancialData",
            "from_column": "Scenario",
            "to_table": "Scenario",
            "to_column": "Scenario"
        },
        {
            "from_table": "Comments",
            "from_column": "Date",
            "to_table": "Date",
            "to_column": "Date"
        },
        {
            "from_table": "Comments",
            "from_column": "Standard Class Key",
            "to_table": "Chart of Account V2",
            "to_column": "Standard Class Key"
        }
    ]
}