How can I store foreign Keys as arrays in laravel?

Question

I have 3 models:

Book
Author
Owner

Book has:

id
name
photo
author_id
owner_id
is_available

Author has:

id
name
photo

Owner has:

id
name
photo
book_id

A book can have multiple Authors and Owners.

How can I store more single id in author_id and owner_id?

Why not use a common many to many relationship? How do you currently define the relations? Manually, or through Eloquent? — Nico Haase
– Nico Haase, Commented Oct 9, 2022 at 16:46
You don't, you use a Many To Many relationship (using a pivot table), it is basic programming/db normalization, not Laravel. Check this documentation, it will help you — matiaslauriti
– matiaslauriti, Commented Oct 9, 2022 at 17:20

Hakim Benmazouz · Accepted Answer · 2022-10-09 19:13:11Z

2

If the author has many books, and the book have many authors, than it’s a many to many relationship and you will need intermediate tables author_book and owner_book. In order to be able to define many author ids for one a book and many books for one author. Check the Laravel doc here for implementation details https://laravel.com/docs/9.x/eloquent-relationships#many-to-many

Good luck.

answered Oct 9, 2022 at 19:13

Hakim Benmazouz

3311 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

matiaslauriti Over a year ago

To be precise, following the Laravel standards naming conventions, you will need author_book and book_owner, not owner_book

Collectives™ on Stack Overflow

How can I store foreign Keys as arrays in laravel?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related