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: BL-Activities
| Activity ID   | Activity Name                             |   Original Duration | Early Start             | Early Finish            | Late Start              | Late Finish             |   Total Float | Activity Type   | L01    | L02     | L03     | L04     | Start     | Finish    |
|:--------------|:------------------------------------------|--------------------:|:------------------------|:------------------------|:------------------------|:------------------------|--------------:|:----------------|:-------|:--------|:--------|:--------|:----------|:----------|
| A1010         | Mobilization and Site Office Installation |                  30 | 2018-01-01 00:00:00.000 | 2018-01-30 00:00:00.000 | 2018-01-01 00:00:00.000 | 2018-01-30 00:00:00.000 |             0 | Task Dependent  | L01-01 | (New)-1 | (New)-1 | (New)-1 | 01-Jan-18 | 30-Jan-18 |
| KEY-16        | Project Start Date                        |                   0 | 2018-01-01 00:00:00.000 |                         | 2018-01-01 00:00:00.000 |                         |             0 | Start Milestone | L01-01 | (New)   | (New)   | (New)   | 01-Jan-18 | 01-Jan-18 |
| 1-SUB-100     | Concrete                                  |                   7 | 2018-01-11 00:00:00.000 | 2018-01-17 00:00:00.000 | 2018-01-28 00:00:00.000 | 2018-02-03 00:00:00.000 |            17 | Task Dependent  | L01-01 | (New)-2 | (New)-2 | (New)-2 | 11-Jan-18 | 17-Jan-18 |
| 2-MS1000      | Concrete                                  |                   7 | 2018-01-18 00:00:00.000 | 2018-01-24 00:00:00.000 | 2018-02-04 00:00:00.000 | 2018-02-10 00:00:00.000 |            17 | Task Dependent  | L01-01 | (New)-2 | (New)-3 | (New)-3 | 18-Jan-18 | 24-Jan-18 |
| 3-MA1000      | Concrete                                  |                   7 | 2018-01-25 00:00:00.000 | 2018-01-31 00:00:00.000 | 2018-02-11 00:00:00.000 | 2018-02-17 00:00:00.000 |            17 | Task Dependent  | L01-01 | (New)-2 | (New)-4 | (New)-4 | 25-Jan-18 | 31-Jan-18 |
| A1030         | Excavation Works                          |                  25 | 2018-01-31 00:00:00.000 | 2018-02-24 00:00:00.000 | 2018-01-31 00:00:00.000 | 2018-02-24 00:00:00.000 |             0 | Task Dependent  | L01-01 | (New)-4 | (New)-8 | (New)-8 | 31-Jan-18 | 24-Feb-18 |
| KEY-26        | Start Construction                        |                   0 | 2018-01-31 00:00:00.000 |                         | 2018-01-31 00:00:00.000 |                         |             0 | Start Milestone | L01-01 | (New)   | (New)   | (New)   | 31-Jan-18 | 31-Jan-18 |
| 4-MD1000      | Concrete                                  |                   7 | 2018-02-01 00:00:00.000 | 2018-02-07 00:00:00.000 | 2018-02-18 00:00:00.000 | 2018-02-24 00:00:00.000 |            17 | Task Dependent  | L01-01 | (New)-2 | (New)-5 | (New)-5 | 01-Feb-18 | 07-Feb-18 |
| 1-SUB-110     | Block                                     |                   7 | 2018-02-20 00:00:00.000 | 2018-02-26 00:00:00.000 | 2018-05-03 00:00:00.000 | 2018-05-09 00:00:00.000 |            72 | Task Dependent  | L01-01 | (New)-2 | (New)-2 | (New)-2 | 20-Feb-18 | 26-Feb-18 |
| 1-SUB-150     | AC Machine                                |                   7 | 2018-02-20 00:00:00.000 | 2018-02-26 00:00:00.000 | 2018-05-13 00:00:00.000 | 2018-05-19 00:00:00.000 |            82 | Task Dependent  | L01-01 | (New)-2 | (New)-2 | (New)-2 | 20-Feb-18 | 26-Feb-18 |


Table: BL-Res
| Activity ID   | Activity Name   | Resource ID   | Resource Name   |   Budgeted Units |   Budgeted Cost  | Spreadsheet Field   | Date of Planned Value   |   BL-ResValue |
|:--------------|:----------------|:--------------|:----------------|-----------------:|-----------------:|:--------------------|:------------------------|--------------:|
| 4-MD1050      | AC Machine      | Man-Power     | Man-Power       |             7.68 |                0 | Budgeted Units      | 2018-03-13 00:00:00.000 |          0.13 |
| 4-MD1050      | AC Machine      | Man-Power     | Man-Power       |             7.68 |                0 | Budgeted Units      | 2018-03-14 00:00:00.000 |          0.13 |
| 4-MD1050      | AC Machine      | Man-Power     | Man-Power       |             7.68 |                0 | Budgeted Units      | 2018-03-15 00:00:00.000 |          0.13 |
| 4-MD1050      | AC Machine      | Man-Power     | Man-Power       |             7.68 |                0 | Budgeted Units      | 2018-03-16 00:00:00.000 |          0.13 |
| 4-MD1050      | AC Machine      | Man-Power     | Man-Power       |             7.68 |                0 | Budgeted Units      | 2018-03-17 00:00:00.000 |          0.13 |
| 4-MD1050      | AC Machine      | Man-Power     | Man-Power       |             7.68 |                0 | Budgeted Units      | 2018-03-18 00:00:00.000 |          0.13 |
| 4-MD1050      | AC Machine      | Man-Power     | Man-Power       |             7.68 |                0 | Budgeted Units      | 2018-03-19 00:00:00.000 |          0.13 |
| 4-MD1050      | AC Machine      | Man-Power     | Man-Power       |             7.68 |                0 | Budgeted Units      | 2018-03-20 00:00:00.000 |          0.13 |
| 4-MD1050      | AC Machine      | Man-Power     | Man-Power       |             7.68 |                0 | Budgeted Units      | 2018-03-21 00:00:00.000 |          0.13 |
| 4-MD1050      | AC Machine      | Man-Power     | Man-Power       |             7.68 |                0 | Budgeted Units      | 2018-03-22 00:00:00.000 |          0.13 |


Table: Date
| Date                    |   DateKey | Fiscal Year   |   Fiscal YearNumber |   Fiscal QuarterNumber | Fiscal Quarter   |   Fiscal YearQuarterNumber | Fiscal Quarter Year   |   Fiscal MonthNumber | Fiscal Month   |   Fiscal YearMonthNumber | Fiscal Month Year   |   Fiscal WeekNumber | Fiscal Week   |   Fiscal YearWeekNumber | Fiscal Week Year   |   Fiscal WeekYearOrder |   Fiscal DayOfYearNumber |   Day of Month |   WeekDayNumber | Week Day   |   Fiscal RelativeWeekPos |   Fiscal RelativeMonthPos |   Fiscal RelativeQuarterPos |   Fiscal RelativeYearPos | Fiscal StartOfMonth     | Fiscal EndOfMonth       | Fiscal StartOfQuarter   | Fiscal EndOfQuarter     |   Calendar YearNumber |   Calendar Year |   Calendar QuarterNumber | Calendar Quarter   |   Calendar YearQuarterNumber | Calendar Quarter Year   |   Calendar MonthNumber | Calendar Month   |   Calendar YearMonthNumber | Calendar Month Year   |   Calendar WeekNumber | Calendar Week   |   Calendar YearWeekNumber | Calendar Week Year   |   Calendar WeekYearOrder |   Calendar DayOfYearNumber |   Calendar RelativeWeekPos |   Calendar RelativeMonthPos |   Calendar RelativeQuarterPos |   Calendar RelativeYearPos | Calendar StartOfMonth   | Calendar EndOfMonth     | Calendar StartOfQuarter   | Calendar EndOfQuarter   |   FW YearNumber | FW StartOfYear          | FW EndOfYear            | FW Year   |   FW QuarterNumber | FW Quarter   |   FW YearQuarterNumber | FW Quarter Year   |   FW MonthNumber | FW Month   |   FW YearMonthNumber | FW Month Year   |   FW WeekNumber | FW Week   |   FW YearWeekNumber | FW Week Year   | FW StartOfWeek          | FW EndOfWeek            |   FW RelativeWeekPos |   FW RelativeMonthPos |   FW RelativeQuarterPos |   FW RelativeYearPos | FW StartOfMonth         | FW EndOfMonth           | FW StartOfQuarter       | FW EndOfQuarter         | Holiday Name   | IsWorkingDay   | Day Type        | Calendar DatePreviousWeek   | Calendar DatePreviousMonth   | Calendar DatePreviousQuarter   | Calendar DatePreviousYear   | Fiscal DatePreviousWeek   | Fiscal DatePreviousMonth   | Fiscal DatePreviousQuarter   | Fiscal DatePreviousYear   | FW DatePreviousWeek     | FW DatePreviousMonth   | FW DatePreviousQuarter   | FW DatePreviousYear   | Calendar StartOfYear    | Calendar EndOfYear      |   Calendar MonthDays |   Calendar QuarterDays |   Calendar YearDays | Fiscal StartOfYear      | Fiscal EndOfYear        |   Fiscal MonthDays |   Fiscal QuarterDays |   Fiscal YearDays |   FW MonthDays |   FW QuarterDays |   FW YearDays |   Calendar DayOfMonthNumber |   Calendar DayOfQuarterNumber |   Fiscal DayOfMonthNumber |   Fiscal DayOfQuarterNumber |   FW DayOfYearNumber |   FW DayOfMonthNumber |   FW DayOfQuarterNumber |   Sequential365DayNumber |   FW PeriodNumber | FW Period   | Col Daily Planned Value   |
|:------------------------|----------:|:--------------|--------------------:|-----------------------:|:-----------------|---------------------------:|:----------------------|---------------------:|:---------------|-------------------------:|:--------------------|--------------------:|:--------------|------------------------:|:-------------------|-----------------------:|-------------------------:|---------------:|----------------:|:-----------|-------------------------:|--------------------------:|----------------------------:|-------------------------:|:------------------------|:------------------------|:------------------------|:------------------------|----------------------:|----------------:|-------------------------:|:-------------------|-----------------------------:|:------------------------|-----------------------:|:-----------------|---------------------------:|:----------------------|----------------------:|:----------------|--------------------------:|:---------------------|-------------------------:|---------------------------:|---------------------------:|----------------------------:|------------------------------:|---------------------------:|:------------------------|:------------------------|:--------------------------|:------------------------|----------------:|:------------------------|:------------------------|:----------|-------------------:|:-------------|-----------------------:|:------------------|-----------------:|:-----------|---------------------:|:----------------|----------------:|:----------|--------------------:|:---------------|:------------------------|:------------------------|---------------------:|----------------------:|------------------------:|---------------------:|:------------------------|:------------------------|:------------------------|:------------------------|:---------------|:---------------|:----------------|:----------------------------|:-----------------------------|:-------------------------------|:----------------------------|:--------------------------|:---------------------------|:-----------------------------|:--------------------------|:------------------------|:-----------------------|:-------------------------|:----------------------|:------------------------|:------------------------|---------------------:|-----------------------:|--------------------:|:------------------------|:------------------------|-------------------:|---------------------:|------------------:|---------------:|-----------------:|--------------:|----------------------------:|------------------------------:|--------------------------:|----------------------------:|---------------------:|----------------------:|------------------------:|-------------------------:|------------------:|:------------|:--------------------------|
| 2017-01-02 00:00:00.000 |  20170102 | F 2017        |                2017 |                      1 | FQ1              |                       8068 | FQ1 2017              |                    1 | Jan            |                    24204 | Jan 2017            |                   1 | FW01          |                    6053 | FW01-2017          |                 201701 |                        2 |              2 |               2 | Mon        |                    -6053 |                    -24204 |                       -8068 |                    -2017 | 2017-01-01 00:00:00.000 | 2017-01-31 00:00:00.000 | 2017-01-01 00:00:00.000 | 2017-03-31 00:00:00.000 |                  2017 |            2017 |                        1 | Q1                 |                         8068 | Q1 2017                 |                      1 | Jan              |                      24204 | Jan 2017              |                     1 | W01             |                      6053 | W01-2017             |                   201701 |                          2 |                      -6053 |                      -24204 |                         -8068 |                      -2017 | 2017-01-01 00:00:00.000 | 2017-01-31 00:00:00.000 | 2017-01-01 00:00:00.000   | 2017-03-31 00:00:00.000 |            2017 | 2017-01-01 00:00:00.000 | 2017-12-30 00:00:00.000 | FW  2017  |                  1 | FW Q1        |                   8068 | FW Q1 2017        |                1 | FW P01     |                24204 | FW P01 2017     |               1 | FW W01    |                6054 | FW W01 2017    | 2017-01-01 00:00:00.000 | 2017-01-07 00:00:00.000 |                -6054 |                -24204 |                   -8068 |                -2017 | 2017-01-01 00:00:00.000 | 2017-01-28 00:00:00.000 | 2017-01-01 00:00:00.000 | 2017-04-01 00:00:00.000 |                | True           | Working day     | 2016-12-26 00:00:00.000     | 2016-12-02 00:00:00.000      | 2016-10-02 00:00:00.000        | 2016-01-02 00:00:00.000     | 2016-12-26 00:00:00.000   | 2016-12-02 00:00:00.000    | 2016-10-02 00:00:00.000      | 2016-01-02 00:00:00.000   | 2016-12-26 00:00:00.000 |                        |                          |                       | 2017-01-01 00:00:00.000 | 2017-12-31 00:00:00.000 |                   31 |                     90 |                 365 | 2017-01-01 00:00:00.000 | 2017-12-31 00:00:00.000 |                 31 |                   90 |               365 |             28 |               91 |           364 |                           2 |                             2 |                         2 |                           2 |                    2 |                     2 |                       2 |                    42708 |                 1 | FW P01      |                           |
| 2017-01-03 00:00:00.000 |  20170103 | F 2017        |                2017 |                      1 | FQ1              |                       8068 | FQ1 2017              |                    1 | Jan            |                    24204 | Jan 2017            |                   1 | FW01          |                    6053 | FW01-2017          |                 201701 |                        3 |              3 |               3 | Tue        |                    -6053 |                    -24204 |                       -8068 |                    -2017 | 2017-01-01 00:00:00.000 | 2017-01-31 00:00:00.000 | 2017-01-01 00:00:00.000 | 2017-03-31 00:00:00.000 |                  2017 |            2017 |                        1 | Q1                 |                         8068 | Q1 2017                 |                      1 | Jan              |                      24204 | Jan 2017              |                     1 | W01             |                      6053 | W01-2017             |                   201701 |                          3 |                      -6053 |                      -24204 |                         -8068 |                      -2017 | 2017-01-01 00:00:00.000 | 2017-01-31 00:00:00.000 | 2017-01-01 00:00:00.000   | 2017-03-31 00:00:00.000 |            2017 | 2017-01-01 00:00:00.000 | 2017-12-30 00:00:00.000 | FW  2017  |                  1 | FW Q1        |                   8068 | FW Q1 2017        |                1 | FW P01     |                24204 | FW P01 2017     |               1 | FW W01    |                6054 | FW W01 2017    | 2017-01-01 00:00:00.000 | 2017-01-07 00:00:00.000 |                -6054 |                -24204 |                   -8068 |                -2017 | 2017-01-01 00:00:00.000 | 2017-01-28 00:00:00.000 | 2017-01-01 00:00:00.000 | 2017-04-01 00:00:00.000 |                | True           | Working day     | 2016-12-27 00:00:00.000     | 2016-12-03 00:00:00.000      | 2016-10-03 00:00:00.000        | 2016-01-03 00:00:00.000     | 2016-12-27 00:00:00.000   | 2016-12-03 00:00:00.000    | 2016-10-03 00:00:00.000      | 2016-01-03 00:00:00.000   | 2016-12-27 00:00:00.000 |                        |                          |                       | 2017-01-01 00:00:00.000 | 2017-12-31 00:00:00.000 |                   31 |                     90 |                 365 | 2017-01-01 00:00:00.000 | 2017-12-31 00:00:00.000 |                 31 |                   90 |               365 |             28 |               91 |           364 |                           3 |                             3 |                         3 |                           3 |                    3 |                     3 |                       3 |                    42709 |                 1 | FW P01      |                           |
| 2017-01-04 00:00:00.000 |  20170104 | F 2017        |                2017 |                      1 | FQ1              |                       8068 | FQ1 2017              |                    1 | Jan            |                    24204 | Jan 2017            |                   1 | FW01          |                    6053 | FW01-2017          |                 201701 |                        4 |              4 |               4 | Wed        |                    -6053 |                    -24204 |                       -8068 |                    -2017 | 2017-01-01 00:00:00.000 | 2017-01-31 00:00:00.000 | 2017-01-01 00:00:00.000 | 2017-03-31 00:00:00.000 |                  2017 |            2017 |                        1 | Q1                 |                         8068 | Q1 2017                 |                      1 | Jan              |                      24204 | Jan 2017              |                     1 | W01             |                      6053 | W01-2017             |                   201701 |                          4 |                      -6053 |                      -24204 |                         -8068 |                      -2017 | 2017-01-01 00:00:00.000 | 2017-01-31 00:00:00.000 | 2017-01-01 00:00:00.000   | 2017-03-31 00:00:00.000 |            2017 | 2017-01-01 00:00:00.000 | 2017-12-30 00:00:00.000 | FW  2017  |                  1 | FW Q1        |                   8068 | FW Q1 2017        |                1 | FW P01     |                24204 | FW P01 2017     |               1 | FW W01    |                6054 | FW W01 2017    | 2017-01-01 00:00:00.000 | 2017-01-07 00:00:00.000 |                -6054 |                -24204 |                   -8068 |                -2017 | 2017-01-01 00:00:00.000 | 2017-01-28 00:00:00.000 | 2017-01-01 00:00:00.000 | 2017-04-01 00:00:00.000 |                | True           | Working day     | 2016-12-28 00:00:00.000     | 2016-12-04 00:00:00.000      | 2016-10-04 00:00:00.000        | 2016-01-04 00:00:00.000     | 2016-12-28 00:00:00.000   | 2016-12-04 00:00:00.000    | 2016-10-04 00:00:00.000      | 2016-01-04 00:00:00.000   | 2016-12-28 00:00:00.000 |                        |                          |                       | 2017-01-01 00:00:00.000 | 2017-12-31 00:00:00.000 |                   31 |                     90 |                 365 | 2017-01-01 00:00:00.000 | 2017-12-31 00:00:00.000 |                 31 |                   90 |               365 |             28 |               91 |           364 |                           4 |                             4 |                         4 |                           4 |                    4 |                     4 |                       4 |                    42710 |                 1 | FW P01      |                           |
| 2017-01-05 00:00:00.000 |  20170105 | F 2017        |                2017 |                      1 | FQ1              |                       8068 | FQ1 2017              |                    1 | Jan            |                    24204 | Jan 2017            |                   1 | FW01          |                    6053 | FW01-2017          |                 201701 |                        5 |              5 |               5 | Thu        |                    -6053 |                    -24204 |                       -8068 |                    -2017 | 2017-01-01 00:00:00.000 | 2017-01-31 00:00:00.000 | 2017-01-01 00:00:00.000 | 2017-03-31 00:00:00.000 |                  2017 |            2017 |                        1 | Q1                 |                         8068 | Q1 2017                 |                      1 | Jan              |                      24204 | Jan 2017              |                     1 | W01             |                      6053 | W01-2017             |                   201701 |                          5 |                      -6053 |                      -24204 |                         -8068 |                      -2017 | 2017-01-01 00:00:00.000 | 2017-01-31 00:00:00.000 | 2017-01-01 00:00:00.000   | 2017-03-31 00:00:00.000 |            2017 | 2017-01-01 00:00:00.000 | 2017-12-30 00:00:00.000 | FW  2017  |                  1 | FW Q1        |                   8068 | FW Q1 2017        |                1 | FW P01     |                24204 | FW P01 2017     |               1 | FW W01    |                6054 | FW W01 2017    | 2017-01-01 00:00:00.000 | 2017-01-07 00:00:00.000 |                -6054 |                -24204 |                   -8068 |                -2017 | 2017-01-01 00:00:00.000 | 2017-01-28 00:00:00.000 | 2017-01-01 00:00:00.000 | 2017-04-01 00:00:00.000 |                | True           | Working day     | 2016-12-29 00:00:00.000     | 2016-12-05 00:00:00.000      | 2016-10-05 00:00:00.000        | 2016-01-05 00:00:00.000     | 2016-12-29 00:00:00.000   | 2016-12-05 00:00:00.000    | 2016-10-05 00:00:00.000      | 2016-01-05 00:00:00.000   | 2016-12-29 00:00:00.000 |                        |                          |                       | 2017-01-01 00:00:00.000 | 2017-12-31 00:00:00.000 |                   31 |                     90 |                 365 | 2017-01-01 00:00:00.000 | 2017-12-31 00:00:00.000 |                 31 |                   90 |               365 |             28 |               91 |           364 |                           5 |                             5 |                         5 |                           5 |                    5 |                     5 |                       5 |                    42711 |                 1 | FW P01      |                           |
| 2017-01-06 00:00:00.000 |  20170106 | F 2017        |                2017 |                      1 | FQ1              |                       8068 | FQ1 2017              |                    1 | Jan            |                    24204 | Jan 2017            |                   1 | FW01          |                    6053 | FW01-2017          |                 201701 |                        6 |              6 |               6 | Fri        |                    -6053 |                    -24204 |                       -8068 |                    -2017 | 2017-01-01 00:00:00.000 | 2017-01-31 00:00:00.000 | 2017-01-01 00:00:00.000 | 2017-03-31 00:00:00.000 |                  2017 |            2017 |                        1 | Q1                 |                         8068 | Q1 2017                 |                      1 | Jan              |                      24204 | Jan 2017              |                     1 | W01             |                      6053 | W01-2017             |                   201701 |                          6 |                      -6053 |                      -24204 |                         -8068 |                      -2017 | 2017-01-01 00:00:00.000 | 2017-01-31 00:00:00.000 | 2017-01-01 00:00:00.000   | 2017-03-31 00:00:00.000 |            2017 | 2017-01-01 00:00:00.000 | 2017-12-30 00:00:00.000 | FW  2017  |                  1 | FW Q1        |                   8068 | FW Q1 2017        |                1 | FW P01     |                24204 | FW P01 2017     |               1 | FW W01    |                6054 | FW W01 2017    | 2017-01-01 00:00:00.000 | 2017-01-07 00:00:00.000 |                -6054 |                -24204 |                   -8068 |                -2017 | 2017-01-01 00:00:00.000 | 2017-01-28 00:00:00.000 | 2017-01-01 00:00:00.000 | 2017-04-01 00:00:00.000 |                | True           | Working day     | 2016-12-30 00:00:00.000     | 2016-12-06 00:00:00.000      | 2016-10-06 00:00:00.000        | 2016-01-06 00:00:00.000     | 2016-12-30 00:00:00.000   | 2016-12-06 00:00:00.000    | 2016-10-06 00:00:00.000      | 2016-01-06 00:00:00.000   | 2016-12-30 00:00:00.000 |                        |                          |                       | 2017-01-01 00:00:00.000 | 2017-12-31 00:00:00.000 |                   31 |                     90 |                 365 | 2017-01-01 00:00:00.000 | 2017-12-31 00:00:00.000 |                 31 |                   90 |               365 |             28 |               91 |           364 |                           6 |                             6 |                         6 |                           6 |                    6 |                     6 |                       6 |                    42712 |                 1 | FW P01      |                           |
| 2017-01-07 00:00:00.000 |  20170107 | F 2017        |                2017 |                      1 | FQ1              |                       8068 | FQ1 2017              |                    1 | Jan            |                    24204 | Jan 2017            |                   1 | FW01          |                    6053 | FW01-2017          |                 201701 |                        7 |              7 |               7 | Sat        |                    -6053 |                    -24204 |                       -8068 |                    -2017 | 2017-01-01 00:00:00.000 | 2017-01-31 00:00:00.000 | 2017-01-01 00:00:00.000 | 2017-03-31 00:00:00.000 |                  2017 |            2017 |                        1 | Q1                 |                         8068 | Q1 2017                 |                      1 | Jan              |                      24204 | Jan 2017              |                     1 | W01             |                      6053 | W01-2017             |                   201701 |                          7 |                      -6053 |                      -24204 |                         -8068 |                      -2017 | 2017-01-01 00:00:00.000 | 2017-01-31 00:00:00.000 | 2017-01-01 00:00:00.000   | 2017-03-31 00:00:00.000 |            2017 | 2017-01-01 00:00:00.000 | 2017-12-30 00:00:00.000 | FW  2017  |                  1 | FW Q1        |                   8068 | FW Q1 2017        |                1 | FW P01     |                24204 | FW P01 2017     |               1 | FW W01    |                6054 | FW W01 2017    | 2017-01-01 00:00:00.000 | 2017-01-07 00:00:00.000 |                -6054 |                -24204 |                   -8068 |                -2017 | 2017-01-01 00:00:00.000 | 2017-01-28 00:00:00.000 | 2017-01-01 00:00:00.000 | 2017-04-01 00:00:00.000 |                | False          | Non-working day | 2016-12-31 00:00:00.000     | 2016-12-07 00:00:00.000      | 2016-10-07 00:00:00.000        | 2016-01-07 00:00:00.000     | 2016-12-31 00:00:00.000   | 2016-12-07 00:00:00.000    | 2016-10-07 00:00:00.000      | 2016-01-07 00:00:00.000   | 2016-12-31 00:00:00.000 |                        |                          |                       | 2017-01-01 00:00:00.000 | 2017-12-31 00:00:00.000 |                   31 |                     90 |                 365 | 2017-01-01 00:00:00.000 | 2017-12-31 00:00:00.000 |                 31 |                   90 |               365 |             28 |               91 |           364 |                           7 |                             7 |                         7 |                           7 |                    7 |                     7 |                       7 |                    42713 |                 1 | FW P01      |                           |
| 2017-01-08 00:00:00.000 |  20170108 | F 2017        |                2017 |                      1 | FQ1              |                       8068 | FQ1 2017              |                    1 | Jan            |                    24204 | Jan 2017            |                   2 | FW02          |                    6054 | FW02-2017          |                 201702 |                        8 |              8 |               1 | Sun        |                    -6054 |                    -24204 |                       -8068 |                    -2017 | 2017-01-01 00:00:00.000 | 2017-01-31 00:00:00.000 | 2017-01-01 00:00:00.000 | 2017-03-31 00:00:00.000 |                  2017 |            2017 |                        1 | Q1                 |                         8068 | Q1 2017                 |                      1 | Jan              |                      24204 | Jan 2017              |                     2 | W02             |                      6054 | W02-2017             |                   201702 |                          8 |                      -6054 |                      -24204 |                         -8068 |                      -2017 | 2017-01-01 00:00:00.000 | 2017-01-31 00:00:00.000 | 2017-01-01 00:00:00.000   | 2017-03-31 00:00:00.000 |            2017 | 2017-01-01 00:00:00.000 | 2017-12-30 00:00:00.000 | FW  2017  |                  1 | FW Q1        |                   8068 | FW Q1 2017        |                1 | FW P01     |                24204 | FW P01 2017     |               2 | FW W02    |                6055 | FW W02 2017    | 2017-01-08 00:00:00.000 | 2017-01-14 00:00:00.000 |                -6055 |                -24204 |                   -8068 |                -2017 | 2017-01-01 00:00:00.000 | 2017-01-28 00:00:00.000 | 2017-01-01 00:00:00.000 | 2017-04-01 00:00:00.000 |                | False          | Non-working day | 2017-01-01 00:00:00.000     | 2016-12-08 00:00:00.000      | 2016-10-08 00:00:00.000        | 2016-01-08 00:00:00.000     | 2017-01-01 00:00:00.000   | 2016-12-08 00:00:00.000    | 2016-10-08 00:00:00.000      | 2016-01-08 00:00:00.000   | 2017-01-01 00:00:00.000 |                        |                          |                       | 2017-01-01 00:00:00.000 | 2017-12-31 00:00:00.000 |                   31 |                     90 |                 365 | 2017-01-01 00:00:00.000 | 2017-12-31 00:00:00.000 |                 31 |                   90 |               365 |             28 |               91 |           364 |                           8 |                             8 |                         8 |                           8 |                    8 |                     8 |                       8 |                    42714 |                 1 | FW P01      |                           |
| 2017-01-09 00:00:00.000 |  20170109 | F 2017        |                2017 |                      1 | FQ1              |                       8068 | FQ1 2017              |                    1 | Jan            |                    24204 | Jan 2017            |                   2 | FW02          |                    6054 | FW02-2017          |                 201702 |                        9 |              9 |               2 | Mon        |                    -6054 |                    -24204 |                       -8068 |                    -2017 | 2017-01-01 00:00:00.000 | 2017-01-31 00:00:00.000 | 2017-01-01 00:00:00.000 | 2017-03-31 00:00:00.000 |                  2017 |            2017 |                        1 | Q1                 |                         8068 | Q1 2017                 |                      1 | Jan              |                      24204 | Jan 2017              |                     2 | W02             |                      6054 | W02-2017             |                   201702 |                          9 |                      -6054 |                      -24204 |                         -8068 |                      -2017 | 2017-01-01 00:00:00.000 | 2017-01-31 00:00:00.000 | 2017-01-01 00:00:00.000   | 2017-03-31 00:00:00.000 |            2017 | 2017-01-01 00:00:00.000 | 2017-12-30 00:00:00.000 | FW  2017  |                  1 | FW Q1        |                   8068 | FW Q1 2017        |                1 | FW P01     |                24204 | FW P01 2017     |               2 | FW W02    |                6055 | FW W02 2017    | 2017-01-08 00:00:00.000 | 2017-01-14 00:00:00.000 |                -6055 |                -24204 |                   -8068 |                -2017 | 2017-01-01 00:00:00.000 | 2017-01-28 00:00:00.000 | 2017-01-01 00:00:00.000 | 2017-04-01 00:00:00.000 |                | True           | Working day     | 2017-01-02 00:00:00.000     | 2016-12-09 00:00:00.000      | 2016-10-09 00:00:00.000        | 2016-01-09 00:00:00.000     | 2017-01-02 00:00:00.000   | 2016-12-09 00:00:00.000    | 2016-10-09 00:00:00.000      | 2016-01-09 00:00:00.000   | 2017-01-02 00:00:00.000 |                        |                          |                       | 2017-01-01 00:00:00.000 | 2017-12-31 00:00:00.000 |                   31 |                     90 |                 365 | 2017-01-01 00:00:00.000 | 2017-12-31 00:00:00.000 |                 31 |                   90 |               365 |             28 |               91 |           364 |                           9 |                             9 |                         9 |                           9 |                    9 |                     9 |                       9 |                    42715 |                 1 | FW P01      |                           |
| 2017-01-10 00:00:00.000 |  20170110 | F 2017        |                2017 |                      1 | FQ1              |                       8068 | FQ1 2017              |                    1 | Jan            |                    24204 | Jan 2017            |                   2 | FW02          |                    6054 | FW02-2017          |                 201702 |                       10 |             10 |               3 | Tue        |                    -6054 |                    -24204 |                       -8068 |                    -2017 | 2017-01-01 00:00:00.000 | 2017-01-31 00:00:00.000 | 2017-01-01 00:00:00.000 | 2017-03-31 00:00:00.000 |                  2017 |            2017 |                        1 | Q1                 |                         8068 | Q1 2017                 |                      1 | Jan              |                      24204 | Jan 2017              |                     2 | W02             |                      6054 | W02-2017             |                   201702 |                         10 |                      -6054 |                      -24204 |                         -8068 |                      -2017 | 2017-01-01 00:00:00.000 | 2017-01-31 00:00:00.000 | 2017-01-01 00:00:00.000   | 2017-03-31 00:00:00.000 |            2017 | 2017-01-01 00:00:00.000 | 2017-12-30 00:00:00.000 | FW  2017  |                  1 | FW Q1        |                   8068 | FW Q1 2017        |                1 | FW P01     |                24204 | FW P01 2017     |               2 | FW W02    |                6055 | FW W02 2017    | 2017-01-08 00:00:00.000 | 2017-01-14 00:00:00.000 |                -6055 |                -24204 |                   -8068 |                -2017 | 2017-01-01 00:00:00.000 | 2017-01-28 00:00:00.000 | 2017-01-01 00:00:00.000 | 2017-04-01 00:00:00.000 |                | True           | Working day     | 2017-01-03 00:00:00.000     | 2016-12-10 00:00:00.000      | 2016-10-10 00:00:00.000        | 2016-01-10 00:00:00.000     | 2017-01-03 00:00:00.000   | 2016-12-10 00:00:00.000    | 2016-10-10 00:00:00.000      | 2016-01-10 00:00:00.000   | 2017-01-03 00:00:00.000 |                        |                          |                       | 2017-01-01 00:00:00.000 | 2017-12-31 00:00:00.000 |                   31 |                     90 |                 365 | 2017-01-01 00:00:00.000 | 2017-12-31 00:00:00.000 |                 31 |                   90 |               365 |             28 |               91 |           364 |                          10 |                            10 |                        10 |                          10 |                   10 |                    10 |                      10 |                    42716 |                 1 | FW P01      |                           |
| 2017-01-11 00:00:00.000 |  20170111 | F 2017        |                2017 |                      1 | FQ1              |                       8068 | FQ1 2017              |                    1 | Jan            |                    24204 | Jan 2017            |                   2 | FW02          |                    6054 | FW02-2017          |                 201702 |                       11 |             11 |               4 | Wed        |                    -6054 |                    -24204 |                       -8068 |                    -2017 | 2017-01-01 00:00:00.000 | 2017-01-31 00:00:00.000 | 2017-01-01 00:00:00.000 | 2017-03-31 00:00:00.000 |                  2017 |            2017 |                        1 | Q1                 |                         8068 | Q1 2017                 |                      1 | Jan              |                      24204 | Jan 2017              |                     2 | W02             |                      6054 | W02-2017             |                   201702 |                         11 |                      -6054 |                      -24204 |                         -8068 |                      -2017 | 2017-01-01 00:00:00.000 | 2017-01-31 00:00:00.000 | 2017-01-01 00:00:00.000   | 2017-03-31 00:00:00.000 |            2017 | 2017-01-01 00:00:00.000 | 2017-12-30 00:00:00.000 | FW  2017  |                  1 | FW Q1        |                   8068 | FW Q1 2017        |                1 | FW P01     |                24204 | FW P01 2017     |               2 | FW W02    |                6055 | FW W02 2017    | 2017-01-08 00:00:00.000 | 2017-01-14 00:00:00.000 |                -6055 |                -24204 |                   -8068 |                -2017 | 2017-01-01 00:00:00.000 | 2017-01-28 00:00:00.000 | 2017-01-01 00:00:00.000 | 2017-04-01 00:00:00.000 |                | True           | Working day     | 2017-01-04 00:00:00.000     | 2016-12-11 00:00:00.000      | 2016-10-11 00:00:00.000        | 2016-01-11 00:00:00.000     | 2017-01-04 00:00:00.000   | 2016-12-11 00:00:00.000    | 2016-10-11 00:00:00.000      | 2016-01-11 00:00:00.000   | 2017-01-04 00:00:00.000 |                        |                          |                       | 2017-01-01 00:00:00.000 | 2017-12-31 00:00:00.000 |                   31 |                     90 |                 365 | 2017-01-01 00:00:00.000 | 2017-12-31 00:00:00.000 |                 31 |                   90 |               365 |             28 |               91 |           364 |                          11 |                            11 |                        11 |                          11 |                   11 |                    11 |                      11 |                    42717 |                 1 | FW P01      |                           |


Table: Info
| Data Date               |
|:------------------------|
| 2018-10-09 00:00:00.000 |


Table: L01
| L01    | L01-Description                           |
|:-------|:------------------------------------------|
| L01-01 | Construction of Schools Program (Phase 9) |


Table: L02
| L02     | L02-Description          |
|:--------|:-------------------------|
| (New)   | KEY DATES AND MILESTONES |
| (New)-1 | PRELIMINARIES            |
| (New)-2 | PROCUREMENT              |
| (New)-3 | ENGINEERING              |
| (New)-4 | CONSTRUCTION             |
| (New)-5 | HANDING OVER             |


Table: L03
| L03     | L03-Description           |
|:--------|:--------------------------|
| (New)   | KEY DATES AND MILESTONES  |
| (New)-1 | PRELIMINARIES             |
| (New)-2 | SUBCONTRACTOERS/SUPPLIERS |
| (New)-3 | MATERIAL SUBMISSION       |
| (New)-4 | MATERIAL APPROVAL         |
| (New)-5 | MATERIAL DEVIVERY         |
| (New)-6 | SHOPDAWINGS SUBMITTAL     |
| (New)-7 | SHOPDAWINGS APPROVAL      |
| (New)-8 | VILLA BUILDING WORKS      |
| (New)-9 | EXTERNAL WORKS            |


Table: L04
| L04     | L04-Description           |
|:--------|:--------------------------|
| (New)   | KEY DATES AND MILESTONES  |
| (New)-1 | PRELIMINARIES             |
| (New)-2 | SUBCONTRACTOERS/SUPPLIERS |
| (New)-3 | MATERIAL SUBMISSION       |
| (New)-4 | MATERIAL APPROVAL         |
| (New)-5 | MATERIAL DEVIVERY         |
| (New)-6 | SHOPDAWINGS SUBMITTAL     |
| (New)-7 | SHOPDAWINGS APPROVAL      |
| (New)-8 | SUB-STRUCTRE              |
| (New)-9 | GROUND FLOOR              |


Table: Resource
| Resource ID   | Resource Name   |
|:--------------|:----------------|
| Cost-School   | Cost-School     |
| Man-Power     | Man-Power       |


Table: Trash



Table: UP-Activities
| Activity ID   | Activity Name                             |   Original Duration |   Remaining Duration |   Actual Duration | Actual Start   | Actual Finish   | BL1 Start   | BL1 Finish   | Total Float   |   Activity % Complete | Activity Type   | L01    | L02     | L03     | L04     | Custom      | Actual/Frorecast Start Date   | Actual/Frorecast Finish Date   |
|:--------------|:------------------------------------------|--------------------:|---------------------:|------------------:|:---------------|:----------------|:------------|:-------------|:--------------|----------------------:|:----------------|:-------|:--------|:--------|:--------|:------------|:------------------------------|:-------------------------------|
| A1010         | Mobilization and Site Office Installation |                  30 |                  1   |               281 | 01-Jan-18      |                 | 01-Jan-18   | 30-Jan-18    | 0             |                0.9667 | Task Dependent  | L01-01 | (New)-1 | (New)-1 | (New)-1 | 01-Jan-18 A | 2018-01-01 00:00:00.000       | 2018-10-09 00:00:00.000        |
| KEY-16        | Project Start Date                        |                   0 |                  0   |                 0 | 01-Jan-18      |                 | 01-Jan-18   |              |               |                1      | Start Milestone | L01-01 | (New)   | (New)   | (New)   | 01-Jan-18 A | 2018-01-01 00:00:00.000       | 2018-01-01 00:00:00.000        |
| 2-MS1060      | Electrical                                |                   7 |                  0   |                 7 | 07-Jan-18      | 13-Jan-18       | 27-Feb-18   | 05-Mar-18    |               |                1      | Task Dependent  | L01-01 | (New)-2 | (New)-3 | (New)-3 | 07-Jan-18 A | 2018-01-07 00:00:00.000       | 2018-01-13 00:00:00.000        |
| 3-MA1000      | Concrete                                  |                   7 |                  0   |               107 | 07-Jan-18      | 24-Apr-18       | 25-Jan-18   | 31-Jan-18    |               |                1      | Task Dependent  | L01-01 | (New)-2 | (New)-4 | (New)-4 | 07-Jan-18 A | 2018-01-07 00:00:00.000       | 2018-04-24 00:00:00.000        |
| 2-MS1030      | Doors and window                          |                   7 |                  0   |                10 | 07-Jan-18      | 17-Jan-18       | 18-Apr-18   | 24-Apr-18    |               |                1      | Task Dependent  | L01-01 | (New)-2 | (New)-3 | (New)-3 | 07-Jan-18 A | 2018-01-07 00:00:00.000       | 2018-01-17 00:00:00.000        |
| 2-MS1040      | Wood Works                                |                   7 |                  0   |                 7 | 07-Jan-18      | 13-Jan-18       | 08-May-18   | 14-May-18    |               |                1      | Task Dependent  | L01-01 | (New)-2 | (New)-3 | (New)-3 | 07-Jan-18 A | 2018-01-07 00:00:00.000       | 2018-01-13 00:00:00.000        |
| 2-MS1070      | Plumbing                                  |                   7 |                  3.5 |               275 | 07-Jan-18      |                 | 27-Feb-18   | 05-Mar-18    | 61.5          |                0.5    | Task Dependent  | L01-01 | (New)-2 | (New)-3 | (New)-3 | 07-Jan-18 A | 2018-01-07 00:00:00.000       | 2018-10-12 00:00:00.000        |
| A1030         | Excavation Works                          |                  25 |                  0   |                25 | 08-Jan-18      | 01-Feb-18       | 31-Jan-18   | 24-Feb-18    |               |                1      | Task Dependent  | L01-01 | (New)-4 | (New)-8 | (New)-8 | 08-Jan-18 A | 2018-01-08 00:00:00.000       | 2018-02-01 00:00:00.000        |
| 2-MS1000      | Concrete                                  |                   7 |                  0   |                40 | 09-Jan-18      | 18-Feb-18       | 18-Jan-18   | 24-Jan-18    |               |                1      | Task Dependent  | L01-01 | (New)-2 | (New)-3 | (New)-3 | 09-Jan-18 A | 2018-01-09 00:00:00.000       | 2018-02-18 00:00:00.000        |
| 2-MS1010      | Block                                     |                   7 |                  0   |                22 | 09-Jan-18      | 31-Jan-18       | 27-Feb-18   | 05-Mar-18    |               |                1      | Task Dependent  | L01-01 | (New)-2 | (New)-3 | (New)-3 | 09-Jan-18 A | 2018-01-09 00:00:00.000       | 2018-01-31 00:00:00.000        |


Table: UP-Res
| Activity ID   | Activity Name   | Resource ID   | Resource Name   |   Budgeted Units |   Budgeted Cost  |   Units % Complete |   Actual Units | Spreadsheet Field   | Actual value Date       |   Actual Value |
|:--------------|:----------------|:--------------|:----------------|-----------------:|-----------------:|-------------------:|---------------:|:--------------------|:------------------------|---------------:|
| 4-MD1060      | Electrical      | Man-Power     | Man-Power       |             7.68 |                0 |                0.9 |           6.91 | Actual Units        | 2018-01-21 00:00:00.000 |           0.03 |
| 4-MD1060      | Electrical      | Man-Power     | Man-Power       |             7.68 |                0 |                0.9 |           6.91 | Actual Units        | 2018-01-22 00:00:00.000 |           0.03 |
| 4-MD1060      | Electrical      | Man-Power     | Man-Power       |             7.68 |                0 |                0.9 |           6.91 | Actual Units        | 2018-01-23 00:00:00.000 |           0.03 |
| 4-MD1060      | Electrical      | Man-Power     | Man-Power       |             7.68 |                0 |                0.9 |           6.91 | Actual Units        | 2018-01-24 00:00:00.000 |           0.03 |
| 4-MD1060      | Electrical      | Man-Power     | Man-Power       |             7.68 |                0 |                0.9 |           6.91 | Actual Units        | 2018-01-25 00:00:00.000 |           0.03 |
| 4-MD1060      | Electrical      | Man-Power     | Man-Power       |             7.68 |                0 |                0.9 |           6.91 | Actual Units        | 2018-01-26 00:00:00.000 |           0.03 |
| 4-MD1060      | Electrical      | Man-Power     | Man-Power       |             7.68 |                0 |                0.9 |           6.91 | Actual Units        | 2018-01-27 00:00:00.000 |           0.03 |
| 4-MD1060      | Electrical      | Man-Power     | Man-Power       |             7.68 |                0 |                0.9 |           6.91 | Actual Units        | 2018-01-28 00:00:00.000 |           0.03 |
| 4-MD1060      | Electrical      | Man-Power     | Man-Power       |             7.68 |                0 |                0.9 |           6.91 | Actual Units        | 2018-01-29 00:00:00.000 |           0.03 |
| 4-MD1060      | Electrical      | Man-Power     | Man-Power       |             7.68 |                0 |                0.9 |           6.91 | Actual Units        | 2018-01-30 00:00:00.000 |           0.03 |

 


tables: name: BL-Activities
data: BL-Activities.csv
name: BL-Res
data: BL-Res.csv
name: Date
data: Date.csv
name: Info
data: Info.csv
name: L01
data: L01.csv
name: L02
data: L02.csv
name: L03
data: L03.csv
name: L04
data: L04.csv
name: Resource
data: Resource.csv
name: Trash
data: Trash.csv
name: UP-Activities
data: UP-Activities.csv
name: UP-Res
data: UP-Res.csv
label: UP-Activities
L01
L01
L01
UP-Activities
L02
L02
L02
UP-Activities
L04
L04
L04
UP-Activities
L03
L03
L03
BL-Activities
L04
L04
L04
BL-Activities
L03
L03
L03
BL-Activities
L02
L02
L02
BL-Activities
L01
L01
L01
UP-Res
Resource ID
Resource
Resource ID
BL-Res
Resource ID
Resource
Resource ID
BL-Res
Activity ID
UP-Activities
Activity ID
output: {
    "joins": [
        {
            "from_table": "UP-Activities",
            "from_column": "L01",
            "to_table": "L01",
            "to_column": "L01"
        },
        {
            "from_table": "UP-Activities",
            "from_column": "L02",
            "to_table": "L02",
            "to_column": "L02"
        },
        {
            "from_table": "UP-Activities",
            "from_column": "L04",
            "to_table": "L04",
            "to_column": "L04"
        },
        {
            "from_table": "UP-Activities",
            "from_column": "L03",
            "to_table": "L03",
            "to_column": "L03"
        },
        {
            "from_table": "BL-Activities",
            "from_column": "L04",
            "to_table": "L04",
            "to_column": "L04"
        },
        {
            "from_table": "BL-Activities",
            "from_column": "L03",
            "to_table": "L03",
            "to_column": "L03"
        },
        {
            "from_table": "BL-Activities",
            "from_column": "L02",
            "to_table": "L02",
            "to_column": "L02"
        },
        {
            "from_table": "BL-Activities",
            "from_column": "L01",
            "to_table": "L01",
            "to_column": "L01"
        },
        {
            "from_table": "UP-Res",
            "from_column": "Resource ID",
            "to_table": "Resource",
            "to_column": "Resource ID"
        },
        {
            "from_table": "BL-Res",
            "from_column": "Resource ID",
            "to_table": "Resource",
            "to_column": "Resource ID"
        },
        {
            "from_table": "BL-Res",
            "from_column": "Activity ID",
            "to_table": "UP-Activities",
            "to_column": "Activity ID"
        }
    ]
}