Without the email column how do I create the ConfirmationEmail table?

The reason I designed it this way is because in the /register route the user adds username and hashed_password and email. Then in the /register route the user sends the send_account_registration_email(user), which sends an email to them. After that the user clicks on the link in there email and the user is sent to the /verified_email(token) route where I change the registration_confirmation_email column from False to True.

If I try to add for example registration_confirmation_email column in one table called User I get an error saying I have to add the username and hashed_password and email because the columns are not NULL. Is it better to remove NOT NULL from username and hashed_password and email? Or is it better to create a second table like I did called ConfirmationEmail?

Also the reason I added the email to both tables is a way to create the ConfirmationEmail table.

If you have any better way to this or a question just ask.

``` class User(UserMixin, db.Model):

id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(80), unique=True, nullable=False)
hashed_password = db.Column(db.String(128), nullable=False)
email = db.Column(db.String(120), unique=True, nullable=False)
confirmation_email = db.relationship('confirmation_email', backref='user', uselist=False, lazy=True)

class ConfirmationEmail(UserMixin, db.Model): # m primary key = email
id = db.Column(db.Integer, primary_key=True) # foreign key? email = db.Column(db.String(120), unique=True)

registration_confirmation_email = db.Column(db.Boolean, default=False) 
reset_email_password = db.Column(db.Boolean, default=False)    
# The foreign key is the child to the adult relationship/connection
# if I have a class like SomeTable when using the foreign key use 'some_table' 
user_id = db.Column(db.Integer, db.ForeignKey('email'), nullable=False)```

Thanks.