The only time the orders_products table will have multiple, duplicate products_model entries is if the customer orders two of the model. Since each could still have separate attributes, they are tied together in the orders_products_attributes table.
The order_id is tied to the orders_products_id and then to the orders_products_attributes_id
The duplicate products_model entries are given separate orders_products_id. The separate orders_products_id entries then get the tied to the appropriate orders_products_attributes_id.
Beat me to it.
Bookmarks