Foreign key

A foreign key is the connecting link between two tables which enables the possibility to use the related information together. In a proper setup, the foreign key is pointing to the primary key of the connected table and it thus ensures the referential integrity of the data.