i have a table stracture which lends itself to table per subclass design. my "base" table has many common fields and each one of the children also has many fields that are unique for that entity. this works very well with joined-sublass where the common fields are added to the child entities through inheritance. the base is linked to the childeren through a common PK However, one of my tables has to be split (due to database replication limitations) and i would like to have the one-to-one mapping of these two tables as a single object. in isolation this would work using the join mapping, but since this class is also inheriting it is not working.
e.g.: DB stracture base - col1 normal_child - col2 split_child1 - col3 split_child2 - col4
abstract entity1- col1 entity2 : entity1 - col1, col2 entity3 : entity1 - col1, col3, col4
is this possible (and what version supports it)? how should the mapping look like
thanks