Re: Help with the best table layout for message board

[Thor Strom]

I almost forgot the most important part of my response: When you say that it is almost not worth normalizing not-too-long strings, do you mean that if I had, e.g. a varchar(8) Name column in the post (entry) table, then I shouldn't use integer primary keys to link the entry and user tables together? I.e. I should just use the Name as the primary key in the user table and then have the Name column in the post table be a foreign key?

Thank you for your time.