Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #1694
| Path | csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!feeder.erje.net!eu.feeder.erje.net!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail |
|---|---|
| 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 | Wed, 26 Feb 2014 23:26:26 +0100 |
| Organization | A noiseless patient Spider |
| Lines | 16 |
| Message-ID | <lelpn8$8sq$1@dont-email.me> (permalink) |
| Mime-Version | 1.0 |
| Content-Type | text/plain; format=flowed; charset="iso-8859-1"; reply-type=original |
| Content-Transfer-Encoding | 7bit |
| Injection-Date | Wed, 26 Feb 2014 22:26:48 +0000 (UTC) |
| Injection-Info | mx05.eternal-september.org; posting-host="8fdc2b5af81c338deb7045fc6c39b0e2"; logging-data="9114"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+iUvmbwcuc5K9ufR3ftUAH" |
| X-MimeOLE | Produced By Microsoft MimeOLE V6.0.6002.18463 |
| X-Newsreader | Microsoft Windows Mail 6.0.6002.18197 |
| Cancel-Lock | sha1:x2fXAgmju+M13pFyLMT0YevqdHU= |
| X-Priority | 3 |
| X-MSMail-Priority | Normal |
| Xref | csiph.com comp.databases.ms-sqlserver:1694 |
Show key headers only | 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
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