Ternary association

herrera · **Posted:** Wed Nov 12, 2003 2:03 pm

I have a problem to understand about ternary association .

I have 3 tables in my db :

Code:

tb_Person 
    idPerson numeric(10) not null  //Pk
    dsPerson varchar2(30) 
    ....

tb_Groups
    idGroup  numeric(10) not null   /Pk
    dsGroup  varchar2(3)
    ...

and I need a relation table between tb_Person and tb_Groups :

tb_PersonGroup
    idPerson        // Fk - tb_Person
    idGroup        //  Fk - tb_Group

ie, One Person might has many Groups

  

The hibernate plugin to Middlegen

emmanuel · **Posted:** Wed Nov 12, 2003 3:01 pm

This should not be mapped as a ternary association but as a simple many-to-many association. tb_personGroup is just your association table, and then no PersonGroup object will be generated.