Hello Everyone,
I'm facing a question regarding my database setup. Currently, I'm utilizing a database with multiple columns and data. Some of this data serves for translation purposes, while others are for quick API calls. Notably, some columns are enumerated types and objects.
While these columns are exclusively used for the front end and aren't directly linked to any other table, I do have other databases utilizing similar types of data. My query is: Is there a method for me to automatically update all other enum columns or object columns with the same type of data when I make updates, rather than having to do it manually?
Thanks in advance for any insights or suggestions.
For example, if I'm listing all the colors in one enum column, and I realize I forgot one, I'd like to add it in a way that automatically updates all the other enum columns displaying colors with this new option.