I'm working with some historic data in a Civi database. For about ten years now we have created a custom field set each year to collect the same two pieces of information via an annual survey. We did it this way rather than using a field set which could store multiple values, because of perceived issues accessing data from multi-value fields (via Views etc.).
So I've now got ten custom field sets, and I'd like to move the custom fields into one larger field set. But the fields from one set have the same machine name as the fields in another set, and so Civi won't let me move them into the same custom field set.
Of course it's easy to change the field label via the UI, but there's no way to edit the machine name of the field. My assumption is that editing custom field names is problematic, otherwise there would probably be a way to do it. So before I get into the database and start editing field names there, I thought it best to ask: will editing field names in the DB break things? Is there a better way to do it, or am I stuck with what I've got?