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: Collections
| Date                    |   Collections | Community   |
|:------------------------|--------------:|:------------|
| 2019-12-31 00:00:00.000 |       1000000 | ABC         |
| 2020-01-31 00:00:00.000 |       2033000 | ABC         |
| 2020-02-29 00:00:00.000 |        490000 | ABC         |
| 2020-03-31 00:00:00.000 |       5000079 | ABC         |
| 2020-04-30 00:00:00.000 |       6000050 | ABC         |
| 2020-05-31 00:00:00.000 |       3595999 | ABC         |
| 2020-06-30 00:00:00.000 |       5655555 | ABC         |
| 2020-07-31 00:00:00.000 |        899999 | ABC         |
| 2020-08-31 00:00:00.000 |        899999 | ABC         |
| 2020-09-30 00:00:00.000 |       6899999 | ABC         |


Table: Date
| Date                    |   Year |   QuarterOfYear |   MonthOfYear |   DayOfMonth |   DateInt | MonthName   | MonthInCalendar   | QuarterInCalendar   |   DayInWeek | DayOfWeekName   | WeekEnding              |   Week Number |   MonthnYear |   QuarternYear |   ShortYear | FY   | IF Prev Month and above   | CurrentAndFutureMonths   |
|:------------------------|-------:|----------------:|--------------:|-------------:|----------:|:------------|:------------------|:--------------------|------------:|:----------------|:------------------------|--------------:|-------------:|---------------:|------------:|:-----|:--------------------------|:-------------------------|
| 2024-07-01 00:00:00.000 |   2024 |               3 |             7 |            1 |  20240701 | July        | Jul 2024          | Q3 2024             |           1 | Monday          | 2024-07-06 00:00:00.000 |            27 |     20240700 |       20240300 |          24 | FY25 | Y                         | True                     |
| 2024-07-02 00:00:00.000 |   2024 |               3 |             7 |            2 |  20240702 | July        | Jul 2024          | Q3 2024             |           2 | Tuesday         | 2024-07-06 00:00:00.000 |            27 |     20240700 |       20240300 |          24 | FY25 | Y                         | True                     |
| 2024-07-03 00:00:00.000 |   2024 |               3 |             7 |            3 |  20240703 | July        | Jul 2024          | Q3 2024             |           3 | Wednesday       | 2024-07-06 00:00:00.000 |            27 |     20240700 |       20240300 |          24 | FY25 | Y                         | True                     |
| 2024-07-04 00:00:00.000 |   2024 |               3 |             7 |            4 |  20240704 | July        | Jul 2024          | Q3 2024             |           4 | Thursday        | 2024-07-06 00:00:00.000 |            27 |     20240700 |       20240300 |          24 | FY25 | Y                         | True                     |
| 2024-07-05 00:00:00.000 |   2024 |               3 |             7 |            5 |  20240705 | July        | Jul 2024          | Q3 2024             |           5 | Friday          | 2024-07-06 00:00:00.000 |            27 |     20240700 |       20240300 |          24 | FY25 | Y                         | True                     |
| 2024-07-06 00:00:00.000 |   2024 |               3 |             7 |            6 |  20240706 | July        | Jul 2024          | Q3 2024             |           6 | Saturday        | 2024-07-06 00:00:00.000 |            27 |     20240700 |       20240300 |          24 | FY25 | Y                         | True                     |
| 2024-07-07 00:00:00.000 |   2024 |               3 |             7 |            7 |  20240707 | July        | Jul 2024          | Q3 2024             |           0 | Sunday          | 2024-07-13 00:00:00.000 |            28 |     20240700 |       20240300 |          24 | FY25 | Y                         | True                     |
| 2024-07-08 00:00:00.000 |   2024 |               3 |             7 |            8 |  20240708 | July        | Jul 2024          | Q3 2024             |           1 | Monday          | 2024-07-13 00:00:00.000 |            28 |     20240700 |       20240300 |          24 | FY25 | Y                         | True                     |
| 2024-07-09 00:00:00.000 |   2024 |               3 |             7 |            9 |  20240709 | July        | Jul 2024          | Q3 2024             |           2 | Tuesday         | 2024-07-13 00:00:00.000 |            28 |     20240700 |       20240300 |          24 | FY25 | Y                         | True                     |
| 2024-07-10 00:00:00.000 |   2024 |               3 |             7 |           10 |  20240710 | July        | Jul 2024          | Q3 2024             |           3 | Wednesday       | 2024-07-13 00:00:00.000 |            28 |     20240700 |       20240300 |          24 | FY25 | Y                         | True                     |


Table: POC
| Community   | Date                    |    POC |   POC Bin |   Current Month POC |
|:------------|:------------------------|-------:|----------:|--------------------:|
| ABC         | 2021-01-31 00:00:00.000 | 0.6865 |      0.65 |              0.6865 |
| ABC         | 2020-12-31 00:00:00.000 | 0.6595 |      0.65 |              0.6595 |
| ABC         | 2020-11-30 00:00:00.000 | 0.6535 |      0.65 |              0.6535 |
| ABC         | 2021-03-31 00:00:00.000 | 0.7405 |      0.7  |              0.7405 |
| ABC         | 2021-02-28 00:00:00.000 | 0.7135 |      0.7  |              0.7135 |
| ABC         | 2021-06-30 00:00:00.000 | 0.7955 |      0.75 |              0.7955 |
| ABC         | 2021-05-31 00:00:00.000 | 0.7755 |      0.75 |              0.7755 |
| ABC         | 2021-04-30 00:00:00.000 | 0.7605 |      0.75 |              0.7605 |
| ABC         | 2020-10-31 00:00:00.000 | 0.6475 |      0.6  |              0.6475 |
| ABC         | 2020-09-30 00:00:00.000 | 0.6415 |      0.6  |              0.6415 |


Table: Tab
| Date                    |   Year |   QuarterOfYear |   MonthOfYear |   DayOfMonth |   DateInt | MonthName   | MonthInCalendar   | QuarterInCalendar   |   DayInWeek | DayOfWeekName   | WeekEnding              |   Week Number |   MonthnYear |   QuarternYear |   ShortYear | FY   | IF Prev Month and above   | CurrentAndFutureMonths   |
|:------------------------|-------:|----------------:|--------------:|-------------:|----------:|:------------|:------------------|:--------------------|------------:|:----------------|:------------------------|--------------:|-------------:|---------------:|------------:|:-----|:--------------------------|:-------------------------|
| 2024-07-01 00:00:00.000 |   2024 |               3 |             7 |            1 |  20240701 | July        | Jul 2024          | Q3 2024             |           1 | Monday          | 2024-07-06 00:00:00.000 |            27 |     20240700 |       20240300 |          24 | FY25 | Y                         | True                     |
| 2024-07-02 00:00:00.000 |   2024 |               3 |             7 |            2 |  20240702 | July        | Jul 2024          | Q3 2024             |           2 | Tuesday         | 2024-07-06 00:00:00.000 |            27 |     20240700 |       20240300 |          24 | FY25 | Y                         | True                     |
| 2024-07-03 00:00:00.000 |   2024 |               3 |             7 |            3 |  20240703 | July        | Jul 2024          | Q3 2024             |           3 | Wednesday       | 2024-07-06 00:00:00.000 |            27 |     20240700 |       20240300 |          24 | FY25 | Y                         | True                     |
| 2024-07-04 00:00:00.000 |   2024 |               3 |             7 |            4 |  20240704 | July        | Jul 2024          | Q3 2024             |           4 | Thursday        | 2024-07-06 00:00:00.000 |            27 |     20240700 |       20240300 |          24 | FY25 | Y                         | True                     |
| 2024-07-05 00:00:00.000 |   2024 |               3 |             7 |            5 |  20240705 | July        | Jul 2024          | Q3 2024             |           5 | Friday          | 2024-07-06 00:00:00.000 |            27 |     20240700 |       20240300 |          24 | FY25 | Y                         | True                     |
| 2024-07-06 00:00:00.000 |   2024 |               3 |             7 |            6 |  20240706 | July        | Jul 2024          | Q3 2024             |           6 | Saturday        | 2024-07-06 00:00:00.000 |            27 |     20240700 |       20240300 |          24 | FY25 | Y                         | True                     |
| 2024-07-07 00:00:00.000 |   2024 |               3 |             7 |            7 |  20240707 | July        | Jul 2024          | Q3 2024             |           0 | Sunday          | 2024-07-13 00:00:00.000 |            28 |     20240700 |       20240300 |          24 | FY25 | Y                         | True                     |
| 2024-07-08 00:00:00.000 |   2024 |               3 |             7 |            8 |  20240708 | July        | Jul 2024          | Q3 2024             |           1 | Monday          | 2024-07-13 00:00:00.000 |            28 |     20240700 |       20240300 |          24 | FY25 | Y                         | True                     |
| 2024-07-09 00:00:00.000 |   2024 |               3 |             7 |            9 |  20240709 | July        | Jul 2024          | Q3 2024             |           2 | Tuesday         | 2024-07-13 00:00:00.000 |            28 |     20240700 |       20240300 |          24 | FY25 | Y                         | True                     |
| 2024-07-10 00:00:00.000 |   2024 |               3 |             7 |           10 |  20240710 | July        | Jul 2024          | Q3 2024             |           3 | Wednesday       | 2024-07-13 00:00:00.000 |            28 |     20240700 |       20240300 |          24 | FY25 | Y                         | True                     |


Table: TB
| Date                    |   TB Amount |
|:------------------------|------------:|
| 2020-09-30 00:00:00.000 |       20000 |
| 2020-09-30 00:00:00.000 |      300000 |
| 2020-09-30 00:00:00.000 |     -400000 |
| 2020-09-30 00:00:00.000 |     6660000 |
| 2020-09-30 00:00:00.000 |     -555000 |
| 2020-09-30 00:00:00.000 |     6000555 |
| 2020-09-30 00:00:00.000 |     3999999 |

 


tables: name: Collections
data: Collections.csv
name: Date
data: Date.csv
name: POC
data: POC.csv
name: Tab
data: Tab.csv
name: TB
data: TB.csv
label: POC
Date
Date
Date
Collections
Date
Date
Date
TB
Date
Date
Date
output: {
    "joins": [
        {
            "from_table": "POC",
            "from_column": "Date",
            "to_table": "Date",
            "to_column": "Date"
        },
        {
            "from_table": "Collections",
            "from_column": "Date",
            "to_table": "Date",
            "to_column": "Date"
        },
        {
            "from_table": "TB",
            "from_column": "Date",
            "to_table": "Date",
            "to_column": "Date"
        }
    ]
}