I'm using legacy database schema where is one table (e.g. laboratory) and for each laboratory exists one table (e.g. [laboratory_shortcut]_order) with same structure.
id - shortcut - description
1 - bio - biochemistry
2 - hem - hematology
and there are two tables bio_order and hem_order. These tables have same structure.
I wish make one entity (Order) that could be mapped sometimes on first table (bio_order) and sometimes on second table (hem_order).
I know that this db schema is terrible but I must use it :(
Thx for advice
You still got no way to solve the problem? I have the same :(