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: CD_Age
| cd_from   | cd_to       | cd_from_to            | is_chronic_path   | gender   | age_group   |   instance |   age_group_sort |   instance_ratio |   instance_ratio_from | image_from                                                            | image_to                                                                  | Probability_Instance   | Probability_Instance_from   |
|:----------|:------------|:----------------------|:------------------|:---------|:------------|-----------:|-----------------:|-----------------:|----------------------:|:----------------------------------------------------------------------|:--------------------------------------------------------------------------|:-----------------------|:----------------------------|
| Alcohol   | C           | Alcohol-->C           | False             | M        | < 40        |          1 |                2 |             0.06 |                 0.855 | https://www.aiinsights.solutions.iqvia.com/images/disease/Alcohol.jpg | https://www.aiinsights.solutions.iqvia.com/images/disease/C.jpg           | Prob: 0.06%            | Prob: 0.855%                |
| Alcohol   | D           | Alcohol-->D           | False             | M        | < 40        |          1 |                2 |             0.06 |                 0.855 | https://www.aiinsights.solutions.iqvia.com/images/disease/Alcohol.jpg | https://www.aiinsights.solutions.iqvia.com/images/disease/D.jpg           | Prob: 0.06%            | Prob: 0.855%                |
| Alcohol   | G           | Alcohol-->G           | False             | M        | < 40        |          1 |                2 |             0.06 |                 0.855 | https://www.aiinsights.solutions.iqvia.com/images/disease/Alcohol.jpg | https://www.aiinsights.solutions.iqvia.com/images/disease/G.jpg           | Prob: 0.06%            | Prob: 0.855%                |
| Alcohol   | Hypothyroid | Alcohol-->Hypothyroid | False             | M        | < 40        |          1 |                2 |             0.06 |                 0.855 | https://www.aiinsights.solutions.iqvia.com/images/disease/Alcohol.jpg | https://www.aiinsights.solutions.iqvia.com/images/disease/Hypothyroid.jpg | Prob: 0.06%            | Prob: 0.855%                |
| Anemia    | CKD         | Anemia-->CKD          | False             | M        | < 40        |          1 |                2 |             0.06 |                10     | https://www.aiinsights.solutions.iqvia.com/images/disease/Anemia.jpg  | https://www.aiinsights.solutions.iqvia.com/images/disease/CKD.jpg         | Prob: 0.06%            | Prob: 10%                   |
| Anemia    | COPD        | Anemia-->COPD         | False             | M        | < 40        |          1 |                2 |             0.06 |                10     | https://www.aiinsights.solutions.iqvia.com/images/disease/Anemia.jpg  | https://www.aiinsights.solutions.iqvia.com/images/disease/COPD.jpg        | Prob: 0.06%            | Prob: 10%                   |
| Anemia    | D           | Anemia-->D            | False             | M        | < 40        |          1 |                2 |             0.06 |                10     | https://www.aiinsights.solutions.iqvia.com/images/disease/Anemia.jpg  | https://www.aiinsights.solutions.iqvia.com/images/disease/D.jpg           | Prob: 0.06%            | Prob: 10%                   |
| Anemia    | Hypothyroid | Anemia-->Hypothyroid  | False             | M        | < 40        |          1 |                2 |             0.06 |                10     | https://www.aiinsights.solutions.iqvia.com/images/disease/Anemia.jpg  | https://www.aiinsights.solutions.iqvia.com/images/disease/Hypothyroid.jpg | Prob: 0.06%            | Prob: 10%                   |
| AR        | FluidsLytes | AR-->FluidsLytes      | False             | M        | < 40        |          1 |                2 |             0.06 |                 8.333 | https://www.aiinsights.solutions.iqvia.com/images/disease/AR.jpg      | https://www.aiinsights.solutions.iqvia.com/images/disease/FluidsLytes.jpg | Prob: 0.06%            | Prob: 8.333%                |
| AR        | Obesity     | AR-->Obesity          | False             | M        | < 40        |          1 |                2 |             0.06 |                 8.333 | https://www.aiinsights.solutions.iqvia.com/images/disease/AR.jpg      | https://www.aiinsights.solutions.iqvia.com/images/disease/Obesity.jpg     | Prob: 0.06%            | Prob: 8.333%                |


Table: CD_Data
| cd_to   | cd_from_to       | is_chronic_path   | gender   | age_group   |   instance |   age_group_sort | develop_type   |   link |   cases |      MU |      SD |   prob |    z |   p | odds          |   odds_order | link_label                 |   d_type_order | cd_from   | odds_symbol   | link_label_p                 | cd_from_full                |   Z_Score |      SE |
|:--------|:-----------------|:------------------|:---------|:------------|-----------:|-----------------:|:---------------|-------:|--------:|--------:|--------:|-------:|-----:|----:|:--------------|-------------:|:---------------------------|---------------:|:----------|:--------------|:-----------------------------|:----------------------------|----------:|--------:|
| Alcohol | Anemia-->Alcohol | False             | M        | 40 to 60    |          1 |                3 | overall        |    424 |    7246 | 17.0896 | 32.9031 |   0.01 | 10.1 |   0 | Very Unlikely |            3 | Prob: 0.01% | p: 0.000 | - |              1 | Anemia    | -             | p value: 0.000 Very Unlikely | (Anemia) Deficiency anemias |     -10.1 | 1.59791 |
| AR      | Anemia-->AR      | False             | F        | 40 to 60    |          1 |                3 | overall        |    424 |    7467 | 17.6108 | 24.4725 |   0.01 | 14   |   0 | Very Unlikely |            3 | Prob: 0.01% | p: 0.000 | - |              1 | Anemia    | -             | p value: 0.000 Very Unlikely | (Anemia) Deficiency anemias |     -14   | 1.18849 |
| AS      | Anemia-->AS      | False             | M        | 40 to 60    |          1 |                3 | overall        |    424 |    7246 | 17.0896 | 32.9031 |   0.01 | 10.1 |   0 | Very Unlikely |            3 | Prob: 0.01% | p: 0.000 | - |              1 | Anemia    | -             | p value: 0.000 Very Unlikely | (Anemia) Deficiency anemias |     -10.1 | 1.59791 |
| COPD    | Anemia-->COPD    | False             | M        | 40 to 60    |          1 |                3 | overall        |    424 |    7246 | 17.0896 | 32.9031 |   0.01 | 10.1 |   0 | Very Unlikely |            3 | Prob: 0.01% | p: 0.000 | - |              1 | Anemia    | -             | p value: 0.000 Very Unlikely | (Anemia) Deficiency anemias |     -10.1 | 1.59791 |
| Drugs   | Anemia-->Drugs   | False             | F        | 40 to 60    |          1 |                3 | overall        |    424 |    7467 | 17.6108 | 24.4725 |   0.01 | 14   |   0 | Very Unlikely |            3 | Prob: 0.01% | p: 0.000 | - |              1 | Anemia    | -             | p value: 0.000 Very Unlikely | (Anemia) Deficiency anemias |     -14   | 1.18849 |
| MHC     | Anemia-->MHC     | False             | M        | 40 to 60    |          1 |                3 | overall        |    424 |    7246 | 17.0896 | 32.9031 |   0.01 | 10.1 |   0 | Very Unlikely |            3 | Prob: 0.01% | p: 0.000 | - |              1 | Anemia    | -             | p value: 0.000 Very Unlikely | (Anemia) Deficiency anemias |     -10.1 | 1.59791 |
| Obesity | Anemia-->Obesity | False             | M        | 40 to 60    |          1 |                3 | overall        |    424 |    7246 | 17.0896 | 32.9031 |   0.01 | 10.1 |   0 | Very Unlikely |            3 | Prob: 0.01% | p: 0.000 | - |              1 | Anemia    | -             | p value: 0.000 Very Unlikely | (Anemia) Deficiency anemias |     -10.1 | 1.59791 |
| Osteo   | Anemia-->Osteo   | False             | F        | 40 to 60    |          1 |                3 | overall        |    424 |    7467 | 17.6108 | 24.4725 |   0.01 | 14   |   0 | Very Unlikely |            3 | Prob: 0.01% | p: 0.000 | - |              1 | Anemia    | -             | p value: 0.000 Very Unlikely | (Anemia) Deficiency anemias |     -14   | 1.18849 |
| Alcohol | AR-->Alcohol     | False             | F        | 40 to 60    |          1 |                3 | overall        |    424 |    7467 | 17.6108 | 24.4725 |   0.01 | 14   |   0 | Very Unlikely |            3 | Prob: 0.01% | p: 0.000 | - |              1 | AR        | -             | p value: 0.000 Very Unlikely | (AR) Arthritis              |     -14   | 1.18849 |
| HIV     | AR-->HIV         | False             | F        | 40 to 60    |          1 |                3 | overall        |    424 |    7467 | 17.6108 | 24.4725 |   0.01 | 14   |   0 | Very Unlikely |            3 | Prob: 0.01% | p: 0.000 | - |              1 | AR        | -             | p value: 0.000 Very Unlikely | (AR) Arthritis              |     -14   | 1.18849 |


Table: cd_from_name
|   ID | cd_from_name                          | cd_from_code   | is_main_chronic   | color_from   | image_from                                                          |
|-----:|:--------------------------------------|:---------------|:------------------|:-------------|:--------------------------------------------------------------------|
|    1 | Arthritis                             | AR             | True              | #67001F      | https://www.aiinsights.solutions.iqvia.com/images/disease/AR.jpg    |
|    2 | Asthma                                | AS             | True              | #B2182B      | https://www.aiinsights.solutions.iqvia.com/images/disease/AS.jpg    |
|    3 | Back Pain                             | BP             | True              | #D6604D      | https://www.aiinsights.solutions.iqvia.com/images/disease/BP.jpg    |
|    4 | Cancer                                | C              | True              | #F4A582      | https://www.aiinsights.solutions.iqvia.com/images/disease/C.jpg     |
|    5 | Cardiovascular Disease                | CVD            | True              | #FDDBC7      | https://www.aiinsights.solutions.iqvia.com/images/disease/CVD.jpg   |
|    6 | Chronic Kidney Disease                | CKD            | True              | #8E0152      | https://www.aiinsights.solutions.iqvia.com/images/disease/CKD.jpg   |
|    7 | Chronic Obstructive Pulmonary Disease | COPD           | True              | #C51B7D      | https://www.aiinsights.solutions.iqvia.com/images/disease/COPD.jpg  |
|    8 | Diabetes                              | D              | True              | #DE77AE      | https://www.aiinsights.solutions.iqvia.com/images/disease/D.jpg     |
|   10 | Mental Health Conditions              | MHC            | True              | #F1B6DA      | https://www.aiinsights.solutions.iqvia.com/images/disease/MHC.jpg   |
|   11 | Osteoporosis                          | Osteo          | True              | #FDE0EF      | https://www.aiinsights.solutions.iqvia.com/images/disease/Osteo.jpg |


Table: cd_to_name
|   ID | cd_to_name                            | cd_to_code   |   is_main_chronic | color_to   | image_to                                                            |
|-----:|:--------------------------------------|:-------------|------------------:|:-----------|:--------------------------------------------------------------------|
|    1 | Arthritis                             | AR           |                 1 | #D1E5F0    | https://www.aiinsights.solutions.iqvia.com/images/disease/AR.jpg    |
|    2 | Asthma                                | AS           |                 1 | #92C5DE    | https://www.aiinsights.solutions.iqvia.com/images/disease/AS.jpg    |
|    3 | Back Pain                             | BP           |                 1 | #4393C3    | https://www.aiinsights.solutions.iqvia.com/images/disease/BP.jpg    |
|    4 | Cancer                                | C            |                 1 | #2166AC    | https://www.aiinsights.solutions.iqvia.com/images/disease/C.jpg     |
|    5 | Cardiovascular Disease                | CVD          |                 1 | #053061    | https://www.aiinsights.solutions.iqvia.com/images/disease/CVD.jpg   |
|    6 | Chronic Kidney Disease                | CKD          |                 1 | #E6F5D0    | https://www.aiinsights.solutions.iqvia.com/images/disease/CKD.jpg   |
|    7 | Chronic Obstructive Pulmonary Disease | COPD         |                 1 | #B8E186    | https://www.aiinsights.solutions.iqvia.com/images/disease/COPD.jpg  |
|    8 | Diabetes                              | D            |                 1 | #7FBC41    | https://www.aiinsights.solutions.iqvia.com/images/disease/D.jpg     |
|   10 | Mental Health Conditions              | MHC          |                 1 | #4D9221    | https://www.aiinsights.solutions.iqvia.com/images/disease/MHC.jpg   |
|   11 | Osteoporosis                          | Osteo        |                 1 | #276419    | https://www.aiinsights.solutions.iqvia.com/images/disease/Osteo.jpg |


Table: chronic_disease_gender
| gender   |
|:---------|
| F        |
| M        |


Table: chronic_disease_interim
|   ID | Chronic_Disease                       | Chronic_Disease_Abbr   |
|-----:|:--------------------------------------|:-----------------------|
|    1 | Arthritis                             | AR                     |
|    2 | Asthma                                | AS                     |
|    3 | Back Pain                             | BP                     |
|    4 | Cancer                                | C                      |
|    5 | Cardiovascular Disease                | CVD                    |
|    6 | Chronic Kidney Disease                | CKD                    |
|    7 | Chronic Obstructive Pulmonary Disease | COPD                   |
|    8 | Diabetes                              | D                      |
|    9 | Gout                                  | G                      |
|   10 | Mental Health Conditions              | MHC                    |


Table: chronic_disease_name_from
|   ID | Chronic_Disease                       | Chronic_Disease_Abbr   | Display_Name                                 |
|-----:|:--------------------------------------|:-----------------------|:---------------------------------------------|
|    1 | Arthritis                             | AR                     | (AR) Arthritis                               |
|    2 | Asthma                                | AS                     | (AS) Asthma                                  |
|    3 | Back Pain                             | BP                     | (BP) Back Pain                               |
|    4 | Cancer                                | C                      | (C) Cancer                                   |
|    5 | Cardiovascular Disease                | CVD                    | (CVD) Cardiovascular Disease                 |
|    6 | Chronic Kidney Disease                | CKD                    | (CKD) Chronic Kidney Disease                 |
|    7 | Chronic Obstructive Pulmonary Disease | COPD                   | (COPD) Chronic Obstructive Pulmonary Disease |
|    8 | Diabetes                              | D                      | (D) Diabetes                                 |
|    9 | Gout                                  | G                      | (G) Gout                                     |
|   10 | Mental Health Conditions              | MHC                    | (MHC) Mental Health Conditions               |


Table: chronic_disease_name_to
|   ID | Chronic_Disease                       | Chronic_Disease_Abbr   |
|-----:|:--------------------------------------|:-----------------------|
|    1 | Arthritis                             | AR                     |
|    2 | Asthma                                | AS                     |
|    3 | Back Pain                             | BP                     |
|    4 | Cancer                                | C                      |
|    5 | Cardiovascular Disease                | CVD                    |
|    6 | Chronic Kidney Disease                | CKD                    |
|    7 | Chronic Obstructive Pulmonary Disease | COPD                   |
|    8 | Diabetes                              | D                      |
|    9 | Gout                                  | G                      |
|   10 | Mental Health Conditions              | MHC                    |


Table: chronic_disease_path_from
|   person_id | cd_path_from   | cd_from   | cd_path_to   | cd_to   |   elapse_years |   elapse_months |   age_diff_from |   age_diff_to | gender   |   age |   age_from |   age_to | images                                                            |   person_id_old | diag_date_from   | diag_date_to   | link_type   |   developing_odd |
|------------:|:---------------|:----------|:-------------|:--------|---------------:|----------------:|----------------:|--------------:|:---------|------:|-----------:|---------:|:------------------------------------------------------------------|----------------:|:-----------------|:---------------|:------------|-----------------:|
|       425_4 | CVD            | CVD       | CVD-->D      | D       |              0 |               0 |              19 |            19 | M        |   104 |         85 |       85 | https://www.aiinsights.solutions.iqvia.com/images/disease/CVD.jpg |             425 | 1998-12-26       | 1998-12-26     | CVD-->D     |         0.680851 |
|       942_1 | CVD            | CVD       | CVD-->D      | D       |              0 |               0 |              22 |            22 | M        |   103 |         81 |       81 | https://www.aiinsights.solutions.iqvia.com/images/disease/CVD.jpg |             942 | 1996-05-30       | 1996-05-30     | CVD-->D     |         0.735849 |
|       951_1 | CVD            | CVD       | CVD-->D      | D       |              0 |               0 |              22 |            22 | M        |   101 |         79 |       79 | https://www.aiinsights.solutions.iqvia.com/images/disease/CVD.jpg |             951 | 1995-12-06       | 1995-12-06     | CVD-->D     |         0.462687 |
|      1035_1 | CVD            | CVD       | CVD-->D      | D       |              0 |               0 |              20 |            20 | M        |    99 |         79 |       79 | https://www.aiinsights.solutions.iqvia.com/images/disease/CVD.jpg |            1035 | 1998-05-16       | 1998-05-16     | CVD-->D     |         0.462687 |
|      1219_1 | CVD            | CVD       | CVD-->D      | D       |              0 |               0 |              21 |            21 | M        |    98 |         77 |       77 | https://www.aiinsights.solutions.iqvia.com/images/disease/CVD.jpg |            1219 | 1997-09-30       | 1997-09-30     | CVD-->D     |         0.34     |
|      1297_1 | CVD            | CVD       | CVD-->D      | D       |              0 |               0 |              20 |            20 | M        |    97 |         77 |       77 | https://www.aiinsights.solutions.iqvia.com/images/disease/CVD.jpg |            1297 | 1998-06-24       | 1998-06-24     | CVD-->D     |         0.34     |
|     1311_17 | CVD            | CVD       | CVD-->D      | D       |              0 |               0 |              22 |            22 | M        |    96 |         74 |       74 | https://www.aiinsights.solutions.iqvia.com/images/disease/CVD.jpg |            1311 | 1996-06-07       | 1996-06-07     | CVD-->D     |         0.403974 |
|     1311_18 | CVD            | CVD       | CVD-->D      | D       |              0 |               0 |              22 |            22 | M        |    96 |         74 |       74 | https://www.aiinsights.solutions.iqvia.com/images/disease/CVD.jpg |            1311 | 1996-06-07       | 1996-06-07     | CVD-->D     |         0.403974 |
|      1442_1 | CVD            | CVD       | CVD-->D      | D       |              0 |               0 |              20 |            20 | M        |    95 |         75 |       75 | https://www.aiinsights.solutions.iqvia.com/images/disease/CVD.jpg |            1442 | 1998-01-28       | 1998-01-28     | CVD-->D     |         0.606557 |
|      1466_1 | CVD            | CVD       | CVD-->D      | D       |              0 |               0 |              19 |            19 | M        |    96 |         77 |       77 | https://www.aiinsights.solutions.iqvia.com/images/disease/CVD.jpg |            1466 | 1999-01-19       | 1999-01-19     | CVD-->D     |         0.34     |


Table: chronic_disease_path_to
|   person_id |   person_id_old | diag_date_from   | cd_path_from   | cd_from   | diag_date_to   | cd_path_to   | cd_to   |   elapse_years |   elapse_months |   age_diff_from |   age_diff_to | gender   |   age |   age_from |   age_to | link_type   | link_type_order   |
|------------:|----------------:|:-----------------|:---------------|:----------|:---------------|:-------------|:--------|---------------:|----------------:|----------------:|--------------:|:---------|------:|-----------:|---------:|:------------|:------------------|
|       425_4 |             425 | 1998-12-26       | CVD            | CVD       | 1998-12-26     | CVD-->D      | D       |              0 |               0 |              19 |            19 | M        |   104 |         85 |       85 | CVD-->D     | D-->CVD           |
|       942_1 |             942 | 1996-05-30       | CVD            | CVD       | 1996-05-30     | CVD-->D      | D       |              0 |               0 |              22 |            22 | M        |   103 |         81 |       81 | CVD-->D     | D-->CVD           |
|       951_1 |             951 | 1995-12-06       | CVD            | CVD       | 1995-12-06     | CVD-->D      | D       |              0 |               0 |              22 |            22 | M        |   101 |         79 |       79 | CVD-->D     | D-->CVD           |
|      1035_1 |            1035 | 1998-05-16       | CVD            | CVD       | 1998-05-16     | CVD-->D      | D       |              0 |               0 |              20 |            20 | M        |    99 |         79 |       79 | CVD-->D     | D-->CVD           |
|      1219_1 |            1219 | 1997-09-30       | CVD            | CVD       | 1997-09-30     | CVD-->D      | D       |              0 |               0 |              21 |            21 | M        |    98 |         77 |       77 | CVD-->D     | D-->CVD           |
|      1297_1 |            1297 | 1998-06-24       | CVD            | CVD       | 1998-06-24     | CVD-->D      | D       |              0 |               0 |              20 |            20 | M        |    97 |         77 |       77 | CVD-->D     | D-->CVD           |
|     1311_17 |            1311 | 1996-06-07       | CVD            | CVD       | 1996-06-07     | CVD-->D      | D       |              0 |               0 |              22 |            22 | M        |    96 |         74 |       74 | CVD-->D     | D-->CVD           |
|     1311_18 |            1311 | 1996-06-07       | CVD            | CVD       | 1996-06-07     | CVD-->D      | D       |              0 |               0 |              22 |            22 | M        |    96 |         74 |       74 | CVD-->D     | D-->CVD           |
|      1442_1 |            1442 | 1998-01-28       | CVD            | CVD       | 1998-01-28     | CVD-->D      | D       |              0 |               0 |              20 |            20 | M        |    95 |         75 |       75 | CVD-->D     | D-->CVD           |
|      1466_1 |            1466 | 1999-01-19       | CVD            | CVD       | 1999-01-19     | CVD-->D      | D       |              0 |               0 |              19 |            19 | M        |    96 |         77 |       77 | CVD-->D     | D-->CVD           |


Table: Comorbidity_Disease_Variables
| cd_from   | cd_to       | cd_from_to           | cd_from_to_from      | cd_from_to_to        |   is_chronic_path | gender   | age_group   |   age_group_order | years_develop   |   year_develop_order |   instance |
|:----------|:------------|:---------------------|:---------------------|:---------------------|------------------:|:---------|:------------|------------------:|:----------------|---------------------:|-----------:|
| Alcohol   | Anemia      | Alcohol-->Anemia     | Alcohol-->Anemia     | Alcohol-->Anemia     |                 0 | M        | 21 to 40    |                 2 | anytime         |                    1 |          1 |
| Alcohol   | C           | Alcohol-->C          | Alcohol-->C          | Alcohol-->C          |                 0 | M        | 21 to 40    |                 2 | anytime         |                    1 |          1 |
| Alcohol   | D           | Alcohol-->D          | Alcohol-->D          | Alcohol-->D          |                 0 | M        | 21 to 40    |                 2 | anytime         |                    1 |          1 |
| Alcohol   | G           | Alcohol-->G          | Alcohol-->G          | Alcohol-->G          |                 0 | M        | 21 to 40    |                 2 | anytime         |                    1 |          1 |
| Alcohol   | NeuroOther  | Alcohol-->NeuroOther | Alcohol-->NeuroOther | Alcohol-->NeuroOther |                 0 | M        | 21 to 40    |                 2 | anytime         |                    1 |          1 |
| Anemia    | CKD         | Anemia-->CKD         | Anemia-->CKD         | Anemia-->CKD         |                 0 | M        | 21 to 40    |                 2 | anytime         |                    1 |          1 |
| Anemia    | D           | Anemia-->D           | Anemia-->D           | Anemia-->D           |                 0 | M        | 21 to 40    |                 2 | anytime         |                    1 |          1 |
| Anemia    | FluidsLytes | Anemia-->FluidsLytes | Anemia-->FluidsLytes | Anemia-->FluidsLytes |                 0 | M        | 21 to 40    |                 2 | anytime         |                    1 |          1 |
| AR        | WeightLoss  | AR-->WeightLoss      | AR-->WeightLoss      | AR-->WeightLoss      |                 0 | M        | 21 to 40    |                 2 | anytime         |                    1 |          1 |
| AS        | NeuroOther  | AS-->NeuroOther      | AS-->NeuroOther      | AS-->NeuroOther      |                 0 | M        | 21 to 40    |                 2 | anytime         |                    1 |          1 |


Table: Comorbidity_Random_Path
| cd_from   | cd_to        | cd_from_to             |   is_chronic_path |   develop_sd |   bootstrap_mean |   instance |   total_cases |   observed_mean |   statistical_mean |    mean_bias |   z_score | develop_type    | is_path_significant   | path_odd   |   lower_value_95 |   upper_value_95 | chronic_or_not   | images                                                                |
|:----------|:-------------|:-----------------------|------------------:|-------------:|-----------------:|-----------:|--------------:|----------------:|-------------------:|-------------:|----------:|:----------------|:----------------------|:-----------|-----------------:|-----------------:|:-----------------|:----------------------------------------------------------------------|
| Alcohol   | Anemia       | Alcohol-->Anemia       |                 0 |  0.000135878 |      0.00124383  |         86 |         69302 |     0.00124095  |          0.0017331 |  2.88592e-06 |     -3.6  | Randomized Path | Yes                   | Unlikely   |      0.000977511 |      0.00151015  | Morbidity        | https://www.aiinsights.solutions.iqvia.com/images/disease/Alcohol.jpg |
| Alcohol   | AR           | Alcohol-->AR           |                 0 |  4.84532e-05 |      0.00015887  |         11 |         69302 |     0.000158726 |          0.0017331 |  1.44296e-07 |    -32.49 | Randomized Path | Yes                   | Unlikely   |      6.39015e-05 |      0.000253838 | Morbidity        | https://www.aiinsights.solutions.iqvia.com/images/disease/Alcohol.jpg |
| Alcohol   | AS           | Alcohol-->AS           |                 0 |  6.73152e-05 |      0.000330178 |         23 |         69302 |     0.000331881 |          0.0017331 | -1.70269e-06 |    -20.84 | Randomized Path | Yes                   | Unlikely   |      0.00019824  |      0.000462116 | Morbidity        | https://www.aiinsights.solutions.iqvia.com/images/disease/Alcohol.jpg |
| Alcohol   | BP           | Alcohol-->BP           |                 0 |  0.000111604 |      0.000836426 |         58 |         69302 |     0.000836917 |          0.0017331 | -4.90606e-07 |     -8.03 | Randomized Path | Yes                   | Unlikely   |      0.000617682 |      0.00105517  | Morbidity        | https://www.aiinsights.solutions.iqvia.com/images/disease/Alcohol.jpg |
| Alcohol   | C            | Alcohol-->C            |                 0 |  0.000104618 |      0.000765692 |         53 |         69302 |     0.000764769 |          0.0017331 |  9.23494e-07 |     -9.25 | Randomized Path | Yes                   | Unlikely   |      0.00056064  |      0.000970744 | Morbidity        | https://www.aiinsights.solutions.iqvia.com/images/disease/Alcohol.jpg |
| Alcohol   | CKD          | Alcohol-->CKD          |                 0 |  5.72959e-05 |      0.00021876  |         15 |         69302 |     0.000216444 |          0.0017331 |  2.31595e-06 |    -26.43 | Randomized Path | Yes                   | Unlikely   |      0.00010646  |      0.00033106  | Morbidity        | https://www.aiinsights.solutions.iqvia.com/images/disease/Alcohol.jpg |
| Alcohol   | Coagulopathy | Alcohol-->Coagulopathy |                 0 |  8.63021e-05 |      0.000506414 |         35 |         69302 |     0.000505036 |          0.0017331 |  1.37803e-06 |    -14.21 | Randomized Path | Yes                   | Unlikely   |      0.000337262 |      0.000675566 | Morbidity        | https://www.aiinsights.solutions.iqvia.com/images/disease/Alcohol.jpg |
| Alcohol   | COPD         | Alcohol-->COPD         |                 0 |  5.48291e-05 |      0.000202029 |         14 |         69302 |     0.000202014 |          0.0017331 |  1.44296e-08 |    -27.92 | Randomized Path | Yes                   | Unlikely   |      9.45638e-05 |      0.000309494 | Morbidity        | https://www.aiinsights.solutions.iqvia.com/images/disease/Alcohol.jpg |
| Alcohol   | D            | Alcohol-->D            |                 0 |  0.000123519 |      0.001051    |         73 |         69302 |     0.00105336  |          0.0017331 | -2.35924e-06 |     -5.52 | Randomized Path | Yes                   | Unlikely   |      0.000808904 |      0.0012931   | Morbidity        | https://www.aiinsights.solutions.iqvia.com/images/disease/Alcohol.jpg |
| Alcohol   | G            | Alcohol-->G            |                 0 |  5.79557e-05 |      0.000219546 |         15 |         69302 |     0.000216444 |          0.0017331 |  3.10236e-06 |    -26.12 | Randomized Path | Yes                   | Unlikely   |      0.000105953 |      0.00033314  | Morbidity        | https://www.aiinsights.solutions.iqvia.com/images/disease/Alcohol.jpg |


Table: Comorbidity_Source_Known
| cd_from   | cd_to       | cd_from_to           |   is_chronic_path |   develop_sd |   bootstrap_mean |   instance |   total_cases |   observed_mean |   statistical_mean |    mean_bias |   z_score | develop_type         | is_path_significant   | path_odd   |   lower_value_95 |   upper_value_95 | chronic_or_not   | images                                                               | Probability          | Reverse_Probability   |
|:----------|:------------|:---------------------|------------------:|-------------:|-----------------:|-----------:|--------------:|----------------:|-------------------:|-------------:|----------:|:---------------------|:----------------------|:-----------|-----------------:|-----------------:|:-----------------|:---------------------------------------------------------------------|:---------------------|:----------------------|
| Anemia    | Alcohol     | Anemia-->Alcohol     |                 0 |  0.00371971  |      0.023095    |         39 |         69302 |     0.0229953   |          0.0416667 |  9.96811e-05 |     -4.99 | Source Disease Known | Yes                   | Unlikely   |      0.0158043   |       0.0303856  | Morbidity        | https://www.aiinsights.solutions.iqvia.com/images/disease/Anemia.jpg | 2.3%, Z Score: -5.0  | 4.0%, Z Score: -0.2   |
| Anemia    | AR          | Anemia-->AR          |                 0 |  0.00250874  |      0.0105989   |         18 |         69302 |     0.0106132   |          0.0416667 | -1.43141e-05 |    -12.38 | Source Disease Known | Yes                   | Unlikely   |      0.00568176  |       0.015516   | Morbidity        | https://www.aiinsights.solutions.iqvia.com/images/disease/Anemia.jpg | 1.1%, Z Score: -12.4 | 2.0%, Z Score: -8.0   |
| Anemia    | AS          | Anemia-->AS          |                 0 |  0.00306176  |      0.0171168   |         29 |         69302 |     0.0170991   |          0.0416667 |  1.77777e-05 |     -8.02 | Source Disease Known | Yes                   | Unlikely   |      0.0111158   |       0.0231179  | Morbidity        | https://www.aiinsights.solutions.iqvia.com/images/disease/Anemia.jpg | 1.7%, Z Score: -8.0  | 2.0%, Z Score: -7.5   |
| Anemia    | BloodLoss   | Anemia-->BloodLoss   |                 0 |  0.00319155  |      0.0182668   |         31 |         69302 |     0.0182783   |          0.0416667 | -1.15324e-05 |     -7.33 | Source Disease Known | Yes                   | Unlikely   |      0.0120113   |       0.0245222  | Morbidity        | https://www.aiinsights.solutions.iqvia.com/images/disease/Anemia.jpg | 1.8%, Z Score: -7.3  | 1.0%, Z Score: -12.1  |
| Anemia    | BP          | Anemia-->BP          |                 0 |  0.00346048  |      0.020564    |         35 |         69302 |     0.0206368   |          0.0416667 | -7.27649e-05 |     -6.1  | Source Disease Known | Yes                   | Unlikely   |      0.0137815   |       0.0273466  | Morbidity        | https://www.aiinsights.solutions.iqvia.com/images/disease/Anemia.jpg | 2.1%, Z Score: -6.1  | 5.0%, Z Score: 1.2    |
| Anemia    | COPD        | Anemia-->COPD        |                 0 |  0.003606    |      0.0212767   |         36 |         69302 |     0.0212264   |          0.0416667 |  5.03046e-05 |     -5.65 | Source Disease Known | Yes                   | Unlikely   |      0.014209    |       0.0283445  | Morbidity        | https://www.aiinsights.solutions.iqvia.com/images/disease/Anemia.jpg | 2.1%, Z Score: -5.7  | 2.0%, Z Score: -5.5   |
| Anemia    | Drugs       | Anemia-->Drugs       |                 0 |  0.000745138 |      0.00135923  |          2 |         69302 |     0.00117925  |          0.0416667 |  0.000179983 |    -54.09 | Source Disease Known | Yes                   | Unlikely   |     -0.000101243 |       0.0028197  | Morbidity        | https://www.aiinsights.solutions.iqvia.com/images/disease/Anemia.jpg | 0.1%, Z Score: -54.1 | 0.0%, Z Score: -68.2  |
| Anemia    | G           | Anemia-->G           |                 0 |  0.00114968  |      0.00242717  |          4 |         69302 |     0.00235849  |          0.0416667 |  6.86812e-05 |    -34.13 | Source Disease Known | Yes                   | Unlikely   |      0.000173798 |       0.00468055 | Morbidity        | https://www.aiinsights.solutions.iqvia.com/images/disease/Anemia.jpg | 0.2%, Z Score: -34.1 | 1.0%, Z Score: -18.5  |
| Anemia    | HIV         | Anemia-->HIV         |                 0 |  0.000492095 |      0.000943329 |          1 |         69302 |     0.000589623 |          0.0416667 |  0.000353706 |    -82.76 | Source Disease Known | Yes                   | Unlikely   |     -2.11777e-05 |       0.00190784 | Morbidity        | https://www.aiinsights.solutions.iqvia.com/images/disease/Anemia.jpg | 0.1%, Z Score: -82.8 | 0.0%, Z Score: -106.8 |
| Anemia    | Hypothyroid | Anemia-->Hypothyroid |                 0 |  0.00257941  |      0.0112533   |         19 |         69302 |     0.0112028   |          0.0416667 |  5.04218e-05 |    -11.79 | Source Disease Known | Yes                   | Unlikely   |      0.00619761  |       0.0163089  | Morbidity        | https://www.aiinsights.solutions.iqvia.com/images/disease/Anemia.jpg | 1.1%, Z Score: -11.8 | 1.0%, Z Score: -16.5  |


Table: Comorbidity_Target_Known
| cd_from     | cd_to   | cd_from_to           |   is_chronic_path |   develop_sd |   bootstrap_mean |   instance |   total_cases |   observed_mean |   statistical_mean |    mean_bias |   z_score | develop_type         | is_path_significant   | path_odd   |   lower_value_95 |   upper_value_95 | chronic_or_not   | images                                                               |
|:------------|:--------|:---------------------|------------------:|-------------:|-----------------:|-----------:|--------------:|----------------:|-------------------:|-------------:|----------:|:---------------------|:----------------------|:-----------|-----------------:|-----------------:|:-----------------|:---------------------------------------------------------------------|
| AR          | Anemia  | AR-->Anemia          |                 0 |  0.00295584  |      0.0179383   |         38 |         69302 |     0.0179245   |          0.0416667 |  1.3792e-05  |     -8.03 | Target Disease Known | Yes                   | Unlikely   |      0.0121449   |       0.0237318  | Morbidity        | https://www.aiinsights.solutions.iqvia.com/images/disease/Anemia.jpg |
| AS          | Anemia  | AS-->Anemia          |                 0 |  0.00292733  |      0.0197747   |         42 |         69302 |     0.0198113   |          0.0416667 | -3.66e-05    |     -7.48 | Target Disease Known | Yes                   | Unlikely   |      0.0140372   |       0.0255123  | Morbidity        | https://www.aiinsights.solutions.iqvia.com/images/disease/Anemia.jpg |
| BloodLoss   | Anemia  | BloodLoss-->Anemia   |                 0 |  0.00243222  |      0.012276    |         26 |         69302 |     0.0122642   |          0.0416667 |  1.1877e-05  |    -12.08 | Target Disease Known | Yes                   | Unlikely   |      0.00750887  |       0.0170432  | Morbidity        | https://www.aiinsights.solutions.iqvia.com/images/disease/Anemia.jpg |
| COPD        | Anemia  | COPD-->Anemia        |                 0 |  0.00327398  |      0.0236373   |         50 |         69302 |     0.0235849   |          0.0416667 |  5.23632e-05 |     -5.51 | Target Disease Known | Yes                   | Unlikely   |      0.0172203   |       0.0300543  | Morbidity        | https://www.aiinsights.solutions.iqvia.com/images/disease/Anemia.jpg |
| Drugs       | Anemia  | Drugs-->Anemia       |                 0 |  0.000594932 |      0.00111015  |          2 |         69302 |     0.000943396 |          0.0416667 |  0.000166756 |    -68.17 | Target Disease Known | Yes                   | Unlikely   |     -5.59144e-05 |       0.00227622 | Morbidity        | https://www.aiinsights.solutions.iqvia.com/images/disease/Anemia.jpg |
| G           | Anemia  | G-->Anemia           |                 0 |  0.00184188  |      0.00758106  |         16 |         69302 |     0.00754717  |          0.0416667 |  3.38925e-05 |    -18.51 | Target Disease Known | Yes                   | Unlikely   |      0.00397097  |       0.0111912  | Morbidity        | https://www.aiinsights.solutions.iqvia.com/images/disease/Anemia.jpg |
| HIV         | Anemia  | HIV-->Anemia         |                 0 |  0.000383182 |      0.000746208 |          1 |         69302 |     0.000471698 |          0.0416667 |  0.00027451  |   -106.79 | Target Disease Known | Yes                   | Unlikely   |     -4.8295e-06  |       0.00149725 | Morbidity        | https://www.aiinsights.solutions.iqvia.com/images/disease/Anemia.jpg |
| Hypothyroid | Anemia  | Hypothyroid-->Anemia |                 0 |  0.00200393  |      0.0085482   |         18 |         69302 |     0.00849057  |          0.0416667 |  5.76373e-05 |    -16.53 | Target Disease Known | Yes                   | Unlikely   |      0.00462049  |       0.0124759  | Morbidity        | https://www.aiinsights.solutions.iqvia.com/images/disease/Anemia.jpg |
| Liver       | Anemia  | Liver-->Anemia       |                 0 |  0.00324874  |      0.0239496   |         51 |         69302 |     0.0240566   |          0.0416667 | -0.00010703  |     -5.45 | Target Disease Known | Yes                   | Unlikely   |      0.017582    |       0.0303171  | Morbidity        | https://www.aiinsights.solutions.iqvia.com/images/disease/Anemia.jpg |
| NeuroOther  | Anemia  | NeuroOther-->Anemia  |                 0 |  0.00252256  |      0.0131711   |         28 |         69302 |     0.0132075   |          0.0416667 | -3.64321e-05 |    -11.3  | Target Disease Known | Yes                   | Unlikely   |      0.0082269   |       0.0181153  | Morbidity        | https://www.aiinsights.solutions.iqvia.com/images/disease/Anemia.jpg |


Table: Comorbidty_Name_From
|   ID | Chronic_Disease                       | Chronic_Disease_Abbr   |   is_main_chronic |
|-----:|:--------------------------------------|:-----------------------|------------------:|
|    1 | Arthritis                             | AR                     |                 1 |
|    2 | Asthma                                | AS                     |                 1 |
|    3 | Back Pain                             | BP                     |                 1 |
|    4 | Cancer                                | C                      |                 1 |
|    5 | Cardiovascular Disease                | CVD                    |                 1 |
|    6 | Chronic Kidney Disease                | CKD                    |                 1 |
|    7 | Chronic Obstructive Pulmonary Disease | COPD                   |                 1 |
|    8 | Diabetes                              | D                      |                 1 |
|    9 | Gout                                  | G                      |                 1 |
|   10 | Mental Health Conditions              | MHC                    |                 1 |


Table: Comorbidty_Name_To
|   ID | Chronic_Disease                       | Chronic_Disease_Abbr   |   is_main_chronic |
|-----:|:--------------------------------------|:-----------------------|------------------:|
|    1 | Arthritis                             | AR                     |                 1 |
|    2 | Asthma                                | AS                     |                 1 |
|    3 | Back Pain                             | BP                     |                 1 |
|    4 | Cancer                                | C                      |                 1 |
|    5 | Cardiovascular Disease                | CVD                    |                 1 |
|    6 | Chronic Kidney Disease                | CKD                    |                 1 |
|    7 | Chronic Obstructive Pulmonary Disease | COPD                   |                 1 |
|    8 | Diabetes                              | D                      |                 1 |
|    9 | Gout                                  | G                      |                 1 |
|   10 | Mental Health Conditions              | MHC                    |                 1 |


Table: Developing_Type
| Developing_type             |   Sort_Order | Notes                                                                                                                                                                                                                                         |
|:----------------------------|-------------:|:----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| General Disease Progression |            1 | General Disease Progression refers to any sequential disease pairs. The purpose of this observation is to understand in general which disease progression path is more likely to develop.                                                     |
| Initial Disease Known       |            2 | Initial Disease Known refers to a sequential disease pair when the initial disease has already known. The purpose of this observation is to understand for a particular disease what will be the next most likely disease as the comorbidity. |

 


tables: name: CD_Age
data: CD_Age.csv
name: CD_Data
data: CD_Data.csv
name: cd_from_name
data: cd_from_name.csv
name: cd_to_name
data: cd_to_name.csv
name: chronic_disease_gender
data: chronic_disease_gender.csv
name: chronic_disease_interim
data: chronic_disease_interim.csv
name: chronic_disease_name_from
data: chronic_disease_name_from.csv
name: chronic_disease_name_to
data: chronic_disease_name_to.csv
name: chronic_disease_path_from
data: chronic_disease_path_from.csv
name: chronic_disease_path_to
data: chronic_disease_path_to.csv
name: Comorbidity_Disease_Variables
data: Comorbidity_Disease_Variables.csv
name: Comorbidity_Random_Path
data: Comorbidity_Random_Path.csv
name: Comorbidity_Source_Known
data: Comorbidity_Source_Known.csv
name: Comorbidity_Target_Known
data: Comorbidity_Target_Known.csv
name: Comorbidty_Name_From
data: Comorbidty_Name_From.csv
name: Comorbidty_Name_To
data: Comorbidty_Name_To.csv
name: Developing_Type
data: Developing_Type.csv
label: chronic_disease_path_from
cd_from
chronic_disease_name_from
Chronic_Disease_Abbr
chronic_disease_path_from
cd_to
chronic_disease_name_to
Chronic_Disease_Abbr
chronic_disease_name_from
Chronic_Disease_Abbr
chronic_disease_interim
Chronic_Disease_Abbr
chronic_disease_path_to
cd_to
chronic_disease_interim
Chronic_Disease_Abbr
chronic_disease_path_from
gender
chronic_disease_gender
gender
Comorbidity_Disease_Variables
cd_from_to
Comorbidity_Random_Path
cd_from_to
Comorbidity_Disease_Variables
cd_from_to
Comorbidity_Source_Known
cd_from_to
Comorbidity_Disease_Variables
cd_from_to
Comorbidity_Target_Known
cd_from_to
Comorbidity_Source_Known
cd_from
Comorbidty_Name_From
Chronic_Disease_Abbr
Comorbidity_Target_Known
cd_to
Comorbidty_Name_To
Chronic_Disease_Abbr
CD_Age
cd_to
cd_to_name
cd_to_code
CD_Age
cd_from
cd_from_name
cd_from_code
CD_Data
d_type_order
Developing_Type
Sort_Order
CD_Data
cd_from
cd_from_name
cd_from_code
CD_Data
cd_to
cd_to_name
cd_to_code
output: {
    "joins": [
        {
            "from_table": "chronic_disease_path_from",
            "from_column": "cd_from",
            "to_table": "chronic_disease_name_from",
            "to_column": "Chronic_Disease_Abbr"
        },
        {
            "from_table": "chronic_disease_path_from",
            "from_column": "cd_to",
            "to_table": "chronic_disease_name_to",
            "to_column": "Chronic_Disease_Abbr"
        },
        {
            "from_table": "chronic_disease_name_from",
            "from_column": "Chronic_Disease_Abbr",
            "to_table": "chronic_disease_interim",
            "to_column": "Chronic_Disease_Abbr"
        },
        {
            "from_table": "chronic_disease_path_to",
            "from_column": "cd_to",
            "to_table": "chronic_disease_interim",
            "to_column": "Chronic_Disease_Abbr"
        },
        {
            "from_table": "chronic_disease_path_from",
            "from_column": "gender",
            "to_table": "chronic_disease_gender",
            "to_column": "gender"
        },
        {
            "from_table": "Comorbidity_Disease_Variables",
            "from_column": "cd_from_to",
            "to_table": "Comorbidity_Random_Path",
            "to_column": "cd_from_to"
        },
        {
            "from_table": "Comorbidity_Disease_Variables",
            "from_column": "cd_from_to",
            "to_table": "Comorbidity_Source_Known",
            "to_column": "cd_from_to"
        },
        {
            "from_table": "Comorbidity_Disease_Variables",
            "from_column": "cd_from_to",
            "to_table": "Comorbidity_Target_Known",
            "to_column": "cd_from_to"
        },
        {
            "from_table": "Comorbidity_Source_Known",
            "from_column": "cd_from",
            "to_table": "Comorbidty_Name_From",
            "to_column": "Chronic_Disease_Abbr"
        },
        {
            "from_table": "Comorbidity_Target_Known",
            "from_column": "cd_to",
            "to_table": "Comorbidty_Name_To",
            "to_column": "Chronic_Disease_Abbr"
        },
        {
            "from_table": "CD_Age",
            "from_column": "cd_to",
            "to_table": "cd_to_name",
            "to_column": "cd_to_code"
        },
        {
            "from_table": "CD_Age",
            "from_column": "cd_from",
            "to_table": "cd_from_name",
            "to_column": "cd_from_code"
        },
        {
            "from_table": "CD_Data",
            "from_column": "d_type_order",
            "to_table": "Developing_Type",
            "to_column": "Sort_Order"
        },
        {
            "from_table": "CD_Data",
            "from_column": "cd_from",
            "to_table": "cd_from_name",
            "to_column": "cd_from_code"
        },
        {
            "from_table": "CD_Data",
            "from_column": "cd_to",
            "to_table": "cd_to_name",
            "to_column": "cd_to_code"
        }
    ]
}