We are planning the data schema for our project. Currently we have a table with classifications, but there is the possibility of a new classification in the future which would require a new field to store associated data.
Is it better to extend an existing table or create a child table with a FK reference to the existing table? I assume creating a child table with a FK to the existing table is the better option because the existing database schema remains stable.
- We're committed to a relational database so an advice on choosing NoSQL is not what we're looking for.
- Keep in mind that the changes aren't expected to be frequent.