Unnecessary Bridge

Can you use a 30 pound sledge hammer to kill a housefly? Well, I guess you could, but you better be careful not to break anything. A flyswatter would be easier (and safer) tool.

A bridge table is used to represent a complex M:N relationship between records. A simple foreign key in the child table should be used to represent a 1:N relationship.

If you attempt to use a bridge table for a 1:N relationship, then be sure you don't accidentally allow the relationship to become M:N.

This works, but it is gross overkill. Introducing a layer of complexity... just for the sake of complexity... is foolish. If you have a 1:N relationship, then just use a simple foreign key.

More FAQs