Re: How to get rid of Composite Primary Key

[Peter Brawley]

You don't need a composite order_item PK, a surrogate PK also works ...

create table Order_Items 
( order_item_id int unsigned primary key auto_increment, 
  order_id int not null 
, item_id int not null 
, qty int not null 
, price decimal(9.2) not null 
, foreign key order_id references Orders( id ) 
, foreign key item_id references Items( id ) /* Assumes an Items table that defines anything that can be ordered */ 
);