I have table A, table B and table C.


table A {
id_col (Primary Key)
}

table B {
asociation (Primary Key)
id_col (Foreign Key)
name
other fields
}

table C {
asociation (Primary Key)
other fields
}

This model was defined by "the architect" and I can't modify it.

In my object model C is a subclass of B.

I like to have a collection map from A (index is id_col and key is name both from table B).
I already know this is supported, however map can contain instances from B and C.

Is it possible this kind of mapping?

I appreciate any suggestions or alternative solutions.

TIA

Sure, sounds like a standard joined-subclass mapping, together with a standard polymorphic collection. No problem here.