ChickenKyiv / ChickenKyiv/database-visuals
schemes to check
- Dominant language
- PHP
- Stars
- 0
- Forks
- 0
- PR merge metrics
- No merged PRs in 30d
Description
#13

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








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



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

https://forum.codeigniter.com/post-7676.html
read: https://fmforums.com/topic/43537-recipe-database-using-kitchen-inventory/

Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.