Deleting Record Also Deletes Related Records?

Is Eloquent smart enough to delete records in a "pivot table" when I delete a record?

If I have three tables, 'books,' 'readers,' and 'book_reader,' and I delete a book, all the records in 'book_reader' with that book_id should be deleted automagically. That's what I expect. What would happen IRL? :D

cklester

9 years ago

Level 3

I've done a bit more searching. I might just softDelete the records for now... I'm still interested in hearing answers and other approaches.

emiragic

9 years ago

Level 13

That is a job for MySQL Cascaded foreign keys.

More info you can find on: https://dev.mysql.com/doc/refman/5.7/en/create-table-foreign-keys.html

1 like

Please or to participate in this conversation.