ALTER TABLE manager_insights
    ADD COLUMN IF NOT EXISTS scope_department VARCHAR(100);

CREATE INDEX IF NOT EXISTS manager_insights_tenant_scope_created_idx
    ON manager_insights (tenant_id, scope_department, created_at DESC);
