Foreign key to one of many tables?

by

No, a foreign key constraint always references exactly one parent table.

This question comes up frequently. Here are some of my past answers to it:

For more on Polymorphic Associations, see my presentation Practical Object-Oriented Models in SQL or my book, SQL Antipatterns, Volume 1: Avoiding the Pitfalls of Database Programming.

More Related Contents:

  1. How to select the nth row in a SQL database table?
  2. What resources exist for Database performance-tuning? [closed]
  3. How do you write a case insensitive query for both MySQL and Postgres?
  4. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  5. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  6. Is there a MySQL option/feature to track history of changes to records?
  7. Binary Data in MySQL [closed]
  8. Can a table field contain a hyphen?
  9. Auto Generate Database Diagram MySQL [closed]
  10. MySQL : Multiple row as comma separated single row
  11. Check for x consecutive days – given timestamps in database
  12. MySQL Insert Into from one Database in another
  13. How do I get the ID of multiple inserted rows in MySQL?
  14. Relationship between catalog, schema, user, and database instance
  15. Case statement in MySQL
  16. How do I show the schema of a table in a MySQL database?
  17. How to find out the MySQL root password
  18. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  19. MySQL concatenating all columns
  20. Remove special characters from a database field
  21. Proper database model for a user feedback system (an interesting case)
  22. How big can a MySQL database get before performance starts to degrade
  23. Easiest way to copy a table from one database to another?
  24. MySQL – Replace Character in Columns
  25. Foreign key constraints: When to use ON UPDATE and ON DELETE
  26. Import MySQL dump to PostgreSQL database
  27. How to Get True Size of MySQL Database?
  28. What are the max number of allowable parameters per database provider type?
  29. MySQL: Computed Column
  30. How do I make a MySQL database run completely in memory?

Leave a Comment