Composite key vs Serrogate for SeqId

Posted by cjhowe on
URL: http://ofbiz.116.s1.nabble.com/Composite-key-vs-Serrogate-for-SeqId-tp174109.html

I've been continuing my playing around with some of
the pentaho project stuff and there's a limitation
with their query structure that doesn't support
composite foreign keys.  While there are several
places in OFBiz where the composite key holds meaning
with the data model, I was reluctant to see the
benefit of using a composite key for entities like
OrderItem (orderId, orderItemSeqId) over simply having
an orderItemId  as a single field primary key.  Does
the sequence (01,02,03, etc) hold any meaning that
needs to be maintained?