I wouldn’t have a users.uid. I would make users.id a unique key and then make comments.uid a foreign key referencing users.id.
@BenWalker A bit confusing. Are you saying I should do away with
users.uid and just make the USER ID as
Right now, the
user.id is just an auto incrementing column. I probably don’t need this now that I think about it because the users ID will be unique.