Hi guys i am working in a web application. I have entities as BaseEntity -->Which contains user login info like createdBy,createdTime,EditedBy,editedTime Employee --> which contains employee information like name,address,etc... RegularEmployee -->which contains salary ,bonus tht kind of fields and ContactEmployee --> which contains HourlyRate,contactPeriod etc....
My inheritance structure is BaseEntity <--- Employee <---- RegularEmployee
(i.e. Employee extends BaseEntity and RegularEmployee extends Employee ContractEmployee also extend Employee Class ).
How to design database structure in this case considering all the tables have id and version fields (all tables should at least have these two fields). I have gone through the inheritance strategies of hibernate but for 1st level inheritance i can achieve but wat to do for 2nd level inheritance in hibernate ? How to design database in this case ?
|