Laravel Many models as Publisher Polymorphic Relationship with pivot?

Question

Hi I am having problems with relation and database design. There are three tables called 'articles' , 'users' , and 'companies' with one attribute each called id: "articles" -id "users" -id "companies" -id The article table contain many publishers that are user model or company model. My pivot table must be something similar to 'authors' -id, -model_id, -model_name, -article_id Is there any way to get article's publisher ids and data from models in one collection with a single query? Maybe I misunderstood the problem and there is a simpler solution for that case. thx in advance JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

Assuming Article only have one company or one user , The right way to do that is to do a one to many (polymorphic) relationship creating the table with these columns:- { article_id , articleable_id , articleable_type } and then define it in your model use Illuminate\Database\Eloquent\Model; class Article extends Model { /** * Get all of the owning articleable models. */ public function articleable() { return $this->morphTo(); } } and the Users table:- class Userextends Model { /** * Get all of the user's articles. */ public function articles() { return $this->morphMany('App\Article', 'articleable'); } } and same in the Company model:- class Company extends Model { /** * Get all of the companies articles. */ public function articles() { return $this->morphMany('App\Article', 'articleable'); } } and then you can retrieve the relationship using:- $user = App\User::find(1); foreach ($user->articles as $article) { // do this } as mentioned here but if the article can have more than user or company then you have to do many to many polymorphic as mentioned here