Ggtcf

Do I need a multiple entry visa for a trip UK -> Sweden -> UK?

How to be diplomatic in refusing to write code that breaches the privacy of our users

Implement the Thanos sorting algorithm

How does it work when somebody invests in my business?

What to do with wrong results in talks?

Is there a problem with hiding "forgot password" until it's needed?

How can I replace every global instance of "x[2]" with "x_2"

Teaching indefinite integrals that require special-casing

Hide Select Output from T-SQL

What will be the benefits of Brexit?

Time travel short story where a man arrives in the late 19th century in a time machine and then sends the machine back into the past

Why are on-board computers allowed to change controls without notifying the pilots?

Is the destination of a commercial flight important for the pilot?

Hostile work environment after whistle-blowing on coworker and our boss. What do I do?

How do I rename a LINUX host without needing to reboot for the rename to take effect?

The baby cries all morning

How to verify if g is a generator for p?

Trouble understanding overseas colleagues

What's the purpose of "true" in bash "if sudo true; then"

Bash method for viewing beginning and end of file

Using parameter substitution on a Bash array

What is the oldest known work of fiction?

Valid Badminton Score?

Curses work by shouting - How to avoid collateral damage?

Laravel how to resolve one to many circular reference

How does database indexing work?How can I prevent SQL injection in PHP?How do I UPDATE from a SELECT in SQL Server?Reference — What does this symbol mean in PHP?How do I check if a string contains a specific word?How does PHP 'foreach' actually work?Laravel Eloquent many-to-many relationship: Use explicit pivot tableLaravel 5: How to do a join query on a pivot table using Eloquent?Querying data based from id (primary key) on many to many eloquent pivot tableLaravel - avoid pivot table for many-to-many relationship through a custom relation?

0

0

Hello I got a special case where I want to resolve the problem of keywords where a main keyword can reference many secondary keywords like that :

My questions :
1/ Should I make a custom pivot model or simply make a pivot table called keyword_keyword ?
I know that Eloquent can't handle composite keys which could here avoid duplicate couples in KeywordsAssociation.
Thank you for your Help.

php sql laravel eloquent

share|improve this question

asked Mar 8 at 9:31

Brian85Brian85

157110

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Just change your column names. It looks confusing. There is no circular reference as such. One keyword refers to many others.
  
  – vivek_23
  Mar 8 at 9:35
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  ok for circular reference, should I simply name the keywordsAssociation keyword_keyword in my migration ?
  
  – Brian85
  Mar 8 at 9:37
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  First, you will migrate the keywords table. Then you will migrate keywordsAssociation table where mainKeyword and secondarykeyword are foreign keys referring to primary key of keywords table. So, parent table before child.
  
  – vivek_23
  Mar 8 at 9:40
  
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Yes, in that case, a model for KeywordAssociation is necessary.
  
  – vivek_23
  Mar 8 at 9:51
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Thank you very much !
  
  – Brian85
  Mar 8 at 9:53
  

  
  
  
  

 | 
show 3 more comments

0

0

Hello I got a special case where I want to resolve the problem of keywords where a main keyword can reference many secondary keywords like that :

My questions :
1/ Should I make a custom pivot model or simply make a pivot table called keyword_keyword ?
I know that Eloquent can't handle composite keys which could here avoid duplicate couples in KeywordsAssociation.
Thank you for your Help.

php sql laravel eloquent

share|improve this question

asked Mar 8 at 9:31

Brian85Brian85

157110

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Just change your column names. It looks confusing. There is no circular reference as such. One keyword refers to many others.
  
  – vivek_23
  Mar 8 at 9:35
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  ok for circular reference, should I simply name the keywordsAssociation keyword_keyword in my migration ?
  
  – Brian85
  Mar 8 at 9:37
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  First, you will migrate the keywords table. Then you will migrate keywordsAssociation table where mainKeyword and secondarykeyword are foreign keys referring to primary key of keywords table. So, parent table before child.
  
  – vivek_23
  Mar 8 at 9:40
  
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Yes, in that case, a model for KeywordAssociation is necessary.
  
  – vivek_23
  Mar 8 at 9:51
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Thank you very much !
  
  – Brian85
  Mar 8 at 9:53
  

  
  
  
  

 | 
show 3 more comments

Hello I got a special case where I want to resolve the problem of keywords where a main keyword can reference many secondary keywords like that :

My questions :
1/ Should I make a custom pivot model or simply make a pivot table called keyword_keyword ?
I know that Eloquent can't handle composite keys which could here avoid duplicate couples in KeywordsAssociation.
Thank you for your Help.

php sql laravel eloquent

share|improve this question

asked Mar 8 at 9:31

Brian85Brian85

157110

share|improve this question

asked Mar 8 at 9:31

Brian85Brian85

157110

share|improve this question

asked Mar 8 at 9:31

Brian85Brian85

157110

asked Mar 8 at 9:31

Brian85Brian85

157110

asked Mar 8 at 9:31

Brian85Brian85

157110