Ruby on Rails下同一列中2个表之间的2个关系的问题

发布于 2024-10-20 21:20:03 字数 537 浏览 2 评论 0原文

我有一个疑问，我正在 Ruby on Rails 网站上创建一个朋友的平台；我有一个名为 users 的表和一个名为 friends 的表，用于管理用户之间的友谊。在朋友中，我有2个字段，*user_id1*和*user_id2*。这是我在模型中建立的关系：

class User < ActiveRecord::Base
    has_many :friends
end

class Friend < ActiveRecord::Base
    belongs_to :user, :foreign_key => "user_id1"
    belongs_to :user, :foreign_key => "user_id2"
end

这是处理这种情况的好方法吗？另一个想法是创建另一个模型，该模型指向数据库中的同一个表 userAux，并将其用于关系。你认为什么是最好的？你有更好的主意吗？

提前致谢。

原文

I have a doubt, Im making a friend's platform on a Ruby on Rails site; I have a table called users, and a table called friends that manages the friendships between the users. In friends I have 2 fields, *user_id1* and *user_id2*. This is the relationship I made in the models:

class User < ActiveRecord::Base
    has_many :friends
end

class Friend < ActiveRecord::Base
    belongs_to :user, :foreign_key => "user_id1"
    belongs_to :user, :foreign_key => "user_id2"
end

Is this a good way to handle this situation? Another idea is create another model that points to the same table in the database, userAux, and use it for the relationship. What do you think is best? Do you have a better idea?

Thanks in advance.

分享到QQ

分享到微博