Level 28
Feb 18, 2021
11
Level 2
Laravel/Eloquent MySQL relationship 1:n and 1:1 help needed
I'm building an app for a digital marketing agency to automate advertising campaign submission and tracking for clients. I'm having trouble wrapping my head around what relationships I need based on the current manual process. I'm the only developer working on this project so I feel like I'm sitting on an island out in the ocean. lol The way the process works now is we have a client prospect, a contract is created, if the prospect/client approves the process goes to the on-boarding/discovery phase followed by the campaign creation and insertion order creation.
The way I have my relationships set up so far is like this:
-
Client table has a 1:n relationship with the contracts table.
-
Contracts, discovery and insertion orders table has a 1:1 relationship with the campaigns table.
-
Contracts table has an foreign key for both the client and campaigns table.
-
Campaigns table has a foreign key for the Client table.
I created an ERD in MySQL Workbench. It shows identifying and non-identifying 1:1 and 1:n. Should I be concerned with these?
As far as the models go, I currently have:
In the Client model:
- contracts hasMany(Contract::class)
- campaigns hasMany(Campaigns::class)
In the Campaign model, I have:
- client - belongsTo(Client::class)
In the Discovery and Insertion Order models:
- campaign - belongsTo(Campaign::class)
In the Contract model:
- client - belongsTo(Client::class)
- campaign belongsTo(Campaign::class)
If you need additional information, please let me know.
Know of any resources, tutorials, etc that might help shed more light on this?
Level 2
I forgot to mention that the client table has a 1:n relationship with the campaigns table.
Level 28
Or better yet watch this whole series:
1 like
Level 75
Not only the videos, but also the chapter on eloquent relationships will guide you on a one to many relation.
When I first learned, I actually worked the examples in the documentation, that helped me a lot.
If you don't want to use eloquent, I would suggest getting a good query visual designer.
Another good source of practicing queries is https://www.mysqltutorial.org/
2 likes
Level 28
@jmacdiarmid You have to set up the migrations and the models for the relationships to work I would follow the series https://laracasts.com/series/eloquent-relationships and read the documentation as well
Or post your models and migrations so we can see :)
1 like
Level 28
Yes @jmacdiarmid, as @jlrdw says work the examples from the documentation in as seperate app using tinker to figure it out
1 like
Level 2
Level 28
@jmacdiarmid laracasts.com is worth the 15 bucks and lots of the stuff is free. https://laracasts.com/series/eloquent-relationships is free Welcome :)
1 like
Level 2
@lemmon Thanks for this. I'm definitely considering signing up for that. I need all the help I can get. :)
Level 28
lot of it is free
Level 2
Hi guys,
I wish it wasn't so, but I'm still having issues with this. Specifically with associating a campaign package with a contract. I have it working with associating all campaign packages that have been assigned to a campaign duration. Do I need a separate "pivot" table for this to link the campaign package to the contract?
Something like:
Schema::create('contract_package_pivot', function (Blueprint $table) {
$table->unsignedBigInteger('contract_id');
$table->foreign('contract_id', 'contract_id_fk_2405103')->references('id')->on('contracts')->onDelete('cascade');
$table->unsignedBigInteger('package_id');
$table->foreign('package_id', 'package_id_fk_2405103')->references('id')->on('campaign_packages')->onDelete('cascade');
});
Please or to participate in this conversation.