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
Список
Дерево обсуждения
Multiple foreign keys to the same table JORGE MALDONADO <jorgemal1960@gmail.com>
Re: Multiple foreign keys to the same table David G Johnston <david.g.johnston@gmail.com>
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 по дате отправления
