Hi
Why do some ecommerce database have tables:
- product
- product_variant
Why not only one product table with all teh fields of product_variant and is_default_product(bool) field?
Thanks
Hi
Why do some ecommerce database have tables:
Why not only one product table with all teh fields of product_variant and is_default_product(bool) field?
Thanks
This is called Slowly Changing Dimension
There are some approaches to implementing it which have their benefits and drawbacks.
Solution with two tables allows easier referencing to products (as opposed to product versions) from other tables.