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: AgeGroups
| AgeGroup   |   Min |   Max |   Position |
|:-----------|------:|------:|-----------:|
| 0-20       |     0 |    20 |          1 |
| 21-30      |    20 |    30 |          2 |
| 31-40      |    30 |    40 |          3 |
| 41-50      |    40 |    50 |          4 |
| 51-60      |    50 |    60 |          5 |
| 61-70      |    60 |    70 |          6 |
| 71-80      |    70 |    80 |          7 |
| 81-90      |    80 |    90 |          8 |
| 91+        |    90 |   200 |          9 |


Table: Alcohol_Service_Dim
|   Alcohol_Service_ID | Alcohol Service   |
|---------------------:|:------------------|
|                    1 | None              |
|                    2 | Full Bar          |
|                    3 | Wine & Beer       |


Table: Area_Dim
|   Area_ID | Area   |
|----------:|:-------|
|         1 | Open   |
|         2 | Closed |


Table: Budget_Dim
|   Budzet_ID | Budget   |
|------------:|:---------|
|           1 | Medium   |
|           2 | Low      |
|           3 | N/A      |
|           4 | High     |


Table: Children_Dim
|   ChildrenID | Children    |
|-------------:|:------------|
|            1 | Independent |
|            2 | Kids        |
|            3 | N/A         |
|            4 | Dependent   |


Table: consumers
| Consumer_ID   | City            | State           | Country   |   Latitude |   Longitude | Smoker   |   Age |   Drink_Level_ID |   Transportation_Method_ID |   Marital_Status_ID |   Occupation_ID |   Budzet_ID |   ChildrenID | AgeGroup   | Age (groups)   |
|:--------------|:----------------|:----------------|:----------|-----------:|------------:|:---------|------:|-----------------:|---------------------------:|--------------------:|----------------:|------------:|-------------:|:-----------|:---------------|
| U1001         | San Luis Potosi | San Luis Potosi | Mexico    |    22.14   |   -100.979  | No       |    23 |                1 |                          1 |                   1 |               1 |           1 |            1 | 21-30      | 21-30          |
| U1005         | San Luis Potosi | San Luis Potosi | Mexico    |    22.1835 |   -100.96   | No       |    20 |                1 |                          2 |                   1 |               1 |           1 |            1 | 21-30      | 0-20           |
| U1002         | San Luis Potosi | San Luis Potosi | Mexico    |    22.1501 |   -100.983  | No       |    22 |                1 |                          2 |                   1 |               1 |           2 |            1 | 21-30      | 21-30          |
| U1003         | San Luis Potosi | San Luis Potosi | Mexico    |    22.1198 |   -100.947  | No       |    23 |                2 |                          2 |                   1 |               1 |           2 |            1 | 21-30      | 21-30          |
| U1007         | San Luis Potosi | San Luis Potosi | Mexico    |    22.1185 |   -100.938  | No       |    23 |                3 |                          2 |                   1 |               1 |           2 |            1 | 21-30      | 21-30          |
| U1008         | San Luis Potosi | San Luis Potosi | Mexico    |    22.123  |   -100.924  | No       |    23 |                2 |                          2 |                   1 |               1 |           2 |            1 | 21-30      | 21-30          |
| U1011         | Ciudad Victoria | Tamaulipas      | Mexico    |    23.725  |    -99.1529 | No       |    23 |                1 |                          2 |                   1 |               1 |           1 |            1 | 21-30      | 21-30          |
| U1012         | Cuernavaca      | Morelos         | Mexico    |    18.8133 |    -99.2437 | No       |    24 |                3 |                          2 |                   1 |               1 |           1 |            1 | 21-30      | 21-30          |
| U1014         | Ciudad Victoria | Tamaulipas      | Mexico    |    23.7516 |    -99.1701 | No       |    22 |                1 |                          2 |                   1 |               1 |           1 |            1 | 21-30      | 21-30          |
| U1016         | San Luis Potosi | San Luis Potosi | Mexico    |    22.1562 |   -100.977  | No       |    21 |                3 |                          1 |                   1 |               1 |           1 |            1 | 21-30      | 21-30          |


Table: consumer_preferences
| Consumer_ID   |   Preferred_CuisineID |
|:--------------|----------------------:|
| U1135         |                    51 |
| U1135         |                    52 |
| U1135         |                    36 |
| U1135         |                    53 |
| U1135         |                    54 |
| U1135         |                    55 |
| U1135         |                    56 |
| U1135         |                    45 |
| U1135         |                    33 |
| U1135         |                    49 |


Table: Cuisines_Dim
|   Cuisine_ID | Cuisine    |
|-------------:|:-----------|
|            1 | Regional   |
|            2 | Cafeteria  |
|            3 | American   |
|            4 | Mexican    |
|            5 | Fast Food  |
|            6 | Italian    |
|            7 | Armenian   |
|            8 | Pizzeria   |
|            9 | Japanese   |
|           10 | Vietnamese |


Table: Drink_Level_Dim
|   Drink_Level_ID | Drink_Level    |
|-----------------:|:---------------|
|                1 | Abstemious     |
|                2 | Social Drinker |
|                3 | Casual Drinker |


Table: Marital_Status_Dim
|   Marital_Status_ID | Marital_Status   |
|--------------------:|:-----------------|
|                   1 | Single           |
|                   2 | Married          |
|                   3 | N/A              |


Table: Occupation_Dim
|   Occupation_ID | Occupation   |
|----------------:|:-------------|
|               1 | Student      |
|               2 | Employed     |
|               3 | N/A          |
|               4 | Unemployed   |


Table: Parking_Dim
|   Parking_ID | Parking   |
|-------------:|:----------|
|            1 | Public    |
|            2 | None      |
|            3 | Yes       |
|            4 | Valet     |


Table: Preferred_Cuisine_Dim
|   Preferred_CuisineID | Preferred Cuisine   |
|----------------------:|:--------------------|
|                     1 | Preferred_Cuisine   |
|                     2 | American            |
|                     3 | Mexican             |
|                     4 | Bakery              |
|                     5 | Breakfast           |
|                     6 | Japanese            |
|                     7 | Contemporary        |
|                     8 | Bagels              |
|                     9 | Coffee Shop         |
|                    10 | Continental         |


Table: ratings
| Consumer_ID   |   Restaurant_ID |   Overall Rating |   Food Rating |   Service Rating |
|:--------------|----------------:|-----------------:|--------------:|-----------------:|
| U1077         |          135085 |                2 |             2 |                2 |
| U1077         |          132825 |                2 |             2 |                2 |
| U1067         |          132584 |                2 |             2 |                2 |
| U1103         |          132613 |                2 |             2 |                2 |
| U1103         |          132733 |                2 |             2 |                2 |
| U1107         |          132584 |                2 |             2 |                2 |
| U1107         |          132733 |                2 |             2 |                2 |
| U1044         |          135088 |                2 |             2 |                2 |
| U1060         |          132564 |                2 |             2 |                2 |
| U1060         |          132717 |                2 |             2 |                2 |


Table: restaurants
|   Restaurant_ID | Name                               | City            | State           | Country   | Zip_Code   |   Latitude |   Longitude | Alcohol_Service   | Smoking Allowed   | Price   | Franchise   |   Area_ID |   Parking_ID |
|----------------:|:-----------------------------------|:----------------|:----------------|:----------|:-----------|-----------:|------------:|:------------------|:------------------|:--------|:------------|----------:|-------------:|
|          132560 | Puesto de Gorditas                 | Ciudad Victoria | Tamaulipas      | Mexico    |            |    23.7523 |    -99.1669 | None              | Yes               | Low     | No          |         1 |            1 |
|          132561 | Cafe Ambar                         | Ciudad Victoria | Tamaulipas      | Mexico    |            |    23.7268 |    -99.1265 | None              | No                | Low     | No          |         2 |            2 |
|          132564 | Church's                           | Ciudad Victoria | Tamaulipas      | Mexico    |            |    23.7309 |    -99.1452 | None              | No                | Low     | No          |         2 |            2 |
|          132572 | Cafe Chaires                       | San Luis Potosi | San Luis Potosi | Mexico    |            |    22.1416 |   -100.993  | None              | No                | Low     | No          |         2 |            3 |
|          132584 | Gorditas Doña Tota                 | Ciudad Victoria | Tamaulipas      | Mexico    |            |    23.7524 |    -99.1653 | None              | No                | Medium  | Yes         |         2 |            3 |
|          132594 | Tacos De Barbacoa Enfrente Del Tec | Ciudad Victoria | Tamaulipas      | Mexico    |            |    23.7522 |    -99.1657 | None              | No                | Low     | No          |         1 |            1 |
|          132608 | Hamburguesas La Perica             | Ciudad Victoria | Tamaulipas      | Mexico    |            |    23.7588 |    -99.1651 | None              | Yes               | Low     | Yes         |         1 |            1 |
|          132609 | Pollo Frito Buenos Aires           | Ciudad Victoria | Tamaulipas      | Mexico    |            |    23.7603 |    -99.1659 | None              | No                | Low     | Yes         |         2 |            3 |
|          132613 | Carnitas Mata                      | Ciudad Victoria | Tamaulipas      | Mexico    |            |    23.7529 |    -99.1651 | None              | Yes               | Medium  | Yes         |         2 |            3 |
|          132626 | La Perica Hamburguesa              | Ciudad Victoria | Tamaulipas      | Mexico    |            |    23.7376 |    -99.1351 | None              | No                | Medium  | Yes         |         2 |            3 |


Table: restaurant_cuisines
|   Restaurant_ID |   Cuisine_ID |
|----------------:|-------------:|
|          132560 |            1 |
|          132572 |            2 |
|          132583 |            3 |
|          132584 |            4 |
|          132594 |            4 |
|          132608 |            4 |
|          132613 |            4 |
|          132630 |            4 |
|          132663 |            4 |
|          132665 |            4 |


Table: Transportation_Method_Dim
|   Transportation_Method_ID | Transportation_Method   | Image Url                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
|---------------------------:|:------------------------|:---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
|                          1 | On Foot                 | data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQEAYAAABPYyMiAAAABGdBTUEAALGPC/xhBQAAACBjSFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAABmJLR0QAAAAAAAD5Q7t/AAAACXBIWXMAAABgAAAAYADwa0LPAAAAB3RJTUUH5QsFCRcBtwZuPQAAA7pJREFUSMetlW1M01cUxs+5LS3bKPVlmI7JwiIoZYJWBT4wsxA0wjYZMpjbWsxaJERCMlSKaxkBYYIEqbgsEhRkYoZbHRhlw8hLlwghxC0FyzAbLCQD1jEVnMCAtf3fs081C/vgP3XPx3OfPPd3cm7ORfBRJZSRTlwmCzA/4O5vq6vXDPwZID3mduMv+COOjI4aJu12xHPnnpTDfAVYPubpXtgRG8suwz7q6unJ+m6wmd0tKIDdVEkR4eFic3wGQOaKF2wjI1wHAJCS0uDUnCKemQnRMAezbrfYHKlYY0pf4cYHe4ODn782W8K2arW0czZeErluHb34lww/nptjufg5wMOH+qv2DLxXVGTIBwD0tb1/Kb6lInbilZyclD2F5umbJpM+WB88uz8kxHte0Z14gGjt2sY9W0/wtPr6JtpCRKtWPfUINhkaq35qUCjQH/LQEBoqieITAO3taEc7bFcqvT7zrp5mxJkZT5qkDVtLS3kSVtDbVVWNdo2KKDnZZwCIdnX7mfV6mIdgVtLUxL/Bk3AtLw/HcIyadTqv7dOk5DDicrkfo0mgxMRlhSscvz56FOPQBODv32jVRPI36+rOno2KIlq9WjQAPge1VL9hA5tj3/PjcjlYMIwClUq6zlz0cn+/1/f3+0vH3SM6HdcIfwAuLMjLZYy2l5VBAdcAqFR4FV3Yfvu2/ArLBIqJEQ1A9ajHG+PjwrNURJeysyGQ34VDk5P+MX4zXGezPQYdRgV9EBgoDZHuABgePqgeSmeDR47gkCQfqK+PeigVYGnJYLtTCNjVJfrxrdRbacbo6dMWy8q6dwQNTs0p/u7589avIq3EZTKxuU/cA69RVdjUmfXrIZQGSO10euuFtn1d81+2tCwbFsfcV9Rq2AY5eNlima+VdQCaTP8bgCAXnqFoo1E24fcIfrt4Masmq2Y2LimJVbNqgNZWLGWvU2F2Nh5e/BBoagrV+B5FBAQ8NcAmQ930+E6tFnPpEa/s7FxcojOuXR4PDLFSSkhNPXmjtTNgf1sbSCmD/e5w4GeKNMCgIOiiOFgUBJ8BgjKs1pF0lQrC8TTnUVG9teZfX7rZ0SHdLWyUOcvLeYTnI9k7xcUAAIhEYi8SDYAJbhcmbN4Mb/BkbHY4XrVVlk39YDTSJOdw2GptKmoqUmy7f/+x/wBeogUini6sAWKM/wxfgARFL+H/ANzLHdWqc2026IM2cMjldIGUdGJw8HpNzcEXBm7dWukX7ghbqL+3F5fhEzpUXIwc8yFQKvqP+QccR5gKO2qp3wAAACV0RVh0ZGF0ZTpjcmVhdGUAMjAyMS0xMS0wNVQwOToyMzowMSswMDowMEHRZ6QAAAAldEVYdGRhdGU6bW9kaWZ5ADIwMjEtMTEtMDVUMDk6MjM6MDErMDA6MDAwjN8YAAAAAElFTkSuQmCC |
|                          2 | Public                  | data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQEAYAAABPYyMiAAAABGdBTUEAALGPC/xhBQAAACBjSFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAABmJLR0QAAAAAAAD5Q7t/AAAACXBIWXMAAABgAAAAYADwa0LPAAAAB3RJTUUH5QsFCREUjIEtUAAAA2pJREFUSMe1lFtsU3Ucx7+/cyaFQM9a2LJIkJSwKF1nzNZpcJ5Nl17O1ExhOuO0GiaJLpkUMGykhj0sEBm4By+BjEgCD8wMqU2TKdmp0F1KOuOAilkR8QUJ7mGZ6y3EsHn288GexjibIcPv6+/y+V3+vz8hK+v4uaJCf0WFMKHdml8bCKAHI1RvseB+aQ+e5sEbN+bLxXXCZGPjj487p1Mvx2IFul34UlvDV7xeDGCE3rJYsI1eQXskghKsx/KjR/kgemi/pt0tj3zYw52iiCD/hl/b2tCDE1Qvy0KDtoZ3er0ApoGWllwBsMPMppUrMQAQAP4ar+Ltvr6rw+5j6ZL+fgDKf+r4TQDtgO2m+px00mzGswAgyzlOVgV5E/TyJIvd3WXm0HvGrW43jXIU8t1PgGupGhdEkUf4Ya5xOAh/NbZgUqWfnL0OGAyGHeL7xiZVhYtuU0lx8fIZ2i2eqq6+dNnlTiRTqXtd/WM8xIVsMv1hnm3j16NRJDDFc1NTdz7VPsicURTBMF5gN2rBIDJoxnWrFe9wgjfE40sF67pCdZSiZBKf4TLbJyZ0jsEt7pBKAwGBG/gnesrlwgp2oXl2dqnARZXl8A84gSJFEagfVdg8NoZh+hxNRuP/XkCWQ7+QFc9Ho0I8oEymP6qpQRInEQyFmHEET5hM9x28kW5jo9msc+Lt7lS6s7Z2wRWQH33U7HSWfaFeMkZCISK04btkcsngbnbRuw4HmhDl3X6/bl54hnEoSBNRkBRsrqrCVt6Hb2MxMG7Sx3V1uj0v0AYVEjNkhLkrHOZH2QLZbic9rgnRv7sL+fJwNV6iGZ8vflrZlWl3ODCGTn5jeHjRjgnreefQUNyrfJ/Z7nQKHfwiXfP58rnn/YhoNQ/goMdT/sLgcekC0bwHp/nBykrqwgYcyc/nLpxHS2Vl+e+Dx6UnW1t5nH7GMY8Hq/HQv9ebVdnsoCalDx2iCjqHdR0d97zzRcQxduLW4cNXl9WLaWnv3twEtNY7NQ8MHTgghg3n58KlpbSCzvJ2Wc79D/qZZl9xXoIJ27DF7cYz/BrOZDIYQxK9BgM/gmLyRyI6J2+87atvtqzaZ7WWXVMbjNOJhM2mqpLEbPswVCjtHx1drENbo7pW2hWJ5OKWhYqMczMz5RfV3lUXN236p/+fTI1rdAVByloAAAAldEVYdGRhdGU6Y3JlYXRlADIwMjEtMTEtMDVUMDk6MTc6MTkrMDA6MDAune8mAAAAJXRFWHRkYXRlOm1vZGlmeQAyMDIxLTExLTA1VDA5OjE3OjE5KzAwOjAwX8BXmgAAAABJRU5ErkJggg==                                                                                                         |
|                          3 | Car                     | data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQEAYAAABPYyMiAAAABGdBTUEAALGPC/xhBQAAACBjSFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAABmJLR0QAAAAAAAD5Q7t/AAAACXBIWXMAAABgAAAAYADwa0LPAAAAB3RJTUUH5QsFCRMbLghSQwAAAj5JREFUSMftkUFIU3Ecx7+/txduBcEYJoi89/5DhECGGKtTh4EieHEdhloONtNGEIgIA5FSMRBBpt4KZScVEfE094bMwyBScCC61G0hkxBisttCVOT9OkQdDJlB0cXP9cfv8/3x+wI3/GfoqsHaQ9Eluioqzg+4jutCIboHG2yqim+ww15Wxu+plVpzOTzjMIclCXfpiI4ODsyHilfxDgy4KEEJurj444sWF6t6q3otFj2orWgrkUgkoiiKYrfH1uwt9ha/PxYScREfHr68p0eFJjSPR/8q9sTe8vKPPau1VJ4ce6LElFh9vTEmjUvjjY2UpCIVXS54+YzPZFkqk2qkGo+Hk1zO5S4X0vDDb7VGs1qD1nBy8lPEYDAAekpxilss8rrp2HS8sRGbUVnliQn6ILtl987OaVa2ybZUquVjJpwJF4ukP9ASWiKVwlvyka+2tmRnL3iBF5JJPMcQhmZn+RGlKT05ee0X6xAQzPyKgxwcHSV9STSL5lwOd7CPfU1DF+YwNzVFr+GG22TiPXKQo1BAhRE0gh0dqKcABaqrSwaV8nyiKEVNJgnnqERlJoN5OOFMp2FHHnmHg9/xJm9ms7jP7dze1EQWkkiany8ZfF3PSx7hkUJBPm03po3ptrbbn6VuqdvpNA4BoL//l9CLXewS4TGt0ur2Nm4Zg8ZgIHBlRW+wjvV8nscIhJ6eyx6aNTqNzq0tCstu2T0z85tgZUmYhVlV9S9an9YXCumssso+37U7/sueG27453wHuG8FKXEFhKoAAAAldEVYdGRhdGU6Y3JlYXRlADIwMjEtMTEtMDVUMDk6MTk6MjcrMDA6MDDu5KMrAAAAJXRFWHRkYXRlOm1vZGlmeQAyMDIxLTExLTA1VDA5OjE5OjI3KzAwOjAwn7kblwAAAABJRU5ErkJggg==                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
|                          4 | N/A                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |

 


tables: name: AgeGroups
data: AgeGroups.csv
name: Alcohol_Service_Dim
data: Alcohol_Service_Dim.csv
name: Area_Dim
data: Area_Dim.csv
name: Budget_Dim
data: Budget_Dim.csv
name: Children_Dim
data: Children_Dim.csv
name: consumers
data: consumers.csv
name: consumer_preferences
data: consumer_preferences.csv
name: Cuisines_Dim
data: Cuisines_Dim.csv
name: Drink_Level_Dim
data: Drink_Level_Dim.csv
name: Marital_Status_Dim
data: Marital_Status_Dim.csv
name: Occupation_Dim
data: Occupation_Dim.csv
name: Parking_Dim
data: Parking_Dim.csv
name: Preferred_Cuisine_Dim
data: Preferred_Cuisine_Dim.csv
name: ratings
data: ratings.csv
name: restaurants
data: restaurants.csv
name: restaurant_cuisines
data: restaurant_cuisines.csv
name: Transportation_Method_Dim
data: Transportation_Method_Dim.csv
label: ratings
Restaurant_ID
restaurants
Restaurant_ID
restaurant_cuisines
Restaurant_ID
restaurants
Restaurant_ID
consumers
Drink_Level_ID
Drink_Level_Dim
Drink_Level_ID
consumers
Transportation_Method_ID
Transportation_Method_Dim
Transportation_Method_ID
consumers
Marital_Status_ID
Marital_Status_Dim
Marital_Status_ID
consumers
Occupation_ID
Occupation_Dim
Occupation_ID
consumers
Budzet_ID
Budget_Dim
Budzet_ID
restaurant_cuisines
Cuisine_ID
Cuisines_Dim
Cuisine_ID
restaurants
Alcohol_Service
Alcohol_Service_Dim
Alcohol Service
restaurants
Area_ID
Area_Dim
Area_ID
restaurants
Parking_ID
Parking_Dim
Parking_ID
consumers
ChildrenID
Children_Dim
ChildrenID
consumer_preferences
Consumer_ID
consumers
Consumer_ID
consumer_preferences
Preferred_CuisineID
Preferred_Cuisine_Dim
Preferred_CuisineID
output: {
    "joins": [
        {
            "from_table": "ratings",
            "from_column": "Restaurant_ID",
            "to_table": "restaurants",
            "to_column": "Restaurant_ID"
        },
        {
            "from_table": "restaurant_cuisines",
            "from_column": "Restaurant_ID",
            "to_table": "restaurants",
            "to_column": "Restaurant_ID"
        },
        {
            "from_table": "consumers",
            "from_column": "Drink_Level_ID",
            "to_table": "Drink_Level_Dim",
            "to_column": "Drink_Level_ID"
        },
        {
            "from_table": "consumers",
            "from_column": "Transportation_Method_ID",
            "to_table": "Transportation_Method_Dim",
            "to_column": "Transportation_Method_ID"
        },
        {
            "from_table": "consumers",
            "from_column": "Marital_Status_ID",
            "to_table": "Marital_Status_Dim",
            "to_column": "Marital_Status_ID"
        },
        {
            "from_table": "consumers",
            "from_column": "Occupation_ID",
            "to_table": "Occupation_Dim",
            "to_column": "Occupation_ID"
        },
        {
            "from_table": "consumers",
            "from_column": "Budzet_ID",
            "to_table": "Budget_Dim",
            "to_column": "Budzet_ID"
        },
        {
            "from_table": "restaurant_cuisines",
            "from_column": "Cuisine_ID",
            "to_table": "Cuisines_Dim",
            "to_column": "Cuisine_ID"
        },
        {
            "from_table": "restaurants",
            "from_column": "Alcohol_Service",
            "to_table": "Alcohol_Service_Dim",
            "to_column": "Alcohol Service"
        },
        {
            "from_table": "restaurants",
            "from_column": "Area_ID",
            "to_table": "Area_Dim",
            "to_column": "Area_ID"
        },
        {
            "from_table": "restaurants",
            "from_column": "Parking_ID",
            "to_table": "Parking_Dim",
            "to_column": "Parking_ID"
        },
        {
            "from_table": "consumers",
            "from_column": "ChildrenID",
            "to_table": "Children_Dim",
            "to_column": "ChildrenID"
        },
        {
            "from_table": "consumer_preferences",
            "from_column": "Consumer_ID",
            "to_table": "consumers",
            "to_column": "Consumer_ID"
        },
        {
            "from_table": "consumer_preferences",
            "from_column": "Preferred_CuisineID",
            "to_table": "Preferred_Cuisine_Dim",
            "to_column": "Preferred_CuisineID"
        }
    ]
}