models.py

from sqlalchemy import Boolean, Column, DateTime, String, INT, JSON, TEXT, ForeignKey, func
from sqlalchemy.orm import relationship
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()


class AwslProducer(Base):
    __tablename__ = 'awsl_producer'

    id = Column(INT, primary_key=True, autoincrement=True)
    uid = Column(String(255), nullable=False)
    name = Column(String(255))
    keyword = Column(String(255))
    profile = Column(JSON)
    max_id = Column(String(255))
    in_verification = Column(Boolean, default=True)
    deleted = Column(Boolean)


class Mblog(Base):
    __tablename__ = 'awsl_mblog'

    id = Column(String(255), primary_key=True)
    uid = Column(String(255))
    mblogid = Column(String(255))
    re_id = Column(String(255))
    re_mblogid = Column(String(255))
    re_user_id = Column(String(255))
    re_user = Column(TEXT)


class Pic(Base):
    __tablename__ = 'awsl_pic'

    id = Column(INT, primary_key=True, autoincrement=True)
    awsl_id = Column(String(255), ForeignKey('awsl_mblog.id'))
    sequence = Column(INT)
    pic_id = Column(String(255))
    pic_info = Column(TEXT)
    awsl_mblog = relationship("Mblog", backref="mblog_of_pic")
    deleted = Column(Boolean)
    cleaned = Column(Boolean)
    create_date = Column(DateTime, server_default=func.now())


class AwslBlob(Base):
    __tablename__ = 'awsl_blob'

    id = Column(INT, primary_key=True, autoincrement=True)
    awsl_id = Column(String(255), ForeignKey('awsl_mblog.id'))
    pic_id = Column(String(255), index=True)
    pic_info = Column(TEXT)
    awsl_mblog = relationship("Mblog", backref="mblog_of_blob")
    create_date = Column(DateTime, server_default=func.now())