views:

59

answers:

0

I have a datamodel that has an intermediate table to manage relationships between entities.

For example, tables Person and Organization are related through the Relationship table

Party (table) - ID

Person (table) - ID (references Party.ID) - name

Organization (table) -ID (references Party.ID) -name

Relationship (table) -ID (PK) -type (references relationshiptype lookup) -fromID (references Party.ID) -ToID (references Party.ID) -fromDate -ToDate Type+fromID+ToID+fromDate+ToDate is guaranteed to be unique.

How do I manage this using hibernate?

TIA