Hello, I am developing a small order control system for a restaurant and I do not have much experience in database modeling, I have created the following entities:
An example of an assembled product would be a snack and the customer would choose all of their components, such as bread,
How could I relate these tables in the best way?
According to your snack example the materials of each product varies by product so you could add an id in the Product_Type table and use that id to relate to the Material table, creating another relationship table between both. (table would relate the Material to the Product_has_Pedido - this new table would store the two ids of the Material and Product_has_Pedido table)
