title: Users database table scenario. Good or bad?
body: <p>I've got a table <code>users</code> which also has a column <code>active</code> that is either 0 or 1. And a <code>activation_keys</code> table that stores the activation keys for newly registered inactive user (where active == 0).</p>
  
  <p>All the users that register for a new account will start off inactive and will always have a matching relational row in the <code>activation_keys</code> table. If a user activates his/her account, the relational row is removed from the <code>activation_keys</code> table and active is set to 1 for that user in the users table.</p>
  
  <p>But now I want to also be able to disable users by setting active to 0. And to distinguish a newly registered user that still needs to activate his account and a user that's disabled, I'll be checking if there is a relational activation key in the <code>activation_keys</code> table. If there is, that means the user is not disabled. If there isn't, it means that the user is disabled and should not have access to his account.</p>
  
  <p>Is the way I just described a good way to handle it?</p>
  
  <p>Also, I would end up with a mixture of disabled and active users in the <code>users</code> table. Is that fine, or should I remove the disabled users to another table specifically for that? Any user that gets disabled, will be disabled permanently.</p>
  
  <p>Any suggestions are welcome.</p>