I was told by a friend:
What unique key do you use? I hope you are not saving the entire user name --- this will use up too much table space! Assign an unique userID to each (unique) userNAME and save this userID (should be INTEGER UNSIGNED auto_increment or BIGINT UNSIGNED auto_increment). Don't forget to create a reference
FOREIGN KEY (
userID
) REFERENCESusertable
(userID
) in all tables using the userID.
What do you think of my friend's comment?