Mutiple FK columns all pointing to the same parent table - a good idea?
Posted
by Randy Minder
on Stack Overflow
See other posts from Stack Overflow
or by Randy Minder
Published on 2010-05-14T19:01:39Z
Indexed on
2010/05/14
19:04 UTC
Read the original article
Hit count: 175
sql
For those of you who live and breath database design, have you ever found compelling reasons to have multiple FK's in a table that all point to the same parent table?
We recently had to deal with a situation where we had a table that contained six columns which were all FK columns to the same parent table. We're debating whether this indicates a poor design on our part or whether this is more common than we think.
Thanks very much.
© Stack Overflow or respective owner