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: Post Product Release Defect Tracking
| Issue key   | Priority   | Summary                                                                                                                | Assignee   | Reporter        | Status   | Fix Version/s   | Fix Version/s_1   | Affects Version/s   | Affects Version/s_22   | Affects Version/s_23   | Component             | Component/s_43   | Found in Build   | Created                 | Resolution   |   Major_Release |
|:------------|:-----------|:-----------------------------------------------------------------------------------------------------------------------|:-----------|:----------------|:---------|:----------------|:------------------|:--------------------|:-----------------------|:-----------------------|:----------------------|:-----------------|:-----------------|:------------------------|:-------------|----------------:|
| PLAT-20478  | 3 - Medium | CLONE - Modifying user queue's displays 'no rows found' till you press the username hyperlink                          | Pnolan     | jacquelynmurphy | New      |                 |                   | 7.2.                |                        |                        | Workflow Configurator |                  | 7.2.1.8          | 2016-12-13 00:05:00.000 |              |             7.2 |
| PLAT-20486  | 3 - Medium | Interactive list section does not resize when filters are hidden.                                                      | Pnolan     | EFitzgerald     | New      |                 |                   | 7.3.1               |                        |                        | Application Builder   |                  | 12356            | 2016-12-16 14:54:00.000 |              |             7.3 |
| PLAT-20618  | 3 - Medium | CLONE - When importing Queuing&Routing configuration, the the list of users subscribed to a queue is not being updated | Pnolan     | kslawinski      | New      |                 |                   | 7.2.                |                        |                        | Administration        |                  | 7.2.0.14         | 2017-02-01 08:39:00.000 |              |             7.2 |
| PLAT-20630  | 3 - Medium | Attach file - error during Workflow action 'EIM__uAttachFile'                                                          | Pnolan     | KWeclewski      | New      |                 |                   | 7.3.1               |                        |                        | Other                 |                  | 7.3.1.0-a7       | 2017-02-08 14:06:00.000 |              |             7.3 |
| PLAT-20681  | 3 - Medium | CLONE - Au-2298 - FRD_AIB_005 - Active Fraud Alert by Reporting Location - The summary view is incorrect               | Pnolan     | vanjabecirovic  | New      |                 |                   | 7.1.1               |                        |                        | Application Builder   |                  | 7.1.1.9          | 2017-02-13 14:33:00.000 |              |             7.1 |
| PLAT-20688  | 3 - Medium | Null Pointer Exception in screenHelper.getScreen(StringUtil.isEmpty(screenId)                                          | Pnolan     | JSchweiss       | New      |                 |                   | 7.1.1               |                        |                        | Application Builder   |                  | 7.1.1.8          | 2017-02-15 08:41:00.000 |              |             7.1 |
| PLAT-20700  | 3 - Medium | CLONE - Files in Platform and in services are checked-in with cp1252 enhcoding instead of UTF-8.                       | Pnolan     | RHome           | New      |                 |                   | 7.3                 |                        |                        | Other                 |                  | 7.2.1.9          | 2017-02-17 11:09:00.000 |              |             7.2 |
| PLAT-20710  | 3 - Medium | CLONE - Characters ">" and "<" are getting displayed as "&gt;" and "&lt;" in slave combo boxes                         | Pnolan     | bgovindula      | New      |                 |                   | 7.2.                |                        |                        | Application Builder   |                  | 7.2.1.26         | 2017-02-20 19:49:00.000 |              |             7.2 |
| PLAT-20749  | 3 - Medium | Inconsistant Rendering by field-formatters                                                                             | Pnolan     | NBresnan        | New      |                 |                   | 7.1.1               |                        |                        | Application Builder   |                  | 7.1.1.2          | 2017-03-01 14:10:00.000 |              |             7.1 |
| PLAT-20752  | 3 - Medium | Default search indexes build into application_home/fts                                                                 | Pnolan     | CMurphy         | New      |                 |                   | 7.2.1               |                        |                        | NR Search             |                  | 7.2.1.47         | 2017-03-01 16:33:00.000 |              |             7.2 |


Table: Product_Components
| Component           | Mapped Component     | Location   |
|:--------------------|:---------------------|:-----------|
| Administration      | Administration       | Malaysia   |
| Application Builder | Application Builder  | Ireland    |
| Base Platform       | Base Platform        | Ireland    |
| Batch Bridge        | Base Platform        | Ireland    |
| Build Process       | Base Platform        | Ireland    |
| CDD                 | Workflow Configuator | Poland     |
| Command and Control | Base Platform        | Ireland    |
| Database            | Base Platform        | Ireland    |
| NR Azure            | NR Azure             | England    |
| NR Search           | NR Search            | England    |


Table: ReleaseAutomation
|   Release |   Total Test Cases |   Manual |   Automated |
|----------:|-------------------:|---------:|------------:|
|       7.3 |               1000 |      890 |         110 |
|       7.4 |               1411 |     1069 |         342 |
|       7.5 |               1400 |      819 |         581 |
|       7.6 |               2198 |      825 |        1373 |
|       7.7 |               2562 |      418 |        2144 |
|       8   |               4135 |      920 |        3215 |
|       8.1 |               9093 |     1382 |        7711 |


Table: ReleaseDates
|   Release | Release Date            | Period 1 End Date       | Period 2 End Date       |
|----------:|:------------------------|:------------------------|:------------------------|
|       7.3 | 2016-12-12 00:00:00.000 | 2017-05-26 00:00:00.000 | 2017-12-22 00:00:00.000 |
|       7.4 | 2017-06-30 00:00:00.000 | 2017-12-01 00:00:00.000 | 2018-06-01 00:00:00.000 |
|       7.5 | 2017-12-01 00:00:00.000 | 2018-04-27 00:00:00.000 | 2018-12-07 00:00:00.000 |
|       7.6 | 2018-06-28 00:00:00.000 | 2018-11-30 00:00:00.000 | 2019-06-28 00:00:00.000 |
|       7.7 | 2018-12-13 00:00:00.000 | 2019-05-31 00:00:00.000 | 2019-12-20 00:00:00.000 |
|       8   | 2019-03-13 00:00:00.000 | 2019-08-28 00:00:00.000 | 2020-03-12 00:00:00.000 |
|       8.1 | 2020-02-21 00:00:00.000 | 2020-07-31 00:00:00.000 | 2021-02-26 00:00:00.000 |


Table: Release_Five
|   Release | Component            |   Development Defect Numbers |   % of Total |
|----------:|:---------------------|-----------------------------:|-------------:|
|       7.7 | Administration       |                            4 |   0.0245399  |
|       7.7 | Application Builder  |                           69 |   0.423313   |
|       7.7 | Other                |                            2 |   0.0122699  |
|       7.7 | NR Search            |                            1 |   0.00613497 |
|       7.7 | NR Azure             |                            0 |   0          |
|       7.7 | Scenario Manager     |                           52 |   0.319018   |
|       7.7 | Base Platform        |                            6 |   0.0368098  |
|       7.7 | Watchlist Manager    |                           29 |   0.177914   |
|       7.7 | Workflow Configuator |                            0 |   0          |


Table: Release_Four
|   Release | Component            |   Development Defect Numbers |   % of Total |
|----------:|:---------------------|-----------------------------:|-------------:|
|       7.6 | Administration       |                            0 |     0        |
|       7.6 | Application Builder  |                           57 |     0.407143 |
|       7.6 | Other                |                            0 |     0        |
|       7.6 | NR Search            |                            0 |     0        |
|       7.6 | NR Azure             |                            0 |     0        |
|       7.6 | Scenario Manager     |                           30 |     0.214286 |
|       7.6 | Base Platform        |                            0 |     0        |
|       7.6 | Watchlist Manager    |                           53 |     0.378571 |
|       7.6 | Workflow Configuator |                            0 |     0        |


Table: Release_One
|   Release | Component            |   Development Defect Numbers |   % of Total |
|----------:|:---------------------|-----------------------------:|-------------:|
|       7.3 | Administration       |                           14 |    0.0721649 |
|       7.3 | Application Builder  |                          150 |    0.773196  |
|       7.3 | Other                |                            2 |    0.0103093 |
|       7.3 | NR Search            |                            2 |    0.0103093 |
|       7.3 | NR Azure             |                            0 |    0         |
|       7.3 | Scenario Manager     |                            6 |    0.0309278 |
|       7.3 | Base Platform        |                            3 |    0.0154639 |
|       7.3 | Watchlist Manager    |                           11 |    0.056701  |
|       7.3 | Workflow Configuator |                            6 |    0.0309278 |


Table: Release_Seven
|   Release | Component            |   Development Defect Numbers |   % of Total |
|----------:|:---------------------|-----------------------------:|-------------:|
|       8.1 | Administration       |                            3 |   0.011236   |
|       8.1 | Application Builder  |                          106 |   0.397004   |
|       8.1 | Other                |                            8 |   0.0299625  |
|       8.1 | NR Search            |                            1 |   0.00374532 |
|       8.1 | NR Azure             |                            0 |   0          |
|       8.1 | Scenario Manager     |                           77 |   0.28839    |
|       8.1 | Base Platform        |                           35 |   0.131086   |
|       8.1 | Watchlist Manager    |                           37 |   0.138577   |
|       8.1 | Workflow Configuator |                            0 |   0          |


Table: Release_Six
|   Release | Component            |   Development Defect Numbers |   % of Total |
|----------:|:---------------------|-----------------------------:|-------------:|
|         8 | Administration       |                            2 |    0.0141844 |
|         8 | Application Builder  |                           70 |    0.496454  |
|         8 | Other                |                            4 |    0.0283688 |
|         8 | NR Search            |                            2 |    0.0141844 |
|         8 | NR Azure             |                            0 |    0         |
|         8 | Scenario Manager     |                           31 |    0.219858  |
|         8 | Base Platform        |                           15 |    0.106383  |
|         8 | Watchlist Manager    |                           17 |    0.120567  |
|         8 | Workflow Configuator |                            0 |    0         |


Table: Release_Three
|   Release | Component            |   Development Defect Numbers |   % of Total |
|----------:|:---------------------|-----------------------------:|-------------:|
|       7.5 | Administration       |                            8 |    0.0909091 |
|       7.5 | Application Builder  |                           29 |    0.329545  |
|       7.5 | Other                |                            9 |    0.102273  |
|       7.5 | NR Search            |                            3 |    0.0340909 |
|       7.5 | NR Azure             |                            0 |    0         |
|       7.5 | Scenario Manager     |                            2 |    0.0227273 |
|       7.5 | Base Platform        |                            8 |    0.0909091 |
|       7.5 | Watchlist Manager    |                           27 |    0.306818  |
|       7.5 | Workflow Configuator |                            2 |    0.0227273 |


Table: Release_Two
|   Release | Component            |   Development Defect Numbers |   % of Total |
|----------:|:---------------------|-----------------------------:|-------------:|
|       7.4 | Administration       |                            2 |    0.0224719 |
|       7.4 | Application Builder  |                           34 |    0.382022  |
|       7.4 | Other                |                            5 |    0.0561798 |
|       7.4 | NR Search            |                            2 |    0.0224719 |
|       7.4 | NR Azure             |                            0 |    0         |
|       7.4 | Scenario Manager     |                            3 |    0.0337079 |
|       7.4 | Base Platform        |                            0 |    0         |
|       7.4 | Watchlist Manager    |                           41 |    0.460674  |
|       7.4 | Workflow Configuator |                            2 |    0.0224719 |

 


tables: name: Post Product Release Defect Tracking
data: Post Product Release Defect Tracking.csv
name: Product_Components
data: Product_Components.csv
name: ReleaseAutomation
data: ReleaseAutomation.csv
name: ReleaseDates
data: ReleaseDates.csv
name: Release_Five
data: Release_Five.csv
name: Release_Four
data: Release_Four.csv
name: Release_One
data: Release_One.csv
name: Release_Seven
data: Release_Seven.csv
name: Release_Six
data: Release_Six.csv
name: Release_Three
data: Release_Three.csv
name: Release_Two
data: Release_Two.csv
label: Release_One
Release
ReleaseDates
Release
Release_Two
Release
ReleaseDates
Release
Release_Three
Release
ReleaseDates
Release
Release_Four
Release
ReleaseDates
Release
Release_Five
Release
ReleaseDates
Release
Release_Six
Release
ReleaseDates
Release
Release_Seven
Release
ReleaseDates
Release
Release_One
Component
Product_Components
Component
ReleaseAutomation
Release
ReleaseDates
Release
Post Product Release Defect Tracking
Component
Product_Components
Component
output: {
    "joins": [
        {
            "from_table": "Release_One",
            "from_column": "Release",
            "to_table": "ReleaseDates",
            "to_column": "Release"
        },
        {
            "from_table": "Release_Two",
            "from_column": "Release",
            "to_table": "ReleaseDates",
            "to_column": "Release"
        },
        {
            "from_table": "Release_Three",
            "from_column": "Release",
            "to_table": "ReleaseDates",
            "to_column": "Release"
        },
        {
            "from_table": "Release_Four",
            "from_column": "Release",
            "to_table": "ReleaseDates",
            "to_column": "Release"
        },
        {
            "from_table": "Release_Five",
            "from_column": "Release",
            "to_table": "ReleaseDates",
            "to_column": "Release"
        },
        {
            "from_table": "Release_Six",
            "from_column": "Release",
            "to_table": "ReleaseDates",
            "to_column": "Release"
        },
        {
            "from_table": "Release_Seven",
            "from_column": "Release",
            "to_table": "ReleaseDates",
            "to_column": "Release"
        },
        {
            "from_table": "Release_One",
            "from_column": "Component",
            "to_table": "Product_Components",
            "to_column": "Component"
        },
        {
            "from_table": "ReleaseAutomation",
            "from_column": "Release",
            "to_table": "ReleaseDates",
            "to_column": "Release"
        },
        {
            "from_table": "Post Product Release Defect Tracking",
            "from_column": "Component",
            "to_table": "Product_Components",
            "to_column": "Component"
        }
    ]
}