versatilewt Posted May 14, 2008 Share Posted May 14, 2008 Hi, I have a project where every lead comes in as a quote, is followed up with, and then finally an order is placed. So, the entry is first in a quote table, and then once all is finalized, it is placed as an order. I'm debating how to approach the table structure, as I'm revising there rest of the application. Would it make more sense to have a separate "orders" and "quotes" tables, or to have a single table with a orders/quotes flag column? If I did the multiple table approach, I would have order_line_item and quote_line_item tables for each as well. Any advice or thoughts will be appreciated. Regards, brian Quote Link to comment Share on other sites More sharing options...
Barand Posted May 15, 2008 Share Posted May 15, 2008 Successful db design goes hand-in-glove with knowledge about the data items (columns) involved and the business processes acting on and changing those items, specifically (in this case) the transition from quote to order. We know none of those Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.