Hibernate Inheritance Modeling

Question

I'm having trouble creating a model for a couple entities that is sane in both Hibernate and the Database. Any help is appreciated.

A company entity and table exists, which provides both a company name and a "company code". The company code must be unique.

Company's may act as 2 different entities, clients or partners.

We'd like to have separate Client and Partner Entities.

The complicating factors I see are

1) Companies can be both a client and a partner.

2) The company code must remain unique.

3) We want to be able to create new clients and partners passing company_code's as a parameter. eg. new Client("WALMART") and new Partner("WALMART") that should map to the same company.

Single-Table and Multi-Table Inheritance don't work because they don't map a Merchant and Client with the same company code to a single company.

Thanks all.

aperkins · Accepted Answer · 2010-09-16 18:02:35Z

2

Could you have a Company table that the Partner and Client entities have a many-to-one link to? This would allow you to set the company on the partner and client as a descriptor (more of a has-a, although it is closer to a typing) without needing inheritance.

answered Sep 16, 2010 at 18:02

aperkins

13.2k5 gold badges31 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Hibernate Inheritance Modeling

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related