I'm doing a study project (online smartphone store) in python + flask + postgresql. I'm still new to this and would like to ask for help with the db structure. I made a rough diagram. Can you tell me please what is wrong in it and how best to do it.

enter image description here

A little about the project

On the site I will have a link to the user profile, to the user's cart and to the user's orders. On the main page there will be smartphones cards, when you click on which, a page of a separate smartphone with its characteristics will open. On the smartphone page, you can add it to the cart. And here one more question arises: how the cart should look in the database, whether it needs a separate entity at all or the orders in the cart are somehow stored through sessions. And how then to link the cart with orders

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.