what is foreign key?
its actually primary key but in another table
to be clear : a table that give primary key is the parent
and a table that retrieve primary key it's the child table and the name of column will be foreign key