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: DateTable
| Date                    |   Year |   QuarterOfYear |   MonthOfYear |   DayOfMonth |   DateInt | MonthName   | MonthInCalendar   | QuarterInCalendar   |   DayInWeek | DayOfWeekName   | WeekEnding              |   Week Number |   MonthnYear |   QuarternYear |   ShortYear | FY   |
|:------------------------|-------:|----------------:|--------------:|-------------:|----------:|:------------|:------------------|:--------------------|------------:|:----------------|:------------------------|--------------:|-------------:|---------------:|------------:|:-----|
| 2015-07-01 00:00:00.000 |   2015 |               3 |             7 |            1 |  20150701 | July        | Jul 2015          | Q3 2015             |           3 | Wednesday       | 2015-07-04 00:00:00.000 |            27 |     20150700 |       20150300 |          15 | FY15 |
| 2015-07-02 00:00:00.000 |   2015 |               3 |             7 |            2 |  20150702 | July        | Jul 2015          | Q3 2015             |           4 | Thursday        | 2015-07-04 00:00:00.000 |            27 |     20150700 |       20150300 |          15 | FY15 |
| 2015-07-03 00:00:00.000 |   2015 |               3 |             7 |            3 |  20150703 | July        | Jul 2015          | Q3 2015             |           5 | Friday          | 2015-07-04 00:00:00.000 |            27 |     20150700 |       20150300 |          15 | FY15 |
| 2015-07-04 00:00:00.000 |   2015 |               3 |             7 |            4 |  20150704 | July        | Jul 2015          | Q3 2015             |           6 | Saturday        | 2015-07-04 00:00:00.000 |            27 |     20150700 |       20150300 |          15 | FY15 |
| 2015-07-05 00:00:00.000 |   2015 |               3 |             7 |            5 |  20150705 | July        | Jul 2015          | Q3 2015             |           0 | Sunday          | 2015-07-11 00:00:00.000 |            28 |     20150700 |       20150300 |          15 | FY15 |
| 2015-07-06 00:00:00.000 |   2015 |               3 |             7 |            6 |  20150706 | July        | Jul 2015          | Q3 2015             |           1 | Monday          | 2015-07-11 00:00:00.000 |            28 |     20150700 |       20150300 |          15 | FY15 |
| 2015-07-07 00:00:00.000 |   2015 |               3 |             7 |            7 |  20150707 | July        | Jul 2015          | Q3 2015             |           2 | Tuesday         | 2015-07-11 00:00:00.000 |            28 |     20150700 |       20150300 |          15 | FY15 |
| 2015-07-08 00:00:00.000 |   2015 |               3 |             7 |            8 |  20150708 | July        | Jul 2015          | Q3 2015             |           3 | Wednesday       | 2015-07-11 00:00:00.000 |            28 |     20150700 |       20150300 |          15 | FY15 |
| 2015-07-09 00:00:00.000 |   2015 |               3 |             7 |            9 |  20150709 | July        | Jul 2015          | Q3 2015             |           4 | Thursday        | 2015-07-11 00:00:00.000 |            28 |     20150700 |       20150300 |          15 | FY15 |
| 2015-07-10 00:00:00.000 |   2015 |               3 |             7 |           10 |  20150710 | July        | Jul 2015          | Q3 2015             |           5 | Friday          | 2015-07-11 00:00:00.000 |            28 |     20150700 |       20150300 |          15 | FY15 |


Table: EODTable
| Customer Level 2                             | Vacancy Number   | Request Number   | Custom Identifier   | PD Number   | Title                                  | Pay Plan   |   Series |   Grade Selected |   # Apps Rec'd | Duty Location                                                                      | AOC             | Internal / External   | Selection Cert   | Req Initiated           | Req Received            |   Request Initiated Time | PD Validated            |   Review PD Time | JAA Samples Sent   | Draft JAA Sent   | JAA Sent to Mgr         | JAA Approved            |   Confirm JAA Strategy Time | JOA Sent for Review     | JOA Approved            | JOA Finalized by HR     |   JOA Finalized Time | JOA Opened              | JOA Closed              |   Receive Applications Time | Sent to SME   | Received from SME   |   SME Sent Time | Quals Completed         |   Quals Complete Time | Cert Issued             |   Cert Issued Time | Selection Made          |   Selection Made Time | Tent Offer Made         | Tent Offer Accepted     |   Tent Offer Time | PSI/BI Req              | PSI/BI Rec              | Physical Req   | Physical Rec   | Drug Test Req   | Drug Test Rec   | Other Info Req   | Other Info Rec   |   Total Preemployment Check Time | Official Offer Made     |   Official Offer Made Time | EOD Date                |   EOD Time |   Total Towards 80 Day Metric | Meets 80 Days?   |   Total Towards 23 Day Metric | Meets 23 Days?   | Pay Period   | WE FRI                  | EOD Status   |   FY Year |   01/02 Validate Need and Request Personnel Action |   03 Review Position Description |   04 Confirm Job Analysis |   05 Post Job Announcement |   06 Receive Applications |   07 Min. Quals Review |   08 Issue Cert/Notify Applicants |   09 Interview and Select |   10 Make Initial Job Offer |   11 Pre-Emp/Security Checks |   12 Official Offer Made |   13 Entrance On Duty | Column   |
|:---------------------------------------------|:-----------------|:-----------------|:--------------------|:------------|:---------------------------------------|:-----------|---------:|-----------------:|---------------:|:-----------------------------------------------------------------------------------|:----------------|:----------------------|:-----------------|:------------------------|:------------------------|-------------------------:|:------------------------|-----------------:|:-------------------|:-----------------|:------------------------|:------------------------|----------------------------:|:------------------------|:------------------------|:------------------------|---------------------:|:------------------------|:------------------------|----------------------------:|:--------------|:--------------------|----------------:|:------------------------|----------------------:|:------------------------|-------------------:|:------------------------|----------------------:|:------------------------|:------------------------|------------------:|:------------------------|:------------------------|:---------------|:---------------|:----------------|:----------------|:-----------------|:-----------------|---------------------------------:|:------------------------|---------------------------:|:------------------------|-----------:|------------------------------:|:-----------------|------------------------------:|:-----------------|:-------------|:------------------------|:-------------|----------:|---------------------------------------------------:|---------------------------------:|--------------------------:|---------------------------:|--------------------------:|-----------------------:|----------------------------------:|--------------------------:|----------------------------:|-----------------------------:|-------------------------:|----------------------:|:---------|
| Office of Chief Human Capital Officer        | 17-HUD-863       | 242841           | INT - 9296          | HA0459      | Supervisory Human Resources Specialist | GS         |      201 |               15 |              5 | Robert Weaver Building, 451 7th Street SW, Washington, DC 20410                    | Merit Promotion | Internal              | MPC              | 2017-08-30 00:00:00.000 | 2017-08-30 00:00:00.000 |                        0 | 2017-08-31 00:00:00.000 |                1 |                    |                  | 2017-08-31 00:00:00.000 | 2017-08-31 00:00:00.000 |                           0 | 2017-09-05 00:00:00.000 | 2017-09-05 00:00:00.000 | 2017-09-05 00:00:00.000 |                    0 | 2017-09-05 00:00:00.000 | 2017-09-11 00:00:00.000 |                           6 |               |                     |               0 | 2017-09-12 00:00:00.000 |                     1 | 2017-09-12 00:00:00.000 |                  0 | 2017-10-06 00:00:00.000 |                    24 | 2017-10-10 00:00:00.000 | 2017-10-10 00:00:00.000 |                 4 | 2017-10-10 00:00:00.000 | 2017-10-10 00:00:00.000 |                |                |                 |                 |                  |                  |                                0 | 2017-10-10 00:00:00.000 |                          0 | 2017-10-15 00:00:00.000 |          5 |                            46 | Yes              |                             5 | Yes              |              | 2017-10-20 00:00:00.000 | Hired        |      2020 |                                                  0 |                                1 |                         0 |                          5 |                         6 |                      1 |                                 0 |                        24 |                           4 |                            0 |                        0 |                     5 |          |
| Office of Public and Indian Housing          | 15-HUD-428       | 206107-1         |                     | HP0719      | Energy Management Specialist           | GS         |     1101 |               13 |             84 | 1670 Broadway, 21th Fl, Denver, CO 80202                                           | Merit Promotion | External              | MPC              | 2015-03-10 00:00:00.000 | 2015-03-10 00:00:00.000 |                        0 | 2015-03-11 00:00:00.000 |                1 |                    |                  | 2015-04-01 00:00:00.000 | 2015-04-01 00:00:00.000 |                          21 | 2015-04-02 00:00:00.000 | 2015-04-03 00:00:00.000 | 2015-04-03 00:00:00.000 |                    0 | 2015-04-03 00:00:00.000 | 2015-04-20 00:00:00.000 |                          17 |               |                     |               0 | 2015-05-05 00:00:00.000 |                    15 | 2015-05-05 00:00:00.000 |                  0 | 2015-09-30 00:00:00.000 |                     6 | 2015-10-05 00:00:00.000 | 2015-10-05 00:00:00.000 |                 0 | 2015-10-05 00:00:00.000 | 2015-10-22 00:00:00.000 |                |                |                 |                 |                  |                  |                               22 | 2015-10-29 00:00:00.000 |                          7 | 2015-11-15 00:00:00.000 |         17 |                           250 | No               |                            22 | Yes              |              | 2015-11-20 00:00:00.000 | Hired        |      2020 |                                                  0 |                                1 |                        21 |                          2 |                        17 |                     15 |                                 0 |                       148 |                           5 |                           17 |                        7 |                    17 |          |
| Office of Public and Indian Housing          | 15-HUD-572       | 206116-1         |                     | HP0719      | Energy Management Specialist           | GS         |     1101 |               13 |             84 | Jacob K Javits Federal Bldg, 26 Federal Plz, Room 35-102, New York, NY 10278       | Merit Promotion | Internal              | MPC              | 2015-03-10 00:00:00.000 | 2015-03-10 00:00:00.000 |                        0 | 2015-03-11 00:00:00.000 |                1 |                    |                  | 2015-04-01 00:00:00.000 | 2015-04-01 00:00:00.000 |                          21 | 2015-04-02 00:00:00.000 | 2015-04-03 00:00:00.000 | 2015-04-03 00:00:00.000 |                    0 | 2015-04-03 00:00:00.000 | 2015-04-20 00:00:00.000 |                          17 |               |                     |               0 | 2015-05-05 00:00:00.000 |                    15 | 2015-05-05 00:00:00.000 |                  0 | 2015-09-16 00:00:00.000 |                   135 | 2015-09-17 00:00:00.000 | 2015-09-24 00:00:00.000 |                 0 |                         |                         |                |                |                 |                 |                  |                  |                                0 | 2015-09-25 00:00:00.000 |                          1 | 2015-10-18 00:00:00.000 |         23 |                           222 | No               |                            16 | Yes              |              | 2015-10-23 00:00:00.000 | Hired        |      2020 |                                                  0 |                                1 |                        21 |                          2 |                        17 |                     15 |                                 0 |                       134 |                           1 |                            0 |                        0 |                    23 |          |
| Office of Community Planning and Development | 17-HUD-876       | 243368           | INT - 9260          | HA0134      | Correspondence Specialist              | GS         |      301 |               12 |              6 | Robert Weaver Building, 451 7th Street SW, Washington, DC 20410                    | Merit Promotion | Internal              | MPC              | 2017-09-12 00:00:00.000 | 2017-09-13 00:00:00.000 |                        1 | 2017-09-13 00:00:00.000 |                0 |                    |                  | 2017-09-14 00:00:00.000 | 2017-09-14 00:00:00.000 |                           1 | 2017-09-19 00:00:00.000 | 2017-09-19 00:00:00.000 | 2017-09-19 00:00:00.000 |                    0 | 2017-09-19 00:00:00.000 | 2017-10-04 00:00:00.000 |                          15 |               |                     |               0 | 2017-10-05 00:00:00.000 |                     1 | 2017-10-05 00:00:00.000 |                  0 | 2017-12-12 00:00:00.000 |                    68 | 2017-12-14 00:00:00.000 | 2017-12-14 00:00:00.000 |                 2 | 2017-12-15 00:00:00.000 | 2017-12-15 00:00:00.000 |                |                |                 |                 |                  |                  |                                0 | 2017-12-15 00:00:00.000 |                          0 | 2017-12-24 00:00:00.000 |          9 |                           103 | No               |                             3 | Yes              |              | 2017-12-29 00:00:00.000 | Hired        |      2020 |                                                  1 |                                0 |                         1 |                          5 |                        15 |                      1 |                                 0 |                        68 |                           2 |                            1 |                        0 |                     9 |          |
| Office of Community Planning and Development | 18-HUD-1         | 244172           | INT - 9167          | HD0346      | Supervisory CPD Specialist             | GS         |      301 |               15 |              8 | Robert Weaver Building, 451 7th Street SW, Washington, DC 20410                    | Merit Promotion | Internal              | MPC              | 2017-09-29 00:00:00.000 | 2017-10-03 00:00:00.000 |                        4 | 2017-10-03 00:00:00.000 |                0 |                    |                  | 2017-10-04 00:00:00.000 | 2017-10-05 00:00:00.000 |                           2 | 2017-10-05 00:00:00.000 | 2017-10-10 00:00:00.000 | 2017-10-10 00:00:00.000 |                    0 | 2017-10-10 00:00:00.000 | 2017-10-27 00:00:00.000 |                          17 |               |                     |               0 | 2017-10-30 00:00:00.000 |                     3 | 2017-10-30 00:00:00.000 |                  0 | 2017-11-20 00:00:00.000 |                    21 | 2017-11-21 00:00:00.000 | 2017-11-21 00:00:00.000 |                 1 | 2017-11-21 00:00:00.000 | 2017-11-21 00:00:00.000 |                |                |                 |                 |                  |                  |                                0 | 2017-11-22 00:00:00.000 |                          1 | 2017-12-10 00:00:00.000 |         18 |                            72 | Yes              |                             5 | Yes              |              | 2017-12-15 00:00:00.000 | Hired        |      2020 |                                                  4 |                                0 |                         2 |                          5 |                        17 |                      3 |                                 0 |                        21 |                           1 |                            0 |                        1 |                    18 |          |
| Office of Policy Development and Research    | 18-HUD-2         | 244104           | INT - 9300          | 17150U      | Secretary                              | GS         |      318 |                9 |              4 | Robert Weaver Building, 451 7th Street SW, Washington, DC 20410                    | Merit Promotion | Internal              | MPC              | 2017-09-27 00:00:00.000 | 2017-10-03 00:00:00.000 |                        6 | 2017-10-04 00:00:00.000 |                1 |                    |                  | 2017-10-05 00:00:00.000 | 2017-10-05 00:00:00.000 |                           1 | 2017-10-06 00:00:00.000 | 2017-10-16 00:00:00.000 | 2017-10-16 00:00:00.000 |                    0 | 2017-10-17 00:00:00.000 | 2017-10-24 00:00:00.000 |                           7 |               |                     |               0 | 2017-10-25 00:00:00.000 |                     1 | 2017-10-25 00:00:00.000 |                  0 | 2017-10-30 00:00:00.000 |                     5 | 2017-11-09 00:00:00.000 | 2017-11-13 00:00:00.000 |                 3 | 2017-11-13 00:00:00.000 | 2017-11-13 00:00:00.000 |                |                |                 |                 |                  |                  |                                7 | 2017-11-13 00:00:00.000 |                          0 | 2017-11-26 00:00:00.000 |         13 |                            60 | Yes              |                             4 | Yes              |              | 2017-12-01 00:00:00.000 | Hired        |      2020 |                                                  6 |                                1 |                         1 |                         12 |                         7 |                      1 |                                 0 |                         5 |                          10 |                            4 |                        0 |                    13 |          |
| Office of the Chief Financial Officer (CFO)  | 18-HUD-4         | 244310-1         | FTE-2540            | HUD026      | Supervisory Accountant                 | GS         |      510 |               15 |             67 | Robert Weaver Building, 451 7th Street SW, Washington, DC 20410                    | Merit Promotion | External              | MPC              | 2017-10-04 00:00:00.000 | 2017-10-06 00:00:00.000 |                        2 | 2017-10-11 00:00:00.000 |                5 |                    |                  | 2017-10-11 00:00:00.000 | 2017-10-11 00:00:00.000 |                           0 | 2017-10-18 00:00:00.000 | 2017-10-18 00:00:00.000 | 2017-10-18 00:00:00.000 |                    0 | 2017-10-18 00:00:00.000 | 2017-11-27 00:00:00.000 |                          40 |               |                     |               0 | 2017-12-06 00:00:00.000 |                     9 | 2017-12-06 00:00:00.000 |                  0 | 2018-01-25 00:00:00.000 |                    50 | 2018-01-25 00:00:00.000 | 2018-01-25 00:00:00.000 |                 0 | 2018-01-31 00:00:00.000 | 2018-02-06 00:00:00.000 |                |                |                 |                 |                  |                  |                               12 | 2018-02-06 00:00:00.000 |                          0 | 2018-03-04 00:00:00.000 |         26 |                           151 | No               |                             9 | Yes              |              | 2018-03-09 00:00:00.000 | Hired        |      2020 |                                                  2 |                                5 |                         0 |                          7 |                        40 |                      9 |                                 0 |                        50 |                           0 |                           12 |                        0 |                    26 |          |
| Office of Public and Indian Housing          | 18-HUD-6         | 243028           | INT - 9301          | HUD057      | Office Administrator                   | GS         |      301 |               12 |              6 | Robert Weaver Building, 451 7th Street SW, Washington, DC 20410                    | Merit Promotion | Internal              | MPC              | 2017-09-05 00:00:00.000 | 2017-10-10 00:00:00.000 |                       35 | 2017-10-13 00:00:00.000 |                3 |                    |                  | 2017-10-16 00:00:00.000 | 2017-10-19 00:00:00.000 |                           6 | 2017-10-19 00:00:00.000 | 2017-10-19 00:00:00.000 | 2017-10-19 00:00:00.000 |                    0 | 2017-10-19 00:00:00.000 | 2017-11-03 00:00:00.000 |                          15 |               |                     |               0 | 2017-11-07 00:00:00.000 |                     4 | 2017-11-07 00:00:00.000 |                  0 | 2017-12-06 00:00:00.000 |                    29 | 2017-12-06 00:00:00.000 | 2017-12-07 00:00:00.000 |                 0 | 2017-12-07 00:00:00.000 | 2017-12-07 00:00:00.000 |                |                |                 |                 |                  |                  |                                0 | 2017-12-07 00:00:00.000 |                          0 | 2017-12-24 00:00:00.000 |         17 |                           110 | No               |                             4 | Yes              |              | 2017-12-29 00:00:00.000 | Hired        |      2020 |                                                 35 |                                3 |                         6 |                          0 |                        15 |                      4 |                                 0 |                        29 |                           0 |                            1 |                        0 |                    17 |          |
| Office of Public and Indian Housing          | 18-HUD-27        | 244714           | FTE - 2241          | FP0020      | Director, Office of Public Housing     | GS         |      340 |               15 |             42 | Milwaukee Field Office, 310 Wisconsin Avenue, Suite 1380, Milwaukee, WI 53203-2289 | Merit Promotion | Internal              | MPC              | 2017-10-17 00:00:00.000 | 2017-10-18 00:00:00.000 |                        1 | 2017-10-19 00:00:00.000 |                1 |                    |                  | 2017-10-19 00:00:00.000 | 2017-10-19 00:00:00.000 |                           0 | 2017-10-19 00:00:00.000 | 2017-10-25 00:00:00.000 | 2017-10-25 00:00:00.000 |                    0 | 2017-10-25 00:00:00.000 | 2017-11-27 00:00:00.000 |                          33 |               |                     |               0 | 2017-12-05 00:00:00.000 |                     8 | 2017-12-05 00:00:00.000 |                  0 | 2017-12-20 00:00:00.000 |                    15 | 2017-12-20 00:00:00.000 | 2017-12-27 00:00:00.000 |                 0 | 2017-12-27 00:00:00.000 | 2017-12-27 00:00:00.000 |                |                |                 |                 |                  |                  |                                0 | 2018-01-03 00:00:00.000 |                          7 | 2018-02-18 00:00:00.000 |         46 |                           124 | No               |                            15 | Yes              |              | 2018-02-23 00:00:00.000 | Hired        |      2020 |                                                  1 |                                1 |                         0 |                          6 |                        33 |                      8 |                                 0 |                        15 |                           0 |                            7 |                        7 |                    46 |          |
| Housing                                      | 18-HUD-36-ICTAP  | 244576           | FTE- 3540           | HUD028      | Accountant                             | GS         |      510 |               14 |             62 | Robert Weaver Building, 451 7th Street SW, Washington, DC 20410                    | Merit Promotion | External              | MPC              | 2017-10-12 00:00:00.000 | 2017-10-20 00:00:00.000 |                        8 | 2017-11-17 00:00:00.000 |               28 |                    |                  | 2017-11-21 00:00:00.000 | 2017-11-21 00:00:00.000 |                           4 | 2017-11-22 00:00:00.000 | 2017-11-29 00:00:00.000 | 2017-11-29 00:00:00.000 |                    0 | 2017-11-30 00:00:00.000 | 2017-12-07 00:00:00.000 |                           7 |               |                     |               0 | 2017-12-13 00:00:00.000 |                     6 | 2017-12-13 00:00:00.000 |                  0 | 2017-12-14 00:00:00.000 |                     1 | 2017-12-15 00:00:00.000 | 2017-12-15 00:00:00.000 |                 0 | 2017-12-19 00:00:00.000 | 2017-12-20 00:00:00.000 |                |                |                 |                 |                  |                  |                                6 | 2017-12-21 00:00:00.000 |                          1 | 2018-01-08 00:00:00.000 |         18 |                            88 | No               |                             7 | Yes              |              | 2018-01-12 00:00:00.000 | Hired        |      2020 |                                                  8 |                               28 |                         4 |                          9 |                         7 |                      6 |                                 0 |                         1 |                           1 |                            5 |                        1 |                    18 |          |


Table: Offices
| Short   | Long                                         |   Sort |
|:--------|:---------------------------------------------|-------:|
| ADMIN   | Office of Administration                     |      2 |
| CPD     | Office of Community Planning and Development |      3 |
| DM      | Office of The Deputy Secretary               |      4 |
| DM      | Office of Public Affairs                     |      4 |
| DM      | Office of The Secretary                      |      4 |
| FHEO    | Office of Fair Housing and Equal Opportunity |      5 |
| FPM     | Office of Field Policy and Management        |      6 |
| GNMA    | Ginnie Mae (GNMA)                            |      7 |
| HOUSING | Housing                                      |      8 |
| OCFO    | Office of the Chief Financial Officer (CFO)  |      9 |


Table: PP_Dates
| PP End Date             |   EODs per Pay Period |
|:------------------------|----------------------:|
| 2019-10-12 00:00:00.000 |                    39 |
| 2019-10-26 00:00:00.000 |                    44 |
| 2019-11-09 00:00:00.000 |                    61 |
| 2019-11-23 00:00:00.000 |                    50 |
| 2019-12-07 00:00:00.000 |                    47 |
| 2019-12-21 00:00:00.000 |                     9 |
| 2020-01-04 00:00:00.000 |                    54 |
| 2020-01-18 00:00:00.000 |                    62 |
| 2020-02-01 00:00:00.000 |                    46 |
| 2020-02-15 00:00:00.000 |                    88 |

 


tables: name: DateTable
data: DateTable.csv
name: EODTable
data: EODTable.csv
name: Offices
data: Offices.csv
name: PP_Dates
data: PP_Dates.csv
label: PP_Dates
PP End Date
DateTable
Date
EODTable
Customer Level 2
Offices
Long
output: {
    "joins": [
        {
            "from_table": "PP_Dates",
            "from_column": "PP End Date",
            "to_table": "DateTable",
            "to_column": "Date"
        },
        {
            "from_table": "EODTable",
            "from_column": "Customer Level 2",
            "to_table": "Offices",
            "to_column": "Long"
        }
    ]
}