Quick question as relates to database.
Where would you store the value of “UserVerified”? (The one that occurs after the user has checked his email and clicked on the “Verify” link with the hash value at the end).
Would you store it in the User table? (Along with username, hash) ?
Or in the UserProfile table (along with first name, last name, email, phone, etc) ?
Please note that both tables will always contain 1 entry for a user, such that when a user is created, automatically a userprofile is created as well.
2
Based on your description of the two tables, it sounds like User contains metadata about the user, such as the hash field (and probably other things the user never enters, but are still important to keep track of in the system). So if you consider isVerified to also be metadata, then it should probably go in the User table with the related fields.