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: CDNOW
|   ID | Date                    |   Volume |   Amount |
|-----:|:------------------------|---------:|---------:|
|    1 | 1997-01-01 00:00:00.000 |        1 |    11.77 |
|   19 | 1997-06-10 00:00:00.000 |        1 |    11.77 |
|   21 | 1997-01-13 00:00:00.000 |        1 |    11.77 |
|   33 | 1997-09-06 00:00:00.000 |        1 |    11.77 |
|   36 | 1997-02-03 00:00:00.000 |        1 |    11.77 |
|   42 | 1997-01-02 00:00:00.000 |        1 |    11.77 |
|   59 | 1997-01-09 00:00:00.000 |        1 |    11.77 |
|   64 | 1997-01-03 00:00:00.000 |        1 |    11.77 |
|   64 | 1997-05-12 00:00:00.000 |        1 |    11.77 |
|   67 | 1997-01-17 00:00:00.000 |        1 |    11.77 |


Table: DTreePred
|   prob1 |   prob2 |   prob3 |   prob4 |   prob5 |   prob6 |   prob7 |   prob8 |   Cluster_Resid |   Cluster |   R |   F |     M |    ID |
|--------:|--------:|--------:|--------:|--------:|--------:|--------:|--------:|----------------:|----------:|----:|----:|------:|------:|
|       1 |       0 |       0 |       0 |       0 |       0 |       0 |       0 |               0 |         1 | 505 |   1 | 11.77 | 11473 |
|       1 |       0 |       0 |       0 |       0 |       0 |       0 |       0 |               0 |         1 | 533 |   1 | 11.77 |  3269 |
|       1 |       0 |       0 |       0 |       0 |       0 |       0 |       0 |               0 |         1 | 541 |   1 | 11.77 |  1420 |
|       1 |       0 |       0 |       0 |       0 |       0 |       0 |       0 |               0 |         1 | 510 |   1 | 11.77 |  9449 |
|       1 |       0 |       0 |       0 |       0 |       0 |       0 |       0 |               0 |         1 | 494 |   1 | 11.77 | 14762 |
|       1 |       0 |       0 |       0 |       0 |       0 |       0 |       0 |               0 |         1 | 514 |   1 | 11.77 |  8619 |
|       1 |       0 |       0 |       0 |       0 |       0 |       0 |       0 |               0 |         1 | 532 |   1 | 11.77 |  3524 |
|       1 |       0 |       0 |       0 |       0 |       0 |       0 |       0 |               0 |         1 | 493 |   1 | 11.77 | 14988 |
|       1 |       0 |       0 |       0 |       0 |       0 |       0 |       0 |               0 |         1 | 478 |   1 | 11.77 | 19631 |
|       1 |       0 |       0 |       0 |       0 |       0 |       0 |       0 |               0 |         1 | 539 |   1 | 11.77 |  1835 |


Table: LogisticPred
|   LogitPredict |   IsVIP_StdErr |   IsVIP_Lower |   IsVIP_Upper |   IsVIP_Resid |    ID |   IsVIP |   R |   F |
|---------------:|---------------:|--------------:|--------------:|--------------:|------:|--------:|----:|----:|
|    0.000111737 |    2.68072e-05 |   6.98173e-05 |   0.000178821 |  -0.000111737 |  5834 |       0 | 524 |   1 |
|    0.00015454  |    3.58841e-05 |   9.80337e-05 |   0.00024361  |  -0.00015454  | 11407 |       0 | 506 |   1 |
|    0.000185049 |    4.21827e-05 |   0.000118367 |   0.000289284 |  -0.000185049 | 14324 |       0 | 496 |   1 |
|    0.000185049 |    4.21827e-05 |   0.000118367 |   0.000289284 |  -0.000185049 | 12758 |       0 | 496 |   1 |
|    0.000109742 |    2.63759e-05 |   6.85127e-05 |   0.000175776 |  -0.000109742 |  5619 |       0 | 525 |   1 |
|    0.000188413 |    4.28699e-05 |   0.000120619 |   0.000294299 |  -0.000188413 | 14278 |       0 | 495 |   1 |
|    0.000217623 |    4.87825e-05 |   0.000140242 |   0.000337685 |  -0.000217623 | 16857 |       0 | 487 |   1 |
|    0.000213737 |    4.80014e-05 |   0.000137625 |   0.00033193  |  -0.000213737 | 15629 |       0 | 488 |   1 |
|    0.000246872 |    5.46154e-05 |   0.000160008 |   0.000380876 |  -0.000246872 | 18669 |       0 | 480 |   1 |
|    0.000120087 |    2.86037e-05 |   7.52885e-05 |   0.000191536 |  -0.000120087 |  7016 |       0 | 520 |   1 |


Table: RFMVIPCluster
|   ID |   R |   F |     M |   R_Score |   F_Score |   M_Score |   Toltal_Score |   IsVIP |   Cluster |
|-----:|----:|----:|------:|----------:|----------:|----------:|---------------:|--------:|----------:|
|  215 | 546 |   1 | 11.77 |         1 |         1 |         1 |            111 |       0 |         1 |
|  169 | 546 |   1 | 11.77 |         1 |         1 |         1 |            111 |       0 |         1 |
| 4958 | 527 |   1 | 11.77 |         1 |         1 |         1 |            111 |       0 |         1 |
| 2688 | 536 |   1 | 11.77 |         1 |         1 |         1 |            111 |       0 |         1 |
| 7125 | 519 |   1 | 11.77 |         1 |         1 |         1 |            111 |       0 |         1 |
| 4912 | 527 |   1 | 11.77 |         1 |         1 |         1 |            111 |       0 |         1 |
|  584 | 530 |   1 | 11.77 |         1 |         1 |         1 |            111 |       0 |         1 |
| 7849 | 517 |   1 | 11.77 |         1 |         1 |         1 |            111 |       0 |         1 |
| 4978 | 527 |   1 | 11.77 |         1 |         1 |         1 |            111 |       0 |         1 |
| 2645 | 536 |   1 | 11.77 |         1 |         1 |         1 |            111 |       0 |         1 |

 


tables: name: CDNOW
data: CDNOW.csv
name: DTreePred
data: DTreePred.csv
name: LogisticPred
data: LogisticPred.csv
name: RFMVIPCluster
data: RFMVIPCluster.csv
label: LogisticPred
ID
RFMVIPCluster
ID
DTreePred
ID
RFMVIPCluster
ID
CDNOW
ID
RFMVIPCluster
ID
output: {
    "joins": [
        {
            "from_table": "LogisticPred",
            "from_column": "ID",
            "to_table": "RFMVIPCluster",
            "to_column": "ID"
        },
        {
            "from_table": "DTreePred",
            "from_column": "ID",
            "to_table": "RFMVIPCluster",
            "to_column": "ID"
        },
        {
            "from_table": "CDNOW",
            "from_column": "ID",
            "to_table": "RFMVIPCluster",
            "to_column": "ID"
        }
    ]
}