title: User Login System Database Schema...Please critique?
body: <p>I am creating a user login system for my website and I need some help creating the database. So I far I have these 3 tables. Do you  think this is a proper database schema? If not, then what would you suggest?</p>
  
  <pre><code>---Users---
  user_id
  user_name
  user_email
  user_firstname
  user_lastname
  user_state
  user_country
  user_occupation
  user_dob
  user_accountcreationdate
  user_sex
  user_role
  user_password
  
  ---Roles---
  role_id
  role_name
  role_description
  
  ---Logins----
  user_id
  last_login
  browser_type
  ip_address
  </code></pre>
  
  <p>Edit****
  Would this be correct then? I added in the 4th table for User Roles. If I add the 4th table does that mean I can remove user_role from the Users table? </p>
  
  <pre><code>---Users---
  user_id
  user_name
  user_email
  user_firstname
  user_lastname
  user_state
  user_country
  user_occupation
  user_dob
  user_accountcreationdate
  user_sex
  user_role
  user_password
  
  ---Roles---
  role_id
  role_name
  role_description
  
  ---Logins----
  user_id
  last_login
  browser_type
  ip_address
  
  ---User Roles---
  user_id
  role_id
  </code></pre>