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: Accomodations
|   Year ID |   Country ID | ACCOMMODATIONS            |   Visitors Accomodation Preference |
|----------:|-------------:|:--------------------------|-----------------------------------:|
|         5 |            1 | Plan to stay in Hotel     |                        1.74197e+06 |
|         5 |            1 | Hotel only                |                        1.4886e+06  |
|         5 |            1 | Plan to stay in Condo     |                   758192           |
|         5 |            1 | Condo only                |                   622907           |
|         5 |            1 | Plan to stay in Timeshare |                   448539           |
|         5 |            1 | Timeshare only            |                   359476           |
|         5 |            1 | Cruise Ship               |                    31049.5         |
|         5 |            1 | Friends/Relatives         |                   422311           |
|         5 |            1 | Rental House              |                   347517           |
|         5 |            1 | Hostel                    |                    18296.9         |


Table: Age
| MMA Country   |   Year ID |   Mean Age (Years) |
|:--------------|----------:|-------------------:|
| US Total      |         6 |            51.8869 |
| US Total      |         5 |            53      |
| US Total      |         4 |            53      |
| US Total      |         3 |            43      |
| US Total      |         2 |            43      |
| US Total      |         1 |            43      |
| US West       |         6 |            51.756  |
| US West       |         5 |            53      |
| US West       |         4 |            53      |
| US West       |         3 |            45      |


Table: Arrivals by Country
|   Year ID |   Island ID |   Country ID |         Visitors |
|----------:|------------:|-------------:|-----------------:|
|         1 |           1 |            1 |      1.34705e+06 |
|         1 |           2 |            1 |      1.03714e+06 |
|         1 |           3 |            1 |  20856.7         |
|         1 |           4 |            1 |  28208.7         |
|         1 |           5 |            1 | 490543           |
|         1 |           6 |            1 | 531762           |
|         1 |           1 |            2 | 986739           |
|         1 |           2 |            2 | 600859           |
|         1 |           3 |            2 |  15488.8         |
|         1 |           4 |            2 |  24969.5         |


Table: Best Feature
|   Year ID | Best Feature                              | MMA Country   |   Feedback |
|----------:|:------------------------------------------|:--------------|-----------:|
|         6 | Natural Beauty/ Nature/ Scenery           | US West       |  0.148678  |
|         6 | Activities/ Attractions (not part of pkg) | US West       |  0.210282  |
|         6 | Friendly/ Warm/ Hospitality/ Aloha Spirit | US West       |  0.118707  |
|         6 | Weather                                   | US West       |  0.149987  |
|         6 | Beach/ Ocean                              | US West       |  0.0855669 |
|         6 | Event/ Celebration- friends/ family       | US West       |  0.113418  |
|         6 | Overall Positive (unspecified)            | US West       |  0.0656447 |
|         6 | Accommodations                            | US West       |  0.101731  |
|         6 | Relaxation/ Atmosphere                    | US West       |  0.0385128 |
|         6 | Local culture/ Food/ Music                | US West       |  0.0512483 |


Table: Country
|   Country ID | Country     |
|-------------:|:------------|
|            1 | USA         |
|            2 | US EAST     |
|            3 | JAPAN       |
|            4 | CANADA      |
|            5 | U.K.        |
|            6 | FRANCE      |
|            7 | GERMANY     |
|            8 | ITALY       |
|            9 | SWITZERLAND |
|           10 | AUSTRALIA   |


Table: Exp by Island
|   Year ID |   Month ID |   Island ID |   Total Expenditure ($ mil.) |   Per Person Per Day Spending ($) |   Per Person Per Trip Spending ($) |   Total Expenditure |
|----------:|-----------:|------------:|-----------------------------:|----------------------------------:|-----------------------------------:|--------------------:|
|         5 |          1 |           1 |                      659.339 |                           214.834 |                            1577.81 |         6.59339e+08 |
|         5 |          2 |           1 |                      587.293 |                           224.784 |                            1495.85 |         5.87293e+08 |
|         5 |          3 |           1 |                      590.598 |                           200.039 |                            1351.96 |         5.90598e+08 |
|         5 |          4 |           1 |                      536.698 |                           206.604 |                            1367.81 |         5.36698e+08 |
|         5 |          5 |           1 |                      542.651 |                           196.225 |                            1309.33 |         5.42651e+08 |
|         5 |          6 |           1 |                      630.576 |                           194.133 |                            1352.43 |         6.30576e+08 |
|         5 |          7 |           1 |                      679.519 |                           199.326 |                            1368.27 |         6.79519e+08 |
|         5 |          8 |           1 |                      662.136 |                           201.795 |                            1374.31 |         6.62136e+08 |
|         5 |          9 |           1 |                      590.87  |                           223.318 |                            1430.52 |         5.9087e+08  |
|         5 |         10 |           1 |                      623.305 |                           230.535 |                            1474.46 |         6.23305e+08 |


Table: Gender
| MMA Country   |   Year ID | Gender   |   % Gender |
|:--------------|----------:|:---------|-----------:|
| US Total      |         6 | Male     |   0.496971 |
| US Total      |         6 | Female   |   0.503029 |
| US Total      |         5 | Male     |   0.491456 |
| US Total      |         5 | Female   |   0.508544 |
| US Total      |         4 | Male     |   0.491456 |
| US Total      |         4 | Female   |   0.508544 |
| US Total      |         3 | Male     |   0.484785 |
| US Total      |         3 | Female   |   0.515215 |
| US Total      |         2 | Male     |   0.484785 |
| US Total      |         2 | Female   |   0.515215 |


Table: Islands Visitation
|   Year ID | ISLANDS VISITED   | MMA Country   |   Island Visitation |
|----------:|:------------------|:--------------|--------------------:|
|         6 | O‘ahu             | US TOTAL      |          0.516988   |
|         6 | Maui              | US TOTAL      |          0.353691   |
|         6 | Moloka‘i          | US TOTAL      |          0.0227443  |
|         6 | Lāna‘i            | US TOTAL      |          0.0221117  |
|         6 | Hilo              | US TOTAL      |          0.145461   |
|         6 | Kona              | US TOTAL      |          0.20762    |
|         6 | Kaua‘i            | US TOTAL      |          0.234165   |
|         5 | O‘ahu             | US TOTAL      |          0.495014   |
|         5 | Maui              | US TOTAL      |          0.344047   |
|         5 | Moloka‘i          | US TOTAL      |          0.00878625 |


Table: Islands
|   Island ID | Island Name   |   Longitude |   Latitude |
|------------:|:--------------|------------:|-----------:|
|           1 | Oahu          |     158     |    21.4389 |
|           2 | Maui          |     156.332 |    20.7984 |
|           3 | Molokai       |     157.023 |    21.1444 |
|           4 | Lanai         |     156.927 |    20.8166 |
|           5 | Kauai         |     159.526 |    22.0964 |
|           6 | Hawaii        |     155.583 |    19.8968 |


Table: Length of Stay
|   Year ID |   Country ID |   Length of Stay |   Age of Party Head |   Party Size |
|----------:|-------------:|-----------------:|--------------------:|-------------:|
|         5 |            1 |          9.2965  |             46.5148 |      2.15066 |
|         5 |            2 |         10.2699  |             47.5045 |      1.94605 |
|         5 |            3 |          5.84182 |             42.8147 |      2.66972 |
|         5 |            4 |         12.3011  |             47.0196 |      2.19394 |
|         5 |            5 |          9.5473  |             44.65   |      2.37607 |
|         5 |            6 |          9.5473  |             44.65   |      2.37607 |
|         5 |            7 |          9.5473  |             44.65   |      2.37607 |
|         5 |            8 |          9.5473  |             44.65   |      2.37607 |
|         5 |            9 |          9.5473  |             44.65   |      2.37607 |
|         5 |           10 |          9.54796 |             44.311  |      2.39185 |


Table: LifeStyle
|   Year ID | Lifestyle               | MMA Country   |   % LifeStyle |
|----------:|:------------------------|:--------------|--------------:|
|         6 | Married/ Honeymoon      | US TOTAL      |     0.0382723 |
|         6 | Family (trvl child <18) | US TOTAL      |     0.199786  |
|         6 | Young (18-34)           | US TOTAL      |     0.112938  |
|         6 | Middle age (35-54)      | US TOTAL      |     0.230621  |
|         6 | Seniors (55+)           | US TOTAL      |     0.418382  |
|         5 | Married/ Honeymoon      | US TOTAL      |     0.0501055 |
|         5 | Family (trvl child <18) | US TOTAL      |     0.24326   |
|         5 | Young (18-34)           | US TOTAL      |     0.100634  |
|         5 | Middle age (35-54)      | US TOTAL      |     0.22832   |
|         5 | Seniors (55+)           | US TOTAL      |     0.377682  |


Table: Likelihood to Recommend
|   Year ID | Likelihood to Recommend   | MMA Country   |   % Recommendation |
|----------:|:--------------------------|:--------------|-------------------:|
|         6 | Very Likely               | US Total      |         0.895622   |
|         6 | Somewhat Likely           | US Total      |         0.0903908  |
|         6 | Not too likely            | US Total      |         0.0105024  |
|         6 | Not at all likely         | US Total      |         0.00348432 |
|         5 | Very Likely               | US Total      |         0.87944    |
|         5 | Somewhat Likely           | US Total      |         0.104153   |
|         5 | Not too likely            | US Total      |         0.0128856  |
|         5 | Not at all likely         | US Total      |         0.00352134 |
|         4 | Very Likely               | US Total      |         0.87944    |
|         4 | Somewhat Likely           | US Total      |         0.104153   |


Table: MMA Country
|   MMA Country ID | MMA Country   |
|-----------------:|:--------------|
|                1 | US WEST       |
|                2 | US EAST       |
|                3 | JAPAN         |
|                4 | CANADA        |
|                5 | US TOTAL      |
|                6 | EUROPE        |
|                7 | OCEANIA       |


Table: Month
|   Month ID | Month   |
|-----------:|:--------|
|          1 | Jan     |
|          2 | Feb     |
|          3 | Mar     |
|          4 | Apr     |
|          5 | May     |
|          6 | June    |
|          7 | July    |
|          8 | Aug     |
|          9 | Sept    |
|         10 | Oct     |


Table: Overall Island Experience
|   Year ID |   Island ID | Experience   | MMA Country   |   % Experience |
|----------:|------------:|:-------------|:--------------|---------------:|
|         6 |           4 | Poor         | US Total      |              0 |
|         6 |           4 | Poor         | US West       |              0 |
|         3 |           4 | Poor         | US West       |              0 |
|         6 |           4 | Poor         | US East       |              0 |
|         5 |           5 | Poor         | US East       |              0 |
|         4 |           5 | Poor         | US East       |              0 |
|         3 |           4 | Poor         | US East       |              0 |
|         3 |           5 | Poor         | US East       |              0 |
|         2 |           5 | Poor         | US East       |              0 |
|         1 |           5 | Poor         | US East       |              0 |


Table: Overall Rating
| MMA Country   |   Year ID | Overall Rating   |   % Rating |
|:--------------|----------:|:-----------------|-----------:|
| US Total      |         6 | Excellent        | 0.85716    |
| US Total      |         6 | Above average    | 0.126666   |
| US Total      |         6 | Below average    | 0.0130794  |
| US Total      |         6 | Poor             | 0.00309387 |
| US Total      |         5 | Poor             | 0.00181878 |
| US Total      |         5 | Below average    | 0.016597   |
| US Total      |         5 | Above average    | 0.158267   |
| US Total      |         5 | Excellent        | 0.823317   |
| US Total      |         4 | Poor             | 0.00181878 |
| US Total      |         4 | Below average    | 0.016597   |


Table: Primary Purpose of Trip
|   Year ID | PRIMARY PURPOSE                               | MMA Country   |   % Purpose |
|----------:|:----------------------------------------------|:--------------|------------:|
|         6 | Vacation                                      | US Total      |  0.623508   |
|         6 | Visit friends or relatives                    | US Total      |  0.0278038  |
|         6 | Anniversary/ birthday                         | US Total      |  0.10233    |
|         6 | Attend/ participate in a wedding              | US Total      |  0.0232545  |
|         6 | Attend a business meeting or conduct business | US Total      |  0.00206474 |
|         6 | Honeymoon                                     | US Total      |  0.0290722  |
|         6 | Attend a convention, conference or seminar    | US Total      |  0.021734   |
|         6 | Family Gathering/ Reunion/ Funeral            | US Total      |  0.0331033  |
|         6 | Attend/ participate in a sporting event       | US Total      |  0.0410104  |
|         6 | Incentive/ reward                             | US Total      |  0.00919984 |


Table: Purpose of Trip
|         Visitors |   Year ID |   Country ID | PURPOSE OF TRIP    |
|-----------------:|----------:|-------------:|:-------------------|
| 108615           |         5 |            1 | Honeymoon          |
|  34447.6         |         5 |            1 | Get Married        |
|      2.82041e+06 |         5 |            1 | Pleasure/Vacation  |
|  90947.7         |         5 |            1 | Conventions        |
|  37329.1         |         5 |            1 | Corporate Meetings |
|  25785.1         |         5 |            1 | Incentive          |
| 149403           |         5 |            1 | Other Business     |
| 393141           |         5 |            1 | Visit Friends/Rel. |
|  32398           |         5 |            1 | Gov't/Military     |
|   8947.22        |         5 |            1 | Attend School      |


Table: Reasons for not revisiting
|   Year ID | Reasons for not revisiting                                                    | MMA Country   |   % Not Returning |
|----------:|:------------------------------------------------------------------------------|:--------------|------------------:|
|         3 | Severe weather / natural calamities / windy / vog                             | US Total      |                 0 |
|         3 | Crime / robbed                                                                | US Total      |                 0 |
|         3 | Food was awful / poor                                                         | US Total      |                 0 |
|         3 | Too expensive / no money                                                      | US Total      |                 0 |
|         3 | No time / no vacation / starting new business / new job                       | US Total      |                 0 |
|         3 | Waikiki has changed                                                           | US Total      |                 0 |
|         3 | Hawaii is not the same as it was in the past                                  | US Total      |                 0 |
|         3 | Too many Japanese / caters too much to Japanese / felt like a foreign country | US Total      |                 0 |
|         3 | Too many homeless                                                             | US Total      |                 0 |
|         3 | Will come back but not for many years                                         | US Total      |                 0 |


Table: Report Content
| Dashboard                  | Key Questions                                                 | Period    | KPIs/Measures                               | View/Filter By   |   Sr No |
|:---------------------------|:--------------------------------------------------------------|:----------|:--------------------------------------------|:-----------------|--------:|
| Visitors Trend Over Time   | Which country most visitors to Hawaii come from?              | 2010-2015 | Total No of Visitors                        | Year             |       1 |
| Visitors Trend Over Time   | Which islands do visitors go to on their Hawaii Trip ?        |           | Visitors Accomodation Preferences           | Country          |       1 |
| Visitors Trend Over Time   | What type of accomodation people stay in when in Hawaii ?     |           | Number of Group Tour and Solo Visitors      |                  |       1 |
| Visitors Trend Over Time   | What is visitors tour details and travel status over time?    |           | Number of Package and No Package Visitors   |                  |       1 |
| Visitors Trend Over Time   | What is the main reason people come to Hawaii ?               |           | Number of First Timer and Repeater Visitors |                  |       1 |
| Island Visitors by Country | Which islands are most popular over time ?                    | 2010-2015 | Total No of Visitors                        | Year             |       2 |
| Island Visitors by Country | Which countries do visitors from specific islands come from ? |           |                                             | Hawaii Islands   |       2 |
| Visitors Preferences       | What is the main reason people come to Hawaii ?               | 2010-2015 | Purpose of Trip                             | MMA Country      |       3 |
| Visitors Preferences       | What is the gender distribution visting to Hawaii ?           |           | Gender Distribution                         |                  |       3 |
| Visitors Preferences       | What is the lifestage of the people visiting Hawaii ?         |           | Lifestage                                   |                  |       3 |


Table: Time
| Name                | Item                | Kind   | Hidden   |
|:--------------------|:--------------------|:-------|:---------|
| Year                | Year                | Sheet  | False    |
| Month               | Month               | Sheet  | False    |
| Islands             | Islands             | Sheet  | False    |
| Country             | Country             | Sheet  | False    |
| Arrivals by Country | Arrivals by Country | Sheet  | False    |
| Length of Stay      | Length of Stay      | Sheet  | False    |
| Accomodations       | Accomodations       | Sheet  | False    |
| Purpose of Trip     | Purpose of Trip     | Sheet  | False    |
| Travel Status       | Travel Status       | Sheet  | False    |
| Exp by Island       | Exp by Island       | Sheet  | False    |


Table: Travel Status
|   Year ID |   Country ID |      Group Tour |        Non-Group |      Package Trip |       No Package |   % First Timers |   % Repeaters |
|----------:|-------------:|----------------:|-----------------:|------------------:|-----------------:|-----------------:|--------------:|
|         5 |            1 |        64081.1  |      3.44357e+06 |  640889           |      2.86676e+06 |         0.187317 |      0.812683 |
|         5 |            2 |        81158.9  |      1.72251e+06 |  379904           |      1.42377e+06 |         0.410218 |      0.589782 |
|         5 |            3 |       349244    |      1.13306e+06 |       1.01433e+06 | 467974           |         0.39636  |      0.60364  |
|         5 |            4 |        11935.2  | 500388           |  103318           | 409006           |         0.371382 |      0.628618 |
|         5 |            5 |         7715.49 | 391903           |  156783           | 242836           |         0.543548 |      0.456452 |
|         5 |            6 |         7715.49 | 391903           |  156783           | 242836           |         0.543548 |      0.456452 |
|         5 |            7 |         7715.49 | 391903           |  156783           | 242836           |         0.543548 |      0.456452 |
|         5 |            8 |         7715.49 | 391903           |  156783           | 242836           |         0.543548 |      0.456452 |
|         5 |            9 |         7715.49 | 391903           |  156783           | 242836           |         0.543548 |      0.456452 |
|         5 |           10 |         6131.56 | 329710           |  132981           | 202861           |         0.550729 |      0.449271 |


Table: Visitation Status
|   Year ID | Visitation Status   | MMA Country   |   % Visitation Status |
|----------:|:--------------------|:--------------|----------------------:|
|         6 | First timers        | US TOTAL      |              0.262849 |
|         6 | Repeat visitors     | US TOTAL      |              0.737151 |
|         5 | First timers        | US TOTAL      |              0.265431 |
|         5 | Repeat visitors     | US TOTAL      |              0.734569 |
|         4 | First timers        | US TOTAL      |              0.265431 |
|         4 | Repeat visitors     | US TOTAL      |              0.734569 |
|         3 | First timers        | US TOTAL      |              0.290742 |
|         3 | Repeat visitors     | US TOTAL      |              0.709258 |
|         2 | First timers        | US TOTAL      |              0.290742 |
|         2 | Repeat visitors     | US TOTAL      |              0.709258 |


Table: Worst Feature
|   Year ID | Worst Feature                | MMA Country   |   Feedback |
|----------:|:-----------------------------|:--------------|-----------:|
|         6 | Language barriers            | US West       |          0 |
|         6 | Parking                      | US West       |          0 |
|         6 | Tour guide/ Travel package   | US West       |          0 |
|         6 | Health concern- dengue/ zika | US West       |          0 |
|         6 | Lack of nightlife            | US West       |          0 |
|         6 | Volcano                      | US West       |          0 |
|         6 | Elderly/ Handicap access     | US West       |          0 |
|         6 | No negative                  | US West       |          0 |
|         6 | Language barriers            | US East       |          0 |
|         6 | Parking                      | US East       |          0 |


Table: Year
|   Year ID |   Year |
|----------:|-------:|
|         1 |   2010 |
|         2 |   2011 |
|         3 |   2012 |
|         4 |   2013 |
|         5 |   2014 |
|         6 |   2015 |

 


tables: name: Accomodations
data: Accomodations.csv
name: Age
data: Age.csv
name: Arrivals by Country
data: Arrivals by Country.csv
name: Best Feature
data: Best Feature.csv
name: Country
data: Country.csv
name: Exp by Island
data: Exp by Island.csv
name: Gender
data: Gender.csv
name: Islands Visitation
data: Islands Visitation.csv
name: Islands
data: Islands.csv
name: Length of Stay
data: Length of Stay.csv
name: LifeStyle
data: LifeStyle.csv
name: Likelihood to Recommend
data: Likelihood to Recommend.csv
name: MMA Country
data: MMA Country.csv
name: Month
data: Month.csv
name: Overall Island Experience
data: Overall Island Experience.csv
name: Overall Rating
data: Overall Rating.csv
name: Primary Purpose of Trip
data: Primary Purpose of Trip.csv
name: Purpose of Trip
data: Purpose of Trip.csv
name: Reasons for not revisiting
data: Reasons for not revisiting.csv
name: Report Content
data: Report Content.csv
name: Time
data: Time.csv
name: Travel Status
data: Travel Status.csv
name: Visitation Status
data: Visitation Status.csv
name: Worst Feature
data: Worst Feature.csv
name: Year
data: Year.csv
label: Accomodations
Country ID
Country
Country ID
Arrivals by Country
Country ID
Country
Country ID
Length of Stay
Country ID
Country
Country ID
Travel Status
Country ID
Country
Country ID
Exp by Island
Month ID
Month
Month ID
Worst Feature
Year ID
Year
Year ID
Reasons for not revisiting
Year ID
Year
Year ID
Purpose of Trip
Year ID
Year
Year ID
Primary Purpose of Trip
Year ID
Year
Year ID
Overall Island Experience
Year ID
Year
Year ID
Likelihood to Recommend
Year ID
Year
Year ID
Islands Visitation
Year ID
Year
Year ID
Overall Island Experience
Island ID
Islands
Island ID
Length of Stay
Year ID
Year
Year ID
Travel Status
Year ID
Year
Year ID
Accomodations
Year ID
Year
Year ID
Arrivals by Country
Year ID
Year
Year ID
Arrivals by Country
Island ID
Islands
Island ID
Best Feature
Year ID
Year
Year ID
Purpose of Trip
Country ID
Country
Country ID
Exp by Island
Year ID
Year
Year ID
Exp by Island
Island ID
Islands
Island ID
LifeStyle
Year ID
Year
Year ID
Visitation Status
Year ID
Year
Year ID
Gender
Year ID
Year
Year ID
Age
Year ID
Year
Year ID
Best Feature
MMA Country
MMA Country
MMA Country
Islands Visitation
MMA Country
MMA Country
MMA Country
Likelihood to Recommend
MMA Country
MMA Country
MMA Country
Overall Island Experience
MMA Country
MMA Country
MMA Country
Primary Purpose of Trip
MMA Country
MMA Country
MMA Country
Reasons for not revisiting
MMA Country
MMA Country
MMA Country
Worst Feature
MMA Country
MMA Country
MMA Country
LifeStyle
MMA Country
MMA Country
MMA Country
Visitation Status
MMA Country
MMA Country
MMA Country
Gender
MMA Country
MMA Country
MMA Country
Age
MMA Country
MMA Country
MMA Country
Overall Rating
Year ID
Year
Year ID
Overall Rating
MMA Country
MMA Country
MMA Country
output: {
    "joins": [
        {
            "from_table": "Accomodations",
            "from_column": "Country ID",
            "to_table": "Country",
            "to_column": "Country ID"
        },
        {
            "from_table": "Arrivals by Country",
            "from_column": "Country ID",
            "to_table": "Country",
            "to_column": "Country ID"
        },
        {
            "from_table": "Length of Stay",
            "from_column": "Country ID",
            "to_table": "Country",
            "to_column": "Country ID"
        },
        {
            "from_table": "Travel Status",
            "from_column": "Country ID",
            "to_table": "Country",
            "to_column": "Country ID"
        },
        {
            "from_table": "Exp by Island",
            "from_column": "Month ID",
            "to_table": "Month",
            "to_column": "Month ID"
        },
        {
            "from_table": "Worst Feature",
            "from_column": "Year ID",
            "to_table": "Year",
            "to_column": "Year ID"
        },
        {
            "from_table": "Reasons for not revisiting",
            "from_column": "Year ID",
            "to_table": "Year",
            "to_column": "Year ID"
        },
        {
            "from_table": "Purpose of Trip",
            "from_column": "Year ID",
            "to_table": "Year",
            "to_column": "Year ID"
        },
        {
            "from_table": "Primary Purpose of Trip",
            "from_column": "Year ID",
            "to_table": "Year",
            "to_column": "Year ID"
        },
        {
            "from_table": "Overall Island Experience",
            "from_column": "Year ID",
            "to_table": "Year",
            "to_column": "Year ID"
        },
        {
            "from_table": "Likelihood to Recommend",
            "from_column": "Year ID",
            "to_table": "Year",
            "to_column": "Year ID"
        },
        {
            "from_table": "Islands Visitation",
            "from_column": "Year ID",
            "to_table": "Year",
            "to_column": "Year ID"
        },
        {
            "from_table": "Overall Island Experience",
            "from_column": "Island ID",
            "to_table": "Islands",
            "to_column": "Island ID"
        },
        {
            "from_table": "Length of Stay",
            "from_column": "Year ID",
            "to_table": "Year",
            "to_column": "Year ID"
        },
        {
            "from_table": "Travel Status",
            "from_column": "Year ID",
            "to_table": "Year",
            "to_column": "Year ID"
        },
        {
            "from_table": "Accomodations",
            "from_column": "Year ID",
            "to_table": "Year",
            "to_column": "Year ID"
        },
        {
            "from_table": "Arrivals by Country",
            "from_column": "Year ID",
            "to_table": "Year",
            "to_column": "Year ID"
        },
        {
            "from_table": "Arrivals by Country",
            "from_column": "Island ID",
            "to_table": "Islands",
            "to_column": "Island ID"
        },
        {
            "from_table": "Best Feature",
            "from_column": "Year ID",
            "to_table": "Year",
            "to_column": "Year ID"
        },
        {
            "from_table": "Purpose of Trip",
            "from_column": "Country ID",
            "to_table": "Country",
            "to_column": "Country ID"
        },
        {
            "from_table": "Exp by Island",
            "from_column": "Year ID",
            "to_table": "Year",
            "to_column": "Year ID"
        },
        {
            "from_table": "Exp by Island",
            "from_column": "Island ID",
            "to_table": "Islands",
            "to_column": "Island ID"
        },
        {
            "from_table": "LifeStyle",
            "from_column": "Year ID",
            "to_table": "Year",
            "to_column": "Year ID"
        },
        {
            "from_table": "Visitation Status",
            "from_column": "Year ID",
            "to_table": "Year",
            "to_column": "Year ID"
        },
        {
            "from_table": "Gender",
            "from_column": "Year ID",
            "to_table": "Year",
            "to_column": "Year ID"
        },
        {
            "from_table": "Age",
            "from_column": "Year ID",
            "to_table": "Year",
            "to_column": "Year ID"
        },
        {
            "from_table": "Best Feature",
            "from_column": "MMA Country",
            "to_table": "MMA Country",
            "to_column": "MMA Country"
        },
        {
            "from_table": "Islands Visitation",
            "from_column": "MMA Country",
            "to_table": "MMA Country",
            "to_column": "MMA Country"
        },
        {
            "from_table": "Likelihood to Recommend",
            "from_column": "MMA Country",
            "to_table": "MMA Country",
            "to_column": "MMA Country"
        },
        {
            "from_table": "Overall Island Experience",
            "from_column": "MMA Country",
            "to_table": "MMA Country",
            "to_column": "MMA Country"
        },
        {
            "from_table": "Primary Purpose of Trip",
            "from_column": "MMA Country",
            "to_table": "MMA Country",
            "to_column": "MMA Country"
        },
        {
            "from_table": "Reasons for not revisiting",
            "from_column": "MMA Country",
            "to_table": "MMA Country",
            "to_column": "MMA Country"
        },
        {
            "from_table": "Worst Feature",
            "from_column": "MMA Country",
            "to_table": "MMA Country",
            "to_column": "MMA Country"
        },
        {
            "from_table": "LifeStyle",
            "from_column": "MMA Country",
            "to_table": "MMA Country",
            "to_column": "MMA Country"
        },
        {
            "from_table": "Visitation Status",
            "from_column": "MMA Country",
            "to_table": "MMA Country",
            "to_column": "MMA Country"
        },
        {
            "from_table": "Gender",
            "from_column": "MMA Country",
            "to_table": "MMA Country",
            "to_column": "MMA Country"
        },
        {
            "from_table": "Age",
            "from_column": "MMA Country",
            "to_table": "MMA Country",
            "to_column": "MMA Country"
        },
        {
            "from_table": "Overall Rating",
            "from_column": "Year ID",
            "to_table": "Year",
            "to_column": "Year ID"
        },
        {
            "from_table": "Overall Rating",
            "from_column": "MMA Country",
            "to_table": "MMA Country",
            "to_column": "MMA Country"
        }
    ]
}