views:

49

answers:

1

Hi

Why do some ecommerce database have tables:

  1. product
  2. product_variant

Why not only one product table with all teh fields of product_variant and is_default_product(bool) field?

Thanks

+2  A: 

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.

Quassnoi
Can you please give example for more easier referencing to products from other tables?
Yosef