Laravel多对多关系中如何保存自定义关联表字段？

Hey there! Let's get this sorted out for you. The issue you're facing is that Laravel (I'm assuming you're using Laravel here since you mentioned model relationships) is defaulting to using the primary key (id) of your jobseekers table when saving to the pivot table, but you want it to use the jobseeker_id field instead. Here's how to fix it:

1. Adjust the Relationship in Your Jobseeker Model #

By default, Laravel uses the model's primary key (usually id) for pivot table associations. To override this and use jobseeker_id instead, you need to specify the localKey (the field on your jobseekers table you want to use) and foreignPivotKey (the corresponding field in the pivot table) in your relationship definition.

Update your jobPositions method in the Jobseeker model like this:

public function jobPositions()
{
    return $this->belongsToMany(JobPosition::class, 'jobposition_jobseeker')
        ->foreignPivotKey('jobseeker_id') // The column name in your pivot table
        ->localKey('jobseeker_id'); // The column name in your jobseekers table you want to store
}

• 'jobposition_jobseeker' is your pivot table name (make sure this matches exactly)
• foreignPivotKey tells Laravel which column in the pivot table to populate
• localKey specifies which value from the jobseekers table to put into that pivot column

2. Don't Forget the Reverse Relationship (Optional but Recommended) #

If you ever need to access job seekers from a job position, update the jobSeekers method in your JobPosition model too:

public function jobSeekers()
{
    return $this->belongsToMany(Jobseeker::class, 'jobposition_jobseeker')
        ->foreignPivotKey('jobposition_id') // Pivot table column for job positions
        ->localKey('id'); // Assuming your jobpositions table uses id as primary key (adjust if needed)
}

3. Saving Data to the Pivot Table #

Now when you use methods like attach(), sync(), or save() to associate records, Laravel will store the jobseeker_id value instead of the default id:

// Example: Attach a job position to a job seeker
$jobseeker = Jobseeker::find(1);
$jobseeker->jobPositions()->attach($jobPositionId);

Quick Note: If jobseeker_id is Your Primary Key #

If your jobseekers table actually uses jobseeker_id as its primary key (instead of the default id), you just need to set that in your model first:

// In Jobseeker model
protected $primaryKey = 'jobseeker_id';

Then your basic belongsToMany relationship will automatically use jobseeker_id for the pivot table, as long as you specify the pivot table and foreign key:

public function jobPositions()
{
    return $this->belongsToMany(JobPosition::class, 'jobposition_jobseeker', 'jobseeker_id', 'jobposition_id');
}

That should do it! Your pivot table will now store the jobseeker_id value from your jobseekers table instead of the default row id.

内容的提问来源于stack exchange，提问作者Soul Coder