Composite key

Also written: composite primary key

A key made of several columns together. order_items uses (order_id, product_id), so a product can't appear twice on one order but can appear on many orders.