许多表之一的外键? [英] Foreign key to one of many tables?

问题描述

设置外键约束的常用方法是选择外键将指向哪个表.

The usual way of setting a foreign key constraint is to choose which table the foreign key will point to.

我在 1 个表和一组表之间存在多态关系.

I'm having a polymorphic relation between 1 table and a set of table.

这意味着该表将与集合中的其中一个表有关系.

That means that this table will have a relation with one of those tables in the set.

例如

images: person_id, person_type
subordinates: id, col1, col2...col9
products: id, colA, colB...colZ

在上面的例子中，如果person_type是subordinates"，那么person_id应该是subordinates.id的外键，产品也是如此.

In the above example, if person_type is "subordinates" then person_id should be a foreign key to subordinates.id and the same goes with products.

所以我想知道，是否可以有一个外键指向多个表中的一个，或者您是否必须在分配一个表时专门设置它指向哪个表.

So I wonder, is it possible to have a foreign key to one of many tables, or do you have to specifically set which table it points to when you assign one.

这个问题是针对 MySQL 和 PostgreSQL 的.

This question is for both MySQL and PostgreSQL.

谢谢

推荐答案

不，外键约束总是只引用一个父表.

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:

• 为什么多态关联中不能有外键吗?
• 可以为两个可能的表之一设置 MySQL 外键吗?
• 在同一列中引用外键
• 在 StackOverflow 克隆中，Comments 表应该与 Questions and Answers 有什么关系?
• MySQL - 条件外键约束
• 如何处理ERD(表格)设计中的OR"关系?
• MySQL:两个 n:1 关系，但不能同时使用

• Why can you not have a foreign key in a polymorphic association?
• Possible to do a MySQL foreign key to one of two possible tables?
• Referencing foreign keys in the same column
• In a StackOverflow clone, what relationship should a Comments table have to Questions and Answers?
• MySQL - Conditional Foreign Key Constraints
• How to handle an "OR" relationship in an ERD (table) design?
• MySQL: Two n:1 relations, but not both at once

有关多态关联的更多信息，请参阅我的演示文稿 Practical Object-SQL 中的面向模型 或我的书 SQL 反模式:避免数据库编程的陷阱.

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

这篇关于许多表之一的外键?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！