I'm creating a small project and I do not have a lot of database experience and having trouble modeling your tables. The project consists of an output manager, where we will have normal products (like products from a market) and products composed of other products (like a basic basket that has several simple products inside). I will also need to record the date of the exit, provided by the user and his name. The first modeling I created looks like this:
The general table of products I had in mind would be a place where I would store both the codes of the simple products and the compounds, but I already realized that it was unnecessary. Could someone suggest me how would be a good modeling?