A primary key uniquely identifies each row of a table. A foreign key is a column that references the primary key of another table and establishes the link between them. Joins generally rely on these columns, and the database can enforce the integrity of the reference.
Example
commandes.client_id -> clients.id