A foreign key is a key field (column) in a database table, which relates the table to another table where the key is a primary key. The primary - foreign key relations are used to cross-reference database tables.
The foreign key is a SQL locking mechanism.
The foreign key is a column that can have NULL values.