flask - How to set foreign keys to one column in sqlalchemy?

Question

class ReportModel(db.Model):
    __tablename__ = "reports"

    id = Column(SmallInteger().with_variant(Integer, "sqlite"), primary_key=True)
    ref_id = Column(
        BigInteger, ForeignKey([PostModel.id, CommentModel.id], nullable=False)
    )
    type = Column(String(20), nullable=False)


    post = relationship("PostModel", backref="post")
    comment = relationship("CommentModel", backref="comment")

There are post, comment tables. I want to make that ref_id to refer post.id and comment.id at once. Is it possible? and how to make it? Thank u!

Answer 1

等待大神答复