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

Is it good to have a price column imn OrderLine table

From	"Tony Johansson" <johansson.andersson@telia.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Is it good to have a price column imn OrderLine table
Date	2014-02-26 23:26 +0100
Organization	A noiseless patient Spider
Message-ID	<lelpn8$8sq$1@dont-email.me> (permalink)

Show all headers | View raw

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

Back to comp.databases.ms-sqlserver | Previous | Next — Next 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