Now, assume that I have only one entity and that its fields are mapped to columns in T3, T5 and T6. I dont have any other entities. Is it possible to make this mapping (in HIbernate/JPA)? (I think it is not, but would very much appreciate someone's oppinion on it).
The question I wanted to ask above (and I guess I did not ask it right) was if, for example, the primary table to which my entity if mapped is T2, then I could use @SecondaryTable annotation to map some of its fields to tables T1 and T4, but I cannot map any of its fields to tables T3 and T6. In other words, I can map a single entity to multiple tables that are in "star"-like schema (they have to be immediate neighbours of the primary table to which the entity is mapped).
If your question is can I have one single entity that is mapped to 6 different tables where the primary table does not have a relationship with some of the tables the answer is no. In this case you would have to create another entity to be used in the composition to define those relationships on.