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: lmiroic android_version
|   idandroid_version | android_version    |
|--------------------:|:-------------------|
|                   1 | 4.0.3 and up       |
|                   2 | 4.2 and up         |
|                   3 | 4.4 and up         |
|                   4 | 2.3 and up         |
|                   5 | 3.0 and up         |
|                   6 | 4.1 and up         |
|                   7 | 4.0 and up         |
|                   8 | 2.3.3 and up       |
|                   9 | Varies with device |
|                  10 | 2.2 and up         |


Table: lmiroic app
|   idapp | app                                                         | installs   |   reviews |
|--------:|:------------------------------------------------------------|:-----------|----------:|
|       8 | Infinite Painter                                            | 1,000,000+ |     36815 |
|       9 | Garden Coloring Book                                        | 1,000,000+ |     13791 |
|      11 | Text on Photo - Fonteee                                     | 1,000,000+ |     13880 |
|      12 | Name Art Photo Editor - Focus n Filters                     | 1,000,000+ |      8788 |
|      50 | Real Tractor Farming                                        | 1,000,000+ |      1598 |
|      52 | Used Cars and Trucks for Sale                               | 1,000,000+ |     17057 |
|      62 | ezETC (ETC balance inquiry, meter trial, real-time traffic) | 1,000,000+ |     38846 |
|      77 | Police Detector (Speed Camera Radar)                        | 1,000,000+ |      3574 |
|      79 | Tickets + PDA 2018 Exam                                     | 1,000,000+ |    197136 |
|      81 | PakWheels: Buy & Sell Cars                                  | 1,000,000+ |     15168 |


Table: lmiroic apps_facts
|   idapps_facts |   idapp |   idcategory |   idrating |   idsize |   idandroid_version | current_ver        |
|---------------:|--------:|-------------:|-----------:|---------:|--------------------:|:-------------------|
|             37 |      37 |            1 |          1 |       29 |                   8 | Varies with device |
|             42 |      42 |            1 |          6 |       29 |                   9 | Varies with device |
|             52 |      52 |            2 |          9 |       29 |                   9 | Varies with device |
|             67 |      67 |            2 |          5 |       29 |                   9 | Varies with device |
|             68 |      68 |            2 |          2 |       29 |                   9 | Varies with device |
|             73 |      73 |            2 |         12 |       29 |                   8 | 2.9                |
|             85 |      85 |            2 |          6 |       29 |                   9 | Varies with device |
|             88 |      88 |            2 |          9 |       29 |                   9 | Varies with device |
|             89 |      89 |            2 |          9 |       29 |                   9 | 4.6.5              |
|             92 |      92 |            2 |          9 |       29 |                   1 | Varies with device |


Table: lmiroic category
|   idcategory | category            |
|-------------:|:--------------------|
|            1 | ART_AND_DESIGN      |
|            2 | AUTO_AND_VEHICLES   |
|            3 | BEAUTY              |
|            4 | BOOKS_AND_REFERENCE |
|            5 | BUSINESS            |


Table: lmiroic dataset
|   App |   Category |   Rating |   Reviews |   Size | Installs   | Type   |   Price | Content_Rating   | Genres                    | Last Updated       | Current_Ver   |   Android_Ver |
|------:|-----------:|---------:|----------:|-------:|:-----------|:-------|--------:|:-----------------|:--------------------------|:-------------------|:--------------|--------------:|
|     1 |          1 |        1 |       159 |      1 | 10,000+    | Free   |       0 | Everyone         | Art & Design              | January 7, 2018    | 1.0.0         |             1 |
|     2 |          1 |        2 |       967 |      2 | 500,000+   | Free   |       0 | Everyone         | Art & Design;Pretend Play | January 15, 2018   | 2.0.0         |             1 |
|     3 |          1 |        3 |     87510 |      3 | 5,000,000+ | Free   |       0 | Everyone         | Art & Design              | August 1, 2018     | 1.2.4         |             1 |
|     5 |          1 |        5 |       967 |      5 | 100,000+   | Free   |       0 | Everyone         | Art & Design;Creativity   | June 20, 2018      | 1.1           |             3 |
|     6 |          1 |        6 |       167 |      6 | 50,000+    | Free   |       0 | Everyone         | Art & Design              | March 26, 2017     | 1.0           |             4 |
|     7 |          1 |        7 |       178 |      1 | 50,000+    | Free   |       0 | Everyone         | Art & Design              | April 26, 2018     | 1.1           |             1 |
|     8 |          1 |        1 |     36815 |      7 | 1,000,000+ | Free   |       0 | Everyone         | Art & Design              | June 14, 2018      | 6.1.61.1      |             2 |
|     9 |          1 |        6 |     13791 |      8 | 1,000,000+ | Free   |       0 | Everyone         | Art & Design              | September 20, 2017 | 2.9.2         |             5 |
|    10 |          1 |        3 |       121 |      9 | 10,000+    | Free   |       0 | Everyone         | Art & Design;Creativity   | July 3, 2018       | 2.8           |             1 |
|    11 |          1 |        6 |     13880 |     10 | 1,000,000+ | Free   |       0 | Everyone         | Art & Design              | October 27, 2017   | 1.0.4         |             6 |


Table: lmiroic rating
|   idrating |   rating |
|-----------:|---------:|
|          1 |      4.1 |
|          2 |      3.9 |
|          3 |      4.7 |
|          4 |      4.5 |
|          5 |      4.3 |
|          6 |      4.4 |
|          7 |      3.8 |
|          8 |      4.2 |
|          9 |      4.6 |
|         10 |      3.2 |


Table: lmiroic size
|   idsize | size   |
|---------:|:-------|
|        1 | 19M    |
|        2 | 14M    |
|        3 | 8.7M   |
|        4 | 25M    |
|        5 | 2.8M   |
|        6 | 5.6M   |
|        7 | 29M    |
|        8 | 33M    |
|        9 | 3.1M   |
|       10 | 28M    |

 


tables: name: lmiroic android_version
data: lmiroic android_version.csv
name: lmiroic app
data: lmiroic app.csv
name: lmiroic apps_facts
data: lmiroic apps_facts.csv
name: lmiroic category
data: lmiroic category.csv
name: lmiroic dataset
data: lmiroic dataset.csv
name: lmiroic rating
data: lmiroic rating.csv
name: lmiroic size
data: lmiroic size.csv
label: lmiroic apps_facts
idandroid_version
lmiroic android_version
idandroid_version
lmiroic apps_facts
idapp
lmiroic app
idapp
lmiroic apps_facts
idcategory
lmiroic category
idcategory
lmiroic apps_facts
idrating
lmiroic rating
idrating
lmiroic apps_facts
idsize
lmiroic size
idsize
output: {
    "joins": [
        {
            "from_table": "lmiroic apps_facts",
            "from_column": "idandroid_version",
            "to_table": "lmiroic android_version",
            "to_column": "idandroid_version"
        },
        {
            "from_table": "lmiroic apps_facts",
            "from_column": "idapp",
            "to_table": "lmiroic app",
            "to_column": "idapp"
        },
        {
            "from_table": "lmiroic apps_facts",
            "from_column": "idcategory",
            "to_table": "lmiroic category",
            "to_column": "idcategory"
        },
        {
            "from_table": "lmiroic apps_facts",
            "from_column": "idrating",
            "to_table": "lmiroic rating",
            "to_column": "idrating"
        },
        {
            "from_table": "lmiroic apps_facts",
            "from_column": "idsize",
            "to_table": "lmiroic size",
            "to_column": "idsize"
        }
    ]
}