I have a case that I am not able to know its terminology other than the title of this question. The case is like the following:
There are three entities (tables), orders
, products
and features
, where orders
has Many to Many relation with products
through junction table order_products
and products
has Many to Many relation with features
through feature_products
table.
Identically, it means that the same product may has different features through one or more orders. For example, suppose that product is a chocolate cake and in one order we have:
- 2 Chocolate Cake: plain, small size and diet
- 1 Chocolate Cake: decorated, medium size, Coconut added and candle
- 1 Cocolate Cake: plain, big size
- 3 Cheese Cake: cinnamon, banana
I have no idea how could I maintain this relation when the same product may have one or more from its related features in a specific order.