Re: 2 versions of an entity worth distinct table?

Поиск
Список
Период
Сортировка
От Radosław Smogura
Тема Re: 2 versions of an entity worth distinct table?
Дата
Msg-id 201012270825.30089.mail@smogura.eu
обсуждение исходный текст
Ответ на 2 versions of an entity worth distinct table?  (gvim <gvimrc@gmail.com>)
Список pgsql-general
Hi,

In this particular case it isn't worth to add separate table just for
additional e-mail.


gvim <gvimrc@gmail.com> Monday 27 December 2010 02:47:29
> If a table representing contact details can have 2 but no more than 2 email
> addresses is it really worth factoring-out email addresses to a separate
> table. Technically it's a 1-to-many relationship so should be done this
> way but what is the general 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 по дате отправления:

Предыдущее
От: Rob Marjot
Дата:
Сообщение: CONSTRAINT does not show when applying a EXCLUDE constraint
Следующее
От: "Gauthier, Dave"
Дата:
Сообщение: Working with v8.3.4 DB using v9.0.1 software