To fix this, we need a sort of intermediary table. And neither can we add a user_id on the Profile model, because there are potentially multiple users as well. How do we fix this? We cannot just add a profile_id on the users table, because there are potentially multiple profiles. when collaborating with others, and each Profile can belong to multiple (many) Users. Consider the following many-to-many relationship: each User can have many Profiles, e.g. Now that we've had the above sort of relationships, we will now discuss a few more advanced relations. HasOneThrough and HasManyThrough Relationship In general, we say that the following sorts of relationships between data exist: Don't worry if this sounds too complex, we'll get to that soon. For this sort of complexer relationship, we can't just add a column to a table and be done with it! For this situation we need a pivot table. How can we solve that? This is a so-called Many-To-Many relationship. This is an example of a relatively easy kind of relationship, a One-To-Many relationship.īut what if each user can have multiple posts, and each post can have multiple authors. And in the (more unlikely) opposite scenario, if each post can belong to multiple authors ( users) and each author can only contribute to one post, we could add a post_id to the users table. To implement this, we can add a user_id to the posts table. Say that each post can only belong to one user. In the above example, we have a users table and a posts table. Which type you have generally depends on the fact whether you have one or (potentially) multiple items of both the first and the second table. There are multiple types of Eloquent relationships.
0 kommentar(er)
