Database Design Advice

Abigail writes:
> 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.
Smylers
--
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