1
I’m creating a small project and I don’t have much experience with databases and having difficulties modeling their tables. The project consists of an output manager, where we will have normal products (such as products from one market) and products composed of other products (such as a basic basket that has several simple products inside). I will also need to record the date of departure, provided by the user and his name. The first modeling I created was like this:
The general table products I had in mind that it would be a place where would store both the codes of the simple products and the compounds, but I have realized that it was unnecessary. Could someone suggest me how good a modeling would look?
Hello! What would be the date of exit provided by the user in this context of products? It would be the date of sale of the product?
– Dherik
Ola @Dherik, that’s right, the user who would provide the date of departure
– João Ávila