A foreign key is a FIELD in a table that refers to parent records in another table. The references are represented by the primary key values of the corresponding parent records. A foreign key field is the same data TYPE as the primary key field of the referenced table. Usually, a foreign key field is named the same as the primary key field of the parent table. This very BENEFICIAL convention is called key migration in data modeling terminology. Child table foreign key references to parent table primary keys embody database relationships.

A foreign key is a field in a table that refers to parent records in another table. The references are represented by the primary key values of the corresponding parent records. A foreign key field is the same data type as the primary key field of the referenced table. Usually, a foreign key field is named the same as the primary key field of the parent table. This very beneficial convention is called key migration in data modeling terminology. Child table foreign key references to parent table primary keys embody database relationships.