Foreign Keys

A foreign key is a field in a table that uniquely identifies an entry in another table. The table that contains this field is the child table and the referenced table is said to be the parent table.