Differance between mshop_product, mshop_product_list and mshop_product_property table

[ahmed31916]

Hello,

I found that most of the main tables, such as Product, Attribute, etc., have a relation with a table with the same name, but by adding the property and list.

For example: the products table contains mshop_product, mshop_product_list and mshop_product_property table.
So, what the difference between them?

[aimeos]

- mshop_product: Main table for basic product data
- mshop_product_list: Reference table (m:n) for associating attributes, media, prices, other products, texts, etc. to products
- mshop_product_property: For storing product properties that are not shared with other products (e.g. width, length, height, etc.)