Manage database storage for default and custom options of select

I am getting crazy to find the best and scalable way to manage select dropdown options. I have a set of default options like:

• Pending
• Open
• Closed

As they are default for all teams of my app, I don't want to save them into database for each team as this would give me issues to align all previous team to this new feature.

Team can then customize the above default options and in this case the new options will be saved into a MYSQL database table, like:

1. New option -> id=1
2. Another new option -> id=2

My issue is: How store default and custom data, considering that the first have not IDs? Data from default and from custom shall be saved into a column when chosen, but I need to find the way to make them in the same logic.

thanks!

https://stackoverflow.com/questions/65783162/manage-database-storage-for-default-and-custom-options-of-select January 19, 2021 at 06:53AM