Match candidates

M2 admin-curated stand-in for full Rosetta match-surfacing (§RS.3.3). Curate one row per Founder × Counterparty match candidate. Founders see their own candidates filtered by their current Capital Path on the web app.

+ Curate a new match candidate

Failed query: 
    SELECT mc.id,
           founder.email AS founder_email,
           cp.email      AS counterparty_email,
           mc.counterparty_kind,
           mc.match_purpose,
           mc.industry, mc.topic, mc.capital_path, mc.business_stage,
           mc.status, mc.created_at
      FROM match_candidates mc
      JOIN persons founder ON founder.id = mc.founder_person_id
 LEFT JOIN persons cp      ON cp.id = mc.counterparty_person_id
     ORDER BY mc.created_at DESC
     LIMIT 200
  
params: