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!

🔴 No definitive solution yet