Differences

> Markup Language (ML) > Extensible Markup Language (XML)

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 [2010/05/24 20:56]
gerardnico
data:modeling:foreign_key [2018/07/06 12:37] (current)
gerardnico [1 - About]
Line 1: Line 1:
-====== Data Modeling - Foreign Key Definition ​======+====== Data Modeling - Foreign Key Constraint ​======
  
 ===== About ===== ===== About =====
 +A Foreign Key is:
 +  * a column ​
 +  * or combination of columns ​
 +used to establish and enforce a [[relationship|relationship (link)]] between data in two tables. ​
 +
 +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.
 +
 +
 +===== Articles Related =====
 +{{backlinks>​.}}
 +
 +===== Example =====
 + 
 An Foreign Key example of a database (with the scott schema from Oracle). An Foreign Key example of a database (with the scott schema from Oracle).
  
Line 21: Line 39:
 If it's not true, there is NO [[referential_integrity|referential integrity]]. If it's not true, there is NO [[referential_integrity|referential integrity]].
  
-===== Articles Related ===== 
-{{backlinks>​.}} 
  
data/modeling/foreign_key.1274727418.txt.gz · Last modified: 2010/05/24 20:56 by gerardnico