Database Design Advice

Smylers Smylers at
Fri Nov 8 15:49:27 GMT 2013

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.

The UK gov's proposed gagging law will suppress protest and campaigning by
charities and political groups. Read more:
Please sign this petition:
Oxfam • BHA • Quakers * Countryside Alliance • League Against Cruel Sports • CND

More information about the mailing list