Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1698

Re: Is it good to have a price column imn OrderLine table

Show all headers | View raw

On Wednesday, February 26, 2014 5:26:26 PM UTC-5, Tony Johansson wrote:
> We have a many to many relations between Order and Product table.
> 
> We therefore create a connection table in between and call it OrderLine.
> 
> In the product table we have for example a field called Price for a specific 
> 
> product.
> 
> 
> In the OrderLine table we have field such as OrderId and ProductId and 
> quantity.
> 
> Now to my question is it good to have a price column in the OrderLine table. 
> 
> ?
> 
> If we have a price will that mean the total price per line
> such as if we have ordered 3 shoes and this specific shoes cost 10 the price 
> 
> field in OrderLine would be 30
> 
> //Tony

I also would expect to see both a unit price column and a quantity ordered column on the order detail line.  Totaling can be done on the invoice so it does not have to be stored on the order line item.

HTH -- Mark D Powell --

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

Is it good to have a price column imn OrderLine table "Tony Johansson" <johansson.andersson@telia.com> - 2014-02-26 23:26 +0100
  Re: Is it good to have a price column imn OrderLine table Erland Sommarskog <esquel@sommarskog.se> - 2014-02-27 08:06 +0000
    Re: Is it good to have a price column imn OrderLine table rja.carnegie@gmail.com - 2014-02-27 03:22 -0800
      Re: Is it good to have a price column imn OrderLine table Erland Sommarskog <esquel@sommarskog.se> - 2014-02-27 11:50 +0000
  Re: Is it good to have a price column imn OrderLine table Mark D Powell <markp28665@gmail.com> - 2014-02-27 11:23 -0800

csiph-web