Storing a list of unknown object types in an RDBMS?

Background

Im working on a game and i want to persist the gameworld. This gameworld is made out of entities looking like this.

    public class Entity{        public Set<Object> obj;      }  

There many, many different object types i need to store, about 100. Thats why the list of objects is required. Some of those objects reference other "Entity" objects aswell. Causing circular references.

Question

Is there a way to define such a loose 1:n relation in sql ?

https://stackoverflow.com/questions/66485281/storing-a-list-of-unknown-object-types-in-an-rdbms March 05, 2021 at 09:05AM