vendredi 12 juillet 2019

laravel using foreign keys

I just cant see this I have events, users, items tables

events
_______________________
id | name

users
______________________
id | name

items
_______________________
id | event_id  | user_id. | name

I want items deleted when either an event or user are deleted

Schema::table('items', function(Blueprint $table) {
        $table->foreign('user_id')->references('id')->on('users');
    });
Schema::table('items', function(Blueprint $table) {
        $table->foreign('events_id')->references('id')->on('events');
    });

So if I add ->onDelete('cascade') to both when the user or event are deleted the item will be also deleted?



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire