Function getWorkOSOrganization

apps/web/src/lib/user/index.ts:1569–1587

(domain: string)

    WHERE scope_key LIKE 'org:%'
      AND (
        recipients->'userIds' ? ${userId}::text
        OR recipients->'emails' ? ${originalEmail}::text
      )
  `);
  await tx.delete(user_period_cache).where(eq(user_period_cache.kilo_user_id, userId));
  await tx
    .delete(kilo_pass_scheduled_changes)
    .where(eq(kilo_pass_scheduled_changes.kilo_user_id, userId));
  await tx
    .delete(github_branch_pull_requests)
    .where(eq(github_branch_pull_requests.owned_by_user_id, userId));

  // Moderation data. Blocks/mutes key on the blocker's Kilo user id; the
  // other column is a GitHub login, so only the blocker side is deleted.
  await tx
    .delete(content_moderation_reports)
    .where(eq(content_moderation_reports.kilo_user_id, userId));
  await tx.delete(user_moderation_blocks).where(eq(user_moderation_blocks.blocker_user_id, userId));
  await tx.delete(user_moderation_mutes).where(eq(user_moderation_mutes.blocker_user_id, userId));
  await tx.delete(user_terms_acceptances).where(eq(user_terms_acceptances.kilo_user_id, userId));

  // Quick chat threads and messages are user-owned, so they are hard-deleted