Relationship between 3 tables

well the only possible thing you can do is to create a Model for it, set the $fillable fields and set the relationships .... a pivot table only accepts two tables's key.

Can a Task belong to many Projects, and can a Task belong to many Users? If not, then it's presence on the pivot table might be superfluous.

Thank you @InaniELHoussain, I have already created my models for each table, except pivot table, if I can't link more than two keys could you please guide me further what else I can do?

Thank you, @tykus_ikus. Can a Task belong to many Projects? No. Task belong to many Users? No.

Could you clarify it more

So in that case, the tasks table should become:

title
due_date
user_id  // you could make this to owner_id and be explicit with the foreign key when defining the relationships
project_id

That make sense, but I found that the tasks table should be separate from other tables and the pivot table would be needed, Am I right or Is that making sense?

The need for the pivot table would depend on whether or not a User can belong to many Projects; and a Project can belong to many Users.

Thank you @tykus_ikus I have already create that pivot table separate, named project_user having two fields user_id, project_id and therefore, user can belong to many projects; also project can belong to many users. :)

@kashifullah you should be all set in that case.

Be aware though that you will now have users attaching to a project in two ways (i) using the project_user pivot table and (ii) using the tasks table - this may or may not be an intended behaviour.

@tykus_ikus What if I implement the same from tasks table rather than project_user pivot table, which is more preferred way to do so.

If your project will only have project participant, i.e. user has task(s), rather than having project watchers, you could remove the pivot table completely.

@tykus_ikus one final question, how can I insert values to tasks tables as it has two foreign keys, user_id and project_id, could you please show me that in php artisan tinker form, let say I have a one-to-many relationship between users and tasks thus I have a relationship method in task table as: public function user() { return $this->belongsTo('App\User'); } And therefore, I can call it as : $task -> user()->attach($user);

But how to insert project_id in task table?

Think in terms of the relations:

$user = App\User::findOrFail($request->user_id);
$project = App\Project::findOrFail($request->project_id);

$task = new App\Task([
    'title' => $request->title,
    'due_date' => $request->due_date
]);

$task->associate( $user ); // sets the user_id

$project->tasks()->save($task); // sets the project_id and saves the new task

Thank you, @tykus_ikus That really helped. :)