Recipe_Ingredients (recipe_id(PF), ingredient_id(PF), amount) Here would be my design: Recipe (recipe_id(PK), name, description) Recipe_Step_Ingredients(recipe_id(PF), step_number(PF), ingredient_id(PF), amount)įrom my understanding, each ingredient is associated to a step in the recipe whereas I feel like each ingredient should be associated directly to a recipe and that the steps could be an attribute of the recipe table or in a Step table directly related to Recipe. Recipe_Steps (recipe_id(PF), step_number(PK), instructions) This db is overly detailed so I decided to used only the following tables: Recipe (recipe_id(PK), name, description) One example that users here seem to point to is the following schema by Barry Williams: My database knowledge is a bit rusty so I've been looking around for inspiration in order to design an appropriate database. I'm using SQLite if that makes any difference. I'm making a simple recipe app that allows user to create and save their recipes. Could not find method addButtonClick on basic SQLite page.How to insert values form sqlite to excel without brackets and in specific column (Python)?.How do i repeat last sql command executed in sqlite command line?.Calculation between row_value at sqlite3.Syntax Error : SQL update with count and inner join.Do calculations on numbers in 1 multiline textView and return result replacing numbers.group by where items in associated table exist in sqlite3.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |