如何更好地组织数据库以考虑用户的状态变化

The users I am concerned with can either be "unconfirmed" or "confirmed". The latter means they get full access, where the former means they are pending on approval from a moderator. I am unsure how to design the database to account for this structure.The users I am concerned with can either be "un