In that particular example, I would agrea with you re: the unique constraint, but that is not a table from our database...  just a poor example that I threw together on...

Because many tables will reference this table via Foreign keys, that would mean I would have to have Usernames spread throughout my entire database.  Additionally, if a user wanted to...

I don't understand your reply...  What we are looking for opinions on are preferred data types for record ids in a table.

For example, do you prefer:

September 5, 2005 at 1:17 am