[ic] Database: transactions and orderline
mike at perusion.com
Fri Jul 30 11:35:47 EDT 2004
Quoting Andre (a.boehlke at syspac.de):
> I would like to discuss why the fields
> - store_id,
> - username,
> - status,
> - shipmode and
> - shipping
> need to be in the transactions _and_ orderline table? This causes
> unnecessary redundancy, doesn't it?
If you are into 3nf, no doubt. 8-)
With regard to the status, this is needed because one item can be
shipped while another is on backorder.
The shipmode and shipping fields are different because some catalogs
have been built that allow different modes for shipping on a per-item
Perusion -- Expert Interchange Consulting http://www.perusion.com/
phone +1.765.647.1295 tollfree 800-949-1889 <mike at perusion.com>
I have a cop friend who thinks he ought be able to give a new ticket;
"too dumb for conditions".
More information about the interchange-users