User ID should be the primary key column of your table.
UserName should be the email address column
you want the user to type the email address and password when they log in.
So the Username column is the email, and the password column is the password.
when the user logs in, the Primary Key value from the ID column will be stored in a session and used to identify the logged in user.