Question

unique key that opens e mail id​

Answer 1

Answer:

Yes, it is a bad primary key because your users will want to update their email addresses. yes, it is better if you use an integer instead. you can also set your email column as unique constraint. Another reason why integer primary key is better is when you refer to email address in different table