3
3
325346212020-12-07 11:11:16
Database design
32534621, 2020-12-07 11:11:16

How to arrange a database with dishes?

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

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)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question