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: Calendar
| Date                    | Year                    | Year-Month   | Year-Quarter   | Quarter   | Month   |   MonthNo |   WeekNo | DayofWeek   |   DayofWeekNo |   DayofMonthNo |   SortNo | Week StartDate          |   Week Rank | Month Year              |
|:------------------------|:------------------------|:-------------|:---------------|:----------|:--------|----------:|---------:|:------------|--------------:|---------------:|---------:|:------------------------|------------:|:------------------------|
| 2021-07-01 00:00:00.000 | 2021-01-01 00:00:00.000 | 2021-Jul     | 2021-Q3        | Q3        | Jul     |         7 |       27 | Thu         |             4 |              1 | 20210701 | 2021-06-28 00:00:00.000 |          27 | 2021-07-31 00:00:00.000 |
| 2021-07-02 00:00:00.000 | 2021-01-01 00:00:00.000 | 2021-Jul     | 2021-Q3        | Q3        | Jul     |         7 |       27 | Fri         |             5 |              2 | 20210702 | 2021-06-28 00:00:00.000 |          27 | 2021-07-31 00:00:00.000 |
| 2021-07-03 00:00:00.000 | 2021-01-01 00:00:00.000 | 2021-Jul     | 2021-Q3        | Q3        | Jul     |         7 |       27 | Sat         |             6 |              3 | 20210703 | 2021-06-28 00:00:00.000 |          27 | 2021-07-31 00:00:00.000 |
| 2021-07-04 00:00:00.000 | 2021-01-01 00:00:00.000 | 2021-Jul     | 2021-Q3        | Q3        | Jul     |         7 |       27 | Sun         |             7 |              4 | 20210704 | 2021-06-28 00:00:00.000 |          27 | 2021-07-31 00:00:00.000 |
| 2021-07-05 00:00:00.000 | 2021-01-01 00:00:00.000 | 2021-Jul     | 2021-Q3        | Q3        | Jul     |         7 |       28 | Mon         |             1 |              5 | 20210705 | 2021-07-05 00:00:00.000 |          28 | 2021-07-31 00:00:00.000 |
| 2021-07-06 00:00:00.000 | 2021-01-01 00:00:00.000 | 2021-Jul     | 2021-Q3        | Q3        | Jul     |         7 |       28 | Tue         |             2 |              6 | 20210706 | 2021-07-05 00:00:00.000 |          28 | 2021-07-31 00:00:00.000 |
| 2021-07-07 00:00:00.000 | 2021-01-01 00:00:00.000 | 2021-Jul     | 2021-Q3        | Q3        | Jul     |         7 |       28 | Wed         |             3 |              7 | 20210707 | 2021-07-05 00:00:00.000 |          28 | 2021-07-31 00:00:00.000 |
| 2021-07-08 00:00:00.000 | 2021-01-01 00:00:00.000 | 2021-Jul     | 2021-Q3        | Q3        | Jul     |         7 |       28 | Thu         |             4 |              8 | 20210708 | 2021-07-05 00:00:00.000 |          28 | 2021-07-31 00:00:00.000 |
| 2021-07-09 00:00:00.000 | 2021-01-01 00:00:00.000 | 2021-Jul     | 2021-Q3        | Q3        | Jul     |         7 |       28 | Fri         |             5 |              9 | 20210709 | 2021-07-05 00:00:00.000 |          28 | 2021-07-31 00:00:00.000 |
| 2021-07-10 00:00:00.000 | 2021-01-01 00:00:00.000 | 2021-Jul     | 2021-Q3        | Q3        | Jul     |         7 |       28 | Sat         |             6 |             10 | 20210710 | 2021-07-05 00:00:00.000 |          28 | 2021-07-31 00:00:00.000 |


Table: Carrier
| CARRIER   |
|:----------|
| AA        |
| DL        |
| UA        |
| AS        |
| VX        |
| HA        |
| 9E        |
| B6        |
| EV        |
| MQ        |


Table: JFK
| FL_DATE                 | OP_CARRIER   |   OP_CARRIER_FL_NUM | ORIGIN   | DEST   | STD                     | STD.HR                  | ATD                     | ATD.HR                  |   DEP_DELAY |   DEP_DEL15 |   TAXI_OUT | TOF                     | TOF.HR                  | TDN                     | TDN.HR                  |   TAXI_IN | STA                     | STA.HR                  | ATA                     | ATA.HR                  |   ARR_DELAY |   ARR_DEL15 |   CANCELLED | CANCELLATION_CODE   |   DIVERTED |   CRS_ELAPSED_TIME |   ACTUAL_ELAPSED_TIME |   AIR_TIME | CARRIER_DELAY   | WEATHER_DELAY   | NAS_DELAY   | SECURITY_DELAY   | LATE_AIRCRAFT_DELAY   | SVC_TYP    |   Year |   Month |
|:------------------------|:-------------|--------------------:|:---------|:-------|:------------------------|:------------------------|:------------------------|:------------------------|------------:|------------:|-----------:|:------------------------|:------------------------|:------------------------|:------------------------|----------:|:------------------------|:------------------------|:------------------------|:------------------------|------------:|------------:|------------:|:--------------------|-----------:|-------------------:|----------------------:|-----------:|:----------------|:----------------|:------------|:-----------------|:----------------------|:-----------|-------:|--------:|
| 2021-01-10 00:00:00.000 | 9E           |                4636 | JFK      | RDU    | 1899-12-30 14:55:00.000 | 1899-12-30 14:00:00.000 | 1899-12-30 14:50:00.000 | 1899-12-30 14:00:00.000 |          -5 |           0 |         22 | 1899-12-30 15:12:00.000 | 1899-12-30 15:00:00.000 | 1899-12-30 16:31:00.000 | 1899-12-30 16:00:00.000 |         4 | 1899-12-30 16:42:00.000 | 1899-12-30 16:00:00.000 | 1899-12-30 16:35:00.000 | 1899-12-30 16:00:00.000 |          -7 |           0 |           0 |                     |          0 |                107 |                   105 |         79 |                 |                 |             |                  |                       | Short-haul |   2021 |       1 |
| 2021-01-11 00:00:00.000 | 9E           |                4636 | JFK      | RDU    | 1899-12-30 14:55:00.000 | 1899-12-30 14:00:00.000 | 1899-12-30 14:50:00.000 | 1899-12-30 14:00:00.000 |          -5 |           0 |         15 | 1899-12-30 15:05:00.000 | 1899-12-30 15:00:00.000 | 1899-12-30 16:21:00.000 | 1899-12-30 16:00:00.000 |         4 | 1899-12-30 16:42:00.000 | 1899-12-30 16:00:00.000 | 1899-12-30 16:25:00.000 | 1899-12-30 16:00:00.000 |         -17 |           0 |           0 |                     |          0 |                107 |                    95 |         76 |                 |                 |             |                  |                       | Short-haul |   2021 |       1 |
| 2021-01-14 00:00:00.000 | 9E           |                4804 | JFK      | RDU    | 1899-12-30 08:35:00.000 | 1899-12-30 08:00:00.000 | 1899-12-30 08:30:00.000 | 1899-12-30 08:00:00.000 |          -5 |           0 |         21 | 1899-12-30 08:51:00.000 | 1899-12-30 08:00:00.000 | 1899-12-30 10:02:00.000 | 1899-12-30 10:00:00.000 |         4 | 1899-12-30 10:30:00.000 | 1899-12-30 10:00:00.000 | 1899-12-30 10:06:00.000 | 1899-12-30 10:00:00.000 |         -24 |           0 |           0 |                     |          0 |                115 |                    96 |         71 |                 |                 |             |                  |                       | Short-haul |   2021 |       1 |
| 2021-01-15 00:00:00.000 | 9E           |                5178 | JFK      | SAV    | 1899-12-30 10:29:00.000 | 1899-12-30 10:00:00.000 | 1899-12-30 10:24:00.000 | 1899-12-30 10:00:00.000 |          -5 |           0 |          8 | 1899-12-30 10:32:00.000 | 1899-12-30 10:00:00.000 | 1899-12-30 12:29:00.000 | 1899-12-30 12:00:00.000 |         4 | 1899-12-30 12:53:00.000 | 1899-12-30 12:00:00.000 | 1899-12-30 12:33:00.000 | 1899-12-30 12:00:00.000 |         -20 |           0 |           0 |                     |          0 |                144 |                   129 |        117 |                 |                 |             |                  |                       | Short-haul |   2021 |       1 |
| 2021-01-30 00:00:00.000 | 9E           |                5178 | JFK      | SAV    | 1899-12-30 10:29:00.000 | 1899-12-30 10:00:00.000 | 1899-12-30 10:24:00.000 | 1899-12-30 10:00:00.000 |          -5 |           0 |          9 | 1899-12-30 10:33:00.000 | 1899-12-30 10:00:00.000 | 1899-12-30 12:21:00.000 | 1899-12-30 12:00:00.000 |         4 | 1899-12-30 12:53:00.000 | 1899-12-30 12:00:00.000 | 1899-12-30 12:25:00.000 | 1899-12-30 12:00:00.000 |         -28 |           0 |           0 |                     |          0 |                144 |                   121 |        108 |                 |                 |             |                  |                       | Short-haul |   2021 |       1 |
| 2021-02-02 00:00:00.000 | 9E           |                4636 | JFK      | RDU    | 1899-12-30 14:55:00.000 | 1899-12-30 14:00:00.000 | 1899-12-30 14:50:00.000 | 1899-12-30 14:00:00.000 |          -5 |           0 |         38 | 1899-12-30 15:28:00.000 | 1899-12-30 15:00:00.000 | 1899-12-30 16:32:00.000 | 1899-12-30 16:00:00.000 |         4 | 1899-12-30 16:42:00.000 | 1899-12-30 16:00:00.000 | 1899-12-30 16:36:00.000 | 1899-12-30 16:00:00.000 |          -6 |           0 |           0 |                     |          0 |                107 |                   106 |         64 |                 |                 |             |                  |                       | Short-haul |   2021 |       2 |
| 2021-02-05 00:00:00.000 | 9E           |                4636 | JFK      | RDU    | 1899-12-30 14:55:00.000 | 1899-12-30 14:00:00.000 | 1899-12-30 14:50:00.000 | 1899-12-30 14:00:00.000 |          -5 |           0 |         12 | 1899-12-30 15:02:00.000 | 1899-12-30 15:00:00.000 | 1899-12-30 16:26:00.000 | 1899-12-30 16:00:00.000 |         4 | 1899-12-30 16:42:00.000 | 1899-12-30 16:00:00.000 | 1899-12-30 16:30:00.000 | 1899-12-30 16:00:00.000 |         -12 |           0 |           0 |                     |          0 |                107 |                   100 |         84 |                 |                 |             |                  |                       | Short-haul |   2021 |       2 |
| 2021-02-25 00:00:00.000 | 9E           |                4636 | JFK      | RDU    | 1899-12-30 14:55:00.000 | 1899-12-30 14:00:00.000 | 1899-12-30 14:50:00.000 | 1899-12-30 14:00:00.000 |          -5 |           0 |          9 | 1899-12-30 14:59:00.000 | 1899-12-30 14:00:00.000 | 1899-12-30 16:20:00.000 | 1899-12-30 16:00:00.000 |         4 | 1899-12-30 16:42:00.000 | 1899-12-30 16:00:00.000 | 1899-12-30 16:24:00.000 | 1899-12-30 16:00:00.000 |         -18 |           0 |           0 |                     |          0 |                107 |                    94 |         81 |                 |                 |             |                  |                       | Short-haul |   2021 |       2 |
| 2021-03-03 00:00:00.000 | 9E           |                5003 | JFK      | SYR    | 1899-12-30 15:00:00.000 | 1899-12-30 15:00:00.000 | 1899-12-30 14:55:00.000 | 1899-12-30 14:00:00.000 |          -5 |           0 |         17 | 1899-12-30 15:12:00.000 | 1899-12-30 15:00:00.000 | 1899-12-30 15:59:00.000 | 1899-12-30 15:00:00.000 |         4 | 1899-12-30 16:15:00.000 | 1899-12-30 16:00:00.000 | 1899-12-30 16:03:00.000 | 1899-12-30 16:00:00.000 |         -12 |           0 |           0 |                     |          0 |                 75 |                    68 |         47 |                 |                 |             |                  |                       | Short-haul |   2021 |       3 |
| 2021-03-05 00:00:00.000 | 9E           |                5062 | JFK      | BTV    | 1899-12-30 19:59:00.000 | 1899-12-30 19:00:00.000 | 1899-12-30 19:54:00.000 | 1899-12-30 19:00:00.000 |          -5 |           0 |         18 | 1899-12-30 20:12:00.000 | 1899-12-30 20:00:00.000 | 1899-12-30 21:02:00.000 | 1899-12-30 21:00:00.000 |         4 | 1899-12-30 21:30:00.000 | 1899-12-30 21:00:00.000 | 1899-12-30 21:06:00.000 | 1899-12-30 21:00:00.000 |         -24 |           0 |           0 |                     |          0 |                 91 |                    72 |         50 |                 |                 |             |                  |                       | Short-haul |   2021 |       3 |


Table: STA.HR
| STA.HR                  |
|:------------------------|
| 1899-12-30 09:00:00.000 |
| 1899-12-30 08:00:00.000 |
| 1899-12-30 14:00:00.000 |
| 1899-12-30 13:00:00.000 |
| 1899-12-30 07:00:00.000 |
| 1899-12-30 18:00:00.000 |
| 1899-12-30 17:00:00.000 |
| 1899-12-30 16:00:00.000 |
| 1899-12-30 10:00:00.000 |
| 1899-12-30 05:00:00.000 |


Table: STD.HR
| STD.HR                  |
|:------------------------|
| 1899-12-30 07:00:00.000 |
| 1899-12-30 11:00:00.000 |
| 1899-12-30 12:00:00.000 |
| 1899-12-30 10:00:00.000 |
| 1899-12-30 06:00:00.000 |
| 1899-12-30 15:00:00.000 |
| 1899-12-30 14:00:00.000 |
| 1899-12-30 08:00:00.000 |
| 1899-12-30 21:00:00.000 |
| 1899-12-30 19:00:00.000 |


Table: Svc Type
| SVC_TYP     |   Index |
|:------------|--------:|
| Short-haul  |       1 |
| Medium-haul |       2 |
| Long-haul   |       3 |


Table: TimeTable
|   MinRange |   HrRange | TimeKey                 | DayQuartile   | HourlyQuartile   |
|-----------:|----------:|:------------------------|:--------------|:-----------------|
|          0 |         0 | 1899-12-30 00:00:00.000 | 0000-0559     | 0-14             |
|          0 |         1 | 1899-12-30 01:00:00.000 | 0000-0559     | 0-14             |
|          0 |         2 | 1899-12-30 02:00:00.000 | 0000-0559     | 0-14             |
|          0 |         3 | 1899-12-30 03:00:00.000 | 0000-0559     | 0-14             |
|          0 |         4 | 1899-12-30 04:00:00.000 | 0000-0559     | 0-14             |
|          0 |         5 | 1899-12-30 05:00:00.000 | 0000-0559     | 0-14             |
|          1 |         0 | 1899-12-30 00:01:00.000 | 0000-0559     | 0-14             |
|          1 |         1 | 1899-12-30 01:01:00.000 | 0000-0559     | 0-14             |
|          1 |         2 | 1899-12-30 02:01:00.000 | 0000-0559     | 0-14             |
|          1 |         3 | 1899-12-30 03:01:00.000 | 0000-0559     | 0-14             |

 


tables: name: Calendar
data: Calendar.csv
name: Carrier
data: Carrier.csv
name: JFK
data: JFK.csv
name: STA.HR
data: STA.HR.csv
name: STD.HR
data: STD.HR.csv
name: Svc Type
data: Svc Type.csv
name: TimeTable
data: TimeTable.csv
label: JFK
OP_CARRIER
Carrier
CARRIER
output: {
    "joins": [
        {
            "from_table": "JFK",
            "from_column": "OP_CARRIER",
            "to_table": "Carrier",
            "to_column": "CARRIER"
        }
    ]
}