参照完整性

参照完整性，又称引用完整性，是数据的属性，用以表明引用之有效。参照的完整性不允许关系中有不存在的实体引用。^[1]参照完整性与实体完整性二者，皆是关系模型必须满足的完整性约束条件，其目的在于保证数据一致性。

参考链接

1. Mike Chapple. Referential Integrity. About.com. [2011-03-20]. （原始内容存档于2016-11-19）. Definition: Referential integrity is a database concept that ensures that relationships between tables remain consistent. When one table has a foreign key to another table, the concept of referential integrity states that you may not add a record to the table that contains the foreign key unless there is a corresponding record in the linked table.