How to design a database to link a warehouse with materials and their properties?

Question

MySQL

There are tables of this type:

There are N warehouses (Warehouse A)
There are Y materials (T-shirt, Sweatshirt, Mug), materials have X properties (Color, Gender, Size, etc.)
How to create a table to store the quantity of goods in a warehouse?
Example 1
"Warehouse A" has 10 men's green T-shirts in size XL
Example 2
"Warehouse A" has 5 white mugs

Answer 1

You now have a description of conditionally "prototypes" and not specific materials.
There are materials, there are properties, there is a connection between them - but there are no concrete objects.
We start new plates to describe the actual unit of goods
1) good
good_id (pri, ai)
material_id
, if desired, you can add a name
2) good_property
good_id (pri)
property_id (pri)
value
And a plate for storing the remains of a particular product in a particular warehouse
3) xref_good_warehouse
good_id ( pri)
warehouse_id (pri)
value