Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Hibernate unidirectional one to many association - why is a join table better?

In this document (scroll down to the Unidirectional section):

http://docs.jboss.org/hibernate/stable/annotations/reference/en/html_single/#entity-mapping-association-collections

it says that a unidirectional one-to-many association with a join table is much preferred to just using a foreign key column in the owned entity. My question is, why is it much preferred?

like image 513
UrLicht Avatar asked Aug 20 '09 16:08

UrLicht


1 Answers

Consider the situation where the owned entity type can also be owned by another parent entity type. Do you put foreign key references in the owned table to both parent tables? What if you have three parent types? It just doesn't scale to large designs.

A join-table decouples the join, so that the owned table has no knowledge of the parent table(s), allowing the design to scale elegantly.

like image 85
skaffman Avatar answered Oct 09 '22 23:10

skaffman