Designing a database for a typical online store?

Question

Database

Hello!
I am a former system administrator, I left my job and am engaged in web development, or rather, I just started studying the stack
. I now have the task of designing a relational database for a simple online store, I sketched something ... Please help, critics, otherwise I won’t figure it out
myself

spoiler

Have I created the entities correctly, are there all entities for the operation of a regular online store?
Have I correctly defined foreign keys, primary keys? connections, data types?
Particularly interested in entities like "address", "phone", "product"
I would also like to know good forums where you can communicate on the topic with both beginners and professionals
Thank you community!

Answer 1

Too much winmania was given to things like address, phone number, etc. There is no real task. Most often, in a real online store, you do not need to normalize this data, let everything be text.
EAV for properties is correct, but with categories it is not clear what you have. There would also be many-to-many easy to do. There is no hierarchy of categories, you didn’t mean that your IM would have a flat catalog from one level of categories?) Here it’s better to read about nested sets right away, I personally remade one store from the usual id -> parent_id to nested sets

Answer 2

I will give a link and there is a procedure for developing a website.
Read carefully!

Answer 3

look at any store