[ic] Database: transactions and orderline

Mike Heins mike at perusion.com
Fri Jul 30 11:35:47 EDT 2004

Quoting Andre (a.boehlke at syspac.de):
> Hallo,
>   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

Mike Heins
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 mailing list