I'm designing a database for a new project and I'm looking for some feedback on the design before I start to implement/test. It basically consists of users, events, user profiles and a messaging system.
Certain users can create events which others can view, this is determined from the userType
table. I'm unsure if I should be storing the lost password columns in the users table, would there any benefit for using a separate table for this?
(I'm not to sure if my relationships are setup correctly)
Appreciate any feedback given =)
Thanks !