Database Design Advice
Smylers at stripey.com
Fri Nov 8 15:49:27 GMT 2013
> On Fri, Nov 08, 2013 at 11:43:08AM +0000, Smylers wrote:
> > A discount can either be a percentage or a value in euros. I can
> > think of several suboptimal ways of representing this:
> I opted for two columns, "additional" and "percentage", the first
> defaulting to 0, the other to 1. Prices can then be easily calculated
> as original_price * percentage + additional. No conditionals needed.
Good idea. Ta.
The UK gov's proposed gagging law will suppress protest and campaigning by
charities and political groups. Read more: http://civilsocietycommission.info/
Please sign this petition: http://38d.gs/1cJ9ViA
Oxfam • BHA • Quakers * Countryside Alliance • League Against Cruel Sports • CND
More information about the london.pm