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

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

X-Received	by 10.182.22.133 with SMTP id d5mr4860305obf.27.1393529017225; Thu, 27 Feb 2014 11:23:37 -0800 (PST)
X-Received	by 10.50.126.39 with SMTP id mv7mr289071igb.15.1393529017043; Thu, 27 Feb 2014 11:23:37 -0800 (PST)
Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!uq10no1876686igb.0!news-out.google.com!h8ni3igy.0!nntp.google.com!uq10no1862266igb.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.databases.ms-sqlserver
Date	Thu, 27 Feb 2014 11:23:36 -0800 (PST)
In-Reply-To	<lelpn8$8sq$1@dont-email.me>
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=15.219.153.73; posting-account=qJFqbQkAAACYQSLN0-cvP6ydkRfuOu6u
NNTP-Posting-Host	15.219.153.73
References	<lelpn8$8sq$1@dont-email.me>
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<0389e551-26ff-4916-ab85-159dab7b3909@googlegroups.com> (permalink)
Subject	Re: Is it good to have a price column imn OrderLine table
From	Mark D Powell <markp28665@gmail.com>
Injection-Date	Thu, 27 Feb 2014 19:23:37 +0000
Content-Type	text/plain; charset=ISO-8859-1
Xref	csiph.com comp.databases.ms-sqlserver:1698

Show key headers only | 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 | Unroll thread

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