question about database design
From: Michael <no_at_spamplease.com>
Date: Mon, 21 Jun 2004 11:03:51 +0200
Message-ID: <a58dd0pnmgus6rpq3iftpp891t19o7cbvg_at_4ax.com>
I have a question about the design of a database structure.
Date: Mon, 21 Jun 2004 11:03:51 +0200
Message-ID: <a58dd0pnmgus6rpq3iftpp891t19o7cbvg_at_4ax.com>
I have a question about the design of a database structure.
I have a customer that has a pricegroup:
Customer PriceGroup 1234 2 3245 3
I have a collegue who like to create a price table this way:
Article PriceGroup1 PriceGroup2 PriceGroup3
A 14 12 7 B 24 23 19
I myself think this one is the better option:
Article PriceGroup Price A 1 14 A 2 12 A 3 7 B 1 24 B 2 23 B 3 19
Can anyone help me what is the best solution? Maybe another one? :)
Thanks,
Michael
Received on Mon Jun 21 2004 - 11:03:51 CEST