> Procedural Languages > Javascript > lang:javascript:browser:start

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
data:modeling:foreign_key [2017/09/13 21:21]
gerardnico ↷ Page moved from data_modeling:foreign_key to data:modeling:foreign_key
data:modeling:foreign_key [2018/07/06 12:37] (current)
gerardnico [1 - About]
Line 2: Line 2:
 ===== About ===== ===== About =====
-A Foreign Key (also known as as a foreign key constraint) ​is:+A Foreign Key is:
   * a column ​   * a column ​
   * or combination of columns ​   * or combination of columns ​
-used to establish and enforce a [[relationship|relationship]] between data in two tables. ​+used to establish and enforce a [[relationship|relationship ​(link)]] between data in two tables. ​
-Usually the foreign key is coupled with the [[primary key|primary key]] of the other table.+The link is created between ​the two tables by adding the column or columns that hold one table'​s ​[[primary key|primary key]] values 
 +to the other table. This column becomes a Foreign Key in the second table.  
 +A foreign key may be enforced, e.g. by a foreign key constraint. 
 +[[Referential Integrity|Referential Integrity]] is a data property whereby a Foreign Key in one table has a corresponding Primary key in a different ​table.
data/modeling/foreign_key.1505330490.txt.gz · Last modified: 2017/09/13 21:21 by gerardnico