4

I have two tables in MySQL, named manuals and library. Both could have uploaded files, so I have made an third table, named files. In files, I have a column parent_id. Can I make parent_id as foreign key from both manuals and library?

I am using Laravel (4.2) and tried this, but it doesn't work:

$table->integer('parent_id')->unsigned();
$table->foreign('parent_id')->references('id')->on('library');
$table->foreign('parent_id')->references('id')->on('manuals');
Marten
  • 1,376
  • 5
  • 28
  • 49
  • 1
    Possible duplicate? http://stackoverflow.com/questions/15547276/it-is-possible-to-reference-one-column-as-multiple-foreign-keys – Mark Jul 27 '15 at 09:31
  • 2
    You can't do this, You can however solve this by splitting the `parent_id` column into two columns. `library_id` and `manual_id` for example. Then fill one of these with their respective id and the other with `null`. – Victor Jul 27 '15 at 09:33
  • @Victor Thanks, I am going use your solution :) – Marten Jul 27 '15 at 09:40

1 Answers1

5

No. You cannot have multiple foreign keys on the same column. From the MySQL documentation:

MySQL supports foreign key references between one column and another within a table. (A column cannot have a foreign key reference to itself.) In these cases, “child table records” really refers to dependent records within the same table.

The reason for this is that MySQL won't be able to differentiate between the parents. Laravel (or any other framework) does not provide a work around for this issue.

This question as been asked in slightly different forms before. Example: it is possible to reference one column as multiple foreign keys

Community
  • 1
  • 1
Mark
  • 5,437
  • 2
  • 19
  • 29
  • I didn't see that question, but thanks. I am going to use Victor's solution. Two columns, one named library_id and the other named manual_id. – Marten Jul 27 '15 at 09:42