What is a foreign key in a relational database?
A foreign key is a field (or collection of fields) in one table that refers to the primary key in another table.