Multiple foreign keys to the same table

Поиск
Список
Период
Сортировка
От JORGE MALDONADO
Тема Multiple foreign keys to the same table
Дата
Msg-id CAAY=A7-L=NMY9fkGWDrdZmQWooGCRyeOr_dmUR4t1gXC3ERuzA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Multiple foreign keys to the same table  (David G Johnston <david.g.johnston@gmail.com>)
Список pgsql-novice
Hi,

I have a table which has 2 fields (among others): origin and destination. Also, I have a single table that represents both origins and destinations. If these 2 tables are to be related through foreign keys then both fields in the first table will point to the second table. Is this a good practice in database design? If not, what is a solution besides making 2 separate tables out of the second one?

Respectfully,
Jorge Maldonado

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

Предыдущее
От: Mike Swierczek
Дата:
Сообщение: Re: Help with a JOIN.
Следующее
От: David G Johnston
Дата:
Сообщение: Re: Multiple foreign keys to the same table