Now the color code of a user is a randomly generated hex code that is persisted into the database when a new user is found during parsing. The color code should be calculated by some formula using the email address or (if there is one) the username of the user. When an email address is connected to a user, the color code should be generated of the username from then on.