How to create an association that sets join table attributes automatically?
如何创造一套联接表的属性自动关联吗？
Creating a join table to manage this relationship would be the right thing to do.
创建一个连接表来管理这个关系会非常适合。
Indeed, the relationship between Book and Author goes beyond the simple join table.
确实如此，Book和Author之间的关系已经超出了简单连接表的范围。
If you want to use a one-to-many relationship you should use a join table instead.
如果你想用一个一对多的关系，你应该使用一个连接表来代替。
The join table allows you to persist books with a single author as well as books with multiple authors.
连接表允许将具有一个作者的图书和具有多个作者的图书持久化。
Change the Join Table separator to an underline (" _ ") and change the name of the database schema.
将Join Table分隔符更改为一个下划线(“_”)并更改数据库模式(schema)的名称。
Rather than adding a foreign key to either the Book or Author table, GORM adds book_id and author_id to the BookAuthor join table.
GORM向BookAuthor 连接表添加 book_id和 author_id，而不是向Book或Author 表添加一个外键。
In a database, three tables represent m: m relationships: the two tables you'd expect (Book and Author), and a third join table (BookAuthor).
在数据库中，用三个表表示m： m关系：前两个表您已经知道了(Book和Author)，第三个是一个连接表(BookAuthor)。
The flight table is the join table, representing the complex relationship among the other tables. Listing 8 shows the fields in the flight table.
flight是连接表，表示其他表之间的复杂关系。
You would probably need to set up a many-to-many relationship with a join table, requiring several joins to determine the actors for a particular movie.
您可能需要使用一个联接表设置一个多对多关系，这需要几个联接来确定某个电影的演员。
If I were to use a relational table structure to design this relationship, I'd need at least three tables: the third being a join table linking a many-to-many relationship.
如果我要使用一个关系表结构来设计这个关系，至少需要3个表：第3表将是链接一个“多对多”关系的联接表。
Testing the subject and subscription association means we must access both the data in the SUBJECTS and the SUBSCRIPTIONS table, as well as the join table SUBJECTS_SUBCRIPTIONS.
要想测试主题和订阅的关联，就必须访问SUBJECTS和subscriptions表以及联结表subjects_subcriptions中的数据。
Before the join begins, the database server first applies filters if there are any, and then sorts the rows for each table on the join column.
连接开始之前，如果有筛选器，那么数据库服务器首先会应用它们，然后对连接列上每个表中的行进行分类。
It selects a hash join with PART as the inner table which runs in 299 seconds.
它选择一个散列连接，以PART作为内部表，这个计划只需运行299秒。
A star join query typically involves a fact table and several dimension tables, with join predicates between the fact table and each dimension table.
一个星型连接查询通常包含一个事实表和几个维度表，事实表和每个维度表之间都有连接谓词。
This is a lot faster than a nested loop join of two table scans without any index usage.
这比不使用任何索引的两个表扫描的嵌套循环连接要快得多。
Customize the formatting ordering of the predicates according to various criteria such as local predicates or join predicates, and table references.
根据各种标准，如本地谓词或连接谓词，以及表引用来定制谓词的格式化顺序。
As a database developer, you usually join the customer table to the contact table and treat the customer as the main table.
作为数据库开发人员，您通常将客户表与联系方式表连接，并将客户表视作主表。
This query plan uses hash join for each join between the fact table and a dimension table.
这个查询对每个事实表和维度表之间的连接使用散列连接。
In the query access plan shown in Listing 9, notice a join between the table EMPLOYEE and a table function, GENROW.
在清单9所示的查询访问计划中，要注意表employee和一个表函数GENROW间的一个连接。
Predicates are reordered and regrouped based on the kind of predicate (local or join) and the table reference.
重新排序和重新组合谓词是基于谓词的种类(本地或联接)和表引用。
As part of the transformation, the optimizer also determines the correct table join order, rewrites expressions, and eliminates any redundancy from the SQL.
作为转换的一部分，优化器还决定正确的表联接顺序，重写表达式，并从SQL中消除任何冗余。
The join is performed by scanning the inner table of the hash join, CUSTOMERS, and generating a lookup table by hashing the join column values.
该连接的执行过程包括扫描散列连接中的内表CUSTOMERS，并通过散列连接列的值生成一个查找表。
To get the remaining information, join this table with table E2KNVVM007.
为了获得剩余的信息，将此表与表e2KNVVM 007联接在一起。
The optimizer will then join that temp table to the fact table using the compound index to quickly locate the rows that satisfy the criteria on the dimension tables.
优化器然后使用复合索引将临时表连接到事实表，来快速定位在维度表中满足条件的行。
But in simple terms, a table join creates a composite table from two other tables.
但是用简单的术语来说，一个表格联系会从两个不同的表格创建一个组合表格。
This provides the table a default order and a fast way to join the table against other tables.
这为表提供一个默认顺序和快速方式来联接其他表。
They will automatically assume you are on your own and may ask you if they can join you at your table.
他们会因此认为你是一个人，并且可能会问你是否愿意让他们加入。
It's a right-deep query plan such that for each hash join, the build table is a small dimension table.
每个散列连接都是右深查询，构建的表是一个小的维度表。
For table CUST_ORDER_HEADER, both of the existing indexes do not support the local and join predicates on the table, as shown below.
对于cust_order_header表，现有的索引表不支持表上的本地和连接谓词，如下所示。
应用推荐