From: Johan De Meersman
Date: December 9 2010 2:35pm
Subject: Re: Design: how to prioritise 1-to-many fields
List-Archive: http://lists.mysql.com/mysql/223767
Message-Id:
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=90e6ba53acf4eccb740496fb275c
--90e6ba53acf4eccb740496fb275c
Content-Type: text/plain; charset=ISO-8859-1
On Thu, Dec 9, 2010 at 3:33 PM, gvim wrote:
> I have a typical contact database which caters for multiple email addresses
> with a distinct Email table keyed to a foreign key inside the Contact table,
> ie. a 1-to-many relationship. However, I want to prioritise these Email
> entries for a given Contact entry so all I can think of is to add a numeric
> Priority field alongside the Address field inside the Email table. Is this
> the best/standard solution or is there another way?
>
That would be it, I guess, yeah :)
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
--90e6ba53acf4eccb740496fb275c--