Create simple hierarchy in Rightsholder tables
Allow for parent-child relationships in Rightsholder to better manage the relationships that we realistically have with publishers (i.e. better tracking and management of publisher mergers and acquisitions). It would also help reporting on publishers because there would be an established relationship I could query against.
Christina Sirois commented
I think a group would be great!
I can't imagine a reason a rightsholder would need to be in more than one group, but perhaps that is because the use case I have for this is in tracking parent-subsidiary relationships of publishers - this would make it much easier for me to report on our overall relationship with large rightsholders like Random House, Simon & Schuster, etc etc.
Due to M&A activity in the publishing sector, though, we would need to be able to move rightsholders between groups (i.e. a one small publishing house is sold to another small publishing house) and make an established rightsholder a child of an existing parent (i.e. a large publishing house buys and independent publisher) as well as break away a child from a parent (i.e. the unlikely case a small publisher regains it's independence from a large publisher).
Let me know if you need more info, though! I am happy to provide.
This is a neat idea and one we haven't heard before. Would it be helpful to have a rightsholder group you could assign them to? That would allow you to still have the individual rightsholders but still combine them in the case of mergers or other relationships that have them associated.
And if so, would a rightsholder need to be part of more than one group?