[ic] Database: transactions and orderline

[Mike Heins]

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
basis.

-- 
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".