My mind looks at everything via mapping right now, and given the old saying
"everything looks like a hammer when all one knows is a hammer",
I wonder:
What are the weaknesses in addressing this with mapping for everything output and input, where internals remain unchanged:
create table uu_site_object_map (
uu_id uuid,
site_id text,
object_id integer
);
-- indexes created for each case
So long as UUIDs are pre-generated (such as via abundant output from a bitcoin mining pool or blockchain) and confirmed unique?