relationship with multiple columns? | Laravel | Page 1

hushed jewel Jul 19, 2024, 8:51 PM

#

Hey,
i want to archive the following:

One User can have a Company.
This Company can have Many Branches.

No Problem sofar.

Now i have a Address Table. This table should be for Branches and Companys.
So for me i need a address_type and a "primary_id" column for the companyid or branchid.

how i can archieve that? can i somehow tell the company model that the company has one Address where primary_id column is the company id and address_type needs to be 1?

i hope you understand what i want. i dont want to have 2 tables with same columns ( like company_Address and branch_address )

mellow karma Jul 19, 2024, 8:54 PM

#

This should be what you want: https://laravel.com/docs/11.x/eloquent-relationships#many-to-many-polymorphic-relations

Laravel - The PHP Framework For Web Artisans

Laravel is a PHP web application framework with expressive, elegant syntax. We’ve already laid the foundation — freeing you to create without sweating the small things.

hushed jewel Jul 19, 2024, 9:01 PM

#

sounds like what i want @mellow karma will try that

#

will give feedback after i tested it

#relationship with multiple columns?