|
Often in real world apps it is more comfortable to work with a single column id, rather that with multi-column key (adding unique key on these columns).
But from the clear database design point of view the compound primary key is of course optimal for this task.
|