I want users to be able to create their own Tags for articles, but I also want to curate these tags to better structure articles etc. Therefore I have 2 places for Tags - a data type for User Created Tags, and an option set for Curated Tags with a few other attributes.
Essentially users would use the existing Curated Tags, but if they feel the need to create a new tag, it will go into the User Created Tags data type.
To maintain speed, I will periodically curate the custom tags and add them to Cureated Tags, deleting the entry in the User Created Tags data table. Some User Created Tags will be removed if I think they’re hardly used, but may still exist in some articles.
As the Tags field on articles is a text list, there’s no issue with the tag being deleted and not being in the Cureated Tags option set, until the user wants to edit their article - if they do, and the tage deosn’t exist anywehre, it gets deleted from the list of tags on the article.
When the user decides to edit their article, I want to be able to check the database for all their tags, and if one is missing, recreate it in the User Created Tags table.
Any ideas on how to set up this workflow?
NB - this is not the actual scenario, but helps illustrate exactly what I am trying to achieve.