Database Design Advice

[Smylers]

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