Disclosure: I'm the founder of CollectSocials. This is an engineering write-up of a data-modeling problem I ran into while evaluating UGC-rights tools, including building our own. I've kept it to what I could reproduce and to schema-level reasoning, not vendor bashing.

This is a rewritten, developer-focused version of an article originally...