Postgres Pro
Downloads
Home   >   mailing lists

Multiple foreign keys to the same table - Mailing list pgsql-novice

From JORGE MALDONADO
Subject Multiple foreign keys to the same table
Date
Msg-id CAAY=A7-L=NMY9fkGWDrdZmQWooGCRyeOr_dmUR4t1gXC3ERuzA@mail.gmail.com
Whole thread Raw
Responses Re: Multiple foreign keys to the same table  (David G Johnston <david.g.johnston@gmail.com>)
List pgsql-novice
Tree view
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 by date:

Previous
From: Mike Swierczek
Date:
Subject: Re: Help with a JOIN.
Next
From: David G Johnston
Date:
Subject: Re: Multiple foreign keys to the same table