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: dev_brook DimAmenities
|   AmenitiesKey |   ListingID | AmenityName   | RowIsCurrent   | RowStartDate            | RowEndDate              | RowChangeReason   |
|---------------:|------------:|:--------------|:---------------|:------------------------|:------------------------|:------------------|
|              3 |        3335 | internet      | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|             11 |        4291 | internet      | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|             18 |        5682 | internet      | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|             26 |        6606 | internet      | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|             33 |        7369 | internet      | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|             41 |        9419 | internet      | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|             51 |        9460 | internet      | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|             60 |        9531 | internet      | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|             71 |        9534 | internet      | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|             81 |        9596 | internet      | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |


Table: dev_brook DimDate
|   DateKey | Date                    | FullDateUSA   |   DayOfWeek | DayName   |   DayOfMonth |   DayOfYear |   WeekOfYear | MonthName   |   MonthOfYear |   Quarter | QuarterName   |   Year | IsAWeekday   |
|----------:|:------------------------|:--------------|------------:|:----------|-------------:|------------:|-------------:|:------------|--------------:|----------:|:--------------|-------:|:-------------|
|  19960708 | 1996-07-08 00:00:00.000 | 07/08/1996    |           2 | Monday    |            8 |         190 |           28 | July        |             7 |         3 | Third         |   1996 | Y            |
|  19960709 | 1996-07-09 00:00:00.000 | 07/09/1996    |           3 | Tuesday   |            9 |         191 |           28 | July        |             7 |         3 | Third         |   1996 | Y            |
|  19960710 | 1996-07-10 00:00:00.000 | 07/10/1996    |           4 | Wednesday |           10 |         192 |           28 | July        |             7 |         3 | Third         |   1996 | Y            |
|  19960711 | 1996-07-11 00:00:00.000 | 07/11/1996    |           5 | Thursday  |           11 |         193 |           28 | July        |             7 |         3 | Third         |   1996 | Y            |
|  19960712 | 1996-07-12 00:00:00.000 | 07/12/1996    |           6 | Friday    |           12 |         194 |           28 | July        |             7 |         3 | Third         |   1996 | Y            |
|  19970707 | 1997-07-07 00:00:00.000 | 07/07/1997    |           2 | Monday    |            7 |         188 |           28 | July        |             7 |         3 | Third         |   1997 | Y            |
|  19970708 | 1997-07-08 00:00:00.000 | 07/08/1997    |           3 | Tuesday   |            8 |         189 |           28 | July        |             7 |         3 | Third         |   1997 | Y            |
|  19970709 | 1997-07-09 00:00:00.000 | 07/09/1997    |           4 | Wednesday |            9 |         190 |           28 | July        |             7 |         3 | Third         |   1997 | Y            |
|  19970710 | 1997-07-10 00:00:00.000 | 07/10/1997    |           5 | Thursday  |           10 |         191 |           28 | July        |             7 |         3 | Third         |   1997 | Y            |
|  19970711 | 1997-07-11 00:00:00.000 | 07/11/1997    |           6 | Friday    |           11 |         192 |           28 | July        |             7 |         3 | Third         |   1997 | Y            |


Table: dev_brook DimListingHostMap
|   ListingHostMapKey |   ListingID |   HostID | HostName           | ListingName                         | RowIsCurrent   | RowStartDate            | RowEndDate              | RowChangeReason   |
|--------------------:|------------:|---------:|:-------------------|:------------------------------------|:---------------|:------------------------|:------------------------|:------------------|
|                   1 |        3335 |     4193 | Jessica<4193>      | Sweet Seattle Urban Homestead 2 Bdr | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                   2 |        4291 |    35749 | Jess & Joey<35749> | Sunrise in Seattle Master Suite     | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                   3 |        5682 |     8993 | Maddy<8993>        | Cozy Studio, min. to downtown -WiFi | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                   4 |        6606 |    14942 | Joyce<14942>       | Fab, private seattle urban cottage! | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                   5 |        7369 |    19425 | Shireen<19425>     | launchingpad/landingpad             | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                   6 |        9419 |    30559 | Angielena<30559>   | Golden Sun vintage warm/sunny       | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                   7 |        9460 |    30832 | Siena<30832>       | Downtown Convention Ctr B&B - Nice! | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                   8 |        9531 |    31481 | Cassie<31481>      | The Adorable Sweet Orange Craftsman | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                   9 |        9534 |    31481 | Cassie<31481>      | The Coolest Tangerine Dream MIL!    | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                  10 |        9596 |    14942 | Joyce<14942>       | the down home ,central and fab!     | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |


Table: dev_brook DimLocations
|   LocationKey |   ListingID | Neighbourhood   | Neighbourhood_Group   |   ZipCode |   Latitude |   Longitude | RowIsCurrent   | RowStartDate            | RowEndDate              | RowChangeReason   |
|--------------:|------------:|:----------------|:----------------------|----------:|-----------:|------------:|:---------------|:------------------------|:------------------------|:------------------|
|            34 |       38545 | Fremont         | Other neighborhoods   |     98103 |    47.653  |    -122.343 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|            43 |       51826 | Fremont         | Other neighborhoods   |     98103 |    47.6604 |    -122.353 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|            45 |       53803 | Fremont         | Other neighborhoods   |     98103 |    47.6603 |    -122.352 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|            72 |      116221 | Fremont         | Other neighborhoods   |     98103 |    47.6544 |    -122.357 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|            75 |      119103 | Fremont         | Other neighborhoods   |     98103 |    47.652  |    -122.35  | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|           114 |      215954 | Fremont         | Other neighborhoods   |     98103 |    47.6614 |    -122.352 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|           136 |      262764 | Fremont         | Other neighborhoods   |     98103 |    47.6542 |    -122.353 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|           147 |      282934 | Fremont         | Other neighborhoods   |     98103 |    47.6576 |    -122.354 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|           192 |      430609 | Fremont         | Other neighborhoods   |     98103 |    47.6588 |    -122.348 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|           221 |      490076 | Fremont         | Other neighborhoods   |     98103 |    47.6543 |    -122.353 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |


Table: dev_brook DimNeighbourhoodScores
|   NeighbourhoodKey | NeighbourhoodName      |   Rank |   Walk_Score |   Transit_score |   Bike_score |   Population | RowIsCurrent   | RowStartDate            | RowEndDate              | RowChangeReason   |
|-------------------:|:-----------------------|-------:|-------------:|----------------:|-------------:|-------------:|:---------------|:------------------------|:------------------------|:------------------|
|                  1 | Downtown               |      1 |           98 |             100 |           72 |         5059 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                  2 | International District |      2 |           98 |             100 |           80 |         3396 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                  3 | Belltown               |      3 |           98 |              99 |           75 |        14163 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                  4 | First Hill             |      4 |           98 |              99 |           78 |         9294 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                  5 | Pioneer Square         |      5 |           98 |             100 |           77 |         4159 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                  6 | Yesler Terrace         |      6 |           94 |             100 |           78 |         4126 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                  7 | South Lake Union       |      7 |           94 |              89 |           80 |         4054 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                  8 | University District    |      8 |           93 |              78 |           86 |        26712 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                  9 | Capitol Hill           |      9 |           93 |              81 |           83 |        29310 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                 10 | Lower Queen Anne       |     10 |           92 |              72 |           69 |        10241 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |


Table: dev_brook DimOccupancyFeatures
|   OccupancyFeatureKey |   ListingID |   Accommodates |   Bathrooms |   Bedrooms |   Beds |   Bedroom_share |   Bathroom_share | RowIsCurrent   | RowStartDate            | RowEndDate              | RowChangeReason   |
|----------------------:|------------:|---------------:|------------:|-----------:|-------:|----------------:|-----------------:|:---------------|:------------------------|:------------------------|:------------------|
|                     2 |        4291 |              2 |           1 |          1 |      1 |             0.5 |              0.5 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                     3 |        5682 |              2 |           1 |          1 |      1 |             0.5 |              0.5 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                     4 |        6606 |              2 |           1 |          1 |      1 |             0.5 |              0.5 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                     5 |        7369 |              2 |           1 |          1 |      1 |             0.5 |              0.5 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                     7 |        9460 |              2 |           1 |          1 |      1 |             0.5 |              0.5 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                    23 |       20927 |              2 |           1 |          1 |      1 |             0.5 |              0.5 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                    24 |       20928 |              2 |           1 |          1 |      1 |             0.5 |              0.5 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                    32 |       30712 |              2 |           1 |          1 |      1 |             0.5 |              0.5 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                    38 |       47196 |              2 |           1 |          1 |      1 |             0.5 |              0.5 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                    40 |       48319 |              2 |           1 |          1 |      1 |             0.5 |              0.5 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |


Table: dev_brook DimPolicies
|   ListingPolicyKey |   ListingID |   Minimum_Nights |   Maximum_Nights | Cancellation_Policy   | Instant_Bookable   | RowIsCurrent   | RowStartDate            | RowEndDate              | RowChangeReason   |
|-------------------:|------------:|-----------------:|-----------------:|:----------------------|:-------------------|:---------------|:------------------------|:------------------------|:------------------|
|                  5 |        7369 |                1 |             1125 | flexible              | N                  | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                249 |      609252 |                1 |             1125 | flexible              | N                  | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                292 |      716829 |                1 |             1125 | flexible              | N                  | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                298 |      745099 |                1 |             1125 | flexible              | N                  | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                310 |      783061 |                1 |             1125 | flexible              | N                  | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                320 |      799882 |                1 |             1125 | flexible              | N                  | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                345 |      888967 |                1 |             1125 | flexible              | N                  | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                427 |     1142039 |                1 |             1125 | flexible              | N                  | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                445 |     1190224 |                1 |             1125 | flexible              | N                  | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                475 |     1260259 |                1 |             1125 | flexible              | N                  | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |


Table: dev_brook DimPriceFees
|   PriceFeesKey |   ListingID |   Price |   WeeklyPrice |   MonthlyPrice |   SecurityDeposit |   CleaningFee |   GuestsIncluded |   ExtraPeopleFee | HasWeeklyPrice   | HasMonthlyPrice   | HasSecurityDeposit   | HasCleaningFee   | HasExtraPeopleFee   |   CalendarAvailableDays | RowIsCurrent   | RowStartDate            | RowEndDate              | RowChangeReason   |
|---------------:|------------:|--------:|--------------:|---------------:|------------------:|--------------:|-----------------:|-----------------:|:-----------------|:------------------|:---------------------|:-----------------|:--------------------|------------------------:|:---------------|:------------------------|:------------------------|:------------------|
|             84 |      149489 |      50 |             0 |              0 |                 0 |             0 |                1 |                0 | N                | N                 | N                    | N                | N                   |                     365 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|            246 |      609252 |     280 |             0 |              0 |                 0 |             0 |                1 |                0 | N                | N                 | N                    | N                | N                   |                     365 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|            558 |     1594412 |     125 |             0 |              0 |                 0 |             0 |                1 |                0 | N                | N                 | N                    | N                | N                   |                     365 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|            729 |     2352218 |      80 |             0 |              0 |                 0 |             0 |                1 |                0 | N                | N                 | N                    | N                | N                   |                     365 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|            937 |     3251069 |     109 |             0 |              0 |                 0 |             0 |                1 |                0 | N                | N                 | N                    | N                | N                   |                     365 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|            992 |     3413183 |     550 |             0 |              0 |                 0 |             0 |                1 |                0 | N                | N                 | N                    | N                | N                   |                     365 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|            994 |     3416590 |     145 |             0 |              0 |                 0 |             0 |                1 |                0 | N                | N                 | N                    | N                | N                   |                     365 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|           1051 |     3604904 |      60 |             0 |              0 |                 0 |             0 |                1 |                0 | N                | N                 | N                    | N                | N                   |                     365 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|           1112 |     3793185 |     175 |             0 |              0 |                 0 |             0 |                1 |                0 | N                | N                 | N                    | N                | N                   |                     365 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|           1140 |     3883041 |     100 |             0 |              0 |                 0 |             0 |                1 |                0 | N                | N                 | N                    | N                | N                   |                     365 | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |


Table: dev_brook DimPropertyTypes
|   PropertyTypeKey |   ListingID | PropertyTypeName   | RowIsCurrent   | RowStartDate            | RowEndDate              | RowChangeReason   |
|------------------:|------------:|:-------------------|:---------------|:------------------------|:------------------------|:------------------|
|                 2 |        4291 | house              | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                 6 |        9419 | house              | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                 8 |        9531 | house              | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                 9 |        9534 | house              | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                11 |       10385 | house              | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                12 |       10695 | house              | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                13 |       11012 | house              | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                14 |       11411 | house              | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                15 |       13068 | house              | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|                16 |       14386 | house              | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |


Table: dev_brook DimSubFeatures
|   SubFeatureKey |   ListingID | SubFeatureName   | RowIsCurrent   | RowStartDate            | RowEndDate              | RowChangeReason   |
|----------------:|------------:|:-----------------|:---------------|:------------------------|:------------------------|:------------------|
|               2 |        3335 | real_bed         | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|               3 |        4291 | real_bed         | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|               6 |        5682 | real_bed         | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|               8 |        6606 | real_bed         | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|              10 |        7369 | real_bed         | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|              11 |        9419 | real_bed         | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|              13 |        9460 | real_bed         | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|              16 |        9531 | real_bed         | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|              18 |        9534 | real_bed         | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |
|              20 |        9596 | real_bed         | True           | 1899-12-31 00:00:00.000 | 9999-12-31 00:00:00.000 |                   |


Table: dev_brook FactHostReviewScores
|   LocationKey |   OccupancyFeatureKey |   SubFeatureKey |   PropertyTypeKey |   ListingHostMapKey |   ListingPolicyKey |   AmenitiesKey |   PriceFeesKey |   NumberOfReviews |   ReviewsPerMonth |   MinimumNights |   ReviewScoresRating |   ReviewScoresAccuracy |   ReviewScoresCleanliness |   ReviewScoresCheckin |   ReviewScoresCommunication |   ReviewScoresLocation |   ReviewScoresValue |   AvgPolarityPositiveScore |   AvgPolarityNegativeScore |   AvgPolarityCompoundScore |   ReviewDaysRange |   ReviewYearsRange |   ReviewsPerYearRate |   ReviewsFrequency |
|--------------:|----------------------:|----------------:|------------------:|--------------------:|-------------------:|---------------:|---------------:|------------------:|------------------:|----------------:|---------------------:|-----------------------:|--------------------------:|----------------------:|----------------------------:|-----------------------:|--------------------:|---------------------------:|---------------------------:|---------------------------:|------------------:|-------------------:|---------------------:|-------------------:|
|           696 |                   696 |            1391 |               696 |                 696 |                696 |           5899 |            687 |                 1 |                 1 |               1 |                  100 |                     10 |                        10 |                    10 |                          10 |                     10 |                  10 |                      0.446 |                          0 |                     0.9702 |                 1 |         0.00273973 |                  365 |                  1 |
|           696 |                   696 |            1391 |               696 |                 696 |                696 |           5900 |            687 |                 1 |                 1 |               1 |                  100 |                     10 |                        10 |                    10 |                          10 |                     10 |                  10 |                      0.446 |                          0 |                     0.9702 |                 1 |         0.00273973 |                  365 |                  1 |
|           696 |                   696 |            1391 |               696 |                 696 |                696 |           5901 |            687 |                 1 |                 1 |               1 |                  100 |                     10 |                        10 |                    10 |                          10 |                     10 |                  10 |                      0.446 |                          0 |                     0.9702 |                 1 |         0.00273973 |                  365 |                  1 |
|           696 |                   696 |            1391 |               696 |                 696 |                696 |           5902 |            687 |                 1 |                 1 |               1 |                  100 |                     10 |                        10 |                    10 |                          10 |                     10 |                  10 |                      0.446 |                          0 |                     0.9702 |                 1 |         0.00273973 |                  365 |                  1 |
|           696 |                   696 |            1391 |               696 |                 696 |                696 |           5903 |            687 |                 1 |                 1 |               1 |                  100 |                     10 |                        10 |                    10 |                          10 |                     10 |                  10 |                      0.446 |                          0 |                     0.9702 |                 1 |         0.00273973 |                  365 |                  1 |
|           696 |                   696 |            1391 |               696 |                 696 |                696 |           5904 |            687 |                 1 |                 1 |               1 |                  100 |                     10 |                        10 |                    10 |                          10 |                     10 |                  10 |                      0.446 |                          0 |                     0.9702 |                 1 |         0.00273973 |                  365 |                  1 |
|           696 |                   696 |            1391 |               696 |                 696 |                696 |           5905 |            687 |                 1 |                 1 |               1 |                  100 |                     10 |                        10 |                    10 |                          10 |                     10 |                  10 |                      0.446 |                          0 |                     0.9702 |                 1 |         0.00273973 |                  365 |                  1 |
|           696 |                   696 |            1391 |               696 |                 696 |                696 |           5906 |            687 |                 1 |                 1 |               1 |                  100 |                     10 |                        10 |                    10 |                          10 |                     10 |                  10 |                      0.446 |                          0 |                     0.9702 |                 1 |         0.00273973 |                  365 |                  1 |
|           696 |                   696 |            1391 |               696 |                 696 |                696 |           5907 |            687 |                 1 |                 1 |               1 |                  100 |                     10 |                        10 |                    10 |                          10 |                     10 |                  10 |                      0.446 |                          0 |                     0.9702 |                 1 |         0.00273973 |                  365 |                  1 |
|           696 |                   696 |            1391 |               696 |                 696 |                696 |           5908 |            687 |                 1 |                 1 |               1 |                  100 |                     10 |                        10 |                    10 |                          10 |                     10 |                  10 |                      0.446 |                          0 |                     0.9702 |                 1 |         0.00273973 |                  365 |                  1 |


Table: dev_brook FactListingEstOcc
|   LocationKey |   OccupancyFeatureKey |   SubFeatureKey |   PropertyTypeKey |   ListingHostMapKey |   ListingPolicyKey |   AmenitiesKey |   PriceFeesKey |   EstLifetimeOccupancyDays |   EstLifetimeOccDailyRate |   EstLifetimeOccYearlyRate |   EstLifetimeIncome |   EstLifetimeYearlyIncome |   EstLifetimePotentialIncome |   EstLifetimePotentialYearlyIncome |   EstLifetimePercentOfPotentialIncome |   LifetimeEarner |
|--------------:|----------------------:|----------------:|------------------:|--------------------:|-------------------:|---------------:|---------------:|---------------------------:|--------------------------:|---------------------------:|--------------------:|--------------------------:|-----------------------------:|-----------------------------------:|--------------------------------------:|-----------------:|
|           933 |                   933 |            1865 |               933 |                 933 |                933 |           7912 |            918 |                          6 |                  0.107143 |                    39.1071 |                1194 |                   7782.32 |                       9495.3 |                              61889 |                               12.5746 |                0 |
|           933 |                   933 |            1865 |               933 |                 933 |                933 |           7913 |            918 |                          6 |                  0.107143 |                    39.1071 |                1194 |                   7782.32 |                       9495.3 |                              61889 |                               12.5746 |                0 |
|           933 |                   933 |            1865 |               933 |                 933 |                933 |           7914 |            918 |                          6 |                  0.107143 |                    39.1071 |                1194 |                   7782.32 |                       9495.3 |                              61889 |                               12.5746 |                0 |
|           933 |                   933 |            1865 |               933 |                 933 |                933 |           7915 |            918 |                          6 |                  0.107143 |                    39.1071 |                1194 |                   7782.32 |                       9495.3 |                              61889 |                               12.5746 |                0 |
|           933 |                   933 |            1865 |               933 |                 933 |                933 |           7916 |            918 |                          6 |                  0.107143 |                    39.1071 |                1194 |                   7782.32 |                       9495.3 |                              61889 |                               12.5746 |                0 |
|           933 |                   933 |            1865 |               933 |                 933 |                933 |           7917 |            918 |                          6 |                  0.107143 |                    39.1071 |                1194 |                   7782.32 |                       9495.3 |                              61889 |                               12.5746 |                0 |
|           933 |                   933 |            1865 |               933 |                 933 |                933 |           7918 |            918 |                          6 |                  0.107143 |                    39.1071 |                1194 |                   7782.32 |                       9495.3 |                              61889 |                               12.5746 |                0 |
|           933 |                   933 |            1865 |               933 |                 933 |                933 |           7919 |            918 |                          6 |                  0.107143 |                    39.1071 |                1194 |                   7782.32 |                       9495.3 |                              61889 |                               12.5746 |                0 |
|           933 |                   933 |            1866 |               933 |                 933 |                933 |           7912 |            918 |                          6 |                  0.107143 |                    39.1071 |                1194 |                   7782.32 |                       9495.3 |                              61889 |                               12.5746 |                0 |
|           933 |                   933 |            1866 |               933 |                 933 |                933 |           7913 |            918 |                          6 |                  0.107143 |                    39.1071 |                1194 |                   7782.32 |                       9495.3 |                              61889 |                               12.5746 |                0 |

 


tables: name: dev_brook DimAmenities
data: dev_brook DimAmenities.csv
name: dev_brook DimDate
data: dev_brook DimDate.csv
name: dev_brook DimListingHostMap
data: dev_brook DimListingHostMap.csv
name: dev_brook DimLocations
data: dev_brook DimLocations.csv
name: dev_brook DimNeighbourhoodScores
data: dev_brook DimNeighbourhoodScores.csv
name: dev_brook DimOccupancyFeatures
data: dev_brook DimOccupancyFeatures.csv
name: dev_brook DimPolicies
data: dev_brook DimPolicies.csv
name: dev_brook DimPriceFees
data: dev_brook DimPriceFees.csv
name: dev_brook DimPropertyTypes
data: dev_brook DimPropertyTypes.csv
name: dev_brook DimSubFeatures
data: dev_brook DimSubFeatures.csv
name: dev_brook FactHostReviewScores
data: dev_brook FactHostReviewScores.csv
name: dev_brook FactListingEstOcc
data: dev_brook FactListingEstOcc.csv
label: dev_brook FactListingEstOcc
AmenitiesKey
dev_brook DimAmenities
AmenitiesKey
dev_brook FactListingEstOcc
LocationKey
dev_brook DimLocations
LocationKey
dev_brook FactListingEstOcc
OccupancyFeatureKey
dev_brook DimOccupancyFeatures
OccupancyFeatureKey
dev_brook FactListingEstOcc
PropertyTypeKey
dev_brook DimPropertyTypes
PropertyTypeKey
dev_brook FactListingEstOcc
SubFeatureKey
dev_brook DimSubFeatures
SubFeatureKey
dev_brook FactHostReviewScores
AmenitiesKey
dev_brook DimAmenities
AmenitiesKey
dev_brook FactHostReviewScores
LocationKey
dev_brook DimLocations
LocationKey
dev_brook FactHostReviewScores
OccupancyFeatureKey
dev_brook DimOccupancyFeatures
OccupancyFeatureKey
dev_brook FactHostReviewScores
PropertyTypeKey
dev_brook DimPropertyTypes
PropertyTypeKey
dev_brook FactHostReviewScores
SubFeatureKey
dev_brook DimSubFeatures
SubFeatureKey
dev_brook DimLocations
ListingID
dev_brook DimPriceFees
ListingID
dev_brook DimPriceFees
ListingID
dev_brook DimPolicies
ListingID
dev_brook FactHostReviewScores
ListingHostMapKey
dev_brook DimListingHostMap
ListingHostMapKey
dev_brook FactListingEstOcc
ListingHostMapKey
dev_brook DimListingHostMap
ListingHostMapKey
output: {
    "joins": [
        {
            "from_table": "dev_brook FactListingEstOcc",
            "from_column": "AmenitiesKey",
            "to_table": "dev_brook DimAmenities",
            "to_column": "AmenitiesKey"
        },
        {
            "from_table": "dev_brook FactListingEstOcc",
            "from_column": "LocationKey",
            "to_table": "dev_brook DimLocations",
            "to_column": "LocationKey"
        },
        {
            "from_table": "dev_brook FactListingEstOcc",
            "from_column": "OccupancyFeatureKey",
            "to_table": "dev_brook DimOccupancyFeatures",
            "to_column": "OccupancyFeatureKey"
        },
        {
            "from_table": "dev_brook FactListingEstOcc",
            "from_column": "PropertyTypeKey",
            "to_table": "dev_brook DimPropertyTypes",
            "to_column": "PropertyTypeKey"
        },
        {
            "from_table": "dev_brook FactListingEstOcc",
            "from_column": "SubFeatureKey",
            "to_table": "dev_brook DimSubFeatures",
            "to_column": "SubFeatureKey"
        },
        {
            "from_table": "dev_brook FactHostReviewScores",
            "from_column": "AmenitiesKey",
            "to_table": "dev_brook DimAmenities",
            "to_column": "AmenitiesKey"
        },
        {
            "from_table": "dev_brook FactHostReviewScores",
            "from_column": "LocationKey",
            "to_table": "dev_brook DimLocations",
            "to_column": "LocationKey"
        },
        {
            "from_table": "dev_brook FactHostReviewScores",
            "from_column": "OccupancyFeatureKey",
            "to_table": "dev_brook DimOccupancyFeatures",
            "to_column": "OccupancyFeatureKey"
        },
        {
            "from_table": "dev_brook FactHostReviewScores",
            "from_column": "PropertyTypeKey",
            "to_table": "dev_brook DimPropertyTypes",
            "to_column": "PropertyTypeKey"
        },
        {
            "from_table": "dev_brook FactHostReviewScores",
            "from_column": "SubFeatureKey",
            "to_table": "dev_brook DimSubFeatures",
            "to_column": "SubFeatureKey"
        },
        {
            "from_table": "dev_brook DimLocations",
            "from_column": "ListingID",
            "to_table": "dev_brook DimPriceFees",
            "to_column": "ListingID"
        },
        {
            "from_table": "dev_brook DimPriceFees",
            "from_column": "ListingID",
            "to_table": "dev_brook DimPolicies",
            "to_column": "ListingID"
        },
        {
            "from_table": "dev_brook FactHostReviewScores",
            "from_column": "ListingHostMapKey",
            "to_table": "dev_brook DimListingHostMap",
            "to_column": "ListingHostMapKey"
        },
        {
            "from_table": "dev_brook FactListingEstOcc",
            "from_column": "ListingHostMapKey",
            "to_table": "dev_brook DimListingHostMap",
            "to_column": "ListingHostMapKey"
        }
    ]
}