When 'Users will need to confirm their email address before signing in for the first time' is off, the email_verified default 'true', if I want users to login first and then verified the email, do I have to use the separate table to do this?
I am trying to do like those website that let you sign up first and then verify the email after. Is there any way to make 'email_verified' as false on auth.users table? I don't want to create a column for email verification that will force me to add complexity to deal with the RLS.
If I can I would love to do it from the auth.user table so I can check with the email verification status from the jwt token. But, so far, I do not see anyway? Is there anyway that I can let users to sign up when email_verified is false...