First I'd like to point out that I am not asking people to give me the mapping. I've been strugging with NHibernate for the past few days, and ran into a few problems with a couple mapping.
In this schema, the ReportParty table is serving as a glorified association table so to speak. It has a one-to-many relationship with both the Report table and the Party table, but with additional fields. I'd like to use the following middle tier structure.
I'm not sure if inheritance is the most intuitive way of mapping this. But I'd like to have the ReportParty object inherit from the Party object. And report should have a collection of ReportParty objects. Is this achievable?
Again, I'm not seeking handouts. Just need the experts to point me in the right direction of how to either map them the way I intended or a way that is possible by hibernate's design.