Creating a foreign key constraint with index disabled.
创建一个索引禁用的外键约束。
Similarly if two tables are connected via a foreign key, they are connected.
与此类似,如果两张表通过一个外键连接起来,我们也称其为连接的。
You don't need to worry about messing around with the primary key or foreign key.
您无需担心处理主键或外键的麻烦。
Data type of primary key columns, foreign key columns, and columns used on indexes.
主键列、外键列和索引上使用的列的数据类型。
It works at a basic level with MySQL, but it won't pick up foreign key relationships.
它基本上能用于MySQL,但不能提取外键关系。
In this example, we will use the name C0989623 as the name of the foreign key (Figure 6).
在本例中,我们将使用名称C0989623作为外键的名称(图6)。
This next section of code adds all of the foreign key links seen in the previous diagram.
下面的代码将添加上图中的所有外键链接。
One-to-one relationships and one-to-many relationships are implemented using a foreign key.
一对一关系和一对多关系使用一个外键来实现。
Minimize the triggers, CHECK and foreign key constraints, and generated columns for the table.
尽量减少表上的触发器、检查和外键约束以及生成的列。
Run rake db:migrate to create the SUBSCRIPTIONS table and add foreign key columns to SUBJECTS.
运行rakedb:migrate以创建SUBSCRIPTIONS表并将外键列添加到SUBJECTS 中。
Therefore, you need to map the foreign key attribute in Employee to the Department's primary key.
因此您需要将Employee的外部关键字属性,与Department的主关键字映射上。
For example, the foreign key to the date table is not repeated for every keyword of a document.
例如,日期表的外键对于一个文档的每个关键词不会重复。
For foreign key creation, another table with a primary key with a compatible data type is required.
对于创建外键,则需要另外一个具有主键的表,且该主键具有兼容的数据类型。
A one-to-one association is mapped to a foreign key buried in one of the tables (no matter which)?
一个一对一关联被映射到表中的一个外键(无所谓哪个)?
In general, that data would live in a child table with a foreign key relation to the table contacts.
通常,那些数据应该存放在一张子表中,子表的外部关键字关联到表contacts。
The foreign key index will be disabled, and the sysobjstate catalog table will reflect that state.
外键索引将被禁用,sysobjstate目录表格也会反映该状态。
In the case of one-to-many relations, your transformation creates a foreign key in every "many" table.
在一对多关联的情况下,你的转换在所有“ many ”表中建立了一个外键。
You can also establish a foreign key in a secondary table to link with a primary key in a primary table.
您还可以在次表中建立外键,以链接主表中的主键。
In table 6, the INSERT into the Orders table fails due to a foreign key constraint violation on custno.
在表6中,对orders表执行insert语句失败,因为custno违背了外键约束。
Step 3: Replace the primary and foreign key values in rawdata.xml with appropriately abstracted tokens.
第三步:用合适的分离标记替换rawdata . xml中的主键以及外键值。
The Location table contains a foreign key (region_id) that corresponds to primary key of the region table.
location表包含一个外键(region_id)对应region表的主键。
In the following example, an SQL statement captures foreign key information and generates DROP statements.
在下面的示例中,一个sql语句将捕捉外键信息并生成drop语句。
An index pushdown USES the pushed-down keys to perform index lookups on a foreign key index of the fact table.
索引下推使用下推键执行事实表外键索引的查询。
Normally, to associate that class to another class, you would use a has_one relationship and a simple foreign key.
通常,为了将该类关联到另一个类,可以使用 has_one关系和一个简单的外键。
A dimension table needs a generalized key as the primary key data; this becomes the foreign key in the fact table.
维度表需要作为主键数据的通用键;这将作为事实表的外键。
Figure 4 depicts the referential integrity (foreign key relationship) shown by a UML association between the tables.
图4描述了由一个表之间的UML关联所表示的引用完整性(外键关系)。
Ensure dependent tables in a referential integrity (ri) relationship have indexes that exactly match the foreign key.
确保参照完整性(referential integrity,ri)关系中的依赖表拥有与外键匹配的索引。
Next, select the newly added foreign key constraint in the editor and specify the key columns using the Properties view.
接下来,在编辑器中选择新添加的外键约束,并使用Properties视图指定关键列。
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,并用它作为事实表中新条目的外键。
For the sake of simplicity, consider VARCHAR as the default type for every column that is not a primary or a foreign key.
为了简单起见,考虑把VARCHAR作为除主键和外键外的所有列的默认类型。
应用推荐