from sqlalchemy import Column, Integer, LargeBinary, String

from domain.models.base_model import UpdateModelBase


class SysNoticeModel(UpdateModelBase):
    """
    通知公告表
    """

    __tablename__ = "sys_notice"

    notice_title = Column(String(50), nullable=False, comment="公告标题")
    notice_type = Column(
        Integer, nullable=False, default=0, comment="公告类型（1通知 2公告）"
    )
    notice_content = Column(LargeBinary, comment="公告内容")
    status = Column(
        Integer, nullable=False, default=0, comment="公告状态（0正常 1关闭）"
    )
    remark = Column(String(255), comment="备注")