Primary key in ProductAssoc preventing duplicate items for BOM

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Primary key in ProductAssoc preventing duplicate items for BOM

jonwimp
Primary key is [productId, productIdTo, productAssocTypeId, fromDate].

I have a scenario where I may have 2 identical items as BOM components of a product. Reason is
that makes it easier for the machining shop. Consider that for a bicycle frame, I have 1
large-diameter metal tube (down tube), and 2 small-diameter tubes (more actually, but this is just
for simple example). For the 2 small-diameter tubes, they're of different lengths.

For ease of manufacturing, I'd like a BOM with 3 items:

- 1 large-diameter tube unit (meters) 1.45

- 1 small-diameter tube unit (meters) 1.23

- 1 small-diameter tube unit (meters) 0.98

Would it be better if I include sequenceNum in the primary key? Or quantity?

I'm importing data from a legacy system, so the fromDate values can be all similar, thus breaking
the primary key constraint.

Jonathon