I was under the impression that a primary key was equivalent to "unique not null", and indexed. In the user_login case the uid would not be unique, since there would be multiple rows with the same uid, one for each login from the same user.

Am I wrong here? Can I really use uid as the primary key in that example?