I want users to be able to dynamically add 'columns' from the front-end of the website. I understand that it is probably not best practice to actually add columns to a table from the front-end, so I was looking for a better way to handle this.
The use case:
I am making an app with a determination table. The user can fill out details of the animal/plant (for example leaf shape) and is supposed to end at the right species.
I want to make it future proof, so that if someone fills out all details and the species they have is not the one the table comes up with, the user can add both their species, and the detail that would tell both species apart.
For example: if the user found a daisy but the table comes up with dandelion, the user could add the daisy and add 'petal colour' as a distinquishing feature.
Users should then be able to fill out the petal colour for all plants that were already in the database.
My database at the moment:
I have one table where all details (like species name, leaf shape etc.) are stored in columns.
My webiste: I use angular 7 for the front-end, PHP on the server and a MySQL database, but general answers are also very welcome.