How to design a database for an online store?

Question

MySQL

They say you need an env scheme, it’s not clear how to make a structure if one product has several colors and the colors can have several product sizes, how to connect it?

Answer 1

one product has several colors and flowers can have several sizes

Something like this:
product
id | article
color
id | hex_code | rgb_code
size
id | rus | eu
offer
product_id | color_id | size_id | count

Answer 2

Well, in fact, you have nothing complicated. You need 3 tables:
1. Products
2. Product properties (color, size)
3. Linking table, where you refer to the first 2 tables with foreign keys.
Thus, you implement a many-to-many relationship (many-to-many) .
Schematically, it looks like this: