Designing an append-only consent ledger: how we record UGC rights so a deleted approval can't erase the proof

Disclosure: I'm the founder of CollectSocials. This is a build-log about a data-modeling decision, written for people who design systems of record. It's the constructive companion to a more critical p