All tables which have foreign key relationships to the selected table — and all foreign key tables from the selected table — will be visualized in the diagram illustrated in Figure 7, following.
对所选择的表具有外键关系的所有表——以及来自所选表的所有外键表——将会在下面的图7中被可视化的显示出来。
Create a foreign key to link this new table with the existing employee table.
创建一个外键,以便将这个新表与已有的雇员表相连接。
One column links to the form (the row in the table) using a foreign key.
一列使用一个外键链接到表单上(表中的一行)。
For foreign key creation, another table with a primary key with a compatible data type is required.
对于创建外键,则需要另外一个具有主键的表,且该主键具有兼容的数据类型。
Having the database generate values for the primary key for a table (and by extension, any foreign key values for related tables) eliminates the burden from the application from having to do so.
数据库为一个表格的主键生成值(通过扩展,为相关表生成外主键),从而将程序从这项任务的重担中解放出来。
Minimize the triggers, CHECK and foreign key constraints, and generated columns for the table.
尽量减少表上的触发器、检查和外键约束以及生成的列。
ON DELETE CASCADE—When a record is deleted from the parent table, all records in the child table with matching foreign key values are also deleted.
ON DELETECASCADE —当一条记录从父表中删除时,子表中的所有记录以及匹配的外键值都全部被删除。
When an ON delete CASCADE rule is active, all records in the child table with matching foreign key values are deleted when a record is deleted from the parent table.
当ONDELETECASCADE规则被激活时,当一条记录从父表中删除时,子表中的所有记录以及匹配的外键值都被删除。
Otherwise, a new key value is taken from the sequence and used for both, a new entry in the dimension table and as a foreign key in the fact table.
否则,从序列获取一个新的键值,用它作为维表中新条目的主键和事实表中的外键。
If so, the existing ID is read from the dimension table and used as the foreign key for the new entries in the fact table.
如果是,则从维表中读取已有的ID,并用它作为事实表中新条目的外键。
You can also establish a foreign key in a secondary table to link with a primary key in a primary table.
您还可以在次表中建立外键,以链接主表中的主键。
Joined table: (Optional) the child class is mapped to a table that has a foreign key relationship to the table to which the parent is mapped.
联合表:(可选)将子类映射到与父类映射到的表具有外键关系的表。
Each one-to-many association is buried as a foreign key in the table of the many class.
每个一对多的关联在表中多个类中充当外键。
An index pushdown USES the pushed-down keys to perform index lookups on a foreign key index of the fact table.
索引下推使用下推键执行事实表外键索引的查询。
Our virtual foreign key is based on two columns from the TB_RIGHT table.
我们的虚拟外键基于TB_RIGHT表的两个列。
For example, if there are any dependent tables (tables that have a foreign key referencing the table into which data is to be loaded, for example), they might be placed in the CHECK PENDING state.
例如,如果存在依赖表(例如表中有一个外键,该外键引用数据要被装载到的目标表),那么这些表可能被设为CHECK PENDING状态。
In the case of a one-to-one relation, your transformation creates a foreign key in each table.
在一对一关联的情况下,你的转换在所有表中都建立了一个外键。
In general, that data would live in a child table with a foreign key relation to the table contacts.
通常,那些数据应该存放在一张子表中,子表的外部关键字关联到表contacts。
In mapping terms, PERSON is the owner of the relation (i.e., the foreign key to the ADDRESS table resides in the PERSON table).
在映射的术语中,PERSON是此关系的所有者(即address表的外键存在于person表内)。
You can also use the system catalog views to retrieve information about NOT NULL, unique, primary key, foreign key, and table check constraints. For example.
也可以使用系统编目视图来检索关于NOT NULL、惟一、主键、外键和表检查约束的信息。
In the case of one-to-many relations, your transformation creates a foreign key in every "many" table.
在一对多关联的情况下,你的转换在所有“ many ”表中建立了一个外键。
Here we see that the mapping for Customer's Address field links the two halves of the relationship together with the foreign key reference in the table schema file.
这里我们看到Customer的Address字段映射用表模式文件中的外键引用将关系的两部分链接在一起。
A one-to-many association is specifically mapped to a foreign key in the "many" table.
一个一对多关联被映射到“many ”表的一个外键。
Syscat.tabconst Contains a row for each unique (u), primary key (p), foreign key (f), or table check (k) constraint db2 select constname, tabname, type from syscat.tabconst.
tabconst为每个唯一性(U)、主键(p)、外键(f)或者表检查(K)约束保持一个行db2select constname,tabname,typefrom syscat . tabconst。
You also need to add a foreign key 'user_id' to the DOCUMENTS table so you know the user who uploaded a particular document.
另外还需要添加一个外键' user_id '到documents表中,以便知道哪个用户上传某个特定的文档。
Run rake db:migrate to create the SUBSCRIPTIONS table and add foreign key columns to SUBJECTS.
运行rakedb:migrate以创建SUBSCRIPTIONS表并将外键列添加到SUBJECTS 中。
The Location table contains a foreign key (region_id) that corresponds to primary key of the region table.
location表包含一个外键(region_id)对应region表的主键。
In addition to the id primary key, you've declared the customer_id column to be a foreign key referencing the customer table.
除了id主键以外,还声明了customer_id列作为引用客户表的外键。
Run rake db: migrate to create the SUBJECTS table and add the subject_id foreign key.
运行rakedb:migrate,以创建subjects表并添加subject _ id外键。
The belongs_to expresses the one-to-one foreign key relationship between the DOCUMENTS and USERS table.
belongs_to表达了DOCUMENTS与USERS表之间一对一的外键关系。
应用推荐