rushfere.blogg.se - Aion database cooking recipes

#AION DATABASE COOKING RECIPES HOW TO#

breakfast as course_nameĪssuming the user has selected a recipe (with ID = 123) in the list of recipes that showed up with "chocolate" in the name JOIN food_category AS fc ON fc.food_category_id = r.food_category_idĪND c.course_id = 1 - i.e. JOIN course AS c ON c.course_id = r.course_id R.recipe_description AS recipeDescription, The Join table is useless as you'd be joining the tables in your SELECT queryĮxample queries Getting recipe details - Recipe query Assuming a search parameter has been entered - i.e. Measurement_name varchar Recipe Steps(table) Measurement_id int primary_key auto_increment Ingredient_quantity float Measurements(table) ingredient_measurement_id int foreign_key.Quantity_id int primary_key auto_increment Other ingredient properties maybe? Quantity(table)

Ingredient_id int primary_key auto_increment Other course properties maybe, such as time of day? Ingredients(table)

recipe_id int primary_key auto_incrementįood_category_id int primary_key auto_increment.

As I'm not completely sure what the scope of the project entails, I can only provide the following based on assumptions of field names and assumptions of project structure.ĭatabase and table structure Recipe(table)

I assume you're asking what might be the best database and table structure for your project. I do not know if I need this 'join' table since 'quantity' seems to be similarĪs I'm not 100% sure what you want. Also, if you could explain what I may or may not be missing would be greatly appreciated. I am a visual learner and it would be much appreciated. If you think you have the answer please structure your tables similar to mine. This is what I have so far in my SQL database:

#AION DATABASE COOKING RECIPES HOW TO#

I will challenge myself to work out how to add the ingredients from the recipes to generate a shopping list, but the question for this post is "How should I structure my tables and connect everything?"

Sort by prep-time, cook-time, cuisine, category, food category and courseĪbility to generate a shopping list from a weekly meal plan by adding the total amount of ingredients from the recipes selected. Inevitably, what I would like the end result to do is to have a solid set up where users can: I am new to the many-to-many style and am not confident in what I have so far. I am in the process of structuring a SQL database for a recipe website that I am playing around with.