posted 8 years ago
Hi there
I am design a web application.Where there is a portion for user registration.In that when I register a user I need to verify their email address and mobile number then their userId and Password is active otherwise not.
For this I have design this table
UserId,Password,OtherFields.......,MobileVerify,EmailVerify
When I register any user I will Insert data in database but these two fields(MobileVerfiy,EmailVerify) are marked as false flag.
I will send a email on user email and a message on user Mobile number.
And based on click on email and some mechanism from mobile I will change these two boolean flag as true.
Will this be right data modelling?
I mean If I have 10milllon rows in mysql table then for any simple execuation I have to check for these two fields to?
Thanks