Laravel pivot table model

/*Model - Service*/
public function customer(){
    return $this->belongsToMany('customer')->withPivot(
        'start_date',
        'stop_date',
        'rem_date',
        'due_date',
        'status'
        );
}

/*Model - customer*/
public function services(){
    return $this->belongsToMany('Service')->withPivot(
        'start_date',
        'stop_date',
        'rem_date',
        'due_date',
        'status'
        );
}

////These following relations didnt workout
/*Model - custserv*/ //uses the pivot table customer_service//
public function staff(){
    return $this->belongsToMany('Staff');
}

/*Model - Staff*/
public function custservs(){
    return $this->belongsToMany('Custserv');
}

/*schema for pivot table 'staff' and 'Custserv' */
Schema::create('customer_service_user', function(Blueprint $table)
    {
        $table->increments('id');
        $table->integer('customer_service_id')->unsigned()->index();
        $table->foreign('customer_service_id')->references('id')->on('customer_service')->onDelete('cascade');
        $table->integer('staff_id')->unsigned()->index();
        $table->foreign('staff_id')->references('id')->on('staff')->onDelete('cascade');
        $table->timestamps();
    });

Source: stackoverflow.com

Similar codes

2 votes103 views1 answer
Check if value is not null in db laravel
PHP Laravel
0 vote108 views1 answer
Custom pagination laravel css
PHP Laravel
6 votes115 views1 answer
PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes") laravel 8
PHP Laravel
1 vote114 views1 answer
Convert php array to javascript json laravel
PHP Laravel
0 vote116 views1 answer
How to check if a user is logged in in a non middleware controller in laravel
PHP Laravel
0 vote111 views1 answer
Laravel raw query join many to many
PHP Laravel
10 votes135 views2 answers
Array to string conversion in laravel controller
PHP Laravel
2 votes113 views1 answer
Add id to route name in laravel blade
PHP Laravel
29 votes124 views3 answers
Laravel clear page cache
PHP Laravel
9 votes121 views6 answers
Laravel validation custom message
PHP Laravel