-- Migration: Zoom analytics — join_with_others flag
-- Description: Adds join_with_others to hdb_zoom_analytics so reconciliation can
--              mark companions credited via someone else's device, and the KPI
--              aggregation can split self-joins from join-with-others attendees.
-- Idempotent — safe to re-run.

ALTER TABLE hdb_zoom_analytics
  ADD COLUMN IF NOT EXISTS join_with_others BOOLEAN NOT NULL DEFAULT false;

COMMENT ON COLUMN hdb_zoom_analytics.join_with_others IS 'True when this participant attended via another person''s device (no own Zoom session)';
