Method exists

server/src/db/notification-db.ts:138–144

(userId: string, type: string, referenceId: string)

  }

  async exists(userId: string, type: string, referenceId: string): Promise<boolean> {
    const result = await query(
      `SELECT 1 FROM notifications WHERE recipient_user_id = $1 AND type = $2 AND reference_id = $3 LIMIT 1`,
      [userId, type, referenceId]
    );
    return result.rows.length > 0;
  }
}