sqlalchemy 建表 给表添加注释 给列添加注释 column add comment table add comment

sqlalchemy 1.2 以上版本 支持 column comment

class Notice(db.Model):
    
    __tablename__ = "tb_notice"
    __table_args__ = {
        'mysql_engine': 'MyISAM',
        'comment': 'Notice table'
    }

    seqno = db.Column(db.Integer, primary_key=True, autoincrement=True, doc="seqno",
                      comment='Integer representing the sequence number')
    title = db.Column(db.String(200), nullable=False, doc="notice title",
                      comment='Title of the notice, represented as a string')
    detail = db.Column(db.TEXT, nullable=True, doc="notice detail",
                       comment='Notice detail description')

参考
https://stackoverflow.com/questions/38709800/how-to-add-comments-to-table-or-column-in-mysql-using-sqlalchemy