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: AccountCategory-1
| Level Name                |   Level Index |
|:--------------------------|--------------:|
| ASSETS                    |             0 |
| Cash & Equivalents        |             1 |
| Cash                      |             2 |
| Bank                      |             7 |
| Accounts Receivable       |            19 |
| Trade Receivables         |            20 |
| Due from Third Parties    |            21 |
| Due from Group Companies  |            26 |
| Other Current Receivables |            28 |
| Due from Third Parties    |            29 |


Table: AccountCategory-2
| Level Name                |   Level Index |
|:--------------------------|--------------:|
| ASSETS                    |             0 |
| Cash & Equivalents        |             1 |
| Cash                      |             2 |
| Bank                      |             7 |
| Accounts Receivable       |            19 |
| Trade Receivables         |            20 |
| Due from Third Parties    |            21 |
| Due from Group Companies  |            26 |
| Other Current Receivables |            28 |
| Due from Third Parties    |            29 |


Table: AccountCategory-3
| Level Name                |   Level Index |
|:--------------------------|--------------:|
| ASSETS                    |             0 |
| Cash & Equivalents        |             1 |
| Cash                      |             2 |
| Bank                      |             7 |
| Accounts Receivable       |            19 |
| Trade Receivables         |            20 |
| Due from Third Parties    |            21 |
| Due from Group Companies  |            26 |
| Other Current Receivables |            28 |
| Due from Third Parties    |            29 |


Table: AccountCategory-4
| Level Name                |   Level Index |
|:--------------------------|--------------:|
| ASSETS                    |             0 |
| Cash & Equivalents        |             1 |
| Cash                      |             2 |
| Bank                      |             7 |
| Accounts Receivable       |            19 |
| Trade Receivables         |            20 |
| Due from Third Parties    |            21 |
| Due from Group Companies  |            26 |
| Other Current Receivables |            28 |
| Due from Third Parties    |            29 |


Table: AccountName
|   Name | Level Name                                         |   Level Index |
|-------:|:---------------------------------------------------|--------------:|
|      1 | Treatement of applications income                  |           163 |
|      1 | Joint application development income               |           164 |
|      1 | Joint application development income (Treatements) |           165 |
|      1 | Air Purification Filter                            |           166 |
|      1 | Fabric -Sales                                      |           167 |
|      1 | Saafkins                                           |           168 |
|      1 | Water Filter                                       |           169 |
|      1 | Face Mask                                          |           170 |
|      1 | Face Mask  RM Sales                                |           171 |
|      1 | Computers & Printer Scrap Sale                     |           172 |


Table: Company
| Company   | Currency   | Date                    |            Value |   FX Rate | Level Index   | Value CHF (BS)   | Value CHF (PL)   |
|:----------|:-----------|:------------------------|-----------------:|----------:|:--------------|:-----------------|:-----------------|
| Company 1 | INR        | 2019-12-31 00:00:00.000 | 155543           |         1 |               |                  |                  |
| Company 1 | INR        | 2019-12-31 00:00:00.000 |      3.05367e+06 |         1 |               |                  |                  |
| Company 1 | INR        | 2019-12-31 00:00:00.000 |      3.70373e+06 |         1 |               |                  |                  |
| Company 1 | INR        | 2019-12-31 00:00:00.000 |      1.5798e+06  |         1 |               |                  |                  |
| Company 1 | INR        | 2019-12-31 00:00:00.000 |      1.485e+06   |         1 |               |                  |                  |
| Company 1 | INR        | 2019-12-31 00:00:00.000 |      1.92033e+06 |         1 |               |                  |                  |
| Company 1 | INR        | 2019-12-31 00:00:00.000 |      1.11483e+06 |         1 |               |                  |                  |
| Company 1 | INR        | 2019-12-31 00:00:00.000 |      1.82967e+06 |         1 |               |                  |                  |
| Company 1 | INR        | 2019-12-31 00:00:00.000 | 946415           |         1 |               |                  |                  |
| Company 1 | INR        | 2019-12-31 00:00:00.000 |      1.31415e+06 |         1 |               |                  |                  |


Table: Hirerchy
|   Level Index |   Branch-1 |   Branch-2 |   Branch-3 | Branch-4   |
|--------------:|-----------:|-----------:|-----------:|:-----------|
|           251 |        250 |        249 |        248 |            |
|           252 |        250 |        249 |        248 |            |
|           253 |        250 |        249 |        248 |            |
|           254 |        250 |        249 |        248 |            |
|           256 |        255 |        249 |        248 |            |
|           257 |        255 |        249 |        248 |            |
|           258 |        255 |        249 |        248 |            |
|           259 |        255 |        249 |        248 |            |
|           260 |        255 |        249 |        248 |            |
|           261 |        255 |        249 |        248 |            |


Table: Note
| Note                                                                                        |
|:--------------------------------------------------------------------------------------------|
| Sanitation Issue :                                                                          |
| Company 2 (1).xlsx, Column1 Name corrected from <<Company Name>> to <<Company>>             |
| Group Profit & Loss (1).xlsx, Financial Income--> Other interest expense this is suspicious |


Table: Report Type
| Initial   |   Report Index | Description   |
|:----------|---------------:|:--------------|
| BS        |             -1 | Balance Sheet |
| PL        |              1 | Profit Loss   |

 


tables: name: AccountCategory-1
data: AccountCategory-1.csv
name: AccountCategory-2
data: AccountCategory-2.csv
name: AccountCategory-3
data: AccountCategory-3.csv
name: AccountCategory-4
data: AccountCategory-4.csv
name: AccountName
data: AccountName.csv
name: Company
data: Company.csv
name: Hirerchy
data: Hirerchy.csv
name: Note
data: Note.csv
name: Report Type
data: Report Type.csv
label: AccountName
Level Index
Hirerchy
Level Index
Hirerchy
Branch-4
AccountCategory-4
Level Index
Hirerchy
Branch-3
AccountCategory-3
Level Index
Hirerchy
Branch-2
AccountCategory-2
Level Index
Hirerchy
Branch-1
AccountCategory-1
Level Index
AccountName
Name
Report Type
Report Index
Company
Level Index
Hirerchy
Level Index
output: {
    "joins": [
        {
            "from_table": "AccountName",
            "from_column": "Level Index",
            "to_table": "Hirerchy",
            "to_column": "Level Index"
        },
        {
            "from_table": "Hirerchy",
            "from_column": "Branch-4",
            "to_table": "AccountCategory-4",
            "to_column": "Level Index"
        },
        {
            "from_table": "Hirerchy",
            "from_column": "Branch-3",
            "to_table": "AccountCategory-3",
            "to_column": "Level Index"
        },
        {
            "from_table": "Hirerchy",
            "from_column": "Branch-2",
            "to_table": "AccountCategory-2",
            "to_column": "Level Index"
        },
        {
            "from_table": "Hirerchy",
            "from_column": "Branch-1",
            "to_table": "AccountCategory-1",
            "to_column": "Level Index"
        },
        {
            "from_table": "AccountName",
            "from_column": "Name",
            "to_table": "Report Type",
            "to_column": "Report Index"
        },
        {
            "from_table": "Company",
            "from_column": "Level Index",
            "to_table": "Hirerchy",
            "to_column": "Level Index"
        }
    ]
}