Is it possible to reference one column as multiple foreign keys?

by

No.

That is, you cannot create a foreign key constraint this way. You can however, use a foreign key without a foreign key constraint.

All a foreign key is, is the value of another table’s (or another record in the same table) primary key, which can be used in joins. In fact, you could reference fields other than the primary key, if all you need is to use the value for joins.

However, a foreign key constraint tells the database to enforce the rule that for every foreign key value in a table, the referenced table has a record with that as it’s primary key. Enforcing that every foreign key in the PDF table had a primary key IN ALL FOUR TABLES won’t work for you. So go ahead and use the field to reference other records, but simply do not create any foreign key constraint.

More Related Contents:

  1. MySQL Cannot Add Foreign Key Constraint
  2. Required to join 2 tables with their FKs in a 3rd table
  3. Can a foreign key reference a non-unique index?
  4. MySQL – Conditional Foreign Key Constraints
  5. How do I use on delete cascade in mysql?
  6. How to create relationships in MySQL
  7. Foreign key constraints: When to use ON UPDATE and ON DELETE
  8. i have an error which i dont understand. can you help me? [closed]
  9. In SQL Server how to get the count of child if both parent and child are available [closed]
  10. Delete the entire content of all table in a Database [closed]
  11. MySQL select 10 random rows from 600K rows fast
  12. Get a list of dates between two dates
  13. Calculate a running total in MySQL
  14. Simulate lag function in MySQL
  15. Get record counts for all tables in MySQL database
  16. How do I check if a column is empty or null in MySQL?
  17. Use MySQL spatial extensions to select points inside circle
  18. INSERT … ON DUPLICATE KEY (do nothing)
  19. MySQL create stored procedure syntax with delimiter
  20. Merge two tables in one SQL query and make the date values unique
  21. How to find non-existing data from another Table by JOIN?
  22. MySQL/SQL: Update with correlated subquery from the updated table itself
  23. MySQL INSERT INTO … VALUES and SELECT
  24. MySQL LIKE query with underscore
  25. Compare only day and month with date field in mysql
  26. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  27. DELETE FROM `table` AS `alias` … WHERE `alias`.`column` … why syntax error?
  28. What happens when I exhaust a bigint generated key? How to handle it?
  29. is there a length limit to group_concat or another reason why it would not work on a text field
  30. MySQL Relationships

Leave a Comment