Sending a friend request is an obvious example.

Ok but in that case, why not use the user ID as the primary key?