How to bind multiple database tables of the same type to one Entity in Symfony?

Question

symfony

For example, I want to store news by year, as there will be a lot of them in a year. And to facilitate the work of the database, I would like to lay them out in tables news2018, news2019, news2020. The main idea is to lay out the data of one entity in different tables and work with them through one repository!
In fact, I need one Entity\News entity, which will be the same for any news2018, news2019, news2020 table. And one Repository\NewsRepository for requests.
In principle, you can create a factory (if I don’t confuse anything) that will create instances of Entity\News2018 entities ..
But will you also need to redo the Repository class ??
Maybe it's possible to make it easier and I'm complicating everything? (really a lot of data to store in one table)

Answer 1

What for? The database itself will figure out how it is easier for it, the main thing is to arrange the indexes, it will not become easier for it from a dozen tables, and the code will become an unsupported garbage can.
Don't do it.