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: SampleStore
| Ship Mode      | Segment   | Country       | City        | State      |   Postal Code | Region   | Category        | Sub-Category   |   Sales |   Quantity |   Discount |   Profit |
|:---------------|:----------|:--------------|:------------|:-----------|--------------:|:---------|:----------------|:---------------|--------:|-----------:|-----------:|---------:|
| Standard Class | Corporate | United States | Los Angeles | California |         90049 | West     | Office Supplies | Storage        |   77.88 |          2 |          0 |   3.894  |
| Standard Class | Consumer  | United States | Los Angeles | California |         90049 | West     | Office Supplies | Art            |    6.63 |          3 |          0 |   1.7901 |
| Standard Class | Consumer  | United States | Los Angeles | California |         90049 | West     | Office Supplies | Art            |    5.88 |          2 |          0 |   1.7052 |
| Second Class   | Consumer  | United States | Los Angeles | California |         90049 | West     | Office Supplies | Art            |    5.46 |          3 |          0 |   1.5288 |
| Second Class   | Consumer  | United States | Los Angeles | California |         90049 | West     | Office Supplies | Art            |   73.2  |          5 |          0 |  21.228  |
| Second Class   | Consumer  | United States | Los Angeles | California |         90049 | West     | Office Supplies | Paper          |   22.72 |          4 |          0 |  10.224  |
| First Class    | Corporate | United States | Los Angeles | California |         90049 | West     | Office Supplies | Paper          |   45.36 |          7 |          0 |  21.7728 |
| Standard Class | Corporate | United States | Los Angeles | California |         90049 | West     | Office Supplies | Fasteners      |   11.34 |          3 |          0 |   5.2164 |
| Standard Class | Corporate | United States | Los Angeles | California |         90049 | West     | Office Supplies | Storage        |   80.3  |          5 |          0 |  20.878  |
| Standard Class | Corporate | United States | Los Angeles | California |         90049 | West     | Office Supplies | Paper          |   64.74 |         13 |          0 |  30.4278 |


Table: SampleSuperstore (2)
| Ship Mode      |   Sales |
|:---------------|--------:|
| Standard Class |   77.88 |
| Standard Class |    6.63 |
| Standard Class |    5.88 |
| Second Class   |    5.46 |
| Second Class   |   73.2  |
| Second Class   |   22.72 |
| First Class    |   45.36 |
| Standard Class |   11.34 |
| Standard Class |   80.3  |
| Standard Class |   64.74 |


Table: SampleSuperstore
| City        | Count   |
|:------------|:--------|
| Los Angeles |         |
| Los Angeles |         |
| Los Angeles |         |
| Los Angeles |         |
| Los Angeles |         |
| Los Angeles |         |
| Los Angeles |         |
| Los Angeles |         |
| Los Angeles |         |
| Los Angeles |         |


Table: Table (10)
| Category        |   Quantity |   Count |
|:----------------|-----------:|--------:|
| Furniture       |          2 |     503 |
| Furniture       |          3 |     534 |
| Office Supplies |          2 |    1461 |
| Furniture       |          5 |     253 |
| Furniture       |          7 |     115 |
| Office Supplies |          4 |     713 |
| Technology      |          6 |      88 |
| Office Supplies |          3 |    1414 |
| Office Supplies |          5 |     752 |
| Furniture       |          9 |      58 |


Table: Table (11)
| Region   |   Quantity |   Count |
|:---------|-----------:|--------:|
| South    |          2 |     363 |
| South    |          3 |     404 |
| West     |          2 |     761 |
| South    |          5 |     201 |
| West     |          7 |     191 |
| West     |          4 |     379 |
| West     |          6 |     187 |
| West     |          3 |     765 |
| West     |          5 |     405 |
| West     |          9 |      83 |


Table: Table (12)
| State        |   Quantity |   Count |
|:-------------|-----------:|--------:|
| Iowa         |          6 |       1 |
| Pennsylvania |         13 |       1 |
| Utah         |          6 |       1 |
| Washington   |         13 |       1 |
| New Jersey   |          9 |       1 |
| Texas        |         12 |       1 |
| Mississippi  |          9 |       1 |
| Colorado     |         13 |       1 |
| Arizona      |         14 |       1 |
| Alabama      |         14 |       1 |


Table: Table (13)
| Sub-Category   |   Quantity |   Count |
|:---------------|-----------:|--------:|
| Bookcases      |          2 |      58 |
| Chairs         |          3 |     149 |
| Labels         |          2 |      96 |
| Tables         |          5 |      32 |
| Storage        |          2 |     190 |
| Furnishings    |          7 |      45 |
| Art            |          4 |      86 |
| Phones         |          6 |      38 |
| Binders        |          3 |     355 |
| Appliances     |          5 |      57 |


Table: Table (14)
| City          |   Quantity |   Count |
|:--------------|-----------:|--------:|
| Richardson    |          7 |       1 |
| Edmond        |          7 |       1 |
| Redlands      |          7 |       1 |
| Tamarac       |          7 |       1 |
| Manchester    |          7 |       1 |
| Gastonia      |          7 |       1 |
| Park Ridge    |          7 |       1 |
| Denver        |          7 |       1 |
| Mission Viejo |          7 |       1 |
| Chester       |          7 |       1 |


Table: Table (15)
| Ship Mode      |    Sales |
|:---------------|---------:|
| Standard Class |  957.577 |
| Standard Class |   22.368 |
| Standard Class |   48.86  |
| Standard Class |    7.28  |
| Standard Class |  907.152 |
| Standard Class |   18.504 |
| Standard Class |  114.9   |
| Standard Class | 1706.18  |
| Standard Class |  911.424 |
| Standard Class |   15.552 |


Table: Table (2)
| Region   |   Count |
|:---------|--------:|
| South    |    1620 |
| West     |    3203 |
| Central  |    2323 |
| East     |    2848 |


Table: Table (3)
| Ship Mode      |   Count |
|:---------------|--------:|
| Second Class   |    1943 |
| Standard Class |    5955 |
| First Class    |    1537 |
| Same Day       |     542 |


Table: Table (4)
| Category        |   Count |
|:----------------|--------:|
| Furniture       |    2121 |
| Office Supplies |    6026 |
| Technology      |    1847 |


Table: Table (5)
| Segment     |   Count |
|:------------|--------:|
| Consumer    |     547 |
| Corporate   |     283 |
| Home Office |     170 |


Table: Table (6)
| Category        | Sub-Category   |   Count |
|:----------------|:---------------|--------:|
| Furniture       | Bookcases      |     228 |
| Furniture       | Chairs         |     615 |
| Office Supplies | Labels         |     363 |
| Furniture       | Tables         |     319 |
| Office Supplies | Storage        |     846 |
| Furniture       | Furnishings    |     956 |
| Office Supplies | Art            |     795 |
| Technology      | Phones         |     889 |
| Office Supplies | Binders        |    1522 |
| Office Supplies | Appliances     |     466 |


Table: Table (7)
| State          |   Count |
|:---------------|--------:|
| Kentucky       |     139 |
| California     |    1996 |
| Florida        |     383 |
| North Carolina |     249 |
| Washington     |     502 |
| Texas          |     983 |
| Wisconsin      |     110 |
| Utah           |      53 |
| Nebraska       |      38 |
| Pennsylvania   |     586 |


Table: Table (8)
| City            |   Count |
|:----------------|--------:|
| Melbourne       |       1 |
| Orland Park     |       1 |
| Whittier        |       1 |
| Chapel Hill     |       1 |
| Layton          |       1 |
| Lindenhurst     |       1 |
| Rochester Hills |       1 |
| Lake Elsinore   |       1 |
| Linden          |       1 |
| Murrieta        |       1 |


Table: Table (9)
| Segment     |   Quantity |   Count |
|:------------|-----------:|--------:|
| Consumer    |          2 |    1254 |
| Consumer    |          3 |    1294 |
| Corporate   |          2 |     729 |
| Consumer    |          5 |     642 |
| Consumer    |          7 |     299 |
| Consumer    |          4 |     616 |
| Consumer    |          6 |     289 |
| Consumer    |          9 |     136 |
| Home Office |          5 |     216 |
| Home Office |          3 |     395 |


Table: Table 4
| Region   | Count   |
|:---------|:--------|
| West     |         |
| West     |         |
| West     |         |
| West     |         |
| West     |         |
| West     |         |
| West     |         |
| West     |         |
| West     |         |
| West     |         |


Table: Table
| Ship Mode      |   Count |
|:---------------|--------:|
| Second Class   |    1945 |
| Standard Class |    5968 |
| First Class    |    1538 |
| Same Day       |     543 |

 


tables: name: SampleStore
data: SampleStore.csv
name: SampleSuperstore (2)
data: SampleSuperstore (2).csv
name: SampleSuperstore
data: SampleSuperstore.csv
name: Table (10)
data: Table (10).csv
name: Table (11)
data: Table (11).csv
name: Table (12)
data: Table (12).csv
name: Table (13)
data: Table (13).csv
name: Table (14)
data: Table (14).csv
name: Table (15)
data: Table (15).csv
name: Table (2)
data: Table (2).csv
name: Table (3)
data: Table (3).csv
name: Table (4)
data: Table (4).csv
name: Table (5)
data: Table (5).csv
name: Table (6)
data: Table (6).csv
name: Table (7)
data: Table (7).csv
name: Table (8)
data: Table (8).csv
name: Table (9)
data: Table (9).csv
name: Table 4
data: Table 4.csv
name: Table
data: Table.csv
label: Table 4
Region
Table (2)
Region
SampleStore
Region
Table (2)
Region
SampleStore
Ship Mode
Table
Ship Mode
SampleStore
Ship Mode
Table (3)
Ship Mode
SampleStore
Segment
Table (5)
Segment
SampleStore
Category
Table (4)
Category
SampleStore
Sub-Category
Table (6)
Sub-Category
SampleStore
State
Table (7)
State
SampleStore
City
Table (8)
City
SampleSuperstore
City
Table (8)
City
Table (11)
Region
Table (2)
Region
Table (12)
State
Table (7)
State
Table (14)
City
Table (8)
City
SampleSuperstore (2)
Ship Mode
Table
Ship Mode
SampleSuperstore (2)
Ship Mode
Table (3)
Ship Mode
Table (15)
Ship Mode
Table
Ship Mode
Table (15)
Ship Mode
Table (3)
Ship Mode
output: {
    "joins": [
        {
            "from_table": "Table 4",
            "from_column": "Region",
            "to_table": "Table (2)",
            "to_column": "Region"
        },
        {
            "from_table": "SampleStore",
            "from_column": "Region",
            "to_table": "Table (2)",
            "to_column": "Region"
        },
        {
            "from_table": "SampleStore",
            "from_column": "Ship Mode",
            "to_table": "Table",
            "to_column": "Ship Mode"
        },
        {
            "from_table": "SampleStore",
            "from_column": "Ship Mode",
            "to_table": "Table (3)",
            "to_column": "Ship Mode"
        },
        {
            "from_table": "SampleStore",
            "from_column": "Segment",
            "to_table": "Table (5)",
            "to_column": "Segment"
        },
        {
            "from_table": "SampleStore",
            "from_column": "Category",
            "to_table": "Table (4)",
            "to_column": "Category"
        },
        {
            "from_table": "SampleStore",
            "from_column": "Sub-Category",
            "to_table": "Table (6)",
            "to_column": "Sub-Category"
        },
        {
            "from_table": "SampleStore",
            "from_column": "State",
            "to_table": "Table (7)",
            "to_column": "State"
        },
        {
            "from_table": "SampleStore",
            "from_column": "City",
            "to_table": "Table (8)",
            "to_column": "City"
        },
        {
            "from_table": "SampleSuperstore",
            "from_column": "City",
            "to_table": "Table (8)",
            "to_column": "City"
        },
        {
            "from_table": "Table (11)",
            "from_column": "Region",
            "to_table": "Table (2)",
            "to_column": "Region"
        },
        {
            "from_table": "Table (12)",
            "from_column": "State",
            "to_table": "Table (7)",
            "to_column": "State"
        },
        {
            "from_table": "Table (14)",
            "from_column": "City",
            "to_table": "Table (8)",
            "to_column": "City"
        },
        {
            "from_table": "SampleSuperstore (2)",
            "from_column": "Ship Mode",
            "to_table": "Table",
            "to_column": "Ship Mode"
        },
        {
            "from_table": "SampleSuperstore (2)",
            "from_column": "Ship Mode",
            "to_table": "Table (3)",
            "to_column": "Ship Mode"
        },
        {
            "from_table": "Table (15)",
            "from_column": "Ship Mode",
            "to_table": "Table",
            "to_column": "Ship Mode"
        },
        {
            "from_table": "Table (15)",
            "from_column": "Ship Mode",
            "to_table": "Table (3)",
            "to_column": "Ship Mode"
        }
    ]
}