Hi all, i have a parent entity Service and a child ExtendedService in a SINGLE_TABLE inheritance.
A third entity ServiceCollector need to include both entites Service and ExtendedService. This is a fixed requirement, and with this design i can realize it using polymorphism.
THE PROBLEM: Very often i need to retrieve ONLY the parent class Service, so i query it by discriminator column... i think this is a bad design for my purpouse, isn't true?
This is a simple example, indeed i have a lot of Service subclasses, think for example to a shop that sell different product, each product can have a different properties.
Thanks in advance.