List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:December 9 2010 3:51pm
Subject:RE: Design: how to prioritise 1-to-many fields
View as plain text  
>From: gvim [mailto:gvimrc@stripped]
>Sent: Thursday, December 09, 2010 9:33 AM
>To: MySQL
>Subject: Design: how to prioritise 1-to-many fields
>
>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?
>
[JS] Sounds about right to me, but don't use a sequence like 1, 2, 3. Use 10, 
20, 30. You never know when you'll have to squeeze in a new priority level, 
and you don't want to have to renumber them all.


Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341
E-mail: jerry@stripped
Web site: www.the-infoshop.com



>gvim
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:    http://lists.mysql.com/mysql?unsub=1




Thread
Design: how to prioritise 1-to-many fieldsgvim9 Dec
  • Re: Design: how to prioritise 1-to-many fieldsJohan De Meersman9 Dec
  • RE: Design: how to prioritise 1-to-many fieldsJerry Schwartz9 Dec
Re: Design: how to prioritise 1-to-many fieldsJan Steinman12 Dec