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

Filed under:

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

Related posts about sql