Can I create many tables according to the same entity?

Question

What I want to do is that I want to make the many tables dinamically which are the same entity structures. And then I want to refer to the dinamically created tables according to the table name. What I understood from hibernate reference is that I can only create only one table and it should be matched exactly with entity. So I can't find any solution to my problem.

If you know any relevent open source related to my problem or any tip or web site, let me know.

Thanks allways

Answer 1

Does it need to be separate tables? Maybe you can add a field called EntityTypeID that is a foreign key to one other table that describes the type for that record? Then you can query the objects separately?