How to arrange a database with dishes?

3

325346212020-12-07 11:11:16

Database design

32534621, 2020-12-07 11:11:16

There is a database with recipes for dishes, how to format the database correctly so that each dish has its own list of products?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Anton R., 2020-12-07
@anton_reut

Google "many to many".
Add tables:
1) Dish_id-Ingredient_id (many-to-many linker)
2) Ingredient (here, one entry is one ingredient)