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: public actions
|   id | name     |
|-----:|:---------|
|    0 | mix      |
|    1 | stir     |
|    2 | boil     |
|    3 | take off |
|    4 | shape    |
|    5 | let      |
|    6 | place    |
|    7 | pour     |
|    8 | bake     |
|    9 | combine  |


Table: public composed
|   id |   recipeid |   stepid |
|-----:|-----------:|---------:|
|    1 |          0 |        1 |
|    2 |          0 |        2 |
|    3 |          0 |        3 |
|    4 |          0 |        4 |
|    5 |          0 |        5 |
|    6 |          0 |        6 |
|    7 |          0 |        7 |
|    8 |          0 |        8 |
|    9 |          1 |        9 |
|   10 |          1 |       10 |


Table: public contains
|   id | size   |   quantity | adjectives   |   recipeid |   ingredientid | public.ingredients.name   | public.recipes.title                                 |
|-----:|:-------|-----------:|:-------------|-----------:|---------------:|:--------------------------|:-----------------------------------------------------|
|   68 | cup    |          1 |              |         15 |              0 | sugar                     | Fresh Strawberry Pie                                 |
|   92 | cup    |          1 |              |         20 |              0 | sugar                     | Grandma Hanrath'S Banana Breadfort Collins, Colorado |
|  206 | cup    |          1 |              |         45 |              0 | sugar                     | Chocolate Mint Bars                                  |
|  254 | cup    |          1 |              |         53 |              0 | sugar                     | Three Bean Salad                                     |
|  361 | cup    |          1 |              |         79 |              0 | sugar                     | Mulled Cider                                         |
|  369 | cup    |          1 |              |         82 |              0 | sugar                     | Cranberry-Apple-Orange Salad                         |
|  427 | cup    |          1 |              |         95 |              0 | sugar                     | Baked Beans                                          |
|  449 | cup    |          1 |              |         98 |              0 | sugar                     | Crazy Peanut Butter Cookies                          |
|  490 | cup    |          1 |              |        107 |              0 | sugar                     | Cutout Cookie                                        |
|  627 | cup    |          1 |              |        134 |              0 | sugar                     | Apple Pie                                            |


Table: public ingredients
|   id | name                |
|-----:|:--------------------|
|    0 | sugar               |
|    1 | milk                |
|    2 | vanilla             |
|    3 | butter              |
|    4 | bite rice biscuit   |
|    5 | beef                |
|    6 | chicken breast      |
|    7 | mushroom soup cream |
|    8 | sour cream          |
|    9 | corn package        |


Table: public instruments
|   id | name        |
|-----:|:------------|
|    0 | saucepan    |
|    1 | clusters    |
|    2 | paper       |
|    3 | bottom      |
|    4 | cooker      |
|    5 | casserole   |
|    6 | fork        |
|    7 | paper towel |
|    8 | kettle      |
|    9 | tablespoons |


Table: public involves
|   id |   ingredientid |   stepid |
|-----:|---------------:|---------:|
|    2 |              0 |        1 |
|   36 |              0 |       51 |
|   44 |              0 |       53 |
|   67 |              0 |       89 |
|   87 |              0 |      111 |
|  102 |              0 |      143 |
|  121 |              0 |      177 |
|  138 |              0 |      197 |
|  174 |              0 |      263 |
|  186 |              0 |      275 |


Table: public recipes
|   id | title                    | steps_nstr                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | ingredients_nstr                                                                                                                                                                                                                                                                                                |
|-----:|:-------------------------|:----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
|    0 | No-Bake Nut Cookies      | In a heavy 2-quart saucepan, mix brown sugar, nuts, evaporated milk and butter or margarine. Stir over medium heat until mixture bubbles all over top. Boil and stir 5 minutes more. Take off heat. Stir in vanilla and cereal; mix well. Using 2 teaspoons, drop and shape into 30 clusters on wax paper. Let stand until firm, about 30 minutes.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      | 1 cup firmly packed brown sugar. 1/2 cup evaporated milk. 1/2 teaspoon vanilla. 1/2 cup broken nuts (pecans). 2 tablespoon butter or margarine. 3 1/2 cup bite size shredded rice biscuits                                                                                                                      |
|    1 | Jewell Ball'S Chicken    | Place chipped beef on bottom of baking dish. Place chicken on top of beef. Mix soup and cream together; pour over chicken. Bake, uncovered, at 275° for 3 hours.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | 1 small jar chipped beef, cut up. 4 boned chicken breasts. 1 can cream of mushroom soup. 1 carton sour cream                                                                                                                                                                                                    |
|    2 | Creamy Corn              | In a slow cooker, combine all ingredients. Cover and cook on low for 4 hours or until heated through and cheese is melted. Stir well before serving. Yields 6 servings.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | 16 ounce package frozen corn. 8 ounce package cream cheese, cubed. 1/3 cup butter, cubed. 1/2 teaspoon garlic powder. 1/2 teaspoon salt. 1/4 teaspoon pepper                                                                                                                                                    |
|    3 | Chicken Funny            | Boil and debone chicken. Put bite size pieces in average size square casserole dish. Pour gravy and cream of mushroom soup over chicken; level. Make stuffing according to instructions on box (do not make too moist). Put stuffing on top of chicken and gravy; level. Sprinkle shredded cheese on top and bake at 350° for approximately 20 minutes or until golden and bubbly.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      | 1 large whole chicken. 10 1/2 ounce cans chicken gravy. 10 1/2 ounce can cream of mushroom soup. 6 ounce box stove top stuffing. 4 ounce shredded cheese                                                                                                                                                        |
|    4 | Reeses Cups(Candy)       | Combine first four ingredients and press in 13 x 9-inch ungreased pan. Melt chocolate chips and spread over mixture. Refrigerate for about 20 minutes and cut into pieces before chocolate gets hard. Keep in refrigerator.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 1 cup peanut butter. 3/4 cup graham cracker crumbs. 1 cup melted butter. 1 pound3 1/2 cup powdered sugar. 1 large package chocolate chips                                                                                                                                                                       |
|    5 | Cheeseburger Potato Soup | Wash potatoes; prick several times with a fork. Microwave them with a wet paper towel covering the potatoes on high for 6-8 minutes. The potatoes should be soft, ready to eat. Let them cool enough to handle. Cut in half lengthwise; scoop out pulp and reserve. Discard shells. Brown ground beef until done. Drain any grease from the meat. Set aside when done. Meat will be added later. Melt butter in a large kettle over low heat; add flour, stirring until smooth. Cook 1 minute, stirring constantly. Gradually add milk; cook over medium heat, stirring constantly, until thickened and bubbly. Stir in potato, ground beef, salt, pepper, 1 cup of cheese, 2 tablespoons of green onion and 1/2 cup of bacon. Cook until heated (do not boil). Stir in sour cream if desired; cook until heated (do not boil). Sprinkle with remaining cheese, bacon and green onions. | 6 baking potatoes. 1 pound of extra lean ground beef. 2/3 cup butter or margarine. 6 cup milk. 3/4 teaspoon salt. 1/2 teaspoon pepper. 1 1/2 c6 ounce shredded cheddar cheese, divided. 12 sliced bacon, cooked, crumbled and divided. 4 green onion, chopped and divided. 8 ounce carton sour cream (optional) |
|    6 | Rhubarb Coffee Cake      | Cream sugar and butter. Add egg and beat well. To creamed butter, sugar and egg, add alternately buttermilk with mixture of flour, salt and soda. Mix well. Add rhubarb and vanilla. Pour into greased 9 x 13-inch pan and add Topping.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | 1 1/2 cup sugar. 1/2 cup butter. 1 egg. 1 cup buttermilk. 2 cup flour. 1/2 teaspoon salt. 1 teaspoon soda. 1 cup buttermilk. 2 cup rhubarb, finely cut. 1 teaspoon vanilla                                                                                                                                      |
|    7 | Scalloped Corn           | Mix together both cans of corn, crackers, egg, 2 teaspoons of melted butter and pepper and place in a buttered baking dish. Dot with remaining 4 teaspoons of butter. Bake at 350° for 1 hour.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | 1 can cream-style corn. 1 can whole kernel corn. 1/2 packageapproximately 20 saltine crackers, crushed. 1 egg, beaten. 6 teaspoon butter, divided. pepper to taste                                                                                                                                              |
|    8 | Nolan'S Pepper Steak     | Roll steak strips in flour. Brown in skillet. Salt and pepper. Combine tomato liquid, water, onions and browned steak. Cover and simmer for one and a quarter hours. Uncover and stir in Worcestershire sauce. Add tomatoes, green peppers and simmer for 5 minutes. Serve over hot cooked rice.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | 1 1/2 pound round steak (1-inch thick), cut into strips. 1 can drained tomatoes, cut up (save liquid). 1 3/4 cup water. 1/2 cup onions. 1 1/2 tablespoon worcestershire sauce. 2 green peppers, diced. 1/4 cup oil                                                                                              |
|    9 | Millionaire Pie          | Empty Cool Whip into a bowl. Drain juice from pineapple. Mix Cool Whip and pineapple. Add condensed milk. Squeeze lemons, remove seeds and add to Cool Whip and pineapple. Chop nuts into small pieces and add to mixture. Stir all ingredients together and mix well. Pour into a graham cracker crust. Use top from crust to cover top of pie. Chill overnight. Makes 2 pies.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | 1 large container cool whip. 1 large can crushed pineapple. 1 can condensed milk. 3 lemons. 1 cup pecans. 2 graham cracker crusts                                                                                                                                                                               |


Table: public steps
|   id | description                                            |   step_number |   actionid | public.actions.name   | public.composed.public.recipes.title                 |
|-----:|:-------------------------------------------------------|--------------:|-----------:|:----------------------|:-----------------------------------------------------|
|   52 | Add egg and beat well.                                 |             2 |         30 | add                   | Rhubarb Coffee Cake                                  |
|  133 | Add strawberries, pineapple, crushed bananas and nuts. |             2 |         30 | add                   | Strawberry Whatever                                  |
|  139 | Sift dry ingredients and add.                          |             2 |         30 | add                   | Eggless Milkless Applesauce Cake                     |
|  144 | Add eggs, salt and soda, then bananas and flour.       |             2 |         30 | add                   | Grandma Hanrath'S Banana Breadfort Collins, Colorado |
|  231 | Add drained tuna, pimento and onion.                   |             2 |         30 | add                   | Tuna Macaroni Casserole                              |
|  278 | Add egg and beat until creamy.                         |             2 |         30 | add                   | Quick Coffee Cake(6 Servings)                        |
|  368 | Add the remaining ingredients.                         |             2 |         30 | add                   | Bonbon Cookies                                       |
|  389 | add the milk and beat smooth.                          |             2 |         30 | add                   | Pineapple Nut Pie                                    |
|  397 | Add remaining ingredients.                             |             2 |         30 | add                   | Frozen Peach Mousse                                  |
|  448 | Add Bisquick and mix thoroughly.                       |             2 |         30 | add                   | Sausage Balls                                        |


Table: public utilize
|   id |   instrumentid |   stepid | public.instruments.name   | public.steps.public.composed.public.recipes.title   |
|-----:|---------------:|---------:|:--------------------------|:----------------------------------------------------|
|   46 |             34 |      222 | oven                      | Cherry Pizza                                        |
|   48 |             34 |      226 | oven                      | Potato And Cheese Pie                               |
|   60 |             34 |      317 | oven                      | Chicken Divan                                       |
|  118 |             34 |      554 | oven                      | Pound Cake                                          |
|  120 |             34 |      575 | oven                      | Baked Beans                                         |
|  158 |             34 |      772 | oven                      | Artichoke Dip                                       |
|  163 |             34 |      794 | oven                      | 7-Up Cake                                           |
|  164 |             34 |      807 | oven                      | Chocolate Pie                                       |
|  170 |             34 |      866 | oven                      | Magic Cookie Bars                                   |
|  171 |             34 |      866 | oven                      | Magic Cookie Bars                                   |

 


tables: name: public actions
data: public actions.csv
name: public composed
data: public composed.csv
name: public contains
data: public contains.csv
name: public ingredients
data: public ingredients.csv
name: public instruments
data: public instruments.csv
name: public involves
data: public involves.csv
name: public recipes
data: public recipes.csv
name: public steps
data: public steps.csv
name: public utilize
data: public utilize.csv
label: public composed
recipeid
public recipes
id
public composed
stepid
public steps
id
public steps
actionid
public actions
id
public contains
ingredientid
public ingredients
id
public contains
recipeid
public recipes
id
public involves
ingredientid
public ingredients
id
public utilize
instrumentid
public instruments
id
public involves
stepid
public steps
id
public utilize
stepid
public steps
id
output: {
    "joins": [
        {
            "from_table": "public composed",
            "from_column": "recipeid",
            "to_table": "public recipes",
            "to_column": "id"
        },
        {
            "from_table": "public composed",
            "from_column": "stepid",
            "to_table": "public steps",
            "to_column": "id"
        },
        {
            "from_table": "public steps",
            "from_column": "actionid",
            "to_table": "public actions",
            "to_column": "id"
        },
        {
            "from_table": "public contains",
            "from_column": "ingredientid",
            "to_table": "public ingredients",
            "to_column": "id"
        },
        {
            "from_table": "public contains",
            "from_column": "recipeid",
            "to_table": "public recipes",
            "to_column": "id"
        },
        {
            "from_table": "public involves",
            "from_column": "ingredientid",
            "to_table": "public ingredients",
            "to_column": "id"
        },
        {
            "from_table": "public utilize",
            "from_column": "instrumentid",
            "to_table": "public instruments",
            "to_column": "id"
        },
        {
            "from_table": "public involves",
            "from_column": "stepid",
            "to_table": "public steps",
            "to_column": "id"
        },
        {
            "from_table": "public utilize",
            "from_column": "stepid",
            "to_table": "public steps",
            "to_column": "id"
        }
    ]
}