外部关键字,数据库中的语言。其概念是关系中某个属性或属性组合并非关键字,但却是另一个关系的主关键字。
通常,那些数据应该存放在一张子表中,子表的外部关键字关联到表contacts。
In general, that data would live in a child table with a foreign key relation to the table contacts.
要深入了解MySQL参照完整性,请参考MySQL产品文档中关于外部关键字的部分。
For more on MySQL referential integrity, please see the section on foreign keys constraints in the MySQL product documentation.
因此您需要将Employee的外部关键字属性,与Department的主关键字映射上。
Therefore, you need to map the foreign key attribute in Employee to the Department's primary key.
应用推荐