为简单起见,该图不含显式的外键。
For the sake of simplicity, it contains no explicit foreign keys.
它类似于关系数据库中的外键。
创建一个索引禁用的外键约束。
如何在模型的外键关联的一些价值?
您为维度所选择的键必须是事实的外键。
The keys you choose for the dimensions must be the foreign keys of the fact.
在包中显示事实表的外键。
非标识可选的外键关系。
表中的外键维护着组间以及组内表之间的管理。
Foreign keys within tables maintain the relationship between intra-group and inter-group tables.
例如,日期表的外键对于一个文档的每个关键词不会重复。
For example, the foreign key to the date table is not repeated for every keyword of a document.
终止和重新创建索引禁用的外键之后,降级就成功完成了。
After the foreign key constraint with index disabled is dropped and recreated, the reversion completes successfully.
维度表需要作为主键数据的通用键;这将作为事实表的外键。
A dimension table needs a generalized key as the primary key data; this becomes the foreign key in the fact table.
需要创建一个新表,还要添加指向blog的每个文章的外键。
You'd need to create a new table and also add a new column representing the foreign key to each article to point to a blog.
SQL找到所有的重复在一个表中,删除,更新链接表的外键。
SQL find all duplicates in a table, remove them, and update foreign key in linked table.
给 Transformer建模师提供事实表中发现的外键。
Expose foreign keys found in fact tables to Transformer modelers.
要终止索引禁用的外键约束,重新创建这个参考约束,执行以下命令
To drop the foreign key constraint with index disabled and recreate this referential constraint, issue the following command
具体到本例,考虑所有关联结尾的外键的建立都带有多重性“1”。
For this example, consider the creation of a foreign key for every association end to occur with a multiplicity of "one". As a consequence, two things may occur.
早期的企业应用程序使用数据库表和表之间的外键关系进行实体建模。
Early enterprise applications used database tables and foreign-key relationships between them to model entities.
在外键页面中(如图3所示),增加一个新的外键ord_cust_key。
In the foreign keys page (shown in Figure 3), add a new foreign key ord_cust_key.
除了id主键以外,还声明了customer_id列作为引用客户表的外键。
In addition to the id primary key, you've declared the customer_id column to be a foreign key referencing the customer table.
否则,从序列获取一个新的键值,用它作为维表中新条目的主键和事实表中的外键。
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.
在清单2中我的location表中,我提供了一个指向account的外键。
In my location table in Listing 2, I provide a foreign key back to account.
要这样做,需要确保当XML元素包含子元素时,子元素包含与父代主键相对应的外键。
To do that, we need to make sure that when an XML element can contain a subelement, the subelement contains a foreign key corresponding to the parent's primary key.
如果在主键列上存在信息检查约束,那么应该在它们相应的外键列上指定信息检查约束。
If informational check constraints exist on the primary key column, you should explicitly specify informational check constraints on their corresponding foreign key columns. For example.
airline表的主键(airline . id)会作为flight表的外键。
Shows up as the foreign key in the Flight table. In the select field, notice that airline.id.
通常,为了将该类关联到另一个类,可以使用 has_one关系和一个简单的外键。
Normally, to associate that class to another class, you would use a has_one relationship and a simple foreign key.
可以使用类似的定义来定义usa . item_supplied昵称上的外键约束。
You can use similar definitions to define foreign key constraints on usa.item_supplied nickname.
接下来,在编辑器中选择新添加的外键约束,并使用Properties视图指定关键列。
Next, select the newly added foreign key constraint in the editor and specify the key columns using the Properties view.
在mysql中运行如下命令,创建employees和timetables表的外键。
In order to establish the foreign key relationship between employees and timesheets table, you would run the following query in your mysql instance.
在本节中,我们将进一步编辑包含生成的DDL的文件,以添加所需的外键语句,从而定义表关系。
In this section, the file containing the generated DDLs is further edited to add the required foreign key statements. This is in order to define the tables relationships.
在本节中,我们将进一步编辑包含生成的DDL的文件,以添加所需的外键语句,从而定义表关系。
In this section, the file containing the generated DDLs is further edited to add the required foreign key statements. This is in order to define the tables relationships.
应用推荐