In which table to store order attributes?

Question

Laravel

Build a many-to-many relationship. In the intermediate table I store id-заказаand id-товара. But where to store the attributes. The first thing that came to mind is here, in the intermediate table. The only problem is that pivotI can only access this table through order_idand product_id. How to reach the rest of the fields with type attributes, coloretc.?
Or is my approach fundamentally wrong and a separate table is needed for attributes (then it will complicate everything, I don’t know how to organize it)?
I would be grateful for help.

Answer 1

withPivot will add any fields to the relationship. If there are many attributes, you can make some kind of OrderDetail and associate with orders