Currently I am trying to create a database design that is long lasting. But I hit a point where I not know how to continue.
I have a
object table in my database. That tables stores one unique object (With a incremental ID). However for the application I am creating attributes about that object are required (extra information so a sort of metadata for that object).
These are now five different attributes per object. But I already know in the upcoming future they want more attributes added to a object so they can get more information about it.
If it would have stayed with those five attributes a would create extra columns in the
But now I am thinking to create seperate
attributes table where I store that data. And I was thinking in the sorts of:
object_data. Is this the best practice or what are your thoughts on the matter?