Re: database modeling suggestion
Posted by: Chris Bassett
Date: October 02, 2014 11:13PM

Found a "workaround" for now (I am still open to suggestion, though).

I am going to store a "!" and the sales order number (such as !300000) for the serial number if there is no serial number associated with the particular row.

Basically, I modified the design to make the serial number a primary key, sales order number, qty, and product ID all unique values (from the serialNumbers table). This seems like it will work for now. It is probably not the best solution, so if anyone has any better suggestions, please do.

Options: ReplyQuote


Subject
Written By
Posted
October 02, 2014 09:21PM
Re: database modeling suggestion
October 02, 2014 11:13PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.