Key-Preserved Tables 主键保留表

Key-Preserved Tables

 

A key-preserved table is the most important requirement for a join view to be modifiable. In a join, a table is called a key-preserved table if its keys are preserved through the join—every key of the table can also be a key of the resultant join result set. Every primary key or unique key value in the base table must also be unique in the result set of the join。

 

翻译：

对于连接视图的修改，主键保留表是一个很重要的概念。在关联中，如果一个表的主键在关联后生成的视图中含有该表的主键或者唯一键则称为主键保留表。基础表中的主键或者唯一键的值必须全部存在在视图中。

 

翻译的不一定正确，大体上是这个意思。