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: hdbk d_artikul
|   id_artikul |   num_artikul | name_divan   |
|-------------:|--------------:|:-------------|
|            1 |         95068 | АРГО-1       |
|            2 |        207451 | ПАРМА-1      |
|            3 |        165312 | РИО          |
|            4 |        101784 | АМИТА        |
|            5 |        169562 | АГАТ         |
|            6 |        207452 | ПАРМА-2      |
|            7 |        214658 | ФОРУМ        |
|            8 |        200810 | РАДУГА       |
|            9 |        164146 | ФЕДЕРИКО     |
|           10 |        175654 | ВЕГА-ЛАМИНО  |


Table: hdbk d_pricecurrency
|   id_pricecurrency | name_pricecurrency   |
|-------------------:|:---------------------|
|                  1 | RUB                  |


Table: hdbk d_stock
|   id_in_stock | name_in_stock   |
|--------------:|:----------------|
|             1 | под заказ       |
|             2 | доступно        |
|             3 | в пути          |


Table: product t_divan
|   id_divan |   id_divan_from_source |   id_artikul |   id_in_stock |   price |   price_discount |   id_pricecurrency | date_snap               | Price Band    | is_actual   |   Ранг_срцены_артикул |   ср.цена по артикулу |
|-----------:|-----------------------:|-------------:|--------------:|--------:|-----------------:|-------------------:|:------------------------|:--------------|:------------|----------------------:|----------------------:|
|         60 |                1064941 |            2 |             2 |   19990 |            19990 |                  1 | 2021-09-19 01:22:06.516 | 17990 - 23190 | True        |                   132 |                 21415 |
|         61 |                1087271 |            5 |             2 |   23990 |            23990 |                  1 | 2021-09-19 01:22:06.516 | 23190 - 28390 | True        |                   129 |                 23990 |
|         62 |                1046675 |            7 |             2 |   25690 |            25690 |                  1 | 2021-09-19 01:22:06.516 | 23190 - 28390 | True        |                   127 |                 25690 |
|         63 |                1053230 |            9 |             2 |   25990 |            25990 |                  1 | 2021-09-19 01:22:06.516 | 23190 - 28390 | True        |                   125 |                 25990 |
|         64 |                1083183 |           10 |             2 |   26290 |            26290 |                  1 | 2021-09-19 01:22:06.516 | 23190 - 28390 | True        |                   124 |                 26290 |
|         65 |                1087132 |           11 |             2 |   26990 |            26990 |                  1 | 2021-09-19 01:22:06.516 | 23190 - 28390 | True        |                   122 |                 27990 |
|         66 |                1087134 |           11 |             2 |   26990 |            26990 |                  1 | 2021-09-19 01:22:06.516 | 23190 - 28390 | True        |                   122 |                 27990 |
|         67 |                1087543 |           11 |             2 |   26990 |            26990 |                  1 | 2021-09-19 01:22:06.516 | 23190 - 28390 | True        |                   122 |                 27990 |
|         68 |                 988550 |           11 |             2 |   28990 |            28990 |                  1 | 2021-09-19 01:22:06.516 | 28390 - 33590 | True        |                   122 |                 27990 |
|         69 |                1032274 |           12 |             2 |   27590 |            27590 |                  1 | 2021-09-19 01:22:06.516 | 23190 - 28390 | True        |                   123 |                 27590 |

 


tables: name: hdbk d_artikul
data: hdbk d_artikul.csv
name: hdbk d_pricecurrency
data: hdbk d_pricecurrency.csv
name: hdbk d_stock
data: hdbk d_stock.csv
name: product t_divan
data: product t_divan.csv
label: product t_divan
id_artikul
hdbk d_artikul
id_artikul
product t_divan
id_pricecurrency
hdbk d_pricecurrency
id_pricecurrency
product t_divan
id_in_stock
hdbk d_stock
id_in_stock
output: {
    "joins": [
        {
            "from_table": "product t_divan",
            "from_column": "id_artikul",
            "to_table": "hdbk d_artikul",
            "to_column": "id_artikul"
        },
        {
            "from_table": "product t_divan",
            "from_column": "id_pricecurrency",
            "to_table": "hdbk d_pricecurrency",
            "to_column": "id_pricecurrency"
        },
        {
            "from_table": "product t_divan",
            "from_column": "id_in_stock",
            "to_table": "hdbk d_stock",
            "to_column": "id_in_stock"
        }
    ]
}