Level 50
Something like this might be a handy addition the the eloquent docs (or possibly the migration ones) on the main laravel site :-)
Jun 18, 2016
8
Level 122
Remember which table gets foreign key in relationship
I put together a little crib list for the common relationships to help me remember which relationship goes with which foreign key requirement.
I hope this is accurate. Please send any amends
+---------------+-------------+--------------+-------------------------+
| | self | other model | pivot |
+===============+=============+==============+=========================+
| hasOne | no key | self_id | |
| belongsTo | other_id | no key | |
| hasMany | no key | self_id | |
| belongsToMany | no key | no key | keys for self and other |
+---------------+-------------+--------------+-------------------------+
self is the model you are writing the relationship in and other model is the one you want the relationship with.
Level 65
Very nice to remember. Sometimes forget!
1 like
Level 17
Thats what i search for
Level 75
Good one @Snapey it should be in the Docs.
1 like
Level 13
If you use Joins foreign keys are self evident. Pivot tables are used to point to 'pooled data' like Customer by Region and/or Date. In a read more than write database the pivot can be a materialized view. Built with the right indexes and queries it can very fast
1 like
Level 1
This is so helpful. Thank you..
1 like
Level 1
bookmarked, Thanks!
Please or to participate in this conversation.