Foreign key: They are in relational databases the matching primary key of a parent database table.
It is always the primary key in the local DB. Seen from the child table the child key is the primary
key and the foreign key is the primary key of the parent table.