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: p2-2010-pawdacity-monthly-sales-p2-2010-pawdacity-monthly-sales (2)
|   Sale |   2010Census |   HouseholdUnder18 |   LandArea |   PopDensity |   TotalFamilies | CITY         |
|-------:|-------------:|-------------------:|-----------:|-------------:|----------------:|:-------------|
| 543132 |        29087 |               4052 |    2748.85 |         5.8  |         7189.43 | Gillette     |
| 208008 |         6120 |                832 |    1829.47 |         1.46 |         1744.08 | Douglas      |
| 303264 |        10615 |               2680 |    4796.86 |         2.34 |         5556.49 | Riverton     |
| 185328 |         4585 |                746 |    3115.51 |         1.55 |         1819.5  | Buffalo      |
| 917892 |        59466 |               7158 |    1500.18 |        20.34 |        14612.6  | Cheyenne     |
| 317736 |        35316 |               7788 |    3894.31 |        11.16 |         8756.32 | Casper       |
| 218376 |         9520 |               1403 |    2998.96 |         1.82 |         3515.62 | Cody         |
| 233928 |         6314 |               1251 |    2673.57 |         1.62 |         3134.18 | Powell       |
| 308232 |        17444 |               2646 |    1893.98 |         8.98 |         6039.71 | Sheridan     |
| 253584 |        23036 |               4022 |    6620.2  |         2.78 |         7572.18 | Rock Springs |


Table: p2-2010-pawdacity-monthly-sales-p2-2010-pawdacity-monthly-sales (3)
| City1   | Month     |   Value |
|:--------|:----------|--------:|
| Buffalo | January   |   16200 |
| Buffalo | February  |   13392 |
| Buffalo | March     |   14688 |
| Buffalo | April     |   17064 |
| Buffalo | May       |   18360 |
| Buffalo | June      |   14040 |
| Buffalo | July      |   12960 |
| Buffalo | August    |   19224 |
| Buffalo | September |   15984 |
| Buffalo | October   |   13392 |


Table: p2-2010-pawdacity-monthly-sales-p2-2010-pawdacity-monthly-sales
| NAME      | ADDRESS         | CITY    | STATE   |   ZIP | Month     |   Value | City1   |
|:----------|:----------------|:--------|:--------|------:|:----------|--------:|:--------|
| Pawdacity | 509 Fort St # A | Buffalo | WY      | 82834 | January   |   16200 | Buffalo |
| Pawdacity | 509 Fort St # A | Buffalo | WY      | 82834 | February  |   13392 | Buffalo |
| Pawdacity | 509 Fort St # A | Buffalo | WY      | 82834 | March     |   14688 | Buffalo |
| Pawdacity | 509 Fort St # A | Buffalo | WY      | 82834 | April     |   17064 | Buffalo |
| Pawdacity | 509 Fort St # A | Buffalo | WY      | 82834 | May       |   18360 | Buffalo |
| Pawdacity | 509 Fort St # A | Buffalo | WY      | 82834 | June      |   14040 | Buffalo |
| Pawdacity | 509 Fort St # A | Buffalo | WY      | 82834 | July      |   12960 | Buffalo |
| Pawdacity | 509 Fort St # A | Buffalo | WY      | 82834 | August    |   19224 | Buffalo |
| Pawdacity | 509 Fort St # A | Buffalo | WY      | 82834 | September |   15984 | Buffalo |
| Pawdacity | 509 Fort St # A | Buffalo | WY      | 82834 | October   |   13392 | Buffalo |


Table: p2-partially-parsed-wy-web-scrape (2)
|   2014Estimate |   2010Census |   2000Census | City1      |
|---------------:|-------------:|-------------:|:-----------|
|           1968 |         1911 |         1818 | Afton      |
|            185 |          181 |          120 | Albin      |
|            845 |          828 |          550 | Alpine     |
|            439 |          440 |          348 | Baggs      |
|            107 |          106 |           97 | Bairoil    |
|           2735 |         2213 |          936 | Bar Nunn   |
|           1312 |         1285 |         1238 | Basin      |
|            538 |          552 |          408 | Big Piney  |
|           4615 |         4585 |         3900 | Buffalo    |
|            332 |          288 |          250 | Burlington |


Table: p2-partially-parsed-wy-web-scrape
| City       | County     |   2014 Estimate |   2010 Census |   2000 Census |
|:-----------|:-----------|----------------:|--------------:|--------------:|
| Afton      | Lincoln    |            1968 |          1911 |          1818 |
| Albin      | Laramie    |             185 |           181 |           120 |
| Alpine     | Lincoln    |             845 |           828 |           550 |
| Baggs      | Carbon     |             439 |           440 |           348 |
| Bairoil    | Sweetwater |             107 |           106 |            97 |
| Bar Nunn   | Natrona    |            2735 |          2213 |           936 |
| Basin      | Big Horn   |            1312 |          1285 |          1238 |
| Big Piney  | Sublette   |             538 |           552 |           408 |
| Buffalo    | Johnson    |            4615 |          4585 |          3900 |
| Burlington | Big Horn   |             332 |           288 |           250 |


Table: p2-wy-453910-naics-data
| BUSINESS NAME                 | PHYSICAL CITY NAME   |   SALES VOLUME | City       | State   | ZipCode    |
|:------------------------------|:---------------------|---------------:|:-----------|:--------|:-----------|
| Mile High Mobile Pet LLC      | Cheyenne             |         300000 | Cheyenne   | WY      | 82007-3528 |
| Pets City Inc                 | Cheyenne             |         640000 | Cheyenne   | WY      | 82009-4851 |
| Petco Animal Sups Stores Inc  | Cheyenne             |              0 | Cheyenne   | WY      | 82009-4945 |
| Pet-A-Care                    | Cheyenne             |          81000 | Cheyenne   | WY      | 82009-1009 |
| Muddy Paws Pet Salon          | Laramie              |          76000 | Laramie    | WY      | 82070-8979 |
| Prossers Feed and Seed L L C  | Wheatland            |          77000 | Wheatland  | WY      | 82201-2901 |
| Pet Pals Inc of Goshen County | Torrington           |         126991 | Torrington | WY      | 82240-3516 |
| Don Bruner Sales LLC          | Torrington           |         750000 | Torrington | WY      | 82240-3516 |
| Pals For Pets Inc             | Saratoga             |          83000 | Saratoga   | WY      | 82331      |
| Pet Barn                      | Worland              |          69000 | Worland    | WY      | 82401-2715 |


Table: p2-wy-demographic-data (2)
|   HouseholdUnder18 |   LandArea |   PopDensity |   TotalFamilies | City1      |
|-------------------:|-----------:|-------------:|----------------:|:-----------|
|               2075 |  2513.75   |         5.19 |         4668.93 | Laramie    |
|                165 |   200.444  |         0.41 |          372.3  | Rock River |
|                250 |   543.951  |         0.66 |          566.43 | Basin      |
|                 63 |   137.646  |         0.17 |          143.34 | Burlington |
|                116 |   252.49   |         0.31 |          262.93 | Byron      |
|                137 |   297.681  |         0.36 |          309.98 | Cowley     |
|                 35 |    76.2859 |         0.09 |           79.44 | Deaver     |
|                318 |   691.226  |         0.84 |          719.8  | Greybull   |
|                372 |   809.454  |         0.98 |          842.91 | Lovell     |
|                 22 |    48.5079 |         0.06 |           50.51 | Manderson  |


Table: p2-wy-demographic-data
| City       | County   |   Land Area |   Households with Under 18 |   Population Density |   Total Families |
|:-----------|:---------|------------:|---------------------------:|---------------------:|-----------------:|
| Laramie    | Albany   |   2513.75   |                       2075 |                 5.19 |          4668.93 |
| Rock River | Albany   |    200.444  |                        165 |                 0.41 |           372.3  |
| Basin      | Big Horn |    543.951  |                        250 |                 0.66 |           566.43 |
| Burlington | Big Horn |    137.646  |                         63 |                 0.17 |           143.34 |
| Byron      | Big Horn |    252.49   |                        116 |                 0.31 |           262.93 |
| Cowley     | Big Horn |    297.681  |                        137 |                 0.36 |           309.98 |
| Deaver     | Big Horn |     76.2859 |                         35 |                 0.09 |            79.44 |
| Greybull   | Big Horn |    691.226  |                        318 |                 0.84 |           719.8  |
| Lovell     | Big Horn |    809.454  |                        372 |                 0.98 |           842.91 |
| Manderson  | Big Horn |     48.5079 |                         22 |                 0.06 |            50.51 |

 


tables: name: p2-2010-pawdacity-monthly-sales-p2-2010-pawdacity-monthly-sales (2)
data: p2-2010-pawdacity-monthly-sales-p2-2010-pawdacity-monthly-sales (2).csv
name: p2-2010-pawdacity-monthly-sales-p2-2010-pawdacity-monthly-sales (3)
data: p2-2010-pawdacity-monthly-sales-p2-2010-pawdacity-monthly-sales (3).csv
name: p2-2010-pawdacity-monthly-sales-p2-2010-pawdacity-monthly-sales
data: p2-2010-pawdacity-monthly-sales-p2-2010-pawdacity-monthly-sales.csv
name: p2-partially-parsed-wy-web-scrape (2)
data: p2-partially-parsed-wy-web-scrape (2).csv
name: p2-partially-parsed-wy-web-scrape
data: p2-partially-parsed-wy-web-scrape.csv
name: p2-wy-453910-naics-data
data: p2-wy-453910-naics-data.csv
name: p2-wy-demographic-data (2)
data: p2-wy-demographic-data (2).csv
name: p2-wy-demographic-data
data: p2-wy-demographic-data.csv
label: p2-2010-pawdacity-monthly-sales-p2-2010-pawdacity-monthly-sales
CITY
p2-wy-demographic-data
City
p2-partially-parsed-wy-web-scrape
City
p2-wy-demographic-data
City
p2-wy-453910-naics-data
City
p2-wy-demographic-data
City
p2-2010-pawdacity-monthly-sales-p2-2010-pawdacity-monthly-sales (2)
LandArea
p2-wy-demographic-data
Land Area
p2-partially-parsed-wy-web-scrape (2)
City1
p2-wy-demographic-data (2)
City1
p2-2010-pawdacity-monthly-sales-p2-2010-pawdacity-monthly-sales
City1
p2-wy-demographic-data (2)
City1
p2-2010-pawdacity-monthly-sales-p2-2010-pawdacity-monthly-sales (3)
City1
p2-wy-demographic-data (2)
City1
output: {
    "joins": [
        {
            "from_table": "p2-2010-pawdacity-monthly-sales-p2-2010-pawdacity-monthly-sales",
            "from_column": "CITY",
            "to_table": "p2-wy-demographic-data",
            "to_column": "City"
        },
        {
            "from_table": "p2-partially-parsed-wy-web-scrape",
            "from_column": "City",
            "to_table": "p2-wy-demographic-data",
            "to_column": "City"
        },
        {
            "from_table": "p2-wy-453910-naics-data",
            "from_column": "City",
            "to_table": "p2-wy-demographic-data",
            "to_column": "City"
        },
        {
            "from_table": "p2-2010-pawdacity-monthly-sales-p2-2010-pawdacity-monthly-sales (2)",
            "from_column": "LandArea",
            "to_table": "p2-wy-demographic-data",
            "to_column": "Land Area"
        },
        {
            "from_table": "p2-partially-parsed-wy-web-scrape (2)",
            "from_column": "City1",
            "to_table": "p2-wy-demographic-data (2)",
            "to_column": "City1"
        },
        {
            "from_table": "p2-2010-pawdacity-monthly-sales-p2-2010-pawdacity-monthly-sales",
            "from_column": "City1",
            "to_table": "p2-wy-demographic-data (2)",
            "to_column": "City1"
        },
        {
            "from_table": "p2-2010-pawdacity-monthly-sales-p2-2010-pawdacity-monthly-sales (3)",
            "from_column": "City1",
            "to_table": "p2-wy-demographic-data (2)",
            "to_column": "City1"
        }
    ]
}