How to write all data of a Flask model to a field of another model?

Question

Flask

There is a Movie model with id, rating, comment and name fields.

class Movie(Base):
    __tablename__ = "movie's"
    id = Column(Integer, primary_key = True)
    name = Column(String(255))
    rating = Column(Float)
    comment = Column(sqlalchemy_jsonfield.JSONField(
            enforce_string=True,
            enforce_unicode=False,
            json=ujson,  
        ))

As you can see, the model has a comment json field, in which I want to write all the field data from another Comment model when they are filled:

class Comment(Base):
    __tablename__ = "comments"
    id = Column(Integer, primary_key = True)
    commentator_name = Column(String(50)
    /and another field/

How to do it?

Important : I need to have a separate Comment model, this is required by my task, so the answer in the style of "transfer these fields to the Movie model" is not welcome

Answer 1

Nafiga and most importantly why? Relational databases are not called relational for nothing, I advise you to read about their essence