Laravel多对多关系查询 [英] Laravel many-to-many relationship query

问题描述

我正在构建一个带有用户表和活动表的Laravel应用程序，并通过称为分配的数据透视表实现活动和用户之间的多对多关系:

I am building a Laravel application with a users table and an activities table, and a many-to-many relationship between activities and users implemented with a pivot table called assignments:

• 用户:id，...
• 活动:id，...
• 分配:id，activity_id，user_id，...

我需要记录用户每次完成活动的时间.用户可以多次完成相同的活动.我正在尝试确定在数据库中建模的最佳方法.据我所知，这些选项是:

I need to keep a record of each time a user completes an activity. A user can complete the same activity many times. I am trying to decide on the best way to model this in the database. The options as far as I can see are:

1. 表补全:id，assignment_id，...
2. 第二个数据透视表补全:id，activity_id，user_id，...

我可以创建迁移等.但是，我在Model类及其关系方法方面苦苦挣扎.特别是对于上面的第一个选项，我将如何定义所需的Model类和关系方法?

I can create the migrations etc. However I am struggling with the Model classes and their relationship methods. In particular, for the first option above, how would I define the required Model classes and relationship methods?

推荐答案

好吧，除了活动跟踪之外，您几乎可以对所有内容进行排序.所以，这是我的建议:

Well, you have pretty much everything sorted except the activity tracking. So, here's what I propose:

用户表

带有列ID，名称，电子邮件等

with columns id, name, email, etc

活动表

带有列ID，名称等

用户活动表(枢轴)

user_activity table (pivot)

具有列ID，用户ID，活动ID等 该表将包含用户和活动之间的多对多映射.

with columns id, user_id, activity_id, etc This table will contain the many to many mapping between users and activities.

activity_tracking

activity_tracking

具有列ID，user_activity_id，状态，updated_at等 在这里，您可以使用整数值表示状态，比如说1.然后，使用updated_at和created_at可以跟踪活动的开始和完成时间.

with columns id, user_activity_id, status, updated_at etc Here you could use an integer value for status to signify completion lets say 1. And using updated_at and created_at you could track activity start and completion timing.

这篇关于Laravel多对多关系查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！