Differences

> 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
Next revision
Previous revision
data:modeling:foreign_key [2012/04/03 14:04]
gerardnico [About]
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.1333454655.txt.gz · Last modified: 2012/04/03 14:04 by gerardnico