Many-to-many (data model)
| Many-to-many (data model) ： ウィキペディア英語版|
In systems analysis, a many-to-many relationship is a type of cardinality that refers to the relationship between two entities (see also entity–relationship model) A and B in which A may contain a parent record for which there are many children in B and vice versa. For instance, think of A as Authors, and B as Books. An Author can write several Books, and a Book can be written by several Authors. Because most database management systems only support one-to-many relationships, it is necessary to implement such relationships physically via a third junction table (also called ''cross-reference table''), say, AB with two one-to-many relationships A -> AB and B -> AB. In this case the logical primary key for AB is formed from the two foreign keys (i.e. copies of the primary keys of A and B).
In web application frameworks such as CakePHP and Ruby on Rails, a many-to-many relationship between database tables in a model is sometimes referred to as a HasAndBelongsToMany (HABTM) relationship.〔(220.127.116.11 hasAndBelongsToMany (HABTM) ). Cakephp.org〕
== See also ==
* Associative Entities
* One-to-one (data model)
* One-to-many (data model)
抄文引用元・出典: フリー百科事典『 ウィキペディア（Wikipedia）』
■ウィキペディアで「Many-to-many (data model)」の詳細全文を読む
| 翻訳と辞書 : 翻訳のためのインターネットリソース|
Copyright(C) kotoba.ne.jp 1997-2016. All Rights Reserved.