A primary key is unique and never NULL, so one value always points at exactly one row. It can span several columns, like (order_id, product_id) in order_items.
Primary key
The column(s) that identify each row uniquely.
A primary key is unique and never NULL, so one value always points at exactly one row. It can span several columns, like (order_id, product_id) in order_items.