• 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中被可视化的显示出来。

    youdao

  • A foreign key is one or more data attributes that appear in one table that may be part of, or is coincidental with, the key of another table.

    外键是在一张表中出现的一个或多个数据属性;它可以是另一张表的键的一部分,或者干脆碰巧就是另一张表的键。

    youdao

  • For foreign key creation, another table with a primary key with a compatible data type is required.

    对于创建外键,则需要另外一个具有主键的表,且该主键具有兼容的数据类型。

    youdao

  • But from our data model's perspective, there is no unique table we can use to create our foreign key constraint, like the one between TB_RIGHT and TB_PERSON.

    但是从我们数据模型的角度来看,我们没有一个惟一的表可以用来创建我们的外键约束,就像TB_RIGHT和TB_PERSON之间那样。

    youdao

  • 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.

    数据库为一个表格的主键生成值(通过扩展,为相关表生成外主键),从而将程序从这项任务的重担中解放出来。

    youdao

  • Minimize the triggers, CHECK and foreign key constraints, and generated columns for the table.

    尽量减少表上的触发器、检查和外键约束以及生成的列。

    youdao

  • When ON delete set NULL is active, when a record is deleted from the parent table, all records in the child table with matching foreign key values are set to NULL.

    当ON DELETESETNULL规则被激活时,如果一条记录从父表中删除,子表中的所有记录以及匹配的外键值都被设置为NULL。

    youdao

  • 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 —当一条记录从父表中删除时,子表中的所有记录以及匹配的外键值都全部被删除。

    youdao

  • 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规则被激活时,当一条记录从父表中删除时,子表中的所有记录以及匹配的外键值都被删除。

    youdao

  • 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.

    否则,从序列获取一个新的键值,用它作为维表中新条目的主键和事实表中的外键。

    youdao

  • 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,并用它作为事实表中新条目的外键。

    youdao

  • You can also establish a foreign key in a secondary table to link with a primary key in a primary table.

    您还可以在次表中建立外键,以链接主表中的主键。

    youdao

  • 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.

    联合表:(可选)将子类映射到与父类映射到的表具有外键关系的表。

    youdao

  • Each one-to-many association is buried as a foreign key in the table of the many class.

    每个一对多的关联在表中多个类中充当外键。

    youdao

  • An index pushdown USES the pushed-down keys to perform index lookups on a foreign key index of the fact table.

    索引下推使用下推键执行事实表外键索引的查询。

    youdao

  • 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状态。

    youdao

  • In the case of a one-to-one relation, your transformation creates a foreign key in each table.

    在一对一关联的情况下,你的转换在所有表中都建立了一个外键。

    youdao

  • In general, that data would live in a child table with a foreign key relation to the table contacts.

    通常,那些数据应该存放在一张子表中,子表的外部关键字关联到表contacts。

    youdao

  • 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表内)。

    youdao

  • 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、惟一、主键、外键和表检查约束的信息。

    youdao

  • In the case of one-to-many relations, your transformation creates a foreign key in every "many" table.

    在一对多关联的情况下,你的转换在所有“ many ”表中建立了一个外键。

    youdao

  • 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字段映射用表模式文件中的外键引用将关系的两部分链接在一起。

    youdao

  • 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。

    youdao

  • 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表中,以便知道哪个用户上传某个特定的文档。

    youdao

  • Run rake db:migrate to create the SUBSCRIPTIONS table and add foreign key columns to SUBJECTS.

    运行rakedb:migrate以创建SUBSCRIPTIONS表并将外键列添加到SUBJECTS 中。

    youdao

  • In table 6, the INSERT into the Orders table fails due to a foreign key constraint violation on custno.

    在表6中,对orders表执行insert语句失败,因为custno违背了外键约束。

    youdao

  • The Location table contains a foreign key (region_id) that corresponds to primary key of the region table.

    location表包含一个外键(region_id)对应region表的主键。

    youdao

  • 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列作为引用客户表的外键。

    youdao

  • Run rake db: migrate to create the SUBJECTS table and add the subject_id foreign key.

    运行rakedb:migrate,以创建subjects表并添加subject _ id外键。

    youdao

  • In order to establish the foreign key relationship between employees and timesheets table, you would run the following query in your mysql instance.

    在mysql中运行如下命令,创建employees和timetables表的外键。

    youdao

$firstVoiceSent
- 来自原声例句
小调查
请问您想要如何调整此模块?

感谢您的反馈,我们会尽快进行适当修改!
进来说说原因吧 确定
小调查
请问您想要如何调整此模块?

感谢您的反馈,我们会尽快进行适当修改!
进来说说原因吧 确定