I'm doing a grocery shop website and I'm still new to web dev. I'd like to add in my Users table a column that stores a list with all the user's purchase date or a dictionary with all the user's purchase date as keys and items as values. I'm using Flask-SQLAlchemy for my database. Is there a way to do this? Here is my code:
class Users(db.Model):
id = db.Column(db.Integer, primary_key=True)
first_name = db.Column(db.String(100), nullable=False)
last_name = db.Column(db.String(120), nullable=False)
email = db.Column(db.String(120), index=True, unique=True, nullable=False)
email_confirmed = db.Column(db.Boolean, nullable=False, default=False)
email_confirmed_on = db.Column(db.DateTime(timezone=True), nullable=True)
purchase_history = db.Column(??)
password_hash = db.Column(db.String(120))
Thank you in advance!