search

ChickenKyiv / database-visuals

GNU General Public License v3.0
0 stars 0 forks source link

schemes to check #28

Open atherdon opened 6 years ago

atherdon commented 6 years ago

13

wnjcc Nice Image, I want it on Readme https://gist.github.com/atherdon/3240cc17ffdcbff6533829d4d0811fda

create table Measure (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, 
    name VARCHAR(30)) 
    ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO Measure (name) VALUES('CUP'), ('TEASPOON'), ('TABLESPOON');

'Food Categories'

Appetizers
Breads
Fish
Beef
Poultry
Pork
Soup
Pastas
Sides
Desserts

Directions

id
recipes_id
direction
prep_time
cook_time

Measurements

id
ingredients_id
name

QUANTITIES

id
recipe_id -- links to recipes table
ingredient_id -- links to ingredients table
quantity

https://stackoverflow.com/questions/13882738/designing-a-recipe-database-that-needs-to-include-ingredients-as-well-as-sub-rec

image

image

image

image

image image

image

image

https://stackoverflow.com/questions/38463361/creating-a-recipe-database image

image

image

https://stackoverflow.com/questions/17651424/bill-of-materials-database-model

image

https://forum.codeigniter.com/post-7676.html

read: https://fmforums.com/topic/43537-recipe-database-using-kitchen-inventory/

image

atherdon commented 6 years ago

atherdon/botkit-my-slack#91 atherdon/botkit-my-slack#81 GroceriStar/groceristar#213 ChickenKyiv/static-react#1 ChickenKyiv/recipe-measurements-api#3