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