Hello all,

I am trying to create an inheritance model for 2 objects

Person and Employee, where the relation between the 2 of them is:

Employee extends Person.

In the other side my legacy relational model includes 3 tables


Person: Table with all the details of the person including a person_id as a PK

InterfaceTable: a table that works as an interface between our person table and our Employee table, used inside the data model as an isolation layer (it translates between employee_ids and person_ids), It includes both a person_id and an employee_id

Employee table: Table with the employee details including an employee_id as PK

Would somebody help me trying to find the best aproach for the mapping of this situation?

Thanks in advance


Hibernate version: 3.0.1