One relationship for different entities

Question

symfony

There is a base entity, from it, let's say 100 other entities are inherited, which are generally similar, but may contain different sets of fields, etc.
All concrete entities must be able to communicate with each other.

When solving head-on, two problems arise:
- In each entity, you will have to describe all possible relationships with another specific entity
- The data will be denormalized - the data related to the base entity will be duplicated in the table of each specific entity

What we would like:
- The base entity is stored in a separate table
- The base entity has a one-to-one relationship with a specific entity, the identifier and name of the specific entity are used for the relationship.

How to implement this in Doctrine correctly?
Is it even possible to implement this in Doctrine?
How would you do it?

Answer 1

What you describe is very similar to Inheritance Mapping .
You can create a base entity and subentities with their individual properties. All data is stored in one table. You can make selections from the entire list or from specific subentities.