2 versions of an entity worth distinct table?

Поиск
Список
Период
Сортировка
От gvim
Тема 2 versions of an entity worth distinct table?
Дата
Msg-id 4D17F031.5030603@gmail.com
обсуждение исходный текст
Ответы Re: 2 versions of an entity worth distinct table?  (Thomas Kellerer <spam_eater@gmx.net>)
Re: 2 versions of an entity worth distinct table?  (Radosław Smogura <mail@smogura.eu>)
Список pgsql-general
If a table representing contact details can have 2 but no more than 2 email addresses is it really worth factoring-out
emailaddresses to a separate table. Technically it's a 1-to-many relationship so should be done this way but what is
thegeneral practice out there in such "max. 2" situations? Keeping them as: 

Primary Email
Secondary Email

.... also preserves priority though not strictly normalised, I know.

gvim

В списке pgsql-general по дате отправления:

Предыдущее
От: gvim
Дата:
Сообщение: Standard schemas for common features?
Следующее
От: AI Rumman
Дата:
Сообщение: Postgresql 9 connection problem