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: CommomCause
| Cause Category              |   Contagem |   Rank |
|:----------------------------|-----------:|-------:|
| MATERIAL/WELD/EQUIP FAILURE |       1435 |      1 |
| ALL OTHER CAUSES            |        118 |      4 |
| CORROSION                   |        592 |      2 |
| INCORRECT OPERATION         |        378 |      3 |
| NATURAL FORCE DAMAGE        |        118 |      4 |
| EXCAVATION DAMAGE           |         97 |      6 |
| OTHER OUTSIDE FORCE DAMAGE  |         57 |      7 |


Table: tcc_bi_puc accidents
|   Report Number | Accident Date/Time      | Operator Name                 | Pipeline/Facility Name                   | Pipeline Location   | Pipeline Type   | Liquid Type   | Liquid Subtype   | Accident City   | Accident County   | Accident State   | Cause Category              | Liquid Explosion   | Pipeline Shutdown   |   All Costs |   Ano |   Accident Latitude |   Accident Longitude |   Unintentional Release |   classification |
|----------------:|:------------------------|:------------------------------|:-----------------------------------------|:--------------------|:----------------|:--------------|:-----------------|:----------------|:------------------|:-----------------|:----------------------------|:-------------------|:--------------------|------------:|------:|--------------------:|---------------------:|------------------------:|-----------------:|
|        20100248 | 2010-11-16 13:00:00.000 | ENTERPRISE CRUDE PIPELINE LLC | FREEPORT TERMINAL                        | ONSHORE             | ABOVEGROUND     | CRUDE OIL     |                  | FREEPORT        | BRAZORIA          | TX               | MATERIAL/WELD/EQUIP FAILURE | NO                 |                     |       29185 |  2010 |             28.9351 |             -95.3198 |                    0.71 |                0 |
|        20100284 | 2010-10-27 15:00:00.000 | ENTERPRISE CRUDE PIPELINE LLC | HOPE STATION                             | ONSHORE             | ABOVEGROUND     | CRUDE OIL     |                  | HOPE            | LAVACA            | TX               | MATERIAL/WELD/EQUIP FAILURE | NO                 | NO                  |       27800 |  2010 |             29.1946 |             -96.9853 |                   10    |                0 |
|        20110023 | 2011-01-07 11:00:00.000 | ENTERPRISE CRUDE PIPELINE LLC | BOWIE STATION                            | ONSHORE             | ABOVEGROUND     | CRUDE OIL     |                  | BOWIE           | MONTAGUE          | TX               | MATERIAL/WELD/EQUIP FAILURE | NO                 |                     |        4625 |  2011 |             33.5739 |             -97.8731 |                    1    |                0 |
|        20110049 | 2011-02-07 14:00:00.000 | ENTERPRISE CRUDE PIPELINE LLC | HOBBS TO MIDLAND                         | ONSHORE             | ABOVEGROUND     | CRUDE OIL     |                  | FRANKEL CITY    | ANDREWS           | TX               | MATERIAL/WELD/EQUIP FAILURE | NO                 | NO                  |        1025 |  2011 |             32.4813 |            -102.859  |                    0.24 |                0 |
|        20110107 | 2011-03-17 10:30:00.000 | ENTERPRISE CRUDE PIPELINE LLC | HWY 148 STATION                          | ONSHORE             | ABOVEGROUND     | CRUDE OIL     |                  | WICHITA FALLS   | CLAY              | TX               | INCORRECT OPERATION         | NO                 | NO                  |        2100 |  2011 |             33.97   |             -98.2215 |                    1    |                0 |
|        20110143 | 2011-04-20 19:30:00.000 | ENTERPRISE CRUDE PIPELINE LLC | SEAWAY PIPELINE/FREEPORT MARINE TERMINAL | ONSHORE             | ABOVEGROUND     | CRUDE OIL     |                  | FREEPORT        | BRAZORIA          | TX               | CORROSION                   | NO                 | NO                  |        7100 |  2011 |             28.5608 |             -95.1914 |                    1    |                0 |
|        20110147 | 2011-05-03 17:45:00.000 | ENTERPRISE CRUDE PIPELINE LLC | VANDERBILT STATION                       | ONSHORE             | ABOVEGROUND     | CRUDE OIL     |                  | VANDERBILT      | JACKSON           | TX               | INCORRECT OPERATION         | NO                 | NO                  |          68 |  2011 |             28.4809 |             -96.3739 |                    0.14 |                0 |
|        20110218 | 2011-03-21 12:30:00.000 | ENTERPRISE CRUDE PIPELINE LLC | C1                                       | ONSHORE             | ABOVEGROUND     | CRUDE OIL     |                  | HOPE            | LAVACA            | TX               | ALL OTHER CAUSES            | NO                 | YES                 |       45540 |  2011 |             29.4388 |             -96.8045 |                   40    |                0 |
|        20110312 | 2011-08-25 07:15:00.000 | ENTERPRISE CRUDE PIPELINE LLC | RINGGOLD STATION                         | ONSHORE             | ABOVEGROUND     | CRUDE OIL     |                  |                 | MONTAGUE          | TX               | MATERIAL/WELD/EQUIP FAILURE | NO                 | YES                 |          45 |  2011 |             33.8636 |             -97.9556 |                    0.5  |                0 |
|        20110425 | 2011-10-27 07:00:00.000 | ENTERPRISE CRUDE PIPELINE LLC |                                          | ONSHORE             | ABOVEGROUND     | CRUDE OIL     |                  |                 |                   | TX               | ALL OTHER CAUSES            | NO                 |                     |       29540 |  2011 |             29.3455 |             -94.9357 |                    6    |                0 |


Table: tcc_bi_puc accident_city
| Accident_City                                |
|:---------------------------------------------|
| 11.5 MILES NORTH OF MCKITTRICK, CA ON HWY 33 |
| 760 ROOSEVELT AVENUE                         |
| 799 SOUTH SEASIDE AVENUE, TERMINAL ISLAND    |
| ABERDEEN                                     |
| ABILENE                                      |
| ACKERLY                                      |
| ADDINGTON                                    |
| AFTON                                        |
| ALBANY                                       |
| ALCOVA                                       |


Table: tcc_bi_puc accident_county
| Accident_County   |
|:------------------|
| ACADIA            |
| ACADIA PARISH     |
| ADA               |
| ADAIR             |
| ADAMS             |
| ADAMS COUNTY      |
| ALAMEDA           |
| ALFALFA           |
| ALLEN             |
| AMITE             |


Table: tcc_bi_puc accident_state
| Accident_State   |
|:-----------------|
| AK               |
| AL               |
| AR               |
| CA               |
| CO               |
| CT               |
| FL               |
| GA               |
| HI               |
| IA               |


Table: tcc_bi_puc cause_category
| Cause_Category              |   Count |
|:----------------------------|--------:|
| ALL OTHER CAUSES            |    2795 |
| CORROSION                   |    2795 |
| EXCAVATION DAMAGE           |    2795 |
| INCORRECT OPERATION         |    2795 |
| MATERIAL/WELD/EQUIP FAILURE |    2795 |
| NATURAL FORCE DAMAGE        |    2795 |
| None                        |    2795 |
| OTHER OUTSIDE FORCE DAMAGE  |    2795 |


Table: tcc_bi_puc liquid_explosion
| Liquid_Explosion   |
|:-------------------|
| NO                 |
| None               |
| YES                |


Table: tcc_bi_puc liquid_subtype
| Liquid_Subtype                                           |
|:---------------------------------------------------------|
| ANHYDROUS AMMONIA                                        |
| BIODIESEL                                                |
| DIESEL, FUEL OIL, KEROSENE, JET FUEL                     |
| GASOLINE (NON-ETHANOL)                                   |
| LPG (LIQUEFIED PETROLEUM GAS) / NGL (NATURAL GAS LIQUID) |
| MIXTURE OF REFINED PRODUCTS (TRANSMIX OR OTHER MIXTURE)  |
| nan                                                      |
| None                                                     |
| OTHER                                                    |
| OTHER HVL                                                |


Table: tcc_bi_puc liquid_type
| Liquid_Type                                          |
|:-----------------------------------------------------|
| BIOFUEL / ALTERNATIVE FUEL(INCLUDING ETHANOL BLENDS) |
| CO2 (CARBON DIOXIDE)                                 |
| CRUDE OIL                                            |
| HVL OR OTHER FLAMMABLE OR TOXIC FLUID, GAS           |
| None                                                 |
| REFINED AND/OR PETROLEUM PRODUCT (NON-HVL), LIQUID   |


Table: tcc_bi_puc operator_name
| Operator_Name                                     |
|:--------------------------------------------------|
| ALYESKA PIPELINE SERVICE CO                       |
| AMOCO OIL CO                                      |
| ASIG - HONOLULU                                   |
| BELLE FOURCHE PIPELINE CO                         |
| BHP BILLITON PETROLEUM (EAGLE FORD GATHERING) LLC |
| BKEP CRUDE, LLC                                   |
| BKEP PIPELINE, LLC                                |
| BLUE RACER MIDSTREAM, LLC                         |
| BP OIL PIPELINE CO                                |
| BP PIPELINE (NORTH AMERICA) INC.                  |


Table: tcc_bi_puc pipeline_facility_name
| Pipeline_Facility_Name                  | Rank   |
|:----------------------------------------|:-------|
| BUCKEYE TEXAS HUB                       |        |
| DOUBLE HH, GURENSEY TERMINAL            |        |
| MORGANS POINT TO TEXAS PETRO OLEFINS #3 |        |
| P89 - BUTANE MAINLINE                   |        |
| VENTURA 10 CRUDE PIPELINE               |        |
| #1 CRUDE SYSTEM / DRUMRIGHT STATION     |        |
| #1 P/L ( OTH TO APPELT )                |        |
| #1-6 ALEXANDRAI TO GRAND FORKS PIPELINE |        |
| #1-8 IRVINGTON TO OMAHA LINE            |        |
| #2-8 MINNEAPOLIS -- DULUTH LINE         |        |


Table: tcc_bi_puc pipeline_location
| Pipeline_Location   |
|:--------------------|
| None                |
| OFFSHORE            |
| ONSHORE             |


Table: tcc_bi_puc pipeline_shutdown
| Pipeline_Shutdown   |
|:--------------------|
| nan                 |
| NO                  |
| None                |
| YES                 |


Table: tcc_bi_puc pipeline_type
| Pipeline_Type   |
|:----------------|
| ABOVEGROUND     |
| nan             |
| None            |
| TANK            |
| TRANSITION AREA |
| UNDERGROUND     |

 


tables: name: CommomCause
data: CommomCause.csv
name: tcc_bi_puc accidents
data: tcc_bi_puc accidents.csv
name: tcc_bi_puc accident_city
data: tcc_bi_puc accident_city.csv
name: tcc_bi_puc accident_county
data: tcc_bi_puc accident_county.csv
name: tcc_bi_puc accident_state
data: tcc_bi_puc accident_state.csv
name: tcc_bi_puc cause_category
data: tcc_bi_puc cause_category.csv
name: tcc_bi_puc liquid_explosion
data: tcc_bi_puc liquid_explosion.csv
name: tcc_bi_puc liquid_subtype
data: tcc_bi_puc liquid_subtype.csv
name: tcc_bi_puc liquid_type
data: tcc_bi_puc liquid_type.csv
name: tcc_bi_puc operator_name
data: tcc_bi_puc operator_name.csv
name: tcc_bi_puc pipeline_facility_name
data: tcc_bi_puc pipeline_facility_name.csv
name: tcc_bi_puc pipeline_location
data: tcc_bi_puc pipeline_location.csv
name: tcc_bi_puc pipeline_shutdown
data: tcc_bi_puc pipeline_shutdown.csv
name: tcc_bi_puc pipeline_type
data: tcc_bi_puc pipeline_type.csv
label: tcc_bi_puc accidents
Liquid Subtype
tcc_bi_puc liquid_subtype
Liquid_Subtype
tcc_bi_puc accidents
Accident City
tcc_bi_puc accident_city
Accident_City
tcc_bi_puc accidents
Accident County
tcc_bi_puc accident_county
Accident_County
tcc_bi_puc accidents
Cause Category
tcc_bi_puc cause_category
Cause_Category
tcc_bi_puc accidents
Liquid Type
tcc_bi_puc liquid_type
Liquid_Type
tcc_bi_puc accidents
Operator Name
tcc_bi_puc operator_name
Operator_Name
tcc_bi_puc accidents
Accident State
tcc_bi_puc accident_state
Accident_State
tcc_bi_puc accidents
Liquid Explosion
tcc_bi_puc liquid_explosion
Liquid_Explosion
tcc_bi_puc accidents
Pipeline/Facility Name
tcc_bi_puc pipeline_facility_name
Pipeline_Facility_Name
tcc_bi_puc accidents
Pipeline Shutdown
tcc_bi_puc pipeline_shutdown
Pipeline_Shutdown
tcc_bi_puc accidents
Pipeline Location
tcc_bi_puc pipeline_location
Pipeline_Location
tcc_bi_puc accidents
Pipeline Type
tcc_bi_puc pipeline_type
Pipeline_Type
output: {
    "joins": [
        {
            "from_table": "tcc_bi_puc accidents",
            "from_column": "Liquid Subtype",
            "to_table": "tcc_bi_puc liquid_subtype",
            "to_column": "Liquid_Subtype"
        },
        {
            "from_table": "tcc_bi_puc accidents",
            "from_column": "Accident City",
            "to_table": "tcc_bi_puc accident_city",
            "to_column": "Accident_City"
        },
        {
            "from_table": "tcc_bi_puc accidents",
            "from_column": "Accident County",
            "to_table": "tcc_bi_puc accident_county",
            "to_column": "Accident_County"
        },
        {
            "from_table": "tcc_bi_puc accidents",
            "from_column": "Cause Category",
            "to_table": "tcc_bi_puc cause_category",
            "to_column": "Cause_Category"
        },
        {
            "from_table": "tcc_bi_puc accidents",
            "from_column": "Liquid Type",
            "to_table": "tcc_bi_puc liquid_type",
            "to_column": "Liquid_Type"
        },
        {
            "from_table": "tcc_bi_puc accidents",
            "from_column": "Operator Name",
            "to_table": "tcc_bi_puc operator_name",
            "to_column": "Operator_Name"
        },
        {
            "from_table": "tcc_bi_puc accidents",
            "from_column": "Accident State",
            "to_table": "tcc_bi_puc accident_state",
            "to_column": "Accident_State"
        },
        {
            "from_table": "tcc_bi_puc accidents",
            "from_column": "Liquid Explosion",
            "to_table": "tcc_bi_puc liquid_explosion",
            "to_column": "Liquid_Explosion"
        },
        {
            "from_table": "tcc_bi_puc accidents",
            "from_column": "Pipeline/Facility Name",
            "to_table": "tcc_bi_puc pipeline_facility_name",
            "to_column": "Pipeline_Facility_Name"
        },
        {
            "from_table": "tcc_bi_puc accidents",
            "from_column": "Pipeline Shutdown",
            "to_table": "tcc_bi_puc pipeline_shutdown",
            "to_column": "Pipeline_Shutdown"
        },
        {
            "from_table": "tcc_bi_puc accidents",
            "from_column": "Pipeline Location",
            "to_table": "tcc_bi_puc pipeline_location",
            "to_column": "Pipeline_Location"
        },
        {
            "from_table": "tcc_bi_puc accidents",
            "from_column": "Pipeline Type",
            "to_table": "tcc_bi_puc pipeline_type",
            "to_column": "Pipeline_Type"
        }
    ]
}